EQEmulator Forums - [Errors] I don't understand?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - [Errors] I don't understand? (https://www.eqemulator.org/forums/showthread.php?t=27506)

Yes, if you run any SQL updates that update full tables (like I think those do), they will delete the current table completely, rebuild the table and fill it from scratch.

Well I tried to source the DB mentioned on the running server and I got a mysql disconnect error and now it wont connect to mysql :) fun fun

Quote:

Originally Posted by seridium (Post 165181)

Well I tried to source the DB mentioned on the running server and I got a mysql disconnect error and now it wont connect to mysql :) fun fun

The bad part is it dissconnects me during DB sourcing, then everytime I try and source peqdb_1129Rev333.sql I get this error

Quote:

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

why would the update disconnect me, I think it has something to do with the items table.

I cannot figure out why I can't update peqdb-1129Rev333.sql? anyone else had this problem?

Well like I said above i load up that db and source it and mysql drops connection and I also noticed after doing this my pc wil now crash constantly is this normal? what version of MYSQL Should I use like come on no one else had this problem?

Well I am still having this problem can anyone help???

Why would mysql get syntaxx errors during installation of peqdb_1129Rev333.sql was there an error with this update???

Quote:

Originally Posted by trevius (Post 165054)

I am not sure what that conversion sql stuff is, but it looks really old. It looked like you were closer before you started running those. Your first error shows this:

Unknown column 'augslot1visible' in 'field list'

Which is an issue that means you are trying to update your database with a new items table, but the existing items table is designed wrong. The augslot1visible used to be named differently until a recent change. You should just need to make sure that you run the SQL to change that field in your table before sourcing your items back in. Here is the SQL change from R292:

Code:

alter table items drop column augslot1visible;

alter table items drop column augslot2visible;

alter table items drop column augslot3visible;

alter table items drop column augslot4visible;

alter table items drop column augslot5visible;



alter table items change column `augslot1unk` `augslot1visible` tinyint(3);

alter table items change column `augslot2unk` `augslot2visible` tinyint(3);

alter table items change column `augslot3unk` `augslot3visible` tinyint(3);

alter table items change column `augslot4unk` `augslot4visible` tinyint(3);

alter table items change column `augslot5unk` `augslot5visible` tinyint(3);

I am getting a error when using this source code:

Quote:

ERROR 1054 (42S22) : unkown column 'augslot1unk' in 'items'
ERROR 1054 (42S22) : unkown column 'augslot2unk' in 'items'
ERROR 1054 (42S22) : unkown column 'augslot3unk' in 'items'
ERROR 1054 (42S22) : unkown column 'augslot4unk' in 'items'
ERROR 1054 (42S22) : unkown column 'augslot5unk' in 'items'

Sounds like you already had the update applied when you ran that SQL. That means that you already had the new fields and just removed them so you no longer have them at all.

You will either need to resource the entire items table, or add those new fields back in manually and populate them as needed (which may be a pain to get all items set correctly).

What do these rules errors actually mean my server works ?

As I have already said here and many other threads; If you are getting errors about rules not being found, then your server code is older than your database is and they NEED to match. The actual rules errors don't mean anything, but 99% of the time, if your source doesn't match your database, there are other SQL updates you are missing that will definitely cause major issues.

I have tried updating to the newest Revisions361 with the peqdb_1129Rev360 and all updates, without installing my items and I get the server to load and it still has the errors so I am done with this install I would like to start from fresh and maybe just maybe it will work this time with no errors :)
So ya how do you uninstall this peq can I just drop_players drop_system would that be correct? or would I just delet the whole data base peq and make a fresh one then source in info?

When I reinstall the new peqdb_1129Rev360 from fresh do I Source all files in the peq_db folder that are downloaded along with the peqdb_1129Rev360.gz file such as accounts.sql etc and then source all updates?