Problem(error/warning): Kada pokusam da se registrujem nista se ne desava, mod je mysql.
Deo skripte: [pawn] ako treba nesto napisite mi[/pawn]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): [pawn][21:10:29] [plugins/mysql] cache_delete: invalid cache id '0'
[21:10:41] [plugins/mysql] error #1364 while executing query "INSERT INTO `user` SET `pName`='Benzoylmethy', `pPassword`='password ispise', `pSex`=1, `pRegDate`=NOW(), `pLastLogin`=NOW(), `pSkinID`=23, `pIP`='nebitno ovde ispise ip'": Field 'pOnline' doesn't have a default value
/pawn]
Slika/video ingame problema(obavezno ako je ingame problem): link slike
kad obrisem pOnline izbacuje mi errore za jos dosta tih sekcija koje treba da ispise na sql
[/b] [pawn]CREATE TABLE `user` (
`pID` int(11) NOT NULL,
`pName` varchar(24) NOT NULL,
`pIP` varchar(16) NOT NULL,
`pPassword` varchar(65) NOT NULL,
`pSex` tinyint(1) NOT NULL,
`pRegDate` datetime NOT NULL,
`pLastLogin` datetime NOT NULL,
`pOnline` tinyint(1) NOT NULL,
`pHours` int(11) NOT NULL,
`pMinutes` int(11) NOT NULL,
`pAdmin` int(11) NOT NULL,
`pAdminCode` int(11) NOT NULL,
`pPremium` tinyint(1) NOT NULL,
`pPremiumHours` int(11) NOT NULL,
`pJail` int(11) NOT NULL,
`pJailReason` varchar(16) NOT NULL,
`pMute` int(11) NOT NULL,
`pMuteReason` varchar(16) NOT NULL,
`pWarn` int(11) NOT NULL,
`pSkinID` int(11) NOT NULL,
`pKills` int(11) NOT NULL,
`pDeaths` int(11) NOT NULL,
`pMaxKS` int(11) NOT NULL,
`pMoney` int(11) NOT NULL,
`pDayKills` int(11) NOT NULL,
`pDayDeaths` int(11) NOT NULL,
`pDayWins` int(11) NOT NULL,
`pMonthKills` int(11) NOT NULL,
`pMonthDeaths` int(11) NOT NULL,
`pMonthWins` int(11) NOT NULL,
`pRank` int(11) NOT NULL DEFAULT '-1',
`pArenaKills` int(11) NOT NULL,
`pArenaDeaths` int(11) NOT NULL,
`pDuelWins` int(11) NOT NULL,
`pDuelDefeats` int(11) NOT NULL,
`pVersusWins` int(11) NOT NULL,
`pVersusDefeats` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/pawn]
Fixao sam to sad izlazi ovo [15:43:36] [plugins/mysql] mysql_format: destination size '155' is too small
[15:43:36] [plugins/mysql] error #1065 while executing query "": Query was empty
Odmah ti je ispisalo problem > Field 'pOnline' doesn't have a default value
Ja imam praksu uglavnom da podesim na neke stvari koje nemam ili je nepotrebno da saljem u queryu putem inserta da imaju default value i u tom slucaju ce ti se prilikom inserta upisati default value. A ti ga nemas za polje pOnline, a u Queryu ne saljes to polje.
Uz to imas NOT NULL u kolonama sto oznacava da tvoje polje ne moze nikada biti null, a buduci da ga prilikom inserta ne saljes, biti ce null i dobit ces error u queryu.
Sto se tice ove zadnje poruke, opet ti pise: error #1065 while executing query "": Query was empty, poslao si prazan query.
Neaktivno, lock - Za unlock PM.