Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
Reload this Page evry important thread WHERE postuserid=
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools
evry important thread WHERE postuserid= Details »»
evry important thread WHERE postuserid=
Version: , by HiSquad HiSquad is offline
Developer Last Online: Feb 2006 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 01-12-2003 Last Update: Never Installs: 0
 
No support by the author.

Hi ,
I would like to know what is exactly problem ?and How I can fix it?

My Problem is:
I remove user in my forum befor 1 year but now any thread that user write in it's appear this messeges:

PHP Code:
Invalid SQL: SELECT COUNT(threadid) AS total FROM thread WHERE postuserid= 
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Sunday 12th of January 2003 04:37:55 PM 

I hoop to tell me what I do now???


Thanks

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 01-13-2003, 02:47 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
update your counters within your admincp, that should help....
Reply With Quote
  #3  
Old 01-13-2003, 08:26 PM
HiSquad's Avatar
HiSquad HiSquad is offline
 
Join Date: Feb 2002
Posts: 89
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I do it this befor .

I hoop to Help me
Reply With Quote
  #4  
Old 01-14-2003, 04:26 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
well it's a hack, and as long as you don't say which one we couldn'T help you more...

i think in your functions.php there would be a line like:
[php]$DB_site->query_first("SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=$post[userid]");[php]

which produces the error, because its on the wron part of the getpostbit section, just put it into the if post[userid]!=0 section...

just a guess..
Reply With Quote
  #5  
Old 01-15-2003, 09:55 PM
HiSquad's Avatar
HiSquad HiSquad is offline
 
Join Date: Feb 2002
Posts: 89
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Sir I didn't used any hack on this.

Please Tell me How I can fix this problem.

Thank you for help me.
Reply With Quote
  #6  
Old 01-15-2003, 10:08 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
well i can't help you if i don't know the error exactly, which file produces the error, what are the errorproducing lines...
Reply With Quote
  #7  
Old 01-16-2003, 03:49 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Code:
SELECT COUNT[high](*)[/high] AS total FROM thread WHERE postuserid=
Post the relevant code, we will have it solved rightaway...
Reply With Quote
  #8  
Old 01-17-2003, 12:43 AM
HiSquad's Avatar
HiSquad HiSquad is offline
 
Join Date: Feb 2002
Posts: 89
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thank you So much for Help me But I have a Question where I should put this code .

and You much to know there are over 300 thread do it same thing Because for one user.

Thank you for help me.
Reply With Quote
  #9  
Old 01-20-2003, 11:05 PM
HiSquad's Avatar
HiSquad HiSquad is offline
 
Join Date: Feb 2002
Posts: 89
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Up

I need to know what I will do

Thanks
Reply With Quote
  #10  
Old 01-21-2003, 11:41 PM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Post the query that gives you the error (use [high] bbcode to highlight it) as well 10lines above and below that query line.
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 09:30 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04819 seconds
  • Memory Usage 2,290KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete