Jump to content
  • 0

Problema MYSQL


Sle|D

Question

Nick: Sle|d

Problema: de la eroarea asta nu merg multe sisteme, nu trimite in chat comenzile folosite de admin nu merge timpul jail, nu se salveaza timp online, nu te poti inregistra cu nume nou zice ca bine ai venit inapoie..chiar daca nu e inregistrat numele.. asa mai departe

Erori / warnings: [pawn]16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:39:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:39:11] [ERROR] cache_get_field_content_int - invalid datatype

[16:40:34] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[16:40:37] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[/pawn]

Lini/script: -

Ai incercat sa rezolvi singur ?: Da si nu.. da pentru ca am cauta pe sa-mp.com si alte site(uri) samp si nu pentru ca habar nu am ce sa fac..

Link to comment
Share on other sites

8 answers to this question

Recommended Posts

Ai un parametru la functia cache_get_field_content_int  gresit credca primul .

nu cred ca e primu:-j.. pai nu se salveaza conturile timp levelul(admin.vip), coins... si  cand intri cu nick nou si nu exista nu-mi da fereastra de register zice ca exista si nu merge nici-o parola(logica daca nu exista contul).. si la personal car apare unde opresc masina personal car (text 3d) si daca opresc in alt loc se adauga si nu dispare cel vechi.. la jail mai am ceva problem cu timul,

Deeeci ce lini sa postez? cu ce?

Link to comment
Share on other sites

Pai ai scris niste parametri gresiti zic eu . Daca zici ca nu se salveaza poate ai scris in baza de date ceva gresit sau nu coincid variabilele , pot sa fie de la 100 de lucruri .

EDIT: tu credca la functia cache_get_field_content_int

cache_get_field_content_int( 0, "ID", aHandle ) ;

inloc de acel 0 ai altceva "i" sau .... uitate prin script dupa aceasta functie .

Link to comment
Share on other sites

Pai ai scris niste parametri gresiti zic eu . Daca zici ca nu se salveaza poate ai scris in baza de date ceva gresit sau nu coincid variabilele , pot sa fie de la 100 de lucruri .

EDIT: tu credca la functia cache_get_field_content_int

cache_get_field_content_int( 0, "ID", aHandle ) ;

inloc de acel 0 ai altceva "i" sau .... uitate prin script dupa aceasta functie .

ceva de genu.. g_Handle

de la asta sa fie aia cu adaugata ma mir ca ai inteles:D.. si alealalte cred ca sunt de al baza de bade nu din gm.. ca am mai pus odata baza si o aparut si o comanda adaugat acum(care credeam ca nu merge) sa apara pentru admini ce comanda foloseste altul.

[pawn]SQL_Function LoadPersonalVehicleInfo( playerid )

{

    if ( !IsPlayerConnected( playerid ) )

        return ( 0 );

    new Field[ 25 ], Rows, Fields;

    cache_get_data( Rows, Fields, g_Handle );

   

    if ( Rows )

    {

        PlayerInfo[ playerid ][ CarID ] = cache_get_field_content_int( 0, "ID", g_Handle );

    PlayerInfo[ playerid ][ car_X ] = cache_get_field_content_float( 0, "Veh_LocX", g_Handle );

    PlayerInfo[ playerid ][ car_Y ] = cache_get_field_content_float( 0, "Veh_LocY", g_Handle );

    PlayerInfo[ playerid ][ car_Z ] = cache_get_field_content_float( 0, "Veh_LocZ", g_Handle );

    PlayerInfo[ playerid ][ car_A ] = cache_get_field_content_float( 0, "Veh_LocA", g_Handle );

    PlayerInfo[ playerid ][ car_Locked ] = cache_get_field_content_int( 0, "car_Locked", g_Handle );

    PlayerInfo[ playerid ][ car_color1 ] = cache_get_field_content_int( 0, "Veh_Color1", g_Handle );

    PlayerInfo[ playerid ][ car_color2 ] = cache_get_field_content_int( 0, "Veh_Color2", g_Handle );

    PlayerInfo[ playerid ][ spoilerid ]  = cache_get_field_content_int( 0, "Spoiler", g_Handle );

    PlayerInfo[ playerid ][ neonid ]    = cache_get_field_content_int( 0, "Plate", g_Handle );

    cache_get_field_content( 0, "Plate", Field, g_Handle );

    format( PlayerInfo[ playerid ][ car_plate ], 20, "%s", Field );

    PlayerInfo[ playerid ][ p_VehID ] = AddStaticVehicleEx( PlayerInfo[ playerid ][ CarID ],

                                        PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], PlayerInfo[ playerid ][ car_A ],

                                        PlayerInfo[ playerid ][ car_color1 ], PlayerInfo[ playerid ][ car_color2 ], 60 );

        format( VehicleOwner[ PlayerInfo[ playerid ][ p_VehID ] ], 25, "%s", PlayerName( playerid ) );

SetVehicleNumberPlate( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ car_plate ] );

if ( PlayerInfo[ playerid ][ neonid ] != 0 )

    OnDialogResponse( playerid, DIALOG_CAR_NEON, 1, PlayerInfo[ playerid ][ neonid ], "lol" );

if ( PlayerInfo[ playerid ][ spoilerid ] != 0 )

            AddVehicleComponent( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ spoilerid ] );

        format( gsString, 128, "%s{ec483e}  masina personala.", PlayerName( playerid ) );

Player3DVehicleLabel[ playerid ] = CreateDynamic3DTextLabel( gsString, 0x22ac38FF, PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], 20 );

    }

    return ( 1 );

}[/pawn]

Link to comment
Share on other sites

Am reincarcat baza de date.. si acum da asta:

[22:38:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] cache_get_field_content_int - invalid datatype

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] cache_get_field_content_int - invalid datatype

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] cache_get_field_content_int - invalid datatype

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] cache_get_field_content_int - invalid datatype

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] cache_get_field_content_int - invalid datatype

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] cache_get_field_content_int - invalid datatype

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] cache_get_field_content_int - invalid datatype

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[22:38:32] [ERROR] cache_get_field_content_int - invalid datatype

[23:08:43] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'STERS' in 'field list'[/pawn]

Asta incerc sa inserez.

INSERT INTO `Duels` (`ID`, `Name`, `pPos_X`, `pPos_Y`, `pPos_Z`, `pPos_A`, `pPos_X_2`, `pPos_Y_2`, `pPos_Z_2`, `pPos_A_2`) VALUES
(1, 'Duel Zone Clasic', 2402, -1162, 1173, 52, 2485, -1228, 1173, 229),

[b]Si asta este tabelul[/b]

CREATE TABLE IF NOT EXISTS `Duels` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` text NOT NULL,
  `pPos_X` int(11) NOT NULL,
  `pPos_Y` int(11) NOT NULL,
  `pPos_Z` int(11) NOT NULL,
  `pPos_A` int(11) NOT NULL,
  `pPos_X_2` int(11) NOT NULL,
  `pPos_Y_2` int(11) NOT NULL,
  `pPos_Z_2` int(11) NOT NULL,
  `pPos_A_2` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

eroare este asta:
MySQL zice: Documentație
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8


[i]
p.s am facut un drowtext in loc de "you die"(cand mori) sa apara alfel..deci cum pot sa fac asta?[/i]

Link to comment
Share on other sites

Pai la tabel din baza de date floaturile trebuie sa le pui cu Float nu cu int . Exemplu:

`Float1` float NOT NULL,
EDIT: Ti-am facut eu tabelul :
CREATE TABLE IF NOT EXISTS `duels` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(24) NOT NULL,
  `pPos_X` float NOT NULL,
  `pPos_Y` float NOT NULL,
  `pPos_Z` float NOT NULL,
  `pPos_A` float NOT NULL,
  `pPos_X_2` float NOT NULL,
  `pPos_Y_2` float NOT NULL,
  `pPos_Z_2` float NOT NULL,
  `pPos_A_2` float NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Link to comment
Share on other sites

Pai la tabel din baza de date floaturile trebuie sa le pui cu Float nu cu int . Exemplu:

`Float1` float NOT NULL,
EDIT: Ti-am facut eu tabelul :
CREATE TABLE IF NOT EXISTS `duels` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(24) NOT NULL,
  `pPos_X` float NOT NULL,
  `pPos_Y` float NOT NULL,
  `pPos_Z` float NOT NULL,
  `pPos_A` float NOT NULL,
  `pPos_X_2` float NOT NULL,
  `pPos_Y_2` float NOT NULL,
  `pPos_Z_2` float NOT NULL,
  `pPos_A_2` float NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

nu merge nici asa dar, acuma am rezolvat una din erori era ceva de la status ce stersesem si nul gasea acum nu mai apare ce nu gaseste uite:

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] cache_get_field_content_int - invalid datatype

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] cache_get_field_content_int - invalid datatype

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] cache_get_field_content_int - invalid datatype

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] cache_get_field_content_int - invalid datatype

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] cache_get_field_content_int - invalid datatype

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] cache_get_field_content_int - invalid datatype

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] cache_get_field_content_int - invalid datatype

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:20:01] [ERROR] cache_get_field_content_int - invalid datatype

[18:21:22] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:21:36] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:50] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] cache_get_field_content_int - invalid datatype

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] cache_get_field_content_int - invalid datatype

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] cache_get_field_content_int - invalid datatype

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] cache_get_field_content_int - invalid datatype

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] cache_get_field_content_int - invalid datatype

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] cache_get_field_content_int - invalid datatype

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] cache_get_field_content_int - invalid datatype

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[18:36:51] [ERROR] cache_get_field_content_int - invalid datatype

[18:39:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

[19:22:56] [ERROR] cache_get_field_content_int - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_float - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_float - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_float - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_float - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_int - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_int - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_int - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_int - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_int - invalid datatype

[19:22:56] [ERROR] cache_get_field_content_int - invalid datatype

sa descriu ceva dinter probleme pai ma conecte nu-mi da fereastra de register ci de login si nu merge nici-o parola ca nu exista contul timpul online se slveaza autoamt maxim, timpul raman cel de la "skin select" timpul la jail nu apare si multe altele...

Link to comment
Share on other sites

Topic Inchis , fara reply in ultimele 48 ore.

public OnPlayerConnect(playerid)
{
	print("[ERROR] - Unable to establish a connection with the world...");
	SendRconCommand("exit");
	return 1;
}

 

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.