View Single Post
  #1  
Old 07-20-2005, 01:02 AM
IWLSR5 IWLSR5 is offline
 
Join Date: Apr 2003
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error in vBulletin 3.0.7:

I posted this same question under vbulletin.com, but they directed me to vbulletin.org because the error is related to a hack? The problem is, I have no idea what hack is causing the error.

Can anyone help me with this error? We're getting automated emails with this error, and can't figure out why? Any help would be much appreciated.

The hacks we installed are:
1. Links Database version 1.60
2. vbChat
3. Aambience (Skin)
4. Admin Alert (Alerts us with the login info of people trying to access admin)

I believe Links "Database version 1.60" was the last hack installed, but everything has been running fine for nearly 2 weeks. Now all of the sudden we're getting this error.

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(threadid) AS articles,
SUM(IF(lastpost>=1121776790 AND open<>10,1,0)) AS newarticle
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')

WHERE 1=1
AND forumid IN ()
AND thread.pollid > 0
AND visible = 1
AND open != 10
AND lastpost >= 1121171990
AND deletionlog.primaryid IS NULL

mysql error: You have an error in your SQL syntax near ')
AND thread.pollid > 0
AND visible = 1
AND open != 10
AND lastpost >= 11211' at line 8

mysql error number: 1064
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01435 seconds
  • Memory Usage 1,762KB
  • 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)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