SQL SYNTAX ERROR. HELP ME TO FIX IT!

Error log:

PHP Notice: Error: 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<br />Error No: 1064<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND () in /home/content/44/7109344/html/store/system/database/mysql.php on line 49

Can anyone help me to fix it ?

Thanks in advance!
Markdat
OC 1.5.3.1

Had you just upgraded to 1.5.3.1 ? Make sure there is a ; at the end of the SQL statement. Without seeing your actual function it's hard to tell. Many have had the same issue because they either edited the code, or have a version of OC that did actually forget a ;

Hi avvici -arvixe,

No it was a clean install of the OC 1.5.3.1. Do you know if a SQL command via myphpadmin can fix it? If yes please let me know how can I do that?

Thanks again,
Markdat

Looks like a bug if filter_name or filter_tag is white space. I haven't tested this but you can try editing /catalog/model/catalog/product.php and changing:
to:

Hi Ryan,

Thank you very much for trying help me but this change not solved the problem.

Best wishes,
Markdat

You need to post the search query that's triggering the error then.

Like I said at the beginning. Why do we have to complicate things

Not sure what you mean. This is all default.

Ryan,

The above error only appears in the error log in the administration of the store. This error does not appear in the store. I've done several tests and was never presented in the store front.

How can I find the search query?

I´m a beginner in OC, so I´m sorry for many questions!

Thanks again,
Markdat

rph wrote:Not sure what you mean. This is all default.

Forget it. Not important. I'm pretty sure I know what the issue is but it seems you've got a handle on it. Moving on...

Hello friends,

New errors yesterday!

Error log:

2013-05-29 20:22:42 - PHP Warning: unlink(/home/content/44/7109344/html/store/system/cache/cache.product.2.0.1.08102527af66a44e4d84545270b01c11.1369884047) [<a href='function.unlink'>function.unlink</a>]: No such file or directory in /home/content/44/7109344/html/store/system/library/cache.php on line 14
2013-05-29 20:22:42 - PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cookie - headers already sent by (output started at /home/content/44/7109344/html/store/index.php:104) in /home/content/44/7109344/html/store/system/library/session.php on line 11
2013-05-29 20:22:42 - PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cache limiter - headers already sent (output started at /home/content/44/7109344/html/store/index.php:104) in /home/content/44/7109344/html/store/system/library/session.php on line 11
2013-05-29 20:22:42 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/content/44/7109344/html/store/index.php:104) in /home/content/44/7109344/html/store/index.php on line 184
2013-05-29 20:22:42 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/content/44/7109344/html/store/index.php:104) in /home/content/44/7109344/html/store/system/library/currency.php on line 45

Any help will be welcome!

Thanks again,
Markdat

You can ignore that error.

There was an issue with the code I originally wrote so you must have just been looking at the old error. I've updated it so try that. (Make sure to clear your error log first.)

Thank you my friend!

Solved this matter just with an update of the VQMOD for last version.2.3.2.

Best regards,
Markdat