mySQL problemos.

[Ken]

Googlei neradau , kaip išspręsti šią problemą todėl kreipiuosi į jus .. Tiesiog pridedu server_log

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

[15:52:02] filterscripts = ""  (string)
[15:52:02] 
[15:52:02] Server Plugins
[15:52:02] --------------
[15:52:02]  Loading plugin: nativechecker.dll
[15:52:02]   Loaded.
[15:52:02]  Loading plugin: mysql.dll
[15:52:02] 

  > MySQL plugin R5 successfully loaded.

[15:52:02]   Loaded.
[15:52:02]  Loaded 2 plugins.

[15:52:02] 
[15:52:02] Filterscripts
[15:52:02] ---------------
[15:52:02]   Loaded 0 filterscripts.

[15:52:02]    Error: Function not registered: 'mysql_debug'
[15:52:02]    Error: Function not registered: 'mysql_connect'
[15:52:02]    Error: Function not registered: 'mysql_ping'
[15:52:02]    Error: Function not registered: 'mysql_close'
[15:52:02]    Error: Function not registered: 'mysql_query'
[15:52:02]    Error: Function not registered: 'mysql_store_result'
[15:52:02]    Error: Function not registered: 'mysql_num_rows'
[15:52:02]    Error: Function not registered: 'mysql_free_result'
[15:52:02]    Error: Function not registered: 'mysql_retrieve_row'
[15:52:02]    Error: Function not registered: 'mysql_fetch_field_row'
[15:52:02] PRISIJUNGIMAS PRIE MYSQL SĖKMINGAS

Redaguota Kovo 15, 2014, nario Ken

[Punk.]

Gali būti blogas pluginas, or libmysq or includas

[Zero Two]

Esi pasidaręs include <a_mysql> ?

[Ken]

Gali būti blogas pluginas, or libmysq or includas

 

Tiek pluginas, tiek libmysql , tiek includas iš BlueG , todėl einu prie išvados , todėl manyčiau , kad su jais viskas gerai :?

Esi pasidaręs include <a_mysql> ?

Žinoma!

Redaguota Kovo 15, 2014, nario Ken

[Punk.]

Parodyk mysql debugą.

[Ken]

[20:38:57] >> mysql_connect( )

[20:38:57] CMySQLHandler::CMySQLHandler() - constructor called.

[20:38:57] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "mokinuosi" | Username: "root" ...

[20:38:57] CMySQLHandler::Connect() - Connection was successful.

[20:38:57] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[20:38:57] >> mysql_ping( Connection handle: 1 )

[20:38:57] CMySQLHandler::Ping() - Connection is still alive.

[20:39:23] >> mysql_query( Connection handle: 1 )

[20:39:23] CMySQLHandler::Query(SELECT * FROM `players` WHERE `Vardas` = 'Ken_Brown') - Successfully executed.

[20:39:23] >> mysql_store_result( Connection handle: 1 )

[20:39:23] CMySQLHandler::StoreResult() - Result was stored.

[20:39:23] >> mysql_num_rows( Connection handle: 1 )

[20:39:23] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:39:23] >> mysql_free_result( Connection handle: 1 )

[20:39:23] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:39:25] >> mysql_query( Connection handle: 1 )

[20:39:25] CMySQLHandler::Query(INSERT INTO `players (Vardas,Password) VALUES ('Ken_Brown','test')) - An error has occured. (Error ID: 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 1)

[20:39:38] >> mysql_query( Connection handle: 1 )

[20:39:38] CMySQLHandler::Query(UPDATE `players` SET Pinigai = 0, Xp = 0, Darbas = 0, Hp = 0.000000 WHERE ID = 0) - Successfully executed.

Redaguota Kovo 15, 2014, nario Ken

[MartynasK]

Atsinaujink mysql failus ir atidaryk .pwn failą per tą pawno, kuriame yra include.

[Ken]

Su Sublime Text 2 dirbu dėl per ten atidarau. + Padariau , kaip sakei , bet nieko ...

Redaguota Kovo 15, 2014, nario Ken