[SOLVED] cron job error: 1064

[berry05]

Database error in vBulletin 3.8.1:

Invalid SQL:
INSERT INTO trackerhistory (`date` , `seeders`, `leechers`, `ulspeed`, `dlspeed`) VALUES (NOW(),0 , 0, , );

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 ' )' at line 1
Error Number : 1064
Request Date : Monday, March 2nd 2009 @ 12:41:00 AM
Error Date : Monday, March 2nd 2009 @ 12:41:04 AM
Script : http://www.thegamingfiles.com/adminc...cron&cronid=89
Referrer : http://www.thegamingfiles.com/adminc....php?do=modify
IP Address : ********
Username : Berry05
Classname : vB_Database
MySQL Version : 5.0.67-log

 

 

what does this mean? I have the updated mySQL and everything!!

[Mchl]

Ask vBulletin support.

This query:

INSERT INTO trackerhistory (`date` , `seeders`, `leechers`, `ulspeed`, `dlspeed`) VALUES (NOW(),0 , 0, , );

has some missing data in it (`ulspeed` and `dlspeed` values are missing)

[berry05]

i'll fill in the  `ulspeed`, `dlspeed` with 0 and see what happens from...i did ask vbulletin for help also and they told me to go to the person that made the modification but there's no help forum for the modification or anything. ill try filling in the values and see what happens

[berry05]

here's a snippet of the code that is the one that probably needs to be fixed...

 

$vbulletin->db->query_write("INSERT INTO ". TABLE_PREFIX ."trackerhistory (`date` , `seeders`, `leechers`, `ulspeed`, `dlspeed`) VALUES   (NOW(),".$row1["c"]." , ".$row1["d"].",".$row2["c"]." , ".$row2["d"].") ");	

 

could you fix that for me so the last 2 values are 0 ?

[Mchl]

$vbulletin->db->query_write("INSERT INTO ". TABLE_PREFIX ."trackerhistory (`date` , `seeders`, `leechers`, `ulspeed`, `dlspeed`) VALUES   (NOW(),".$row1["c"]." , ".$row1["d"].",0 , 0)"); 

[berry05]

duuude! your the best!!

 

 

thank you soo much!! wow ur awesome!!