[MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

[siaocyberhunter]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

i execute batch files i opened osrose and after i click start this is what i get

[Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working
[Err] -- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(64) default NULL,
`password` varchar(32) default NULL,
`accesslevel` int(11) default '100',
`lastip` varchar(15) default '0.0.0.0',
`lasttime` int(11) default '0',
`lastsvr` int(11) default '0',
`lastchar` varchar(64) default NULL,
`email` varchar(100) default NULL,
`nb_donation` int(11) default '0',
`donation` varchar(255) default '0',
`active` int(11) default '1',
`active_key` varchar(255) default NULL,
`zulystorage` int(11) default '0',
`platinum` tinyint(1) default '0',
`online` tinyint(1) default '0',
`login_count` int(11) default '0',
`isSiteLogged` tinyint(1) default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

and if i ticked Continue on errors this is what i get
theres too much to list so i will put this
Queries: 8050
Processed: 2
Errors: 8048
Time: 45.574s

this is wired ....:wounded1:

 

[nerrr]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Use server rev.80 and Rose Online Evolution rev.152. When login to server selection screen, i have error , like "server blablabla maintenaince blablalba, try later..". Help, plz =\

 

[warofworld]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

I am crazy too.....

He Say MAINTENANCE T_T HELP ME PLEASE

 

[dragonshard]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

when i make my server localhost and i press test connection it always says 1045- Access denied for user 'root'@'localhost' (using password:YES) what should i do?

 

[dragonshard]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Hey

First off thanks for the TuT it helped me loads..

I think I've followed it perfectly... just when i try to make an accoutn on localhost i get this error

To view the content, you need to sign in or register

Could you post back ASAP?

Thanks


~Kyle

i get teh same error :blowup:

 

[nerrr]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Cure of MAINTENANCE problem for me is setting up config normally.
My local ip is 192.168.1.2
My mask is 255.255.255.0
My wan ip is dyndns adress (blablabla.homeip.net)
My database host is localhost
In system32\drivers\etc\host file i write:
127.0.0.1 localhost
blablabla.homeip.net blablabla.homeip.net
For me, ip in Rose Loader config is 127.0.0.1
For others is blablabla.homeip.net
It's simple

 

[Kenfan]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

I solved my problems, Also thank you for the guide it is a very nice guide and very usefull

 

[queenniejoy]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Why do i get this error???

 

[dragonshard]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\wamp\www\modules\register.php on line 55

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in D:\wamp\www\modules\register.php on line 56

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\wamp\www\modules\register.php on line 57

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\wamp\www\modules\register.php on line 57

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\wamp\www\modules\register.php on line 58

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\wamp\www\modules\register.php on line 67

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\wamp\www\modules\register.php on line 67

Registration Failed! what do i do now? :|

 

[dragonshard]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

bump

 

[Mambo]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

I can't make an account I've this error:
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\Program Files\xampp\htdocs\RoseCMS\_inc\config.php on line 4

 

[saleem]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Now i get

4.) When I try to login, I get "The Servers are currently undergoing maintenance"
Solution: Make sure your using the latest Rose EVO client and server files, and your ports or forwarded and that you have applied the GameGuard patch (new at 4/28/07) after your last client update.

My evo client is lastest and server files are these in guide why i get it?

 

[GeNyaa]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Make sure your ports are open and....
That your Server is on...
That you use if it is on the same PC were the client on use the IP 127.0.0.1
Maby that will help...

 

[saleem]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

.
That you use if it is on the same PC were the client on use the IP 127.0.0.1
Maby that will help...

Whats that mean?

 

[skw2005]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

CAn help me pls
when i login until the chnnel they
can i will get the SERVER DEAD

can help me pls

 

[emilevanhalsema]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

hi can someone help me im trying to make a website for registration but it says this:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampplite\htdocs\inc\admin_functions.inc.php on line 7

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampplite\htdocs\inc\admin_functions.inc.php on line 8

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in C:\xampplite\htdocs\inc\admin_functions.inc.php on line 8

 

[Mambo]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

If I try to login: It works
If I try to choose a wolrd: It works
If I try to make an account: It works
If I try to get on the world server: It gets an error about TRose

It isn't a missing file it is just an error....

Could someone help me?

Mambo

 

[Sambezander]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Hi,

I'm a big fan of your guide, I think it rocks!

I'm having the problem that, while i connect from my computer with the .bat file set to server 127.0.0.1, it all works fine, but as soon as i change that to my LanIP it doesnt work. I can log into the game from any computer, whether at a friends or in my own house and the server files recognise it, even use the computer that the servers are running on, but as soon as they select the world, i get the typical server going under maintenance box.

I have checked all my IP's and they are all right. And i am not going through a router, directly plugged in, so do i need to do port forwarding?

I have looked at hundreds of replies from different people of different websites and none of there fixes have worked.

I'm really stuck. Please Help.

<EDIT>
I have done the tutorial from start to finish, checking each and every bit. Firewalls are off on both. But both have the same problem. Even more stuck now :S

Sambez

 

[queenniejoy]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

PRobLem......

-some skills like: stealth, cloaking, additional damage buff, are not working

-some aoe's don't work

-normal attack does more damage than skills if you have like 800 ap

help please..

 

[Heroia]

re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Ok I try these files for a starter.