Problem(error/warning): Upload sam na gamepanel mod sa mysql radi mod, ali kad kucam neke komande naprimer za pravljenje biznisa/kuca ig nista se ne desava ostavicu dole mysql_log, na kucnom odnosno localhostu radi sve
Dio skripte: [ pawn ]
[ /pawn ]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): [ code ][21:51:56 12/26/18] [ERROR] CMySQLQuery::Execute[CreateBizzQuery] - (error #1364) Field 'bOwner' doesn't have a default value (Query: "INSERT INTO `business` (bEntranceX,bEntranceY,bEntranceZ,bType,bLevel,bPrice,bName) VALUES ('1611.929565','-2329.674804','13.546875','5','5','5000','55')")
[21:51:56 12/26/18] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1 (Query: "INSERT INTO `logs_cmd_all` (data,added) VALUES ('CMD: \'/acreatebizz 5 5 5000 55\', player: \'Luka_Babic\' [ID:0]',NOW())")
[21:53:03 12/26/18] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1 (Query: "INSERT INTO `logs_cmd_all` (data,added) VALUES ('CMD: \'/vozilo\', player: \'Luka_Babic\' [ID:0]',NOW())")
[21:54:17] [ERROR] CMySQLQuery::Execute[] - (error #1265) Data truncated for column 'gpci' at row 1
[21:54:17] [ERROR] CMySQLQuery::Execute[] - (error #1265) Data truncated for column 'pGpci' at row 1
[21:54:24] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:54:24] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:54:34] [ERROR] CMySQLQuery::Execute[CreateBizzQuery] - (error #1364) Field 'bOwner' doesn't have a default value
[21:54:34] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:55:09] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:55:11] [ERROR] CMySQLQuery::Execute[CreateHouseQuery] - (error #1364) Field 'hOwned' doesn't have a default value
[21:55:11] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:55:54] [ERROR] CMySQLQuery::Execute[CreateHouseQuery] - (error #1364) Field 'hOwner' doesn't have a default value
[21:55:54] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:56:53] [ERROR] CMySQLQuery::Execute[CreateBizzQuery] - (error #1364) Field 'bOwner' doesn't have a default value
[21:56:53] [ERROR] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[ /code ]
Slika/video ingame problema(obavezno ako je ingame problem): link slike
ÄŒitaj Å¡ta ti piÅ¡e, "Field 'bOwner' doesn't have a default value" . Postavi DEFAULT na '0/NULL' ili na koju veÄ value ti treba, možeÅ¡ u skripti ili u phpmyadmin.
Za ovo drugo bez koda možemo samo nagaÄ'ati, ostavi kod ali već ti piÅ¡e otprilike Å¡ta i di je problem.
Verovatno koristis varchar za bOwner i hOwner i stoji ti prazno. Postavi da ti po default-u bude 'None'.
Out of range value for column 'added' at row 1 - Ovde prelazis granicu kojim si definisao added.
Sredjeno, hvala momci :)