Need Help with Installing Data base

Guides for osRose and osiRose (compilation / setup)...

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

Re: Need Help with Installing Data base

Postby Eterdaz on Tue May 12, 2015 4:42 pm

i tried install the database at my computer and it's done without errors.

Picture1.jpg


Picture2.jpg


I think nothing is wrong with the sql script. before you install directly from the sql file, you already install from the .bat file and failed. maybe that's causing the errors.

I suggest you to try delete the roseon database then make the new one and execute the sql file again. if this way don't work, try reinstall the mysql.
Eterdaz
Jelly Bean
Jelly Bean
 
Posts: 19
Joined: Fri Jul 18, 2014 1:40 pm

Re: Need Help with Installing Data base

Postby Eterdaz on Tue May 12, 2015 4:57 pm

PurpleYouko wrote:
Personally i have never liked to to it from the batch file. It never works properly for me.



I agree with that. :D

PurpleYouko wrote:PHPMyadmin completely replaces Navicat.
It is Free (comes with Xampp)
It is easy to use
It can be accessed on remote machines so you can edit your database on your server machine from anywhere in the world.

Navicat, on the other hand, doesn't meet any of these 3 criteria and is made of a combination of all kinds of SUCK and FAIL.
I don't like Navicat. :lol:


that's maybe the weakness of navicat, but i think navicat is tidier and simpler. thanks for the advice. :)

Anyway I'm still newbie and just follow the tutorial which is using navicat for manage the database. you can choose which way is easier for you. 8-)
Eterdaz
Jelly Bean
Jelly Bean
 
Posts: 19
Joined: Fri Jul 18, 2014 1:40 pm

Re: Need Help with Installing Data base

Postby PurpleYouko on Tue May 12, 2015 7:33 pm

yeah. Whatever works best for you. A lot of people prefer navicat.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Need Help with Installing Data base

Postby edgieramos on Fri May 15, 2015 12:46 pm

Hey there guys, @PurpleYouko thanks i followed your tip to use xampp works so well compared to navicat lol, i got things working but i got an error on my world server about errors in loading some files from my data base, i also chose to install the osrose database you sent to me, any idea's on what might be causing this problem?

world.png
Error and hangs and closes.
edgieramos
Jelly Bean
Jelly Bean
 
Posts: 27
Joined: Wed Dec 11, 2013 5:33 am

Re: Need Help with Installing Data base

Postby Eterdaz on Fri May 15, 2015 3:47 pm

the error not at the database, but at the stb file . the solution is you must extract the stb file from your client and put it at "binary/3ddata/stb". when i check the source link you give earlier, the stb folder still empty. https://osirose.googlecode.com/svn/trun ... DData/STB/
Eterdaz
Jelly Bean
Jelly Bean
 
Posts: 19
Joined: Fri Jul 18, 2014 1:40 pm

Re: Need Help with Installing Data base

Postby edgieramos on Fri May 15, 2015 6:13 pm

i see so there is a problem on the svn files, got any ideas on where i can download a good one? tried other links its either broken or the password doesn't work, hope you guys can help us again and a lot of thanks from me and my friends for your help :D
edgieramos
Jelly Bean
Jelly Bean
 
Posts: 27
Joined: Wed Dec 11, 2013 5:33 am

Re: Need Help with Installing Data base

Postby Eterdaz on Fri May 15, 2015 6:17 pm

that's not broken, you just need extract the file from the client, because every client have diffrent stb file.
Eterdaz
Jelly Bean
Jelly Bean
 
Posts: 19
Joined: Fri Jul 18, 2014 1:40 pm

Re: Need Help with Installing Data base

Postby PurpleYouko on Fri May 15, 2015 6:24 pm

Those errors look like there are no STBs at all in the server Binary/3DDATA/STB folder
Even if they were the wrongs ones, they would still load
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Need Help with Installing Data base

Postby edgieramos on Fri May 15, 2015 6:35 pm

Oh! isee sorry about that, how do i extract those in stb folder? and are these the files i should extract?

svn.png
svn.png (5.56 KiB) Viewed 10106 times
edgieramos
Jelly Bean
Jelly Bean
 
Posts: 27
Joined: Wed Dec 11, 2013 5:33 am

Re: Need Help with Installing Data base

Postby PurpleYouko on Fri May 15, 2015 6:41 pm

grab one of the VFS tools from the tools list. We have several
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

PreviousNext

Return to osRose / osiRose Guides

Who is online

Users browsing this forum: No registered users and 4 guests

cron