View Single Post
  #112  
Old 02-25-2008, 08:49 PM
Boothby Boothby is offline
 
Join Date: Mar 2002
Location: at home
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

maxXximum from vBGo reported this SQL-error-message.
Code:
Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:

SELECT 
modtable.usergroupid as modgroup,
modtable.username as moderator,
editlog.postid as postid,
editlog.reason as reason,
editlog.dateline as dateline,
editlog.userid as modid,
post.threadid as threadid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
post.title as action
FROM vb7editlog as editlog
LEFT JOIN vb7post as post ON (post.postid = editlog.postid)
LEFT JOIN vb7thread AS thread ON (thread.threadid = post.threadid) 
LEFT JOIN vb7user AS modtable ON (modtable.userid = editlog.userid) 
LEFT JOIN vb7forum AS forum ON (forum.forumid = thread.forumid)
WHERE 
post.userid = 3 AND post.userid != editlog.userid AND 1203889380-editlog.dateline <86400 AND modtable.usergroupid IN () 
ORDER BY editlog.dateline DESC
LIMIT 10;

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 ') 
ORDER BY editlog.dateline DESC
LIMIT 10' at line 19
Error Number : 1064
I think that happens when $vbulletin->options['eum_groups'] is empty.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01152 seconds
  • Memory Usage 1,765KB
  • 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_code
  • (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