NG:RP Script Help: What is this?

Harrison Khan

Active member
Joined
Jan 1, 2015
Messages
27
Reaction score
0
I use the latest version of Navicat Premium and wamp when running this script.
After the registration panel, I get this error in mysql logs:
[20:02:56] [ERROR] CMySQLQuery::Execute[OnLoadPayNSprays()] - (error #1146) Table 'database.paynsprays' doesn't exist
[20:02:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage0")
[20:02:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage1")
[20:02:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage2")
[20:02:56] [WARNING] CMySQLResult::GetRowDataByName - field not found ("dgGateFlage3")
[20:03:50] [ERROR] CMySQLQuery::Execute[OnQueryFinish(iii)] - (error #1292) Incorrect date value: '0000-00-00' for column 'BirthDate' at row 1

And here's the error I get in the samp-server.exe:
[connection] 192.168.1.102:58964 requests connection cookie.
[connection] incoming connection: 192.168.1.102:58964 id: 0
[join] Julian_Williams has joined the server (0:192.168.1.102)
[MySQL] Query Error - (ErrorID: 1292) (Handle: 1)
[MySQL] Check mysql_log.txt to review the query that threw the error.
Dumping query from 2017/6/30 (20:3:50)
Description: Incorrect date value: '0000-00-00' for column 'BirthDate' at row 1
(index 0). Query:

INSERT INTO `accounts` (`RegiDate`, `LastLogin`, `Username`, `Key`) VALUES (NOW(
), NOW(), 'Harrison_Khan','2CB979ACBD518053DBC3F2FA36934387393E5D96A8E279DB3E3
2F07A60877C988BD78F925C0D0C50DC832DD55F20799338950959D0C92863D4843ABC944FBF35')
[part] Harrison_Khan has left the server (0:1)

FYI my account has not yet been registered in game.
 

C0RE

Active member
Joined
Apr 16, 2014
Messages
36
Reaction score
0
My guess is that you haven't imported all of the tables associated with the gamemode. I /don't/ know what could be giving me that impression "Table 'database.paynsprays' doesn't exist" :thinking:
 
Top