vb.org Archive - 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 :

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 [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:

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 [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
Page Generation 0.01106 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: