View Single Post
  #1  
Old 04-26-2014, 11:59 PM
Kung! Kung! is offline
 
Join Date: May 2007
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error - unsure what it's related to

I'll state up front that I did a bit of searching around; so if I missed something, my profuse apologies.

A while back our site got infected with malware. We finally got it fully cleaned, and in the process of that we updated our site from 4.1.10 PL3 (or something - I forget just now lol) to 4.2.2 PL1.

I've got most of the kinks ironed out, but while I can access EVERY other page of the site, the main index gives me a database error:

Quote:
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT connections.*,rooms.*,user.*
FROM connections as connections
LEFT JOIN rooms as rooms ON connections.roomid = rooms.id
LEFT JOIN user as user ON connections.userid = user.userid
WHERE connections.userid > 0 AND connections.ip != '0.0.0.0'
AND connections.updated > DATE_SUB(NOW(),INTERVAL 60 SECOND)
ORDER BY start;

MySQL Error : Table '(our database).connections' doesn't exist
By looking at it, it seems like it's related to some sort of chat room, but I'm unsure. Can anyone point me in the right direction? Help would be much appreciated.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01262 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete