MYSQL 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: MYSQL ERROR (/showthread.php?tid=646882)
+- 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: MYSQL ERROR (/showthread.php?tid=646882)
MYSQL ERROR - JulianWilliams - 25.12.2017
Код:
[23:19:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage0")
[23:19:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage1")
[23:19:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage2")
[23:19:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage3")
[23:19:51] [ERROR] CMySQLQuery::Execute[OnQueryFinish(iii)] - (error #1292) Incorrect date value: '0000-00-00' for column 'BirthDate' at row 1
[23:40:46] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage0")
[23:40:46] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage1")
[23:40:46] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage2")
[23:40:46] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage3")
[23:41:30] [ERROR] CMySQLQuery::Execute[OnQueryFinish(iii)] - (error #1292) Incorrect date value: '0000-00-00' for column 'BirthDate' at row 1
Re: MYSQL ERROR - Ritzy2K - 25.12.2017
Doesnt looks like anything is wrong in the script from the logs.
They're all database warning and errors.
The warnings are that the fields dgGateFlag(0-3) doesn't exist, see the data type from the script (most likely, the enum) and create 3 new fields in your table.
And the error is that, the BirthDate column has an incorrect date value.
Re: MYSQL ERROR - JulianWilliams - 25.12.2017
Quote:
|
Originally Posted by Ritzy
 Doesnt looks like anything is wrong in the script from the logs.
They're all database warning and errors. The warnings are that the fields dgGateFlag(0-3) doesn't exist, see the data type from the script (most likely, the enum) and create 3 new fields in your table. And the error is that, the BirthDate column has an incorrect date value. |
Re: MYSQL ERROR - Ritzy2K - 25.12.2017
I thought I did.
Anyway, if you know the data type for dgGateFlag(0,1,2,3) then its good, else you can check it from your enum or your mysql query. (Most probably it will be integer or float.)
Then head to phpmyadmin, make the 3 fields in the corresponding table.
And you need to delete the Incorrect data for the field BirthDate (0000-00-00)
I'm not really good at explaining stuff. I hope you got me.
Re: MYSQL ERROR - JulianWilliams - 25.12.2017
Quote:
|
Originally Posted by Ritzy
I thought I did.
Anyway, if you know the data type for dgGateFlag(0,1,2,3) then its good, else you can check it from your enum or your mysql query. (Most probably it will be integer or float.) Then head to phpmyadmin, make the 3 fields in the corresponding table. And you need to delete the Incorrect data for the field BirthDate (0000-00-00) I'm not really good at explaining stuff. I hope you got me. |