Printable View
There were batch files you needed to run to start the server. Those batch files look at the configs only once. Which means any changes you make to them, you need to stop the services started by the batches, and restart them. This may be why the changes to the network configs are not working.
Okay so the batch files didn't really do much.. opened up a black screen for a sec, and then shut down? Lol.. is that bad? X.X
What server are you using, also what guide did you follow?
There should have been a way to start the server.
well actually, i already downloaded heidi, so just what's the gigatoon you were talking about lol. I feel that that actually might be easier than this x.x. is it this?
http://forum.ragezone.com/f587/aion-...7-5-a-1072930/
Yeah that's the one I use.
Honestly, though, the issue you had is bothering me. I actually might lose sleep tonight because we weren't able to fix it. I'll get over it I guess lol.
As far as SQL clients, Navicat or Heidi doesn't matter. They do the same thing, they just look different and may have a few features the other doesn't.
Make sure you use this tutorial: http://forum.ragezone.com/f588/aion-...7-5-a-1073648/
Okay, But i kind of like heidi better lol. Although.. Why can't I import x.x. it's not working D:.
And apparently there's an error with the .sql file. T.T. Idk maybe i wasn't meant for this x.x.
What is x.x.?
You mean the databases?
idk... the guide says to import, but nothing happens, and so I try and execute it, but then there's an error.. im so lost XD
Ahh. This part fucked me up too.
In Heidi, left click on the master database icon on the left and then right click. Select "Create New" and the "Database"
(The icon probably looks like a dolphin)
Name it ac47_server_ls
Do it again for ac47_server_gs
Once you have those two new databases, click on one of them, and hit Ctrl+O (Or File > Load SQL file) Find the SQL file with the same name as the database you've clicked onto. Select it then hit "Open"
From here, hit the blue play button at the top to execute the SQL file (or hit F9). It should begin importing. When it's done, do the same thing for the other database. Make sure the name for the target DB (you new one) matches the source DB (what you're importing)
It's probably going to give you some warnings. Disregard this.
When both of these are done, close Heidi and re-open it and reconnect. You should see the database information populated.
when i execute it, an error pops up and says SQL Error (1064) you have an error in your SQL syntax; 'KEY_BLOCK_SIZE=16' at line 7
Which SQL file were you importing, GS or LS?
The syntax error message indicates that something isn't right with the spelling or the commands used.
gs. ls worked fine.
Find the gs sql file (SERVER>GAME>SQL) right click it and select "Edit"
This should open the SQL file in notepad. Screenshot the window without scrolling and post the link. Something seems off about the SQL file. Mine makes no mention of KEY_BLOCK_SIZE in line 7
idk how to screenshot T.T
/*
Navicat MySQL Data Transfer
by GiGatR00n v4.7.5.x
Source Server : Localhost
Source Server Version : 50616
Source Host : 127.0.0.1:3306
Source Database : ac47_server_gs
Target Server Type : MYSQL
Target Server Version : 50616
File Encoding : 65001
Date: 2015-05-11 19:21:17
*/
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `abyss_rank`;
CREATE TABLE `abyss_rank` (
`player_id` int(11) NOT NULL,
`daily_ap` int(11) NOT NULL,
`daily_gp` int(11) NOT NULL,
`weekly_ap` int(11) NOT NULL,
`weekly_gp` int(11) NOT NULL,
`ap` int(11) NOT NULL,
`gp` int(11) NOT NULL,
`rank` int(2) NOT NULL DEFAULT '1',
`top_ranking` int(4) NOT NULL,
`daily_kill` int(5) NOT NULL,
`weekly_kill` int(5) NOT NULL,
`all_kill` int(4) NOT NULL DEFAULT '0',
`max_rank` int(2) NOT NULL DEFAULT '1',
`last_kill` int(5) NOT NULL,
`last_ap` int(11) NOT NULL,
`last_gp` int(11) NOT NULL,
`last_update` decimal(20,0) NOT NULL,
`rank_pos` int(11) NOT NULL DEFAULT '0',
`old_rank_pos` int(11) NOT NULL DEFAULT '0',
`rank_ap` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`player_id`),
CONSTRAINT `abyss_rank_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
Did you get that information when you opened the sql file in notepad, or is that a log from navicat?