SQL Error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL Error (/showthread.php?tid=634340)

---

SQL Error - kapwa02 - 17.05.2017

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")

---

Re: SQL Error - Fairuz - 17.05.2017

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

---

Re: SQL Error - Vince - 17.05.2017

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.

---

Re: SQL Error - OneDay - 17.05.2017

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

---