GTAONLINE.PL :: Kłopot z mysql

Zaloguj się by uzyskać pełen dostęp. Nie masz jeszcze konta? Założ je już teraz w kilka sekund.

Witajcie, mam problem z gm. Ot?? przy pr?bie uruchomienia na dom?wce wyskakuj? mi errory. Poni?ej zamieszczam server_log.

Kod:

 SA-MP Dedicated Server

----------------------

v0.3.7-R2, (C)2005-2015 SA-MP Team

[17:46] filterscripts = ""  (string)

[17:46] 

[17:46] Server Plugins

[17:46] --------------

[17:46]  Loading plugin: mysql.dll

[17:46]  >> plugin.mysql: R39-5 successfully loaded.

[17:46]   Loaded.

[17:46]  Loading plugin: crashdetect.dll

[17:46]   CrashDetect v4.15.1 is OK.

[17:46]   Loaded.

[17:46]  Loading plugin: sscanf.dll

[17:46] 

[17:46]  ===============================

[17:46]       sscanf plugin loaded.     

[17:46]          Version:  2.8.2        

[17:46]    (c) 2012 Alex "Y_Less" Cole  

[17:46]  ===============================

[17:46]   Loaded.

[17:46]  Loading plugin: whirpool.dll

[17:46]   Failed.

[17:46]  Loading plugin: streamer.dll

[17:46] 

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[17:46]   Loaded.

[17:46]  Loading plugin: audio.dll

[17:46] 

*** Audio Plugin v0.5 R2 by Incognito loaded ***

[17:46]   Loaded.

[17:46]  Loading plugin: timerfix.dll

[17:46]   >> TimerFix v1.5 successfully loaded.

[17:46]   Loaded.

[17:46]  Loaded 6 plugins.

[17:46] 

[17:46] Filterscripts

[17:46] ---------------

[17:46]   Loaded 0 filterscripts.

[17:46] [debug] Run time error 19: "File or function is not found"

[17:46] [debug]  mysql_store_result

[17:46] [debug]  mysql_num_rows

[17:46] [debug]  mysql_free_result

[17:46] [debug]  mysql_fetch_row

[17:46] [debug]  mysql_fetch_field

[17:46] [debug]  mysql_init

[17:46] [debug] Run time error 19: "File or function is not found"

[17:46] [debug]  mysql_store_result

[17:46] [debug]  mysql_num_rows

[17:46] [debug]  mysql_free_result

[17:46] [debug]  mysql_fetch_row

[17:46] [debug]  mysql_fetch_field

[17:46] [debug]  mysql_init

[17:46] Script[gamemodes/test.amx]: Run time error 19: "File or function is not found"

[17:46] Number of vehicle models: 0

Posiadasz z?y plugin, gdy? u?ywasz pluginu od BlueG/maddinat0r'a a skrypt u?ywa funkcji, kt?re posiada plugin StrickenKid'a.

Dzia?a, ale nie tworzy tabel:

Kod:

SA-MP Dedicated Server

----------------------

v0.3.7-R2, (C)2005-2015 SA-MP Team

[18:51] filterscripts = ""  (string)

[18:51] 

[18:51] Server Plugins

[18:51] --------------

[18:51]  Loading plugin: mysql.dll

[18:51]  SA:MP MySQL Plugin v2.1.1 Loaded.

[18:51]   Loaded.

[18:51] [MySQL] Thread running. Threadsafe: Yes.

[18:51]  Loading plugin: crashdetect.dll

[18:51]   CrashDetect v4.15.1 is OK.

[18:51]   Loaded.

[18:51]  Loading plugin: sscanf.dll

[18:51] 

[18:51]  ===============================

[18:51]       sscanf plugin loaded.     

[18:51]          Version:  2.8.2        

[18:51]    (c) 2012 Alex "Y_Less" Cole  

[18:51]  ===============================

[18:51]   Loaded.

[18:51]  Loading plugin: whirpool.dll

[18:51]   Failed.

[18:51]  Loading plugin: streamer.dll

[18:51] 

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[18:51]   Loaded.

[18:51]  Loading plugin: audio.dll

[18:51] 

*** Audio Plugin v0.5 R2 by Incognito loaded ***

[18:51]   Loaded.

[18:51]  Loading plugin: timerfix.dll

[18:51]   >> TimerFix v1.5 successfully loaded.

[18:51]   Loaded.

[18:51]  Loaded 6 plugins.

[18:51] 

[18:51] Filterscripts

[18:51] ---------------

[18:51]   Loaded 0 filterscripts.

[18:52] [MySQL] Connected (0) to 'samp14815'@'s4.servhost.pl via TCP/IP'.

[18:52] [MySQL] Server Version 5.1.73-1+deb6u1.

[18:52] [MySQL] Error (0): Failed to exeute query. Table 'samp14815.Ustawienia' doesn't exist.

[18:52] [MySQL] Error (0): Failed to exeute query. Table 'samp14815.Ustawienia' doesn't exist.

[18:52] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp14815.Ustawienia' doesn't exist.

[18:52] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp14815.Ustawienia' doesn't exist.

[18:52] Wczytano: 0 Kont, 0 Wej??, 0 Kick?w, 0 Ban?w z ustawie?

[18:52] [MySQL] Error (0): Failed to exeute query. Table 'samp14815.PojazdyGraczy' doesn't exist.

[18:52] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp14815.PojazdyGraczy' doesn't exist.

[18:52] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp14815.PojazdyGraczy' doesn't exist.

[18:52] Naliczono 1 pcar, zmienna 'i' wynosci: 1

[18:52] [MySQL] Error (0): Failed to exeute query. Table 'samp14815.Gracze' doesn't exist.

[18:52] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp14815.Gracze' doesn't exist.

[18:52] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp14815.Gracze' doesn't exist.

[18:52] Naliczono 1 UIDPLAYER, zmienna 'i' wynosci: 1

[18:52] [debug] Run time error 5: "Invalid memory access"

[18:52] [debug] AMX backtrace:

[18:52] [debug] #0 0000b828 in   (17774996, 180000, 1) from RealTruck2016.amx

[18:52] [debug] #1 0000004b in public zcmd_OnGameModeInit () from RealTruck2016.amx

[18:52] [debug] #2 native CallLocalFunction () from samp-server.exe

[18:52] [debug] #3 00000320 in public OnGameModeInit () from RealTruck2016.amx

[18:52] Number of vehicle models: 0

Przyk?adowy kod gdzie powinno stworzy? tabel?:

Pawn

new StringUsers[800];
        strcat(StringUsers, "CREATE TABLE IF NOT EXISTS Gracze (");
        strcat(StringUsers, "Nick VARCHAR(40),");
        strcat(StringUsers, "Haslo VARCHAR(40),");
        strcat(StringUsers, "Score INT(10),");
        strcat(StringUsers, "Kasa INT(10),");
        strcat(StringUsers, "Dostarczen INT(10),");
        strcat(StringUsers, "Sila INT(10),");
        strcat(StringUsers, "Skin INT(10),");
        strcat(StringUsers, "PozycjaX FLOAT(10),");
        strcat(StringUsers, "PozycjaY FLOAT(10),");
        strcat(StringUsers, "PozycjaZ FLOAT(10),");
        strcat(StringUsers, "PozycjaR FLOAT(10),");
        strcat(StringUsers, "Glod INT(10),");
        strcat(StringUsers, "Sen INT(10),");
        strcat(StringUsers, "DMG FLOAT(10),");
        strcat(StringUsers, "Poziom INT(10),");
        strcat(StringUsers, "Opis VARCHAR(64),");
        strcat(StringUsers, "Online INT(10),");
        strcat(StringUsers, "Gwiazdki INT(10),");
        strcat(StringUsers, "PrawoJazdyA INT(10),");
        strcat(StringUsers, "PrawoJazdyB INT(10),");
        strcat(StringUsers, "PrawoJazdyC INT(10),");
        strcat(StringUsers, "Health FLOAT(10),");
        strcat(StringUsers, "Armour FLOAT(10),");
        strcat(StringUsers, "CzasPracy INT(10),");
        strcat(StringUsers, "PremiumPoints INT(10),");
        strcat(StringUsers, "KartaWedkarska INT(10),");
        strcat(StringUsers, "Bank INT(10),");
        strcat(StringUsers, "Pozyczka INT(10),");
        strcat(StringUsers, "UstalonaSplata INT(10),");
        strcat(StringUsers, "Ranga INT(10))");
        mysql_query(StringUsers);

"MasterCard" napisał/a:

[MySQL] Error (0): Failed to exeute query. Table 'samp14815.Ustawienia' doesn't exist.

"MasterCard" napisał/a:

[MySQL] Error (0): Failed to exeute query. Table 'samp14815.PojazdyGraczy' doesn't exist.

Poda?e? kod do stworzenia tabeli Gracze, potrzebne s? jeszcze inne tabele.

"MasterCard" napisał/a:

new?StringUsers[800] = "CREATE?TABLE?IF?NOT?EXISTS?Gracze?(";

??????strcat(StringUsers,?"Nick?VARCHAR(40),");

??????strcat(StringUsers,?"Haslo?VARCHAR(40),");

??????strcat(StringUsers,?"Score?INT(10),");

??????strcat(StringUsers,?"Kasa?INT(10),");

??????strcat(StringUsers,?"Dostarczen?INT(10),");

??????strcat(StringUsers,?"Sila?INT(10),");

??????strcat(StringUsers,?"Skin?INT(10),");

??????strcat(StringUsers,?"PozycjaX?FLOAT(10),");

??????strcat(StringUsers,?"PozycjaY?FLOAT(10),");

??????strcat(StringUsers,?"PozycjaZ?FLOAT(10),");

??????strcat(StringUsers,?"PozycjaR?FLOAT(10),");

??????strcat(StringUsers,?"Glod?INT(10),");

??????strcat(StringUsers,?"Sen?INT(10),");

??????strcat(StringUsers,?"DMG?FLOAT(10),");

??????strcat(StringUsers,?"Poziom?INT(10),");

??????strcat(StringUsers,?"Opis?VARCHAR(64),");

??????strcat(StringUsers,?"Online?INT(10),");

??????strcat(StringUsers,?"Gwiazdki?INT(10),");

??????strcat(StringUsers,?"PrawoJazdyA?INT(10),");

??????strcat(StringUsers,?"PrawoJazdyB?INT(10),");

??????strcat(StringUsers,?"PrawoJazdyC?INT(10),");

??????strcat(StringUsers,?"Health?FLOAT(10),");

??????strcat(StringUsers,?"Armour?FLOAT(10),");

??????strcat(StringUsers,?"CzasPracy?INT(10),");

??????strcat(StringUsers,?"PremiumPoints?INT(10),");

??????strcat(StringUsers,?"KartaWedkarska?INT(10),");

??????strcat(StringUsers,?"Bank?INT(10),");

??????strcat(StringUsers,?"Pozyczka?INT(10),");

??????strcat(StringUsers,?"UstalonaSplata?INT(10),");

??????strcat(StringUsers,?"Ranga?INT(10))");

??????mysql_query(StringUsers);