[Slawiii]

i m mfind this errors in server_logs

PHP код:

[01:07:52] errorid: 1136 | error: Column count doesn't match value count at row 1 | resultid: -1 | extraid: -1 | callback: NULL | query: INSERT INTO `Accounts` (`Key`,`Name`,`IP`,`Password`,`RegisterDate`,`LoggedIn`,`Level`,`Vip`,`rVip`,`LastOn`,`Cash`,`Score`,`Kills`,`Deaths`,`Online`,`Rank`,`BestKillings`,`KillingSpree`,`Drugs`,`TimesOnServer`,`Coins`,`SAdmin`,`FavSkin`,`UseSkin`,`Description1`,`Description2`,Description3,`Positive`,`Negative`,`Clan`,`ClanRank`,`E-Mail`,`ClanPoints`,`ClanDeaths`,`ClanOnline`,`ClanJoined`,`Kicks`, `Bans`,`Jails`,`Warns`,`ClearChats`,`ReactionTest`,`MathTest`,`Mutes`,`ARatio`,`Property`,`Jailed`,`JailTime`,`Frozen`,`FreezeTime`,`RAdmin`,`ChatColor`,`DriftScore`,`DuelScore`,`vSpawn_X`,`vSpawn_Y`,`vSpawn_Z`,`vSpawn_A`,`Offer_ID`,`TopOnline`,`AdminWarns`,`OwnedCarID`, `Cookies`, `Cakes`, `Biscuits`, `Icecreams`) VALUES(0, '[xB]Slawi', '105.156.204.91', '74DFC2B27ACFA364DA55F93A5CAEE29CCAD3557247EDA238831B3E9BD931B01D77FE994E4F12B9D4CFA92A124461D2065197D8CF7F33FC88566DA2DB2A4D6EAE', '2015-6-22', '1', '0', '0', '0', '2015-6-22', '500', '0', '0', '0', '00:00:00', '0', '0', '0', '0', '1', '0', '0', 0, 0, ' ', ' ', ' ', 0, 0, 'None', 0, ' ', 0,0,'0:0:0','None', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '00:00', 0, '00:00', 0, '0xFFFFFFFF', 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0) 


Pleaz how to Fix it


Register Dialog script:

PHP код:

        case RegDialog:
        {
            if ( !response )
                return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, "{FFFFFF}Register {FF0000}Failed !", "{FF0000}ERROR:\n\n{FFFFFF}You must obligatory register your account!", "Register", "" );
            new
                rPassword[ 25 ]
            ;
            if ( sscanf( inputtext, "s[25]", rPassword ) )
                return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, "{FFFFFF}Register {FF0000}Failed !", "{FFFFFF}You must type a password if you want to register!", "Register", "" );
            if ( strlen( rPassword ) < 6 || strlen( rPassword ) > 25 )
                return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, "{FFFFFF}Register {FF0000}Failed !", "{FFFFFF}The password must be between 6 and 24 characters!", "Register", "" );
            new Buf[ 129 ];
            WP_Hash( Buf, 129, rPassword );
            mysql_real_escape_string( Buf, Buf );
            new
                liYear,
                liMonth,
                liDay,
                pNaMe[ 25 ]
            ;
            getdate( liYear, liMonth, liDay );
            GetPlayerName( playerid, pNaMe, 25 );
            mysql_real_escape_string( pNaMe, pNaMe );
            gsString[ 0 ] = EOS;
            format( gsString, sizeof gsString, "INSERT INTO `Accounts` (`Key`,`Name`,`IP`,`Password`,`RegisterDate`,`LoggedIn`,`Level`,`Vip`,`rVip`,`LastOn`,`Cash`,`Score`,`Kills`,\
                                                `Deaths`,`Online`,`Rank`,`BestKillings`,`KillingSpree`,`Drugs`,`TimesOnServer`,`Coins`,`SAdmin`,`FavSkin`,`UseSkin`,`Description1`,`Description2`,Description3," );
            format( gsString, sizeof gsString, "%s`Positive`,`Negative`,`Clan`,`ClanRank`,`E-Mail`,`ClanPoints`,`ClanDeaths`,`ClanOnline`,`ClanJoined`,`Kicks`, \
                                                `Bans`,`Jails`,`Warns`,`ClearChats`,`ReactionTest`,`MathTest`,`Mutes`,`ARatio`,`Property`,`Jailed`,`JailTime`,`Frozen`,`FreezeTime`,`RAdmin`,`ChatColor`,", gsString );
            format( gsString, sizeof gsString, "%s`DriftScore`,`DuelScore`,`vSpawn_X`,`vSpawn_Y`,`vSpawn_Z`,`vSpawn_A`,`Offer_ID`,`TopOnline`,`AdminWarns`,`OwnedCarID`, `Cookies`, `Cakes`, `Biscuits`, `Icecreams`)", gsString );
            format( gsString, sizeof gsString, "%s VALUES(0, '%s', '%s', '%s', '%d-%d-%d', '1', '0', '0', '0', '%d-%d-%d', '500', \
                                                           '0', '0', '0', '00:00:00', '0', '0', '0', '0', '1', '0', '0', \
                                                             0, 0, ' ', ' ', ' ', 0, 0, 'None', 0, ' ', 0", gsString, pNaMe, GetPlayerIPEx( playerid ), Buf, liYear, liMonth, liDay, liYear, liMonth, liDay );
            format( gsString, sizeof( gsString ), "%s,0,'0:0:0','None', 0, 0, 0, 0, 0, 0, 0, \
                                                   0, 0, 0, 0, '00:00', 0, '00:00', 0, '0xFFFFFFFF', \
                                                   0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0)", gsString );
            mysql_query( gsString );
            PlayerInfo[ playerid ][ AccID ] = mysql_insert_id( );
            format( gsString, 144, "INFO: {FF0000}%s {FFFFFF}Has registred on server, making have {FF0000}%s {FFFFFF}registred players on server!", PlayerName( playerid ), FormatNumber( PlayerInfo[ playerid ][ AccID ] ) );
            SendClientMessageToAll( COLOR_YELLOW, gsString );
            ShowPlayerDialog( playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "{FF0000}#2 {FFFFFF}Type your E-Mail", "{FFFFFF}Ok, now the last step before you can play on our server.\n\
                                                                                                                  {00FF00}Please enter your e-mail adress !\n\n\
                                                                                                                  {FFFFFF}Why we need your e-mail adress? Because if you loose your password\n\
                                                                                                                  you can change it by press '{00FF00}Recover Password{FFFFFF}'\n\
                                                                                                                  on Player Control Panel at {FF0000}www.omp-samp.tk/pcp", "Enter", "" );
            PlayerInfo[ playerid ][ LoggedIn ] = 1;
            GivePlayerMoney( playerid, 500 );
            return 1;
        } 


Pleaz help

[Slawiii]

Pleaz help !

[!damo!spiderman]

The errors means that you have either more column defines than you do values or the other way around, and it's no wonder either... you have so many columns defined, its so messy plus most of them could be set as default values in your mysql table define so then you don't have to have such long query messages.

[Slawiii]

ok thank you Bro Fixed !