No items showing up on characters Plz help

[calasoren]

Has anyone else had this issue and if so what could it be i cant think of anything else other then maybe a database error.

None of the items i put on my characters show up on me. Any help would be greatly appreciated. Im not receiving any errors in logs or anything from what i can see if you want anything posted just let me know.

[GeorgeS]

First of all if this is your server, then you need a sql browser and must examine the character and linked inventory tables. It may be the inventory link is incorrect for your character.

table Character_ field id stores the unique id for the toon. It's inventory is found in;
table inventory, field charid.

If there are no items for the character, then the error must lie somewhere else.

Run this query to examine the contents of your toon.

SELECT name,slotid,itemid FROM character_ , inventory WHERE name="mytoon" AND (character_.id=inventory.charid)


GeorgeS

[calasoren]

Thanks for the input george ya i was looking through there yesterday seems to all look alright from what i could see other then the inventory field in my character_ database is null. There are a very few items that do change apperance on my server no weapons or anything like that though. I think if i do a clean install for ver 245 again it might work better my database is having lots of small little bugs that i think will be more hastle to fix then what its worth.

Pok books missing from zones, Most items no weapons change appearance, Frogs look human, HT doesn't work in warrens, Guild tag shows as unknown on friends account across the internet shows fine on local think thats most of them.

By chance is there a way i can backup my characters from the server and move them over to my new install when i have that up and going? Just dont wanna have to make everyone start over again. I do want a fresh database atleast for the most part cause i figure that is where a big part of my issues are coming from.

[trevius]

If you haven't tried restarting your server yet, that should be the first thing to try. Sometimes if you are doing database changes while the server is running, it will mess something up and inventory will be empty sometimes when you zone and come back sometimes when you zone again. The only way to fix that is restarting the server.

To backup your characters, you can do that easily by using navicat. Install it and connect to your database, then hold down CTRL and click on all of the tables you want to keep and right click them once they are highlighted. For character, you at least want to keep the character_ and inventory tables, but there are probably others that you would want as well. Then, select to dump them to SQL and set a file name to save it to. Once the dump is complete, you should be all set. You can also backup your entire database that way so you can restore it at any time in case anything goes wrong (and it is a good idea to do regular backups). Then, when you want your tables back after you update your database from a fresh install, you can just run the sql file you created. You can do it the same way you run the database setup from the guide or you can just use Navicat and right click the database and select to run a batch file and chose the file you created and run it.

[calasoren]

Thanks trevius ill be using that for backing up chars from now on as for the no items issue ive restarted server ive wiped every file related to eqemu, perl, mysql and everything right off the system and done it from scratch. Either im missing something different im supposed to do with rev245 or something in my rev245 is wierd.

Unless someone has a good idea on what could be happening with rev245.

Is there a place to download all the files for rev233 or something near that range i might just jump back to an older revision for now and see if that solves the issues im seeing.

Thank you for the help its greatly appreciated as is all the work you guys do with the program.

[jtcoyle]

I Just wanted you to know calasoren that I just installed Rev245 a few days ago from scracth and it works great. I first started with the no bot files and once that was working I upgraded the server to bots and that is working fine as well.

I first tried Rev233 and had problems with the data base for 233 were not correct and I had some issues. Once Rev245 was released along with the corresponding 245 database, all worked great.

Hope you get your server working.

Dark Wing

[calasoren]

I wonder if maybe its just the bot version then thats the one im currently using. Am i missing a step implementing the new version? Install activeperl, install mysql, create database peq, source player and source peq_db1129rev245.sql after of course doing the cvs atm i just did a cvs update maybe i have corrupt files some how from cvs? :pserver:anonymous@eqemuquests.cvs.sourceforge.net :/cvsroot/eqemuquests and @peq.cvs.sourceforge.net:/cvsroot/peq

and then just the other odds and ends copying map files in copy plugins folder from quests into /eqemu all that little stuff i figure if its an issue im doing its probably in my cvs or mysql.

[calasoren]

yep that did the trick uninstalled everything again redid the server with the non bot version of 245 sourced in player and rev245.sql then just for good measure sourced in all the previous update files from the update folder a few changes were added here and there. Finished up all my usual stuff and loaded in frogloks are now in the game items can all be seen lots of little issues were fixed.

[calasoren]

Sorry friend just checked his comp still has the issues with froglok and items so those issues i figure came from the everquest installation i honestly didn't even think to look at that since that was never an issue before it worked orginally. Reinstalling everquest titanium worked perfect for anyone else that may have an issue similar in the future :)