March 10th, 2010, 05:05 PM
|
#1 (permalink)
|
| Member Verified Customer
Join Date: Oct 2006
Posts: 233
| MySQL Error Report
Chuck I need some help, Im still getting errors. Can you look at the last 5 and point me in the right direction to fix them. Thanks... Quote: |
An error was encountered during execution of the query: SELECT n.id,n.product,n.type,c.id,c.catname,p.id,p.title FROM cp_notify n LEFT JOIN cp_categories c ON c.id=n.product LEFT JOIN cp_products p ON p.id=n.product WHERE n.userid= The query returned with an errorcode of: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community To turn off these emails, set $debug=0 in your config-inc.php file.
| Quote: |
An error was encountered during execution of the query: SELECT product,comment FROM cp_comments WHERE userid= AND comment != '' ORDER BY date DESC LIMIT 1 The query returned with an errorcode of: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND comment != '' ORDER BY date DESC LIMIT 1' at line 1 If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community To turn off these emails, set $debug=0 in your config-inc.php file.
| Quote: |
An error was encountered during execution of the query: SELECT p.id,p.title,p.userid,p.cat,p.approved,p.bigimage FROM cp_products p LEFT JOIN cp_categories c ON p.cat=c.id WHERE p.userid= ORDER BY p.date DESC The query returned with an errorcode of: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY p.date DESC' at line 1 If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community To turn off these emails, set $debug=0 in your config-inc.php file.
| Quote: |
An error was encountered during execution of the query: SELECT count(*) FROM cp_comments WHERE userid= The query returned with an errorcode of: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community To turn off these emails, set $debug=0 in your config-inc.php file.
| Quote: |
An error was encountered during execution of the query: SELECT SUM(views), count(*) FROM cp_products WHERE userid= The query returned with an errorcode of: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community To turn off these emails, set $debug=0 in your config-inc.php file.
| |
| |