Latest Register Log In

+ Advanced Search

MySQL errors

MySQL errors
By
10/06/03 (Edited 03/11/14)

To fix a MySQL error/warning, please follow this procedure:

1) If the error appears immediately after an upgrade, try going to yoursite/upgrade.php and running that to make sure all needed fields are added. If you've just manually upgraded from a previous version, please re-check readme.html to confirm that you've followed all steps of the upgrade procedure.

2) You'll see a bunch of debug output on the page with the warning. Relay all of this data to support via email or forum post.

Note: On a live site you'll likely want to keep the debug level at Admin -> Settings -> System Configruation -> Debug set to suppress errors for non-admins so that regular users don't see the error messages..




Description Dealing with SQL errors such as "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/username/public_html/listings/classes/database.php on line 22"
Rating
Views 2716 views. Averaging 0 views per day.