![]() |
Error 1064 in MySQL
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:
|
All times are GMT. The time now is 10:03 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|