Thread: Profile Enhancements - Activity Streams
View Single Post
  #20  
Old 12-29-2010, 07:43 PM
wEbAddEr wEbAddEr is offline
 
Join Date: Aug 2004
Location: Argentina
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the new file gives me a database error:

Database error in vBulletin 4.1.0:

Invalid SQL:

SELECT thread.postusername as firstpostusername, thread.postuserid as firstpostuserid, post.dateline, post.pagetext, post.allowsmilie, post.postid,
thread.threadid, thread.title, thread.prefixid, post.attach, thread.replycount,
forum.forumid, post.title AS posttitle, post.dateline AS postdateline,
user.userid as postuserid, user.username as postusername
FROM post AS post
JOIN thread AS thread ON (thread.threadid = post.threadid)
JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE 1=1
AND ( thread.forumid IN(3,4,11,5,56,6,7,8,9,10,12,13,14,15,16,17,18,19, 28,20,40,22,23,24,25,26,27,53, 54,55,29,31,32,52,30,35,41,42,43,44,45,46,47,48,49 ,50,51,36,37,38,39)

AND thread.visible = 1
AND post.visible = 1
AND thread.open <> 10
AND post.dateline > 1291844552
AND post.parentid > 0


AND post.userid IN (1)
ORDER BY post.dateline DESC
LIMIT 0,1;

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 post.dateline DESC
LIMIT 0,1' at line 20
Error Number : 1064
Request Date : Wednesday, December 29th 2010 @ 01:42:32 PM
Error Date : Wednesday, December 29th 2010 @ 01:42:32 PM
Script :
Referrer :
IP Address :
Username :
Classname :
MySQL Version : 5.0.51a-community
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02935 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