Check folder log, find database.log, look in.
It says that it cant connect, but it has mysql error
Printable View
@Sam3000, could you drop your current databases here?
Error:
2021-03-11_16:16:27 INFO Opening DatabasePool 'mu_online_game'. Asynchronous connections: 1, synchronous connections: 2.2021-03-11_16:16:27 INFO MySQL client library: 5.6.292021-03-11_16:16:27 INFO MySQL server ver: 5.5.5-10.4.17-MariaDB 2021-03-11_16:16:27 INFO Connected to MySQL database at 127.0.0.12021-03-11_16:16:27 INFO MySQL client library: 5.6.292021-03-11_16:16:27 INFO MySQL server ver: 5.5.5-10.4.17-MariaDB 2021-03-11_16:16:27 INFO Connected to MySQL database at 127.0.0.12021-03-11_16:16:27 INFO MySQL client library: 5.6.292021-03-11_16:16:27 INFO MySQL server ver: 5.5.5-10.4.17-MariaDB 2021-03-11_16:16:27 INFO Connected to MySQL database at 127.0.0.12021-03-11_16:16:27 INFO DatabasePool 'mu_online_game' opened successfully. 3 total connections running.2021-03-11_16:16:27 INFO Opening DatabasePool 'mu_online_characters'. Asynchronous connections: 1, synchronous connections: 2.2021-03-11_16:16:27 INFO MySQL client library: 5.6.292021-03-11_16:16:27 INFO MySQL server ver: 5.5.5-10.4.17-MariaDB 2021-03-11_16:16:27 INFO Connected to MySQL database at 127.0.0.12021-03-11_16:16:27 INFO MySQL client library: 5.6.292021-03-11_16:16:27 INFO MySQL server ver: 5.5.5-10.4.17-MariaDB 2021-03-11_16:16:27 INFO Connected to MySQL database at 127.0.0.12021-03-11_16:16:27 INFO MySQL client library: 5.6.292021-03-11_16:16:27 INFO MySQL server ver: 5.5.5-10.4.17-MariaDB 2021-03-11_16:16:27 INFO Connected to MySQL database at 127.0.0.12021-03-11_16:16:27 INFO DatabasePool 'mu_online_characters' opened successfully. 3 total connections running.2021-03-11_16:16:27 INFO Opening DatabasePool 'mu_online_log'. Asynchronous connections: 1, synchronous connections: 1.2021-03-11_16:16:27 INFO MySQL client library: 5.6.292021-03-11_16:16:27 INFO MySQL server ver: 5.5.5-10.4.17-MariaDB 2021-03-11_16:16:27 INFO Connected to MySQL database at 127.0.0.12021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 0, sql: "INSERT DELAYED INTO log_item_drop (server, account_id, account, char_id, char_name, player_data, item_data, `comment`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_item_drop'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 1, sql: "INSERT DELAYED INTO log_item_loot (server, account_id, account, char_id, char_name, player_data, item_data, `comment`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_item_loot'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 2, sql: "INSERT DELAYED INTO log_item_sell (server, account_id, account, char_id, char_name, player_data, item_data, `comment`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_item_sell'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 3, sql: "INSERT DELAYED INTO log_item_buy (server, account_id, account, char_id, char_name, player_data, item_data, `comment`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_item_buy'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 4, sql: "INSERT DELAYED INTO item_bag_serial (serial, server, name, level, account_id, account, char_id, char_name, world, world_x, world_y, instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'item_bag_serial'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 5, sql: "INSERT DELAYED INTO log_level_up (char_id, char_name, level_normal, level_master, level_majestic, world, world_x, world_y, event_ground) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_level_up'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 6, sql: "INSERT DELAYED INTO log_jewel_drop (char_id, account_id, jewel_type, jewel_index, jewel_name, world, log_jewel_drop.x, log_jewel_drop.y) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_jewel_drop'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 7, sql: "INSERT DELAYED INTO log_cash_shop (server_id, account_id, account, char_id, char_name, player_data, dest_char, package_id, product_id, option_id, product_name, price_type, price, gift) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_cash_shop'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 8, sql: "INSERT DELAYED INTO log_mix (server, account_id, account, char_id, char_name, player_data, mix_id, mix_name, rate, cost, result, item_data_before, item_data_after) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_mix'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 9, sql: "INSERT DELAYED INTO log_boss_kill (boss_index, boss_name, boss_id, character_id, character_name, damage, damage_reflect, damage_debuff, damage_elemental, log_boss_kill.server, first_hit) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_boss_kill'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 10, sql: "INSERT DELAYED INTO log_jewel_mix (char_id, char_name, server, mix_type, mix_id, mix_level) VALUES (?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_jewel_mix'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 11, sql: "INSERT DELAYED INTO log_item_create (account_id, account, char_id, char_name, interface_id, world, world_x, world_y, server, serial, serial_shop, item, level, item_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_item_create'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 12, sql: "INSERT DELAYED INTO log_personal_store (server, account_id_01, account_01, char_id_01, char_name_01, player_data_01, account_id_02, account_02, char_id_02, char_name_02, player_data_02, offstore, item_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_personal_store'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 13, sql: "INSERT DELAYED INTO log_trade (server, account_id_01, account_01, char_id_01, char_name_01, player_data_01, account_id_02, account_02, char_id_02, char_name_02, player_data_02, money, item_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_trade'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 14, sql: "INSERT DELAYED INTO antihack (server, account_id, account, char_id, char_name, player_data, player_location, type, description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'antihack'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 15, sql: "INSERT DELAYED INTO log_errtel_pentagram (server, account_id, account, char_id, char_name, player_data, type, blessing_spirit, result, pentagram_data, errtel_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_errtel_pentagram'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 16, sql: "INSERT DELAYED INTO mix_recovery (`server`, account_id, `account`, char_id, char_name, player_data, `type`, item_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'mix_recovery'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 17, sql: "INSERT DELAYED INTO reward_dungeon (`server`, account_id, `account`, char_id, char_name, player_data, `type`, item_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'reward_dungeon'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 18, sql: "INSERT DELAYED INTO reward_labyrinth_of_dimensions (`server`, char_id, char_name, `category`, `rank`, item_data) VALUES (?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'reward_labyrinth_of_dimensions'2021-03-11_16:16:27 ERROR In mysql_stmt_prepare() id: 19, sql: "INSERT DELAYED INTO log_pvp (`char_id_1`, char_name_1, char_class_1, `char_stat_1`, `char_set_1`, `char_id_2`, char_name_2, char_class_2, `char_stat_2`, `char_set_2`, skill, hp_damage, sd_damage) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-11_16:16:27 ERROR DELAYED option not supported for table 'log_pvp'2021-03-11_16:16:27 ERROR DatabasePool mu_online_log NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at 404 Not Found
Hmmm, mine still cant, dunno why for now...
Anyway character deleting is working :D
- - - Updated - - -
https://github.com/samik3k/mu_online.../main/Database updated for my current
@dudusiao can you compare my db with urs?
With those updates the character is created, but I can't enter the world. It's stuck after char select.
I also get this error in LoginServer -> Player.log:
Updated tables:Quote:
2021-03-11_16:50:28 INFO Adding Player [1][user]
2021-03-11_16:50:28 INFO LoginQueue::Process -- [Acc: user][IP: 192.168.1.150][MAC: 2C:F0:5D:AD:A8:9C][SERIAL: 1458217639] Result: 1
2021-03-11_16:50:28 INFO Removing Player [1][user] - Disconnected.
- Attachment 169335
- Attachment 169336
i see that you have wrong entry for Lorencia map in world_template (entry and display_entry should be 0)
try with my data (now it has only 9 maps, i will add rest later): https://www.mediafire.com/file/6mkm7...tfull.csv/file
With the database and the latest world_template I confirm I can enter the world and move across Lorencia
Full DB combined:
- Attachment 169337
Hi, does the client does not accept 127.0.0.1? I always get DC whenever I open the client from the server side everything is fine, I use MySQL 5.7.29 as recommended above.