In a previous post in this thread, you said you were able to source all of the PEQ SQL without errors, but now you are getting errors when you try?
Are you following these 3 step exactly (accounting for the path difference where your PEQ files are located)?
Code:
13.First, go to your C-Drive and right click on the folder you made called peqdb
and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase (then click OK)
It will finish with "At Revision XX"
Next, go to that folder peqdb and unzip the file from peqdb_rev1751.sql.gz
to the same peqdb folder.
This file will be named peqdb_rev1751.sql (without the .gz)
***NOTE***
The "rev1751" was the most current at the time of this writing. It may change over time.
14. Ok, now open up your Navicat Lite program that you installed.
On the upper left you will see Connection. Click on that and choose MySQL
A connection window will open. The only thing you really need to do is put your mysql
password in (make sure the "Save Password" is checked) and click OK.
This will create a connection with MySQL.
In the Connections window, you should now see localhost_3306 (Double click on that)
Then right click on that same name (localhost_3306) and choose New Database...
In the next window, in the first line, type peq (then click OK)
Close Navicat Lite.
15. NOW, you need to go in to a command prompt and navigate to the peqdb folder.
Simply type cd \peqdb and you should be there. You will see: C:\peqdb>_
REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)
***WARNING*** - at this point, make sure you are in the peqdb folder.
Type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_
Type the following (in order):
use peq (Hit enter and you will see a short note saying "Database changed")
Then type the following:
source peqdb_rev1751.sql (when this is done, you will be back at the mysql>_ prompt)
Then type in the following:
source load_player.sql (this will load fast)
***WARNING*** - When you compiled your server, if you chose "ReleaseBots", you will now
need to type the following at the mysql prompt:
source load_bots.sql
Which ever you chose, you can now close the command window and work on the sql updates.
***WARNING*** - the sql updates ARE NOT in the peqdb folder, they are in the source
folder where you compiled your server, but you can use Navicat Lite to run the updates.
If you follow those 3 steps, your DB should be all set and you can move on to troubleshooting your next issue(s). If you are unable to understand exactly what to do at any part of those 3 steps, just ask specifically about the part you are unsure about.
If you don't know how to open a command prompt, you can do all of this fairly easily through Navicat and probably HeidiSQL as well. I don't use HeidiSQL, so I can't speak for how to do it there, but Navicat is similar I am sure and very simple. You just create a new database named "peq" (without the quotes). Then you double click that database to connect to it and right click on it. In that menu, you should see an option to Source the SQL (may not be worded exactly like that, but I am not at my desktop to verify right now). You then browse to the folder where your PEQ SQL files are located and run them in the order that the guide says to.