PEQDB Error??
 

Hi guys im getting this error when i try to source my sql file that i extracted right after with winrar. any suggestions on how i can fix this?

http://i27.photobucket.com/albums/c1...nko/errrra.jpg

Thanks in advance

Ive also realized that this may be because my path was C:\Peqdb_Peq_Db , i had ran those commands when there 2 peqdb folders inside eachother, copied the files into one folder and it became C:\peqdb , and its still giving me the same thing now, mabye its because i created database peq; when i had those 2 folders in eachother ?

Try typing in the whole address of "source c:\peqdb\peqdb_1106.sql". Just because you \u in mysql, doesn't change the directory for when you try and open files, it just changes the DB.

god bless you ;p works now thanks alot hehe

but now ive been hit with another probem when i run my start.bat =/

http://i27.photobucket.com/albums/c1...anko/erra2.jpg

check your eqemu_config.xml file. It sounds like you don't have the right user/password/DB being assigned in it. If you used cavedude's installer pack4, the eqemu_config.xml file is wrong as it lists the db as "eq" by default instead of the actual database it makes which is "peq".

It should read something like:

<?xml version="1.0">
<server>
<world>
<shortname>Birthright [PEQ-Custom All Spells and Items]</shortname>
<longname>Birthright [PEQ-Custom All Spells and Items]</longname>

<address>WAN IP</address>
<localaddress>LAN IP</localaddress>

<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<key>12345678</key>

<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>what ever you made it during MySQL setup</password>
<db>peq</db>
</database>
</server>

Nope did all of that stuff correctly ,but there are 2 files ... eqemu_config(XML document) and eqemu_config.xml.full (FULL document) can this be my problem?
EDIT:: deleted the eqemu full file as it had stupid unnecessary information in it. Start.bat still gives me the same errors

some other logs

You're missing your player tables, be sure to source load_player.sql as well.

k went back opened up mysql commandline and pathed to my peqdb folder and tried to source load_player.sql and this is what happened =/

http://img356.imageshack.us/img356/9826/error3py5.jpg

here is a ss of what my peqdb folder contains ...

http://img356.imageshack.us/img356/7772/peqdbssmf8.jpg

also ... tried sourcing aa_timers.sql independently and this is what happened ...

http://img356.imageshack.us/img356/316/error4ze4.jpg

and for those concerned about the wrong XML writeout ... heres mine ;

http://img356.imageshack.us/img356/4283/xml1cc7.jpg

Your address line is wrong. how you have it now would be if you were using minilogin, but your loginserver is listed as eqemulator.net. If you are trying to host it via public login server, then the address line MUST be the IP your cable/dsl modem is using, NOT a private IP such as 192.168.xxx.xxx.

Example:
<address>12.345.6.78</address>
<localaddress>192.168.5.15</localaddress>

how would i figure out the IP my cable/dsl modem is using then? is my localaddress correct? Will this correct my sourcing problem ?

Not sure if this will help, but I ran across a similar issue with the variables table not being there. When I sourced load_player.sql MySQL errored on me. I checked my PEQ database and noticed it didn't follow through all the source files listed in load_player.sql. I matched up and found that it had stopped on name_filter.sql. I then removed this from load_player.sql and re-sourced it with no error.