what version of MySQL I should use for 2007/08/10 PEQ DB

samplempg · #1 08-10-2007, 02:17 AM

What version of MySQL I should use to get my latest download of PEQ DB (from wincvs) to work ?

When I follow the guide.pdf and run "source load_system.sql" it runs fine at beggning and after 20-30 lines buch error happens. I am currently using mysql-essential-5.0.37-win32.msi (as the guide recommand).

Zandig · #2 08-10-2007, 02:37 AM

The MySQL version in the guide works fine. I use 5.0.27 but no difference.

Try this command to source the database:

Code:

\. load_system.sql

samplempg · #3 08-10-2007, 02:56 AM

Quote:

Originally Posted by Zandig

The MySQL version in the guide works fine. I use 5.0.27 but no difference.

Try this command to source the database:

Code:

\. load_system.sql

result exactly same error

, maybe I should try non-essential version or just version 5.0.27 (maybe the author make a typo mistake between 2 and 3)

Zandig · #4 08-10-2007, 04:01 AM

What exactly are the errors?

techguy84 · #5 08-10-2007, 04:10 AM

double check that your sourceing in your peq file from the peq directory, the one that contains all the sql files. For some people its c:\peqdb\peq_db\

You do this before you run mysql -u root -p.

When you open command prompt, you type in

Code:

 cd\peqdb\peq_db

and then your line should look like this

Code:

 c:\peqdb\peq_db>

and at this point start the mysql stuff.

John Adams · #6 08-10-2007, 05:31 AM

Also make sure you are sourcing to a new DB and not an existing one, unless you first run the drop_system.sql.

samplempg · #7 08-10-2007, 05:50 AM

It is brand new DB, and i also do "drop database peq;" (and "create database peq" again and "/u peq") everytime when I retry.

this is the error message when I try to import load_system.sql

http://www.geocities.com/samplempg/error.JPG

John Adams · #8 08-10-2007, 05:56 AM

See that "near (,(11"? that's the problem. Not sure what source you are using, but peq_db from the CVS is not missing column data or malformed SQL statements.

This is like trying to insert (id,field,data) as (,blah,bleh) <-- the first field's data is missing.

samplempg · #9 08-10-2007, 06:29 AM

Quote:

Originally Posted by John Adams

See that "near (,(11"? that's the problem. Not sure what source you are using, but peq_db from the CVS is not missing column data or malformed SQL statements.

This is like trying to insert (id,field,data) as (,blah,bleh) <-- the first field's data is missing.

I am using chinese traditional version of xp sp2. Is that cause the problem ?

because sometimes 2 ansi code can be combine to 1 chinese world.

John Adams · #10 08-10-2007, 07:36 AM

Oh yeah, way out of my league pal.

sorry...

samplempg · #11 08-10-2007, 02:32 PM

weird, the database download from PEQ website (luclin 0.7.0 final release) dosen't give any error on "source load_system.sql", what version of EQEMU I should run to match luclin 0.7.0 final database ?

samplempg · #12 08-10-2007, 04:27 PM

I got more usefull error message by import latest DB by useing navicat, here is the screenshot

http://www.geocities.com/samplempg/error2.JPG

samplempg · #13 08-10-2007, 06:24 PM

all right..I think the error are cause by typo mistakes on .sql file. here is little screenshot make it obiously (there are at least 3 typo on different .sql when I try import the DB)

note: these typo error only happen on latest wincvs downloaded peq_db, can someone help me report this bug to Project EQ forums ? My forum account having trouble to get activate, maybe the forum admin are too busy

http://www.geocities.com/samplempg/error3.JPG

**cavedude** · #14 08-11-2007, 01:59 AM

Newest CVS loads without an error for me on a Windows box and several Linux boxes. Typos in the dumps are nearly impossible because they aren't edited by hand. Yeah, and as John Adams said that malformed line doesn't exist in CVS, I just looked so I'm not sure where you are getting the db from.

But, I'm going to be updating CVS today so maybe that will fix it for you.

samplempg · #15 08-11-2007, 04:37 AM

I did download twice on yesterday, both try gives error

Btw, tonight's download works perfect! No more errors!