[MYSQL][Problema Run Time Eror 19]

SaSkript · Sausio 16, 2014

Sveiki, pradėjau mokintis MYSQL ir kai paleidžiu serverį, rašo štai ką:

[19:37:46] ===============================

[19:37:46] Loaded.

[19:37:46] Loading plugin: streamer.dll

[19:37:46]

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

[19:37:46] Loaded.

[19:37:46] Loading plugin: mysql.dll

[19:37:46] >> plugin.mysql: R34 successfully loaded.

[19:37:46] Loaded.

[19:37:46] Loaded 3 plugins.

[19:37:46]

[19:37:46] Filterscripts

[19:37:46] ---------------

[19:37:46] Loaded 0 filterscripts.

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

[19:37:46] Number of vehicle models: 0

Pluginai, viskas yra gerai, tai kas čia blogai?

bebras · Sausio 16, 2014

Įsikelk "nativechecker" plugin ir parodyk tada server log.

Mano teorija kad netinkamą MySQL plugin naudoji.

SaSkript · Sausio 16, 2014

Greit atrašei, pats matau dabar :X

[19:40:49] ===============================

[19:40:49] Loaded.

[19:40:49] Loading plugin: streamer.dll

[19:40:49]

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

[19:40:49] Loaded.

[19:40:49] Loading plugin: mysql.dll

[19:40:49] >> plugin.mysql: R34 successfully loaded.

[19:40:49] Loaded.

[19:40:49] Loading plugin: nativechecker.dll

[19:40:49] Loaded.

[19:40:49] Loaded 4 plugins.

[19:40:49]

[19:40:49] Filterscripts

[19:40:49] ---------------

[19:40:49] Loaded 0 filterscripts.

[19:40:49] Error: Function not registered: 'mysql_debug'

[19:40:49] Error: Function not registered: 'mysql_ping'

[19:40:49] Error: Function not registered: 'mysql_store_result'

[19:40:49] Error: Function not registered: 'mysql_num_rows'

[19:40:49] Error: Function not registered: 'mysql_free_result'

[19:40:49] Error: Function not registered: 'mysql_fetch_int'

[19:40:49] Error: Function not registered: 'mysql_fetch_field_row'

[19:40:49] Script[gamemodes/GM.amx]: Run time error 19: "File or function is not found"

[19:40:49] Number of vehicle models: 0

Numestum link į R5 gerą pluginą? :X

bebras · Sausio 16, 2014

http://forum.sa-mp.com/showthread.php?t=56564

SaSkript · Sausio 16, 2014

Dėkoju, viskas veikia, tik problėma dar vieną:

Jei žaidėjas užsiregistruoja atsijungia ir vėl prisijungia ir vėl rašo registruotis, kame problema?

Gal tipa blogą parinkau? Koks turi būti slaptažodžio tipas?

bebras · Sausio 16, 2014

Slaptažodžio tipas Pawn'e string, MySQL duomenų bazėje VARCHAR. Daugiau apie tai čia: http://www.supergames.lt/topic/142487-pamokamysql-lenteliu-kurimas/

Parodyk server log. (Jį reikia įjungti su mysql_debug(1); )

SaSkript · Sausio 16, 2014

[19:57:55] MySQL Debugging activated (01/16/14)

[19:57:55] ---------------------------

[19:57:55]

[19:58:14] >> mysql_reconnect( Connection handle: 1 )

[19:58:14] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)

[19:58:14] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

[19:58:14] >> mysql_query( Connection handle: 1 )

[19:58:14] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[19:58:14] >> mysql_store_result( Connection handle: 1 )

[19:58:14] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[19:58:14] >> mysql_num_rows( Connection handle: 1 )

[19:58:14] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[19:58:14] >> mysql_free_result( Connection handle: 1 )

[19:58:14] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[19:58:17] >> mysql_reconnect( Connection handle: 1 )

[19:58:17] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)

[19:58:17] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

[19:58:17] >> mysql_query( Connection handle: 1 )

[19:58:17] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[19:58:20] >> mysql_query( Connection handle: 1 )

[19:58:20] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[19:58:20] >> mysql_store_result( Connection handle: 1 )

[19:58:20] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[19:58:20] >> mysql_num_rows( Connection handle: 1 )

[19:58:20] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[19:58:20] >> mysql_free_result( Connection handle: 1 )

[19:58:20] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[19:58:24] >> mysql_query( Connection handle: 1 )

[19:58:24] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[19:58:41] >> mysql_reconnect( Connection handle: 1 )

[19:58:41] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)

[19:58:41] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

[19:58:41] >> mysql_query( Connection handle: 1 )

[19:58:41] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[19:58:41] >> mysql_store_result( Connection handle: 1 )

[19:58:41] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[19:58:41] >> mysql_num_rows( Connection handle: 1 )

[19:58:41] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[19:58:41] >> mysql_free_result( Connection handle: 1 )

[19:58:41] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[19:58:45] >> mysql_reconnect( Connection handle: 1 )

[19:58:45] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)

[19:58:45] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

[19:58:45] >> mysql_query( Connection handle: 1 )

[19:58:45] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[19:58:46] >> mysql_query( Connection handle: 1 )

[19:58:46] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[19:58:46] >> mysql_store_result( Connection handle: 1 )

[19:58:46] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[19:58:46] >> mysql_num_rows( Connection handle: 1 )

[19:58:46] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[19:58:46] >> mysql_free_result( Connection handle: 1 )

[19:58:46] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[19:58:47] >> mysql_query( Connection handle: 1 )

[19:58:47] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

bebras · Sausio 16, 2014

Galėtum tą debug eilutę pridėti PRIEŠ mysql_connect, tai turėtų duoti daugiau informacijos.

Bet kaip suprantu neprisijungia prie MySQL.

SaSkript · Sausio 16, 2014

Hmm. Tai kaip ištaisyti?

#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB "duombaze"
#define TABLENAME "zaidejei"

mysql_connect(SQL_HOST, SQL_USER,SQL_DB, SQL_PASS);

bebras · Sausio 16, 2014

XAMP/WAMP pasileidžia be problemų?

SaSkript · Sausio 16, 2014

XAMP/WAMP pasileidžia be problemų?

Rašo Wamp server offline, kodėl? nors žalias :X

bebras · Sausio 16, 2014

Tikriausiai apache neįsijungia.

WAMP naudoja tą patį port kaip ir skype(80). Todėl įjungiant WAMP skype turi būti išjungtas(arba nustatymuose pažymėk kad jis nenaudotų to port).

SaSkript · Sausio 16, 2014

Tikriausiai apache neįsijungia.

WAMP naudoja tą patį port kaip ir skype(80). Todėl įjungiant WAMP skype turi būti išjungtas(arba nustatymuose pažymėk kad jis nenaudotų to port).

Aš pats radau, tai, pagooglines, skype išjungtas, perkraudinėju, same shit :X

Redaguota Sausio 16, 2014, nario SaSkript

bebras · Sausio 16, 2014

Pažiūrėk ar dirba apache, paspausk ant WAMP ikonos -> apache -> service. Jeigu ne, pabandyk paleisti paspaudęs.

SaSkript · Sausio 16, 2014

Pažiūrėk ar dirba apache, paspausk ant WAMP ikonos -> apache -> service. Jeigu ne, pabandyk paleisti paspaudęs.

Dabar rašo, kad ONLINE, tai gerai, bet:

[20:24:21] MySQL Debugging activated (01/16/14)

[20:24:21] ---------------------------

[20:24:21]

[20:27:55] >> mysql_reconnect( Connection handle: 1 )

[20:27:55] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)

[20:27:55] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

[20:27:55] >> mysql_query( Connection handle: 1 )

[20:27:55] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:27:55] >> mysql_store_result( Connection handle: 1 )

[20:27:55] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[20:27:55] >> mysql_num_rows( Connection handle: 1 )

[20:27:55] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[20:27:55] >> mysql_free_result( Connection handle: 1 )

[20:27:55] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[20:27:58] >> mysql_reconnect( Connection handle: 1 )

[20:27:58] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)

[20:27:58] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

[20:27:58] >> mysql_query( Connection handle: 1 )

[20:27:58] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:27:59] >> mysql_query( Connection handle: 1 )

[20:27:59] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:27:59] >> mysql_store_result( Connection handle: 1 )

[20:27:59] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[20:27:59] >> mysql_num_rows( Connection handle: 1 )

[20:27:59] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[20:27:59] >> mysql_free_result( Connection handle: 1 )

[20:27:59] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[20:28:05] >> mysql_query( Connection handle: 1 )

[20:28:05] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:29:21] >> mysql_reconnect( Connection handle: 1 )

[20:29:21] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)

[20:29:21] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

[20:29:21] >> mysql_query( Connection handle: 1 )

[20:29:21] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:29:21] >> mysql_store_result( Connection handle: 1 )

[20:29:21] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[20:29:21] >> mysql_num_rows( Connection handle: 1 )

[20:29:21] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[20:29:21] >> mysql_free_result( Connection handle: 1 )

[20:29:21] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[20:29:40] >> mysql_reconnect( Connection handle: 1 )

[20:29:40] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead)

[20:29:40] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

[20:29:40] >> mysql_query( Connection handle: 1 )

[20:29:40] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:29:41] >> mysql_query( Connection handle: 1 )

[20:29:41] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[20:29:41] >> mysql_store_result( Connection handle: 1 )

[20:29:41] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[20:29:41] >> mysql_num_rows( Connection handle: 1 )

[20:29:41] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[20:29:41] >> mysql_free_result( Connection handle: 1 )

[20:29:41] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[20:29:45] >> mysql_query( Connection handle: 1 )

[20:29:45] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

bebras · Sausio 16, 2014

[20:29:40] CMySQLHandler::Connect() - Unknown database 'duombaze' (Error ID: 1049)

Nėra tokios duomenų bazės..

SaSkript · Sausio 17, 2014

Nėra tokios duomenų bazės..

O tai kokia turi būti? :X

bebras · Sausio 17, 2014

Tokia, kokią sukūrei.

SaSkript · Sausio 17, 2014

Tokia, kokią sukūrei.

Supratau, tuoj pamėginsiu..

Redaguota Sausio 17, 2014, nario SaSkript

SaSkript · Sausio 17, 2014

Padėk:

[15:26:37] CMySQLHandler::Query(INSERT INTO `zaidejai` (Vardas,Slaptazodis) VALUES ('Darijus_White')) - An error has occured. (Error ID: 1136, Column count doesn't match value count at row 1)

format(query,sizeof(query),"INSERT INTO `"TABLENAME"` (Vardas,Slaptazodis) VALUES ('%s')",vardas,inputtext);

Prisijungti

[MYSQL][Problema Run Time Eror 19]

Recommended Posts

SaSkript

bebras

SaSkript

bebras

SaSkript

bebras

SaSkript

bebras

SaSkript

bebras

SaSkript

bebras

SaSkript

bebras

SaSkript

bebras

SaSkript

bebras

SaSkript

SaSkript

Šiame puslapyje naršo: 0 nariai

Skelbimai

Naujausios temos

Naujausi būsenos atnaujinimai

Nustatymai

Teksto formatavimas

Nario nuotrauka

Member

Nustatymai

Populiariausi nariai

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

Naujienos

Bendruomenė

Prisijungti

[MYSQL][Problema Run Time Eror 19]

Recommended Posts

Šiame puslapyje naršo: 0 nariai

Skelbimai

Naujausios temos

Naujausi būsenos atnaujinimai Nustatymai Teksto formatavimas Nario nuotrauka Member Išsaugoti

Nustatymai

Populiariausi nariai

Naujausi būsenos atnaujinimai

Nustatymai

Teksto formatavimas

Nario nuotrauka

Member