SQL Error
#1

whats with this error guys?

[22:38:47] [ERROR] CMySQLQuery::Execute[OnQueryFinish(i)] - (error #1064) 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

also with this?

[13:01:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BanMask")
[14:01:02] [ERROR] CMySQLQuery::Execute[OnQueryFinish(ii)] - (error #1064) 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 's pass is "Emma"', `Allegiance` = 1, `Bug` = 7, `Radio` = 0, `DeptRadio` = 0, `I' at line 1

[14:52:59] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage0")
[14:53:00] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage1")
[14:53:00] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage2")
[14:53:00] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage3")
[14:53:00] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Modelz")
[14:53:00] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Price")
[14:53:00] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Modelz")
Reply
#2

Because your field on MySQL is not available,you should create them first.
Reply
#3

It looks like SQL injection. At the very least it's improper escaping. And don't store passwords in plain text. If you don't know what you're doing then use a ready-made registration system.
Reply
#4

Don't use column names with numbers in - make another table.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)