a Screach Error

[Mick2015]

i need some help ive been trying tp fix this error for the past week im not sure if its VBA or jsut VB the error is

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT userid, username FROM vb_user WHERE vb_userid=27;

MySQL Error : Unknown column 'vb_userid' in 'where clause'
Error Number : 1054
Date : Tuesday, June 12th 2007 @ 02:05:50 PM
Script : http://www.micksworld.co.uk/index.php
Referrer :
IP Address : **.**.***.***
Username : Mick
Classname : vB_Database

[succo]

that means that somewhere in your files there is a " . TABLE_PREFIX . " too much, as userid wouldn't need to be 'table_prefixed' being a row in a table :)

search for " . TABLE_PREFIX . "userid in your files and you will know where the error is :D

[Our Sponsors]

[Mick2015]

ok will do and in the style or php files ???

[Brian]

My guess would be that you've added a custom module that has a mistake in the coding. Is this only happening when a certain module is active on the page? If so, you should be able to search the .php file for that module for " . TABLE_PREFIX . "userid and replace it with just 'userid' (without the quotes).

[Our Sponsors]

[Mick2015]

it was let this after ive updated, also ive had a look at the files onthe server plus the custom modules aswell and cant see anything there that need to be gone

[Brian]

The only thing I can suggest would be to turn off all of your modules on the page and then start re-enabling them one by one to see which one is causing the error. Or, if you still get the same error with all of them disabled then it's most likely another pluing that's causing the problem. In that case, I would suggest disabling those one by one until you see which one is causing it.