I got shmat issues...

**WildcardX** · #1 10-20-2007, 01:00 PM

The solution to this problem isnt in the server code. Its fixable by your distros configuration. You need to increase the value in your /proc/sys/kernel/shmmax file to some value greater than 32 MB. The value in that files in is bytes and its probably going to vary from distro to distro. I'm not sure what a good value is, but i can confirm setting it to 100 MB does allow us to import the current 13th floor items table.

Enjoy!

I also want to thank both Cavedude and FatherNitWit for assisting me in identifying this issue and testing the solution. I believe you can expect PEQ to have a current items table in the next few days now.

**cavedude** · #2 10-21-2007, 02:53 AM

Here we are, a brand new items table consisting of the newest 13th floor dump as of this morning (62,000+ items) Stackable items work, and I made the appropriate changes to the columns so all the data got converted and merged in. I've been testing it all morning and had no issues (other than pre-existing ones in the Emu code of course) so it looks like we are good.

http://projecteq.net/items_102107.rar

As Wild said, Linux users will probably need to bump your /proc/sys/kernel/shmmax file a bit. Windows users need not do anything.

uncommon · #3 10-21-2007, 05:56 AM

Many thanks cavedude. Sourced it np.

**cavedude** · #4 10-21-2007, 10:37 AM

The following changes are needed:

Code:

update items set stackable = 1 where clickeffect = -1 and maxcharges = 1;
update items set stackable = 1 where itemtype in (14,18,28,55,15,19,37,56,17,27,38,53,21);
update items set casttime = casttime_;
update items set stackable = 1 where name like 'Spell:%' and itemtype = 20;
update items set slots = 2097152 where slots = 4194304;

Some more itemtypes were added as being stackable, food/drink consumption is fixed, and many ammo slot items are now fixed. The players on PEQ didn't really find any other bugs with the new table so after this update all should be good. If more updates are needed, however I will post.

**cavedude** · #5 10-22-2007, 12:56 AM

More fixes bard spells and items:

Code:

update items set slots = 2099200 where slots = 4196352;
update items set stackable = 1 where name like 'Song:%' and itemtype = 20;

John Adams · #6 10-23-2007, 01:57 AM

Excellent guys, thank you for bringing this to a conclusion.

Cavedude, are the updates you mentioned in the peq-db svn? If so, I'll just continue to source from there. Thanks again!

**cavedude** · #7 10-23-2007, 02:32 AM

They will be by the end of the day