Problems with setting up a server

Welcome in the osRose emulator Project.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

Re: Problems with setting up a server

Postby WadJaRa on Mon Jul 28, 2008 7:02 pm

Now when i try to insert the extra_skills.sql in navicat i get this error

[Err] 1062 - Duplicate entry '2839' for key 'PRIMARY'
[Err] INSERT INTO `skills_data` VALUES ('2839','0','0','14','0','0','0','0','10','100','0|0|0|0|0','0|0|0|0|0','0|0|0','0|0|0','0','0','0','0','0','0','0','0','0','0','0','0','____________: Metal Moldie _Pre_F2P Unique Skill_','60','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I could insert the other .sql files from the CSV 170 without any problems into navicat...
WadJaRa
Smoulie
Smoulie
 
Posts: 50
Joined: Sat Sep 01, 2007 7:46 pm

Re: Problems with setting up a server

Postby lmame on Mon Jul 28, 2008 7:12 pm

Come on... Same error than before... Delete the '2839' in the database, not in the sql, in the database...
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: Problems with setting up a server

Postby WadJaRa on Mon Jul 28, 2008 7:21 pm

I can´t delete it in the database because it is not loaded in the database...and in the extra-skills.sql there is only that line so..

BTW:Should i delete the problems in the skill_data some posts befor in the database or in the .sql because i deleted them in the .sql...

Okay i fixed the problem but i have deleted the lines every time in the .sql files and not in the database...so is it wrong?

WadJaRa
WadJaRa
Smoulie
Smoulie
 
Posts: 50
Joined: Sat Sep 01, 2007 7:46 pm

Re: Problems with setting up a server

Postby lmame on Mon Jul 28, 2008 8:02 pm

For doubles it's normal you delete from the .sql.
As for extraskill it depends if it exists or not before.
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: Problems with setting up a server

Postby WadJaRa on Mon Jul 28, 2008 8:45 pm

Okay now i could load all the .sql files without any problems into navicat...

Thx a lot for your fast help again very good job

WadJaRa
WadJaRa
Smoulie
Smoulie
 
Posts: 50
Joined: Sat Sep 01, 2007 7:46 pm

Re: Problems with setting up a server

Postby lmame on Mon Jul 28, 2008 8:47 pm

Cool ^_^
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Previous

Return to Support - OsRose Emulator

Who is online

Users browsing this forum: No registered users and 10 guests