Thread: Help Please
View Single Post
  #1  
Old 02-19-2006, 02:25 PM
MoveOver.cc MoveOver.cc is offline
 
Join Date: Dec 2005
Posts: 75
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help Please

I have been adding quite a few good hacks from here but since doing one of them, I have the following error when I try and click on a members profile -

Invalid SQL:

SELECT thread.threadid,
thread.title AS tht,
thread.postusername,
thread.replycount,
thread.lastposter,
thread.lastpost,
thread.dateline,
user.userid AS lastposterid2,
thread.views,
thread.attach,
forum.title AS fot,
forum.forumid AS fir
FROM thread AS thread, forum AS forum, user AS user
WHERE thread.postuserid = 1
AND thread.forumid = forum.forumid
AND thread.threadid IN ()
AND thread.lastposter = user.username
LIMIT XX;

MySQL Error : You have an error in your SQL syntax near ')
AND thread.lastposter = user.username
LIMIT XX
' at line 17
Error Number : 1064
Date : Saturday, February 18th 2006 @ 06:29:15 PM
Script : http://212.67.202.205/~mad4it4/forums/member.php?u=1
Referrer : http://212.67.202.205/~mad4it4/forum...ead.php?t=1441
Classname : vb_database

Could anyone shed some light as to what I might have done wrong, what to look for and where to look for it.

Many thanks
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01107 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