Balkan SA:MP

PAWN skriptanje, gamemodovi, filterskripte, include fajlovi, mape, pluginovi => Razgovor u vezi PAWN - skriptanja => Temu započeo: [IG] Bole poslato Decembar 27, 2018, 00:44:56 PRE PODNE

Naslov: MySQL problem
Poruka od: [IG] Bole poslato Decembar 27, 2018, 00:44:56 PRE PODNE
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
Naslov: Odg: MySQL problem
Poruka od: L3o poslato Decembar 27, 2018, 00:49:33 PRE PODNE
Č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.
Naslov: Odg: MySQL problem
Poruka od: lucius poslato Decembar 27, 2018, 15:09:40 POSLE PODNE
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.
Naslov: Odg: MySQL problem
Poruka od: [IG] Bole poslato Decembar 27, 2018, 15:46:54 POSLE PODNE
Sredjeno, hvala momci :)