invalid sql

[|2elentless]

Hello all,

I just upgraded to vBulletin 3.8 and I'm getting this everytime I try to access any page on my website:

Invalid SQL:
select * from style where styleid = or styleid = 57 ORDER BY styleid ASC;

MySQL 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 'or styleid = 74 ORDER BY styleid ASC' at line 1

I've also repaired/optimized all my tables.

How or where do I fix this?

[Lynne]

Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true); 

[|2elentless]

Hi Lynne,

Thank you for the quick response. It worked.

so what is the problem? How do I make it work without the plugin system disabled?

Thanks

[Lynne]

If it worked with the plugins disabled, then that means you have a plugin causing the problem. So, go to the products page and turn them all off and also to the plugins page and turn off all the ones under the vBulletin heading. Now, get rid of that line in your config.php page. Then go start turning on products/plugins and testing your site after each addition. At some point, you will turn one on and the problem will happen again and then you'll know which plugin/product is causing the problem.

[|2elentless]

Ok, I've turned off the plugin that was causing this and enabled the hook and now the posts don't show up in threads. When I'm a certain forum, I can see like the 'last post' and time it was posted but when I click on any thread, no posts shows up but everything else seems to be in place.

I've tried disabling the hook in the config file again and they do show up. So I turned off all my plugins and enabled the hook again, and again...no luck.

[Lynne]

When you turned off your plugins, did you turn off the products on the products page and then also all the extra, single plugins on the plugins page? You need to do both.