MySQL Errors

[Forlap_Thorninfoot]

Heya folks! I'm trying to start up a server, had one awhile back, but looks like things have changed a great bit.... anywho!

I'm getting loads of errors when i try to source the DB in MySQL.

running version 5.5 of MySQL, downloaded the DB with TortiseSVN, got the files NP, extraced the peqdb_rev1052 into the bin folder. Currently thats the only source i can load no prob at all.

when trying to load the load_player and load_bots files as downloaded i get an error: 2 message. After some searching i found that one has to edit the files to show the full location of the player_tables folder (C:\Program Files\MySQL\MySQL Server 5.5\bin\projecteqdb\peqdatabase on my computer).

So (for the sake of my ears, that beep is annoying as hell) i tryed the load_bots.sql file first as theres only 6 or 7 things in it. Edited them all to look as such:
source C:/Program Files/MySQL/MySQL Server 5.5/bin/projecteqdb/peqdatabase/player_tables/bots.sql;

as so on down the line through all of them (tried with the windows \ and got lots of errors too)

This does some things, but i dont know if its working fully or not:

mysql> source load_bots.sql;
Query OK, 0 rows affected (0.20 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.22 sec)
Rows matched: 1 Changed: 0 Warnings: 0

ERROR 1146 (42S02): Table 'peq.rule_values' doesn't exist
ERROR 1146 (42S02): Table 'peq.rule_values' doesn't exist
ERROR 1146 (42S02): Table 'peq.rule_values' doesn't exist
ERROR 1146 (42S02): Table 'peq.rule_values' doesn't exist
ERROR 1146 (42S02): Table 'peq.rule_values' doesn't exist
ERROR 1146 (42S02): Table 'peq.rule_values' doesn't exist
ERROR 1146 (42S02): Table 'peq.rule_values' doesn't exist
ERROR 1146 (42S02): Table 'peq.commands' doesn't exist
ERROR 1050 (42S01): Table 'bots' already exists
ERROR 1146 (42S02): Table 'peq.group_id' doesn't exist
ERROR 1146 (42S02): Table 'peq.guild_members' doesn't exist
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'IF NO
T EXISTS `vwGuildMembers` AS
select 'C' as mobtype,
cm.char_id,
cm.guild_' at line 1
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'IF NO
T EXISTS `vwBotCharacterMobs` AS
select 'C' as mobtype,
c.id,
c.name,
c.c' at line 1
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1146 (42S02): Table 'peq.group_id' doesn't exist
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>

i just tried changing the load_player.sql and it loaded just fine. no beeps at least:

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.02 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 21 rows affected (0.00 sec)
Records: 21 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql>


lots more, but the window only holds so much.

so i think (it didn't work until just now, so i'm rather pleased) the load_player is done, but i cant get the load_bots file to work.

Now i dont want my players to have bots, at all, so two things:

1) do i need to fix this? if so, how? and please spell things out, i am a major n00b at this.
2) If i dont need or need to fix, will it affect my server beyond not having bots allowed?

I would like to get my server up ASAP, so please help!

P.S. i had a good number of edited items/spells on my old server. is there a way to bring them over? the way we form the DB has changed more than i had dreamed.

[jetstrike]

I am having a similar problem except mine is looking to update variables and keeps erroring saying peq.variables does not exist

[Forlap_Thorninfoot]

good to know i'm not alone! =)

[pfyon]

Does the table exist in your db?

[jetstrike]

Yes it does. Ive tried reinstalling a few times and nothin is working. So I am going to uninstall everythin and give ax classic a try

[cavedude]

If you want bots, you have to source them after load_player.sql. It's in the readme :P Doing it in the reverse order will give you the table doesn't exist errors. Obviously, if you don't want bots on the server, you don't even need to source load_bots.sql. Also, you can't source both files if you already have a working database. In that case, you have to source in all the updates in the updates folder. Lastly, PEQ's DB repo is not compatible with EQEmu's DB updates. Every update found in the EQEmu repo is also in the PEQ repo, but due to the way each handles updates using both will cause conflicts. I recommend using PEQ to most people, unless they have a lot of custom content, then using the EQEmu updates may be best.

MySQL 5.0 sources in all files without the need to edit. If MySQL 5.5 was changed to require full paths, then that really sucks on their part!

As for the:
ERROR 1064 (42000): in load_bots.sql, I just copied the bots source from the EQEmu repo verbatim, so if there are problems sourcing blame the bots folks :P