The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
(Help) Database Error
I got this problem on my site and i dont know how to fix it...if anybody knows how to fix them pls needing ur helps..
Code:
Invalid SQL: SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforum, session.lastactivity, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid FROM session AS session LEFT JOIN user AS user ON(user.userid = session.userid) WHERE session.lastactivity > 1169626756 ORDER BY username ASC; MySQL Error : Unknown column 'user.username' in 'field list' Error Number : 1054 |
#2
|
|||
|
|||
Code:
ORDER BY user.username ASC; |
#3
|
|||
|
|||
what the f**kin gonna in here ? i asked a firm to build for me a site and paid them the money for this and lisence, so i got this one, thanks for the information, now im trying to get back the money
|
#4
|
|||
|
|||
chill out, have you tried my suggestion above?
|
#5
|
|||
|
|||
but i dont know how to fix it or try to reinstall the Vbb ?
|
#6
|
|||
|
|||
Don't think you need to reinstall VB.
What add-ons are installed on the VB? |
#7
|
|||
|
|||
nothing...because i created this two days ago, and all set by default. Maybe a languague scripts but its not add-ons. I just edited and added some cripts in footer of template.
|
#8
|
|||
|
|||
try reverting the templates changed one by one. After each reverted, try to access the problem page again.
If it's just a clean install from two days ago, then you can reinstall VB and forget all the hassles. But you need to re-configure your modifications. You said you paid the firm money for the license and the site. Did you download the script directly from vbulletin.com members area or the script provided by the firm? If it's provided by the firm, then those scripts may have been tampered. |
#9
|
|||
|
|||
i downloaded this scripts from a site, not from vbulletin and i installed it by myself. I think the best way it to reinstall it now. thanks so much 4 ur help. Wish u all the best, guy.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|