filburt1
06-10-2003, 12:19 PM
Error 1064 in MySQL is a syntax error. 99% of the time it is caused by a badly written hack such that it tries to assign nothing to a column, but still specifies the column. For example, the bold part of the query below is the problem:
UPDATE user SET yourcolumn= WHERE userid = 1;
If you wrote the hack, then make sure that whatever variable to which you're assigning yourcolumn is not empty. Also, in PHP, a boolean with a value of false evals to an empty string instead of 0. To get around this, do this:
$tempval = intval($originalval);
$DB_site->query("UPDATE user SET yourcolumn = $tempval WHERE userid = 1");
If you didn't write the hack and still don't understand, ask the hacker in his or her hack support thread.
UPDATE user SET yourcolumn= WHERE userid = 1;
If you wrote the hack, then make sure that whatever variable to which you're assigning yourcolumn is not empty. Also, in PHP, a boolean with a value of false evals to an empty string instead of 0. To get around this, do this:
$tempval = intval($originalval);
$DB_site->query("UPDATE user SET yourcolumn = $tempval WHERE userid = 1");
If you didn't write the hack and still don't understand, ask the hacker in his or her hack support thread.