Most visitors online was 12720 , on 2 May 2024
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
Is this server a private/local, port forwarded, or a dedicated/vps hosted server?if you can assist me online it will be good and thank you so much because i have change the ip but it dont work :/
Is this server a private/local, port forwarded, or a dedicated/vps hosted server?
There is video tutorials how to setup 4.7-4.9 Aion on YouTube . Schema is in all cases are samehi all , wish i can get help plz ans thank youi lunch but i get "No game server is available to the authorization server.(6) when i log
View attachment 167021
There is video tutorials how to setup 4.7-4.9 Aion on YouTube . Schema is in all cases are same
You missing aion noip patch to your bin32 and bin64. No need to open any ports there or change to another ips. Don't let yourself get more confused from all this answers. On aion noip github you have instruction what commandsneed to be added inside your launcher and wgat files should be deleted from both bin32 and bin64 who can in some cases occur problems as well. Good luck.
[SQL] Query al_server_ls start
[ERR] 1067 - Invalid default value for 'time'
[ERR] SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------
DROP TABLE IF EXISTS `account_data`;
CREATE TABLE `account_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(45) NOT NULL,
`password` varchar(65) NOT NULL,
`activated` tinyint(1) NOT NULL DEFAULT '1',
`access_level` tinyint(3) NOT NULL DEFAULT '0',
`membership` tinyint(3) NOT NULL DEFAULT '0',
`old_membership` tinyint(3) NOT NULL DEFAULT '0',
`last_server` tinyint(3) NOT NULL DEFAULT '-1',
`last_ip` varchar(20) DEFAULT NULL,
`last_mac` varchar(20) NOT NULL DEFAULT 'xx-xx-xx-xx-xx-xx',
`ip_force` varchar(20) DEFAULT NULL,
`expire` date DEFAULT NULL,
`toll` bigint(13) NOT NULL DEFAULT '0',
`email` varchar(50) DEFAULT NULL,
`question` varchar(50) DEFAULT NULL,
`answer` varchar(50) DEFAULT NULL,
`balance` float DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account_data
-- ----------------------------
-- ----------------------------
-- Table structure for account_playtime
-- ----------------------------
DROP TABLE IF EXISTS `account_playtime`;
CREATE TABLE `account_playtime` (
`account_id` int(10) unsigned NOT NULL,
`accumulated_online` int(10) unsigned NOT NULL DEFAULT '0',
`lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account_playtime
-- ----------------------------
-- ----------------------------
-- Table structure for account_rewards
-- ----------------------------
DROP TABLE IF EXISTS `account_rewards`;
CREATE TABLE `account_rewards` (
`uniqId` int(11) NOT NULL AUTO_INCREMENT,
`accountId` int(11) NOT NULL,
`added` varchar(70) NOT NULL DEFAULT '',
`points` decimal(20,0) NOT NULL DEFAULT '0',
`received` varchar(70) NOT NULL DEFAULT '0',
`rewarded` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uniqId`),
KEY `FK_account_rewards` (`accountId`),
CONSTRAINT `FK_account_rewards` FOREIGN KEY (`accountId`) REFERENCES `account_data` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account_rewards
-- ----------------------------
-- ----------------------------
-- Table structure for account_time
-- ----------------------------
DROP TABLE IF EXISTS `account_time`;
CREATE TABLE `account_time` (
`account_id` int(11) NOT NULL,
`last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`expiration_time` timestamp NULL DEFAULT NULL,
`session_duration` int(10) DEFAULT '0',
`accumulated_online` int(10) DEFAULT '0',
`accumulated_rest` int(10) DEFAULT '0',
`penalty_end` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`account_id`),
CONSTRAINT `FK_account_time` FOREIGN KEY (`account_id`) REFERENCES `account_data` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account_time
-- ----------------------------
-- ----------------------------
-- Table structure for banned_ip
-- ----------------------------
DROP TABLE IF EXISTS `banned_ip`;
CREATE TABLE `banned_ip` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mask` varchar(45) NOT NULL,
`time_end` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mask` (`mask`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of banned_ip
-- ----------------------------
-- ----------------------------
-- Table structure for banned_mac
-- ----------------------------
DROP TABLE IF EXISTS `banned_mac`;
CREATE TABLE `banned_mac` (
`uniId` int(10) NOT NULL AUTO_INCREMENT,
`address` varchar(20) NOT NULL,
`time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`details` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`uniId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Rec
[SQL] Finished with error
be sure your your mysql version are similar like in database file. open in editor and check info and codingYes, this is the exact tutorial i used and followed thoroughly (and also was very lucky to find it).
And yes, you were corect that i missed deleting those .dll files from bin 32, bin 64. Also i wrote .bat file exactly like it was in the tutorial.
However i am still missing gameservers table. Which i believe is crucial for connecting to the server. And somehow this fact is completely left ignored.
Btw sql file for Login server executed with errors (no errors in tutorial)
View attachment 252761
View attachment 252762
Full log below:
Code:[SQL] Query al_server_ls start [ERR] 1067 - Invalid default value for 'time' [ERR] SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for account_data -- ---------------------------- DROP TABLE IF EXISTS `account_data`; CREATE TABLE `account_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(45) NOT NULL, `password` varchar(65) NOT NULL, `activated` tinyint(1) NOT NULL DEFAULT '1', `access_level` tinyint(3) NOT NULL DEFAULT '0', `membership` tinyint(3) NOT NULL DEFAULT '0', `old_membership` tinyint(3) NOT NULL DEFAULT '0', `last_server` tinyint(3) NOT NULL DEFAULT '-1', `last_ip` varchar(20) DEFAULT NULL, `last_mac` varchar(20) NOT NULL DEFAULT 'xx-xx-xx-xx-xx-xx', `ip_force` varchar(20) DEFAULT NULL, `expire` date DEFAULT NULL, `toll` bigint(13) NOT NULL DEFAULT '0', `email` varchar(50) DEFAULT NULL, `question` varchar(50) DEFAULT NULL, `answer` varchar(50) DEFAULT NULL, `balance` float DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of account_data -- ---------------------------- -- ---------------------------- -- Table structure for account_playtime -- ---------------------------- DROP TABLE IF EXISTS `account_playtime`; CREATE TABLE `account_playtime` ( `account_id` int(10) unsigned NOT NULL, `accumulated_online` int(10) unsigned NOT NULL DEFAULT '0', `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of account_playtime -- ---------------------------- -- ---------------------------- -- Table structure for account_rewards -- ---------------------------- DROP TABLE IF EXISTS `account_rewards`; CREATE TABLE `account_rewards` ( `uniqId` int(11) NOT NULL AUTO_INCREMENT, `accountId` int(11) NOT NULL, `added` varchar(70) NOT NULL DEFAULT '', `points` decimal(20,0) NOT NULL DEFAULT '0', `received` varchar(70) NOT NULL DEFAULT '0', `rewarded` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`uniqId`), KEY `FK_account_rewards` (`accountId`), CONSTRAINT `FK_account_rewards` FOREIGN KEY (`accountId`) REFERENCES `account_data` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of account_rewards -- ---------------------------- -- ---------------------------- -- Table structure for account_time -- ---------------------------- DROP TABLE IF EXISTS `account_time`; CREATE TABLE `account_time` ( `account_id` int(11) NOT NULL, `last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `expiration_time` timestamp NULL DEFAULT NULL, `session_duration` int(10) DEFAULT '0', `accumulated_online` int(10) DEFAULT '0', `accumulated_rest` int(10) DEFAULT '0', `penalty_end` timestamp NULL DEFAULT NULL, PRIMARY KEY (`account_id`), CONSTRAINT `FK_account_time` FOREIGN KEY (`account_id`) REFERENCES `account_data` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of account_time -- ---------------------------- -- ---------------------------- -- Table structure for banned_ip -- ---------------------------- DROP TABLE IF EXISTS `banned_ip`; CREATE TABLE `banned_ip` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mask` varchar(45) NOT NULL, `time_end` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `mask` (`mask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of banned_ip -- ---------------------------- -- ---------------------------- -- Table structure for banned_mac -- ---------------------------- DROP TABLE IF EXISTS `banned_mac`; CREATE TABLE `banned_mac` ( `uniId` int(10) NOT NULL AUTO_INCREMENT, `address` varchar(20) NOT NULL, `time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `details` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`uniId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Rec [SQL] Finished with error
Thank you very much for the reply. Ufortunately i do not posses required knowledge, there's so much that i still need to know to actually make it work. However i managed to run server locally once, making myself an admin etc. but faced big troubles when i wanted to try to make it public. It seems like no matter how good a tutorial is, there's still more troubles i can find.be sure your your mysql version are similar like in database file. open in editor and check info and coding
Uniserver will fix your problemsThank you very much for the reply. Ufortunately i do not posses required knowledge, there's so much that i still need to know to actually make it work. However i managed to run server locally once, making myself an admin etc. but faced big troubles when i wanted to try to make it public. It seems like no matter how good a tutorial is, there's still more troubles i can find.
But okay, i checked coding in a notepad++ and it says its UTF-8, i hope that's what you meant, but where should i look for a version info in a database file?
Uniserver will fix your problems
You must be registered to see linksi checked and its work with one from Robson 4.3.
to work with xampp or wwhat you using you need to change in mysql ini few things .
You do same as in tutorial what I sent before. There is used same uniformserver.Okay i downloaded Uniserver,i need to change what in mysql.ini for working with xampp, but why am i needed Uniserver then?
I see that i can change something here: is it here where i need to do changes? gameservers table will appear in my Navicat after this?
View attachment 252830
Then it's look like you skip some steps of correct setup.I am taking this error while trying setup Aion 4.6 server, i have gameservers table in my database, but i am still taking this error, who can help me?
Login Server Working
Chat Server Working
Game Server Working
But when i try to login on client, after login taking this error after select the server.
Then it's look like you skip some steps of correct setup.
Here is good tut for it.