Database error with vb 3.0.7

[all-the-vb]

YUSIF
اها فهمت قصدك.

ابحث عن:

PHP Code:

if($bbuserinfo[userid]!=0 and $post[userid] !=0){ 
  $usertherd = $DB_site->query_first("SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=$post[userid] "); 
        $usertherdcoun = $usertherd[total]; 
        $userpostdcoun = $post[posts] - $usertherdcoun ; 
} 


واستبدله بي:

PHP Code:

if($post[userid] !=0){ 
  $usertherd = $DB_site->query_first("SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=$post[userid] "); 
        $usertherdcoun = $usertherd[total]; 
        $userpostdcoun = $post[posts] - $usertherdcoun ; 
} 


[Marco van Herwaarden]

@all-the-vb

Could you please continue support in the public threads in English.

[YUSIF]

salam all-the-vb

even this didn't help still get wrong number in posts field with (-)

maybe i should remove all this hack if its unpossible to fix it

waiting from you

[index]

Hi All,



am getting like this error:

PHP Code:

<!--
Database error in Board 3.0.7:

Invalid SQL: 
        SELECT * FROM cpsession
        WHERE userid = 
            AND hash = 'cd3c00bcde427656daf2825b0c98cfc3'
            AND dateline &gt; 1118232464
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 'AND hash = 'cd3c00bcde427656daf2825b0c98cfc3'
            AND dateline 

mysql error number: 1064

Date: Wednesday 08th of June 2005 04:07:44 PM
Script: http://............com/vb/admincp/
Referer: 
IP Address:########
 --> 


can anyone help me guyz :S

Thanks a lot