PEQ Source schema.sql and expansions.sql Solution

[Bytebait]

This is for any others that run into this issue and the solution isn't in google or found on the forums.

From an absolute clean install of EQEmu on a clean server the mysql commands in MariaDB console may fail for you.

I solved it by
Open HeidiSQL and open your peq database
Now Open/Import the sql file by going to
File > Load SQL file > "your_path_to_schema.sql"
it will load the sql contents, then Execute the SQL by pressing the blue 'play' button.

Do the same for expansions.sql

That solved it for me and PeQ is working like a charm. Hope somebody else may find this useful.

[Huppy]

Just curious, I've been doing fresh installs for several years, but I have never seen those file names:

your_path_to_schema.sql and expansions.sql

Where did you get those from ? The current PEQ does not come with them.

http://db.projecteq.net/latest

[joligario]

The DB Editor

[Bytebait]

Just curious, I've been doing fresh installs for several years, but I have never seen those file names:

your_path_to_schema.sql and expansions.sql

Where did you get those from ? The current PEQ does not come with them.

http://db.projecteq.net/latest
Sorry Huppy, it's the db editor.

[Huppy]

Ya, I guess everyone has their own preferences for utilities/apps for editing the database. I've never used the common db editors, so it makes communication a pita sometimes, lol