The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database Error after Impex Cleanup
Ok, I really need somebody's help!
Code:
Database error in vBulletin 4.2.0: Invalid SQL: SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend, user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible FROM forum AS forum LEFT JOIN user AS user ON (user.userid = forum.lastposterid) LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = ); 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 ')' at line 7 Error Number : 1064 Request Date : Monday, July 23rd 2012 @ 08:23:08 PM Error Date : Monday, July 23rd 2012 @ 08:23:08 PM Script : http://www.twizyowners.com/vbulletin/forum.php Referrer : http://www.twizyowners.com/vbulletin/admincp/index.php?do=head IP Address : 82.12.9.127 Username : Classname : vB_Database MySQL Version : I have no idea what any of that means, but I know some nice soul here will!! I don't have any data on the forum that I really need, apart from a style I've spent a week creating. It wasn't backed up and I'd amassed quite a lengthy additional.css file! Really annoyed at myself for not backing it up. Thanks in advance! --------------- Added [DATE]1343072757[/DATE] at [TIME]1343072757[/TIME] --------------- Somehow just after posting the above message, and without me doing anything, my forum is back in action. HOWEVER, I seem to have wiped my admin user account. Any ideas?? --------------- Added [DATE]1343072890[/DATE] at [TIME]1343072890[/TIME] --------------- Ok, even funnier. I managed to reset my password using the forgotten password tool and now I have this message. Quote:
--------------- Added [DATE]1343073444[/DATE] at [TIME]1343073444[/TIME] --------------- Ok, so I seem to have solved my own problem. I uploaded tools.php from the do not upload folder that you get when you download bulletin to the admincp folder as well as the install folder back to my root, and navigated to tools.php it in my browser. I then reset the admin privileges for my user account and everything is working again. I thought I'd post the solution in case anybody else runs into this problem. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|