evry important thread WHERE postuserid=

[HiSquad]

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:


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

[Xenon]

update your counters within your admincp, that should help....

[HiSquad]

I do it this befor .

I hoop to Help me

[Xenon]

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..

[HiSquad]

Sir I didn't used any hack on this.

Please Tell me How I can fix this problem.

Thank you for help me.

[Xenon]

well i can't help you if i don't know the error exactly, which file produces the error, what are the errorproducing lines...

[TECK]

SELECT COUNT(*) AS total FROM thread WHERE postuserid=
Post the relevant code, we will have it solved rightaway...

[HiSquad]

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.

[HiSquad]

Up

I need to know what I will do

Thanks

[TECK]

Post the query that gives you the error (use [high] bbcode to highlight it) as well 10lines above and below that query line.

[HiSquad]

Mr.TECK
Do you have any command can fix all thread because it's mooooore.

Thanks

[Xenon]

Please read the posts exactly.

we can't do anything without your php-code

Post the query that gives you the error (use [high] bbcode to highlight it) as well 10lines above and below that query line.