MYSQL klaida

[Matas Luc]

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team

[17:46:04] filterscripts = ""  (string)
[17:46:04]
[17:46:04] Server Plugins
[17:46:04] --------------
[17:46:04]  Loading plugin: streamer.dll
[17:46:04]

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

[17:46:04]   Loaded.
[17:46:04]  Loading plugin: mysql.dll
[17:46:04]

  > MySQL plugin loaded on. |

[17:46:04]   Loaded.
[17:46:04]  Loading plugin: nativechecker.dll
[17:46:04]   Loaded.
[17:46:04]  Loaded 3 plugins.

[17:46:04]
[17:46:04] Filterscripts
[17:46:04] ---------------
[17:46:04]   Loaded 0 filterscripts.

[17:46:04]    Error: Function not registered: 'mysql_retrieve_row'
[17:46:04] Script[gamemodes/gm.amx]: Run time error 19: "File or function is not found"
[17:46:04] Number of vehicle models: 0

Kaip ištaisyti šitą dalyką? nes ant MYSQL esu naujokas ir nesuprantu kas čia vyksta...

 

[Drye']

tikriausiai plugino versija nesutampa su įskiepio(include) versija.

[Matas Luc]

tikriausiai plugino versija nesutampa su įskiepio(include) versija.

taip ir buvo, tą reikalą susitvarkiau

, dabar kaip pajungiu samp-server.exe, viską užkraunna, ir jis išsijungia, serverio loguose rašo

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team

[18:03:08] filterscripts = ""  (string)
[18:03:08]
[18:03:08] Server Plugins
[18:03:08] --------------
[18:03:08]  Loading plugin: streamer.dll
[18:03:08]

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

[18:03:08]   Loaded.
[18:03:08]  Loading plugin: mysql.dll
[18:03:08]

  > MySQL plugin R6-2 successfully loaded.

[18:03:08]   Loaded.
[18:03:08]  Loading plugin: nativechecker.dll
[18:03:08]   Loaded.
[18:03:08]  Loaded 3 plugins.

[18:03:08]
[18:03:08] Filterscripts
[18:03:08] ---------------
[18:03:08]   Loaded 0 filterscripts.

[18:03:08] failai/Interiors.pwn
[18:03:08] Prisijungeme prie MySQL sekmingai!

čia kaip suprantu gerai

MYSQL debug rašo

[18:03:08] ---------------------------

[18:03:08] MySQL Debugging activated (12/15/14)

[18:03:08] ---------------------------

[18:03:08]  

[18:03:08] >> mysql_connect( )

[18:03:08] CMySQLHandler::CMySQLHandler() - constructor called.

[18:03:08] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root" ...

[18:03:08] CMySQLHandler::Connect() - Connection was successful.

[18:03:08] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[18:03:08] >> mysql_ping( Connection handle: 1 )

[18:03:08] CMySQLHandler::Ping() - Connection is still alive.

[18:03:09] >> mysql_query( Connection handle: 1 )

[18:03:09] CMySQLHandler::Query(SELECT * FROM `bussiness` WHERE `ID` = '0') - Successfully executed.

[18:03:09] >> mysql_store_result( Connection handle: 1 )

[18:03:09] CMySQLHandler::StoreResult() - Result was stored.

[18:03:09] >> mysql_retrieve_row( Connection handle: 1 )

[18:03:09] >> mysql_num_rows( Connection handle: 1 )

[18:03:09] CMySQLHandler::NumRows() - Returned 1 row(s)

[18:03:09] >> mysql_fetch_field_row( Connection handle: 1 )

čia gal kažkas ne taip?

[Explit.]

parodyk server.cfg

[Matas Luc]

parodyk server.cfg

echo Executing Server Config...
lanmode 1
rcon_password matas
maxplayers 2
port 7777
hostname Kuriamas
gamemode0 gm 1
filterscripts
announce 1
query 1
weburl www.nera.lt
maxnpc 100
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 200.0
stream_rate 1000
plugins streamer.dll mysql.dll nativechecker.dll
password baba

[bebras]

 

Įsikelk "crashdetect" ir tada parodyk server log.

 

Jei serveris išsijunginėja - reikia crashdetect. VISADA.

 

[Matas Luc]

 

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team

[20:11:57] filterscripts = ""  (string)
[20:11:57]
[20:11:57] Server Plugins
[20:11:57] --------------
[20:11:57]  Loading plugin: streamer.dll
[20:11:57]

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

[20:11:57]   Loaded.
[20:11:57]  Loading plugin: mysql.dll
[20:11:57]

  > MySQL plugin R6-2 successfully loaded.

[20:11:57]   Loaded.
[20:11:57]  Loading plugin: nativechecker.dll
[20:11:57]   Loaded.
[20:11:57]  Loading plugin: crashdetect.dll
[20:11:58]   CrashDetect must be loaded before 'streamer.dll'
[20:11:58]   Failed.
[20:11:58]  Loaded 3 plugins.

[20:11:58]
[20:11:58] Filterscripts
[20:11:58] ---------------
[20:11:58]   Loaded 0 filterscripts.

[20:11:58] failai/Interiors.pwn
[20:11:58] Prisijungeme prie MySQL sekmingai!

[bebras]

Reiškia serveris necrashina, reiškia ieškok SendRconCommand("gmx");

[Matas Luc]

Reiškia serveris necrashina, reiškia ieškok SendRconCommand("gmx");

Nėra tokio...Katik pabandžiau, be mysql pasijungia jis, tai čia mysql bėdos

[Explit.]

echo Executing Server Config...
lanmode 1
rcon_password matas
maxplayers 2
port 7777
hostname Kuriamas
gamemode0 gm 1
filterscripts
announce 1
query 1
weburl www.nera.lt
maxnpc 100
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 200.0
stream_rate 1000
plugins mysql.dll streamer.dll  nativechecker.dll
password baba

pasikeisk į šitą. ( server.cfg )