Szerző Téma: Mysql plugin gond (Megtekintve 791 alkalommal)

Stallion · « **Dátum:** 2015. július 13. - 22:12:39 »

Jo estet kivanok!

Akadt egy problemam. Vps-re valtottam (Lynx).

Azelott a mod mysql R6 pluginnal futott, most pedig a vps-en nem hajlando futni R6-al csak is R5-el.

Problema pedig az hogy emiatt a mod leall naponta 2x 3x.

Keresgeltem pluginokat de semmi csak is ezzel hajlando futni (R5).

Vps elott nem volt ilyen gond hogy leallt volna a mod.

Legyszives segitsetek ebben koszonom.

Dupla hozzászólás automatikusan összefûzve. ( 2015. július 14. - 15:26:28 )

Valakinek valami otlet?

ZyZu. · « **Válasz #1 Dátum:** 2015. július 14. - 19:38:20 »

MySQL hibanapló bekapcsolva? Ha igen és van akkor másold be az egészet kérlek kód taggal.

Stallion · « **Válasz #2 Dátum:** 2015. július 14. - 20:04:51 »

Nem volt bekapcsolva mostanaig amint leall a mod bemasolom kod taggal.

ZyZu. · « **Válasz #3 Dátum:** 2015. július 14. - 20:20:44 »

Idézetet írta: Stallion date=1436897091\" data-ipsquote-contentapp=\"forums\" data-ipsquote-contenttype=\"forums\" data-ipsquote-contentid=\"55151\" data-ipsquote-contentclass=\"forums_Topic

Nem volt bekapcsolva mostanaig amint leall a mod bemasolom kod taggal.

Próbáld bekapcsolni, majd másold be a server_log fájlt is.

Stallion · « **Válasz #4 Dátum:** 2015. július 15. - 00:59:23 »

Bekapcsoltam ha a mysql_debug-ra ertetted, de abbol lett egy 100mb-os txt.

[23:50:53] CMySQLHandler::Query(SELECT `pisi` FROM `players` WHERE `name`=\'Attila_Father\') - Successfully executed.
[23:50:53] >> mysql_store_result( Connection handle: 1 )
[23:50:53] CMySQLHandler::StoreResult() - Result was stored.
[23:50:53] >> mysql_fetch_int( Connection handle: 1 )
[23:50:53] CMySQLHandler::FetchRow() - Return: 4
[23:50:53] >> mysql_free_result( Connection handle: 1 )
[23:50:53] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[23:50:53] >> mysql_query( Connection handle: 1 )
[23:50:53] CMySQLHandler::Query(SELECT `pisi` FROM `players` WHERE `name`=\'Attila_Father\') - Successfully executed.
[23:50:53] >> mysql_store_result( Connection handle: 1 )
[23:50:53] CMySQLHandler::StoreResult() - Result was stored.
[23:50:53] >> mysql_fetch_int( Connection handle: 1 )
[23:50:53] CMySQLHandler::FetchRow() - Return: 4
[23:50:53] >> mysql_free_result( Connection handle: 1 )
[23:50:53] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[23:50:53] >> mysql_query( Connection handle: 1 )
[23:50:53] CMySQLHandler::Query(UPDATE `players` SET `pisi`=\'5\' WHERE `name`=\'Attila_Father\') - Successfully executed.
[23:50:53] >> mysql_query( Connection handle: 1 )
[23:50:53] CMySQLHandler::Query(SELECT `pisi` FROM `players` WHERE `name`=\'Attila_Father\') - Successfully executed.
[23:50:53] >> mysql_store_result( Connection handle: 1 )
[23:50:53] CMySQLHandler::StoreResult() - Result was stored.
[23:50:53] >> mysql_fetch_int( Connection handle: 1 )
[23:50:53] CMySQLHandler::FetchRow() - Return: 5
[23:50:53] >> mysql_free_result( Connection handle: 1 )
[23:50:53] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[23:50:53] >> mysql_query( Connection handle: 1 )
[23:50:53] CMySQLHandler::Query(SELECT `pisi` FROM `players` WHERE `name`=\'Attila_Father\') - Successfully executed.
[23:50:53] >> mysql_store_result( Connection handle: 1 )
[23:50:53] CMySQLHandler::StoreResult() - Result was stored.
[23:50:53] >> mysql_fetch_int( Connection handle: 1 )
[23:50:53] CMySQLHandler::FetchRow() - Return: 5
[23:50:53] >> mysql_free_result( Connection handle: 1 )
[23:50:53] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[23:50:54] >> mysql_real_escape_string( Connection handle: 1 )
[23:50:54] CMySQLHandler::EscapeString(Slot: 10 | Tüzhely | 1 db | 2.0000 kg); - Escaped 37 characters to Slot: 10 | Tüzhely | 1 db | 2.0000 kg.
[23:50:56] >> mysql_real_escape_string( Connection handle: 1 )
[23:50:56] CMySQLHandler::EscapeString(Tárgyak); - Escaped 7 characters to Tárgyak.
[23:50:56] >> mysql_query( Connection handle: 1 )
[23:50:56] CMySQLHandler::Query(SELECT  `inventory`.`itemid` ,  `invname`.`name` , SUM(  `inventory`.`amount` ), SUM( `invname`.`weight` * `inventory`.`amount` ) FROM  `inventory` ,  `invname` WHERE  `inventory`.`pname` =\'Demeter_Jozsef\' AND  `invname`.`itemid` =  `inventory`.`itemid` GROUP BY  `inventory`.`itemid` ASC HAVING SUM(  `inventory`.`amount` ) >0 LIMIT 0, 10) - Successfully executed.
[23:50:56] >> mysql_store_result( Connection handle: 1 )
[23:50:56] CMySQLHandler::StoreResult() - Result was stored.
[23:50:56] >> mysql_num_rows( Connection handle: 1 )
[23:50:56] CMySQLHandler::NumRows() - Returned 8 row(s)
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:56] CMySQLHandler::FetchRow() - Return: 9|Cigaretta|2|0.0020000000949949026
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:56] CMySQLHandler::FetchRow() - Return: 10|Öngyújtó|1|0.029999999329447746
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:56] CMySQLHandler::FetchRow() - Return: 27|Normál szemüveg|1|0.10000000149011612
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:56] CMySQLHandler::FetchRow() - Return: 31|Fekete szemüveg|1|0.10000000149011612
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:56] CMySQLHandler::FetchRow() - Return: 50|Sárga sapi|1|0.09000000357627869
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:56] CMySQLHandler::FetchRow() - Return: 529|Fa szék|2|2
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:56] CMySQLHandler::FetchRow() - Return: 824|Desert Eagle|1|2
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:56] CMySQLHandler::FetchRow() - Return: 924|Desert Eagle töltény|77|0
[23:50:56] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:57] >> mysql_real_escape_string( Connection handle: 1 )
[23:50:57] CMySQLHandler::EscapeString(Slot: 5 | Fa szék | 2 db | 2.0000 kg); - Escaped 36 characters to Slot: 5 | Fa szék | 2 db | 2.0000 kg.
[23:50:57] >> mysql_query( Connection handle: 1 )
[23:50:57] CMySQLHandler::Query(SELECT `inventory`.`itemid` ,  `invname`.`name` , `invname`.`objecte`, SUM(  `inventory`.`amount` ) FROM  `inventory` ,  `invname` WHERE  `inventory`.`pname` =\'Demeter_Jozsef\' AND  `invname`.`itemid` =  `inventory`.`itemid` GROUP BY  `inventory`.`itemid` ASC HAVING SUM(  `inventory`.`amount` ) >0 LIMIT 0, 10) - Successfully executed.
[23:50:57] >> mysql_store_result( Connection handle: 1 )
[23:50:57] CMySQLHandler::StoreResult() - Result was stored.
[23:50:57] >> mysql_num_rows( Connection handle: 1 )
[23:50:57] CMySQLHandler::NumRows() - Returned 8 row(s)
[23:50:57] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:57] CMySQLHandler::FetchRow() - Return: 9|Cigaretta|0|2
[23:50:57] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:57] CMySQLHandler::FetchRow() - Return: 10|Öngyújtó|0|1
[23:50:57] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:57] CMySQLHandler::FetchRow() - Return: 27|Normál szemüveg|0|1
[23:50:57] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:57] CMySQLHandler::FetchRow() - Return: 31|Fekete szemüveg|0|1
[23:50:57] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:57] CMySQLHandler::FetchRow() - Return: 50|Sárga sapi|0|1
[23:50:57] >> mysql_fetch_row_format( Connection handle: 1 )
[23:50:57] CMySQLHandler::FetchRow() - Return: 529|Fa szék|2309|2
[23:50:57] >> mysql_query( Connection handle: 1 )
[23:50:57] CMySQLHandler::Query(SELECT `id` FROM `serveritems` WHERE `id`=\'1\') - Successfully executed.
[23:50:57] >> mysql_store_result( Connection handle: 1 )
[23:50:57] CMySQLHandler::StoreResult() - Result was stored.
[23:50:57] >> mysql_num_rows( Connection handle: 1 )
[23:50:57] CMySQLHandler::NumRows() - Returned 1 row(s)
[23:50:57] >> mysql_query( Connection handle: 1 )
innen kivagtam eleg sok dolgot a serveritems-bol
[23:51:37] CMySQLHandler::Query(SELECT `id` FROM `serveritems` WHERE `id`=\'881\') - Successfully executed.
[23:51:37] >> mysql_store_result( Connection handle: 1 )
[23:51:37] CMySQLHandler::StoreResult() - Result was stored.
[23:51:37] >> mysql_num_rows( Connection handle: 1 )
[23:51:37] CMySQLHandler::NumRows() - Returned 1 row(s)
[23:51:37] >> mysql_query( Connection handle: 1 )

A mod pedig ennel a sornal leallt.