Email: MySQL Error Report

[Amedeus]

I got 15 of these yesterday - I just turned my classifieds on yesterday.

An error was encountered during execution of the query: SELECT c.cat,c.product,c.comment,p.bigimage,p.cat,p.userid,p.title FROM class_comments c LEFT JOIN class_products p ON p.id=c.product WHERE c.comment != '' AND c.userid= ORDER BY c.date DESC LIMIT 10 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 c.date DESC LIMIT 10' 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.

[Chuck S]

which product are we talking about here your posting in the photopost pro support forums?

There is no query in classifieds like that!!

What version of the software is this which software and where is it installed and and what page is the error on?

[Amedeus]

Originally Posted by Chuck S

which product are we talking about here your posting in the photopost pro support forums?

My Classifieds tables are prefixed with class_, so it presume it's Classifieds.
I posted here because the error link directed me here.

Originally Posted by Chuck S

There is no query in classifieds like that!!

Beats me, I just posted the error as instructed.
I did a clean install yesterday and am using it with vB. This was not an upgrade, so there shouldn't be any leftover files.

Edit: I searched for it and found it in member.php, line 696

Originally Posted by Chuck S

What version of the software is this which software and where is it installed and and what page is the error on?

I am running the latest beta with vB 3.8.2.
Main Index - Classifieds

[Chuck S]

Maybe line 693 of member.php

Content visible to verified customers only.

change to

Content visible to verified customers only.

[Amedeus]

I replaced it and get this when I click Comments:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\Inetpub\bloodbanktalk\classifieds\member.php on line 704

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\Inetpub\bloodbanktalk\classifieds\member.php on line 745

[Chuck S]

If you turn debug option to display errors in global options what is the true error?

[Amedeus]

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT c.cat,c.product,c.comment,p.bigimage,p.cat,p.userid,p.title FROM class_comments c LEFT JOIN class_products p ON p.id=c.product WHERE c.comment != '' AND c.userid= ORDER BY c.date DESC LIMIT 10

Result: 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 c.date DESC LIMIT 10' at line 4

Database handle: Resource id #24