MySQL errors
MySQL errors
By Paul
Oct 06, 2003 (Edited Mar 11, 2014)
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..
By Paul
Oct 06, 2003 (Edited Mar 11, 2014)
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 | 2,722 views. Averaging 0 views per day. |
| Similar Listings |