Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2012, 06:42 PM
vialli25 vialli25 is offline
 
Join Date: Jul 2012
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:33 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07305 seconds
  • Memory Usage 2,165KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete