Zaključano

MySQL problem

Započeo [IG] Bole
pre 7 godina
424
pregleda
4
postova
Ova tema je zaključana. Samo moderatori i administratori mogu odgovarati.
Bojan_Babic
Enforcer
pre 7 godina
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] CMySQLQuery::Execute - (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] 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] 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] CMySQLQuery::Execute[] - (error #1265) Data truncated for column 'gpci' at row 1
[21:54:17] CMySQLQuery::Execute[] - (error #1265) Data truncated for column 'pGpci' at row 1
[21:54:24] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:54:24] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:54:34] CMySQLQuery::Execute - (error #1364) Field 'bOwner' doesn't have a default value
[21:54:34] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:55:09] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:55:11] CMySQLQuery::Execute - (error #1364) Field 'hOwned' doesn't have a default value
[21:55:11] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:55:54] CMySQLQuery::Execute - (error #1364) Field 'hOwner' doesn't have a default value
[21:55:54] CMySQLQuery::Execute[] - (error #1264) Out of range value for column 'added' at row 1
[21:56:53] CMySQLQuery::Execute - (error #1364) Field 'bOwner' doesn't have a default value
[21:56:53] 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
Gospodin Leo
Enforcer
pre 7 godina
Č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.
Chezno
Enforcer
pre 7 godina
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.
Bojan_Babic
Enforcer
pre 7 godina
Sredjeno, hvala momci 🙂

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava