The Arcive of vBulletin Modifications Site. |
|
Error 1064 in MySQL Details »»
|
|||||||||||||||||||||||||
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:
[sql] UPDATE user SET yourcolumn= WHERE userid = 1; [/sql] 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: PHP Code:
Show Your Support
|
|||||||||||||||||||||||||
![]() |
|
|