Page 1 of 1

Server and DB 1.902 Released!

PostPosted: Thu Mar 20, 2008 11:24 pm
by IStandAloneToo
Well community, it has been a while since 1.901 was launched and we felt that it was a good time to make a new release before some major changes to DOL goes stable. I don't have much to tell you in the way of changes (the staff can fill this thread with some changes), but I'd like to thank Graveen for fitting the 1.901 DB to Revision 1134. He also fixed many DB errors (invalid npctemplates, itemtemplates, etc). So, go! Enjoy!

Direct link to SF.

Re: Server and DB 1.902 Released!

PostPosted: Thu Mar 20, 2008 11:26 pm
by IStandAloneToo
NOTE:
Etaew needs to quit being so lazy and making it our site update when I release something :). As for now, go download it from SourceForge. I will update the links when he gets back on.

Re: Server and DB 1.902 Released!

PostPosted: Fri Mar 21, 2008 1:54 am
by Etaew
The links are updated, not quite sure how we'd do it, unless SF releases some XML for it.

Re: Server and DB 1.902 Released!

PostPosted: Sat Mar 22, 2008 6:52 pm
by pacific
hi, thx for your great job on dol, it seems something goes wrong with the sql file of 40meg: on navicat 8 it process only 975 queries (no errors) and no tables are filled...and with an empty db, no tables are created.
as i am a noob, i really dont know whats happenning.

have fun,

Re: Server and DB 1.902 Released!

PostPosted: Sat Mar 22, 2008 8:59 pm
by Graveen
hi

before be sure you have mysql 5.x installed

then use mysql gui tools - administrator - restore option

or

open cmd command
and type
Code: Select all
mysql -u root --password=yourpassword dol < db_1902.sql

Anyone got problems ?

Re: Server and DB 1.902 Released!

PostPosted: Sat Mar 22, 2008 10:17 pm
by pacific
thx for your quick answer ;)

that dont work: computer is working about the same time of the test with navica and same story.
i am using mysql 5.0.27 , i will try with the 5.1.23 and post when done

Re: Server and DB 1.902 Released!

PostPosted: Sat Mar 22, 2008 10:46 pm
by pacific
did the tests with navicat and cmd on the v5.1.23 : same story :?:
usually when i've installed parts of db, that's worked fine.

have fun

Re: Server and DB 1.902 Released!

PostPosted: Sat Mar 22, 2008 11:12 pm
by Graveen
download mysql gui tools

query browser -> file -> open script -> db_1902.sql

execute script

important: this is creating/updating a database called DOL.
so if you wait another db name, you must change the header of the script:
Code: Select all
CREATE DATABASE IF NOT EXISTS dol;
USE dol;

Re: Server and DB 1.902 Released!

PostPosted: Sat Mar 22, 2008 11:26 pm
by pacific
ok that was my mistake: i already had an old db named dol, and havent looked attention to it.... (damnit little brain ;)) while trying to install the db under a dol1902...
i have deleted my old dol db and all working fine now.

thx a lot m8 for your help /claps

have fun

Re: Server and DB 1.902 Released!

PostPosted: Sat Mar 22, 2008 11:51 pm
by Graveen
np, i prefer that, i wonder if it was not a charset problem, even if i checked it was good before packing :D

Good to hear all is fine 4 u !