Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Bug Reports

Development::Bug Reports Post detailed bug reports and what you would like to see next in the emu here.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2006, 12:03 AM
Magefeu
Sarnak
 
Join Date: Aug 2006
Location: Belgium
Posts: 65
Default Inventory issue

Hello everyone.

I've installed a brand new eqemu 845 + Luclin RC1 server with mysql 5. (Of course active perl ect...)
I applied all the 845 update and did the necessary modifications as writen in the wiki. Created the account. ect...

Everything is running fine I can summon items, cast spells, fight ect... but when I zone my character looses all his equipment except the containers but the containers are empy. All the equipment I got is summoned (not mage summoned of course but summoned with #summonitem XXXXX)

I did a #save to force the save of the character but same issue.

I looked in the mysql inventory table and saw only the backpack on the correct slot id => Why only the backpacks...

Where should I look ?
Reply With Quote
  #2  
Old 09-19-2006, 02:38 AM
mattmeck
Guest
 
Posts: n/a
Default

mysql 5 is not supported with EQEmu, there is some people in the community who have gotten it to work tho.

Did you follow the setup guide in the wiki for mysql 5.0 or the default setup for the older mysql setup?

The mysql 5 setup has a series of sql commands to run that may / may not get everything working.
Reply With Quote
  #3  
Old 09-19-2006, 02:56 AM
MikeyUSC
Fire Beetle
 
Join Date: Sep 2005
Posts: 10
Default

My server is running 5 with no issues... so it IS possible.
Reply With Quote
  #4  
Old 09-19-2006, 03:13 AM
mattmeck
Guest
 
Posts: n/a
Default

Quote:
Originally Posted by MikeyUSC
My server is running 5 with no issues... so it IS possible.

I never stated it wasnt, I stated its NOT SUPPORTED, hell I even state

that others have gotten it to work.

How about you stop posting when your not contributing to the thread.
Reply With Quote
  #5  
Old 09-19-2006, 07:47 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

I ran on MySQL 5.0 (can't remember the minor version) and had no real issues straight out of the box (simple install and update). I know some believe the Loglevel in tables "variables" has no purpose anymore, but you might set the 0000 to 1111, and see if your logs spit anything out.

(I have yet to get the new logsys working, but this appears to still work for me...)

What if you equip your char and log out, then back in? Do you still lose stuff?


Edit: Check this post on DRP site: MySQL 5.0 Inventory Issues

Last edited by John Adams; 09-19-2006 at 04:10 PM..
Reply With Quote
  #6  
Old 09-19-2006, 07:08 PM
Magefeu
Sarnak
 
Join Date: Aug 2006
Location: Belgium
Posts: 65
Default

I used the wiki posted by Kayot :
http://www.eqemulator.net/forums/showthread.php?t=21527

I tried to log out... but same issue...the inventory table is not updated.

I just thought about one thing... when setting up MySQL 5 you are asked for the maximum number of simultaneous connections... as I don't need many connections (well that's what I thought) I put that number to 15... maybe this is too low.

When zoning I see a disconnection message in the world window and then a logging in back. On client side this is not seen at all... That's what make me thinking about a DB connection problem.
Reply With Quote
  #7  
Old 09-21-2006, 06:22 PM
Magefeu
Sarnak
 
Join Date: Aug 2006
Location: Belgium
Posts: 65
Default

Still crashing.... I went down to a Mysql4 and everything is running fine... I will look further with mysql 5 on another computer to check with the different install options...
Reply With Quote
  #8  
Old 10-15-2006, 03:59 PM
WildcardX
Developer
 
Join Date: Apr 2003
Posts: 589
Default

I just ran into this problem myself and I am also running MySQL 5.0.

Anyone find a solution for this?
__________________
Read my developer notes at my blog.

Quote:
If it's not on IRC, it ain't l33t!
Reply With Quote
  #9  
Old 10-15-2006, 05:38 PM
WildcardX
Developer
 
Join Date: Apr 2003
Posts: 589
Default

FYI MySQL 5 operators:

I have articulated this cause of this problem in the following post. If someone else doesn't already have this fixed then I'll post a permanent fix in a week or so (I have a job, unfortunately...)

http://www.eqemulator.net/forums/sho...795#post126795
__________________
Read my developer notes at my blog.

Quote:
If it's not on IRC, it ain't l33t!
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:23 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3