Pomoc oko registracije MySQL

[Benzoylmethy]

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

[Benzoylmethy]

kad obrisem pOnline izbacuje mi errore za jos dosta tih sekcija koje treba da ispise na sql

[Benzoylmethy]

[/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]

[Benzoylmethy]

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

[Slade]

Odmah ti je ispisalo problem >

Kod [Izaberi] Proširi

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.

[Bit Frosty]

Neaktivno, lock - Za unlock PM.