vialli25
07-23-2012, 06:42 PM
Ok, I really need somebody's help!
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 :
Above is an error I'm receiving and I can't access my forum at all. I tried to do a cleanup using Impex as I'd already done a test import from an old forum, and wanted to now perform a full import. Unfortunately it seems to have messed something up entirely in the process.
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 1343072757 at 1343072757 ---------------
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 1343072890 at 1343072890 ---------------
Ok, even funnier. I managed to reset my password using the forgotten password tool and now I have this message.
You have been banned for the following reason:
No reason was specified.
Date the ban will be lifted: Never
LOL. Something has gone seriously wrong with my forum!
--------------- Added 1343073444 at 1343073444 ---------------
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.
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 :
Above is an error I'm receiving and I can't access my forum at all. I tried to do a cleanup using Impex as I'd already done a test import from an old forum, and wanted to now perform a full import. Unfortunately it seems to have messed something up entirely in the process.
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 1343072757 at 1343072757 ---------------
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 1343072890 at 1343072890 ---------------
Ok, even funnier. I managed to reset my password using the forgotten password tool and now I have this message.
You have been banned for the following reason:
No reason was specified.
Date the ban will be lifted: Never
LOL. Something has gone seriously wrong with my forum!
--------------- Added 1343073444 at 1343073444 ---------------
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.