vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Help Please (https://vborg.vbsupport.ru/showthread.php?t=108381)

MoveOver.cc 02-19-2006 02:25 PM

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

Princeton 02-19-2006 04:04 PM

there's no $ids in thread.threadid IN ()

MoveOver.cc 02-19-2006 06:23 PM

Thanks.

Can you please tell me where I would go to change this and what exactly do I need to add.

Princeton 02-19-2006 07:50 PM

I have no idea. I don't know what hacks you have installed.
I recommend hiring someone to check this for you.


All times are GMT. The time now is 08:44 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00949 seconds
  • Memory Usage 1,712KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (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_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete