[Errors] I don't understand?

[trevius]

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:

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);

[seridium]

I have no idea how this is done?

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:

Guidance Please :P

Where do I find th esql to run to fix that ?

[seridium]

Originally Posted by trevius

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:

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);

Should I just remove the whole Augslot1visible Calumn from the table will that fix it?
I noticed in the old Table ITems the augslot1visible doesnt exist, and in the new update it is there that is why I ask this.

[trevius]

If you haven't already put alot of work into your database yet, then you would probably be best off just starting over with a fresh database. You can always copy in your player-related tables later if needed. Judging by the different errors you have gotten and different things it sounds like you have done, I have no idea what state your current database may be in. Did you back up your database before hand? As long as you have a backup, you can always source that back in to replace anything that has changed. Then you will just need to run any needed SQL changes from the source code to get it updated to run with the version of server code you are wanting to run.

First off, you need to figure out exactly what versions of Database and Server code you are running. Post that here and maybe we can help you. Otherwise, it seems like you may have been making things worse and not easily recoverable. Really, someone with more database experience than I would be better to help with this though, so don't take everything I say as a fact

If you are running a PEQ database, it should be fairly easy to get things going once you have matching versions of database and server code. I think the PEQ forums probably have more information on that subject than you will find here though.

[seridium]

Well I have altered 5 zones with custom loot tables for every mob in featured zones, server quests, over 25 custom items, and I really don't want to do it all over again it seems the only issue I am having is with the items not laoding.


My DB is 070_pop_cvs I sourced the peqdb_1129Rev291.sql then the updates after installing emu added quests etc.

then I decided to update by sourcing the new peqdb_1129Rev333.sql and all updates, I figured I Could add all my custom db data by sourcing these files I extracted.

Files I extracted with NAvicat from my working server tables:
Account.sql
character_.sql
character_backup.sql
character_Activities.sql
character_enablestasks.sql
character_tasks.sql
inventory.sql
items-0.6.0-DR2-0.6.1-DR1-convert.sql
lootdrop.sql
lootdrop_entries.sql
lootable.sql
lootable_entries.sql
variables.sql
zone.sql

I did also make a backup of all tables in one file. so I could just source and make it back to normal.

But after trying to source character_.sql and getting an error I figured ok I will just make a sql file with what i needed into one file so I added the above files into one .sql instead of individual files and it seemed to put all my Character info back into effect levels zone flags etc were all good except the Item error?

I can re source the peqdb_1129Rev333.sql and it loads fine no errors but no items I made either :(

__________________________________________________ ______________

I am testing this on a second pc with the same server setup as the one I am running, I am doing this to avoid server downtime so its not like my server is all screwed or nothing but it would be nice to not have to make all my items all over again or my zone changes etc.

[trevius]

To get the items you had before, you would need to source your old database again (you can even do it into a new database name so you don't have to delete the one you have now), then, run the update that I posted above to adjust the items table so it is compatible with current DBs. Then, just dump the items table alone to sql. Last, just source that items sql file you made into your existing database. It should now be updated with the new field change and be compatible with the new items table adjustment.

[seridium]

Thanks for the info trevius but I am not sure how to run that update?

I cant find a rev292 update in the updates folder I just downloaded the peq_db too.

[seridium]

Originally Posted by seridium

Thanks for the info trevius but I am not sure how to run that update?

I cant find a rev292 update in the updates folder I just downloaded the peq_db too.

Ok I get it make a notepad file with info you posted and renamed it .sql sourced it trying now Thanks man...

[Iwasseridium]

Originally Posted by trevius

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:

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:

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'

[trevius]

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).

[Iwasseridium]

What do these rules errors actually mean my server works ?

[trevius]

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.

[Iwasseridium]

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?