Thread: Statistics Modifications - AJAX
View Single Post
  #137  
Old 01-08-2009, 11:37 AM
blue6995 blue6995 is offline
 
Join Date: Oct 2005
Posts: 207
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm getting this error and I have no idea why. Does anyone know how I can fix this? Many thanks

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT attachment.attachmentid, thread.threadid, thread.title
FROM vb3_attachment AS attachment
LEFT JOIN vb3_post AS post ON (attachment.postid=post.postid)
LEFT JOIN vb3_thread AS thread ON (post.threadid=thread.threadid)
WHERE attachment.extension IN ('bmp','gif','jpe','jpeg','jpg','png') AND thread.forumid NOT IN(44,42,129,87,,40,87,101,129)
ORDER BY rand()
LIMIT 0, 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 '40,87,101,129)
ORDER BY rand()
LIMIT 0, 10' at line 5
Error Number : 1064
Request Date : Thursday, January 8th 2009 @ 02:32:16 PM
Error Date : Thursday, January 8th 2009 @ 02:32:18 PM
Script : http://www.rwf-forum.co.uk/vBulletin...splay.php?f=70
Referrer :
IP Address : xx.xx.xxx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01321 seconds
  • Memory Usage 1,763KB
  • 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