Troubleshooting vBulletin Problems Discuss i cant access to Admincp in the vBulletinSetup Information forums; hi i can t access to Admincp i get this error n webmaster's mail helpe me plz thanks in advance Database error in vBulletin 3.7.2: Invalid SQL: SELECT administrator.*, userfield.*, ...

[izem013]

hi

i can t access to Admincp i get this error n webmaster's mail

helpe me plz

thanks in advance

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_cphome AS phrasegroup_cphome,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'administrator.userid' in 'on clause'
Error Number : 1054
Request Date : Wednesday, October 8th 2008 @ 07:36:54 PM
Error Date : Wednesday, October 8th 2008 @ 07:36:54 PM
Script : http://XXXX.XXX/admincp/index.php
Referrer : Unknown Domain
IP Address : XXX.XXX.XX.XXX
Username :
Classname : vB_Database
MySQL Version :

[glennybee]

Edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

This will disable all hacks on your forum, this is most likely the cause of the error.

When you get ACP access you can disable the last hack you installed and track back to see which one is causing the error.

If you've not recently installed a hack, what was the last modification you made?

[izem013]

thank you glennybee , now it s working