Forums / General Questions / SQL error on advanced_search_result page

SQL error on advanced_search_result page

Results 1 to 2 of 2

9 Mar 2011, 8:36 AM

danielle

Totally Zenned

Join Date:: Oct 2004
Posts:: 973
Plugin Contributions:: 0

SQL error on advanced_search_result page

I am getting the following error on the advanced_search_results page:

1064 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 'from where manufacturers_id = 0' at line 2
in:
[select from where manufacturers_id = 0]

The site was just upgraded to 1.3.9h. It is using all of the same mods, but the 1.3.9 versions, and I made sure to merge all the files.

Any idea what could be causing this error?

Thanks!

9 Mar 2011, 2:17 PM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 177

Re: SQL error on advanced_search_result page

I suspect your files in the /includes/index_filters/ folder aren't merged correctly. And if you had never customized those, then simply replacing them with the new version should suffice.