При создании персонажа выдает ошибку "Не удалось создать персонажа из-за ошибки в базе данных игры." Сервер Please login or register to view links Лаунчер Please login or register to view links/Please login or register to view links Клиент Aion_RUOff_5.80 На форуме, пишут нужно установить No-IP , установил "Lucky_Dice_Patch_EU", не помогает. В логах: 2020-02-03 16:43:56,667 Error saving new player: 325445 Dert com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'is_highdaeva' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_80] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_80] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5PlayerDAO.saveNewPlayer(MySQL5PlayerDAO.java]:269) ~[na:na] at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(PlayerService.java:145) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.clientpackets.CM_CREATE_CHARACTER.runImpl(CM_CREATE_CHARACTER.java:266) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:65) [AL-Game.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80] Заранее благодарен.
При добавлении файла Please login or register to view links [Err] 1060 - Duplicate column name 'reduction_level' [Err] ALTER TABLE `inventory` ADD COLUMN reduction_level INT(11) NOT NULL AFTER `buff_skill`; ALTER TABLE `players` ADD COLUMN is_highdaeva tinyint(1) NOT NULL DEFAULT '0' AFTER `wardrobe_size`; ALTER TABLE `players` ADD COLUMN creativity_point int(11) NOT NULL DEFAULT '0' AFTER `is_highdaeva`; ALTER TABLE `players` ADD COLUMN creativity_step int(11) NOT NULL DEFAULT '0' AFTER `creativity_point`; CREATE TABLE IF NOT EXISTS `player_transformation` ( `player_id` int(10) NOT NULL, `panel_id` int(5) NOT NULL DEFAULT '0', `item_id` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `player_cp` ( `player_id` int(11) NOT NULL, `slot` int(11) NOT NULL, `point` int(3) NOT NULL, PRIMARY KEY (`player_id`,`slot`), CONSTRAINT `player_cp_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; [Msg] Finished - Unsuccessfully -------------------------------------------------- Может что не так: ALTER TABLE `inventory` ADD COLUMN reduction_level INT(11) NOT NULL AFTER `buff_skill`; ALTER TABLE `players` ADD COLUMN is_highdaeva tinyint(1) NOT NULL DEFAULT '0' AFTER `wardrobe_size`; ALTER TABLE `players` ADD COLUMN creativity_point int(11) NOT NULL DEFAULT '0' AFTER `is_highdaeva`; ALTER TABLE `players` ADD COLUMN creativity_step int(11) NOT NULL DEFAULT '0' AFTER `creativity_point`; CREATE TABLE IF NOT EXISTS `player_transformation` ( `player_id` int(10) NOT NULL, `panel_id` int(5) NOT NULL DEFAULT '0', `item_id` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `player_cp` ( `player_id` int(11) NOT NULL, `slot` int(11) NOT NULL, `point` int(3) NOT NULL, PRIMARY KEY (`player_id`,`slot`), CONSTRAINT `player_cp_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Также рядом на файл ругается Please login or register to view links [Err] 1146 - Table 'al_server_gs5.account_data' doesn't exist [Err] ALTER TABLE `account_data` ADD COLUMN luna int(11) NOT NULL DEFAULT '0' AFTER `balance`; ALTER TABLE `account_rewards` ADD COLUMN luna decimal(20,0) NOT NULL DEFAULT '0' AFTER `rewarded`; [Msg] Finished - Unsuccessfully -------------------------------------------------- Может что нужно изменить в коде: ALTER TABLE `account_data` ADD COLUMN luna int(11) NOT NULL DEFAULT '0' AFTER `balance`; ALTER TABLE `account_rewards` ADD COLUMN luna decimal(20,0) NOT NULL DEFAULT '0' AFTER `rewarded`;
вот эти добавь ALTER TABLE `players` ADD COLUMN is_highdaeva tinyint(1) NOT NULL DEFAULT '0' AFTER `wardrobe_size`; ALTER TABLE `players` ADD COLUMN creativity_point int(11) NOT NULL DEFAULT '0' AFTER `is_highdaeva`; ALTER TABLE `players` ADD COLUMN creativity_step int(11) NOT NULL DEFAULT '0' AFTER `creativity_point`; учи как пользоваться программа ми и почитай а так тыкать не знаю что и зачем оно будет лет так 5
Решение: Использовать рекомендую: mysql-installer-community-5.7.28.0 MySQL Workbench CE jdk-7u80-windows-x64 jre-8u161-windows-x64 dotnet-sdk-2.2.207-win-x64 JAVA_HOME добавить путь к ...\java_portable\bin Добавить в ...build\dist\AL-Game\StartGS.bat в начале строку SET PATH="C:\Program Files\Java\jdk1.7.0_80\bin" Добавить в ... build\dist\AL-Login\StartGS.bat в начало строку SET PATH="C:\Program Files\Java\jre1.8.0_161\bin" Лаунчер, запускать с правами администратора. Понадобившиеся программы для запуска 7.2, по ссылке ниже. Хорошего настроения!
При такой ошибки. Как бы пофиг на версия PHP. Версия PHP имеет значение только при условии что есть сайт/форум/чат и т.д. и т.п.
