MYSQL ERROR
#1

Код:
[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
Reply
#2

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.
Reply
#3

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.
Please tell me how to fix it. This is just thelast step before we are able to run the server.
Reply
#4

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.
Reply
#5

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.
Sorry man, didn't understand. Anyway, thanks.
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)