Crashing When Logging In

[Uleat]

If you do find the specific item(s) causing the issue, please post an export using:

[CMD Prompt]

mysqldump -t -u MyUserName -pMyPassword MyDatabase items --where="id = n"

changing the 'My' info appropriately..

-- or --

[HeidiSQL SQL Inserts Export]

SELECT * FROM `items` WHERE `id` = n;

and export the results using 'SQL Inserts' option..


..where

n

is the item id causing the issue.


It should look something like this:

Originally Posted by CMD Prompt Export

-- MySQL dump 10.15 Distrib 10.0.22-MariaDB, for Win64 (AMD64)
--
-- Host: localhost Database: peq
-- ------------------------------------------------------
-- Server version 10.0.22-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `items`
--
-- WHERE: id = 1001

LOCK TABLES `items` WRITE;
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
INSERT INTO `items` VALUES (1001,0,'Cloth Cap',0,2,0,0,0,0,0,0,0,0,0,7,1,0,1,0,1
,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','0 ',65535,4278190080,'0',0,0,200
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',-1,0,0,0,0,0,0,639,'IT63',0,10,5,0
,0,0,'Cloth Cap',0,0,0,0,0,0,0,0,0,1,1,0,0,0,65535,0,0,0,0,1,0 ,1,-1,0,4,-1,0,0,0
,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,'2012-12-27 10:34:27','',0,0,0,0,1,0,0,'',0,-
1,0,0,0,0,-1,0,0,0,0,0,0,0,0,-1,0,0,0,0,NULL,'2012-04-01 05:58:31',NULL,'13THFLO
OR',0,'',1,0,0,0,0,0,0,0,0,0,-1,0,1,'00000000000000000000',0,'',-1,0,0,0,0,'',-1
,0,0,0,0,0,'',-1,0,0,0,0,0,'',-1,0,0,0,0,0,'',-1,0,0,0,0,0,0,'','','','','',0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'2003-10-09 13:57:50',0,70,0,0,0,-1,0,0,0,0,0,0,
0,0,'',-1,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-256,255,0,0,0,0,0,0,0,0);
/*!40000 ALTER TABLE `items` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-01-04 17:15:02

or this:

Originally Posted by HeidiSQL SQL Inserts Export

INSERT INTO `items` (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`, `augslot5type`, `augslot5visible`, `augslot6type`, `augslot6visible`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `herosforgemodel`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `UNK012`, `UNK013`, `benefitflag`, `UNK054`, `UNK059`, `booktype`, `recastdelay`, `recasttype`, `guildfavor`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`, `lorefile`, `UNK014`, `svcorruption`, `skillmodmax`, `UNK060`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`, `augslot5unk2`, `augslot6unk2`, `UNK120`, `UNK121`, `questitemflag`, `UNK132`, `clickunk5`, `clickunk6`, `clickunk7`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `UNK193`, `purity`, `evoitem`, `evoid`, `evolvinglevel`, `evomax`, `clickname`, `procname`, `wornname`, `focusname`, `scrollname`, `dsmitigation`, `heroic_str`, `heroic_int`, `heroic_wis`, `heroic_agi`, `heroic_dex`, `heroic_sta`, `heroic_cha`, `heroic_pr`, `heroic_dr`, `heroic_fr`, `heroic_cr`, `heroic_mr`, `heroic_svcorrup`, `healamt`, `spelldmg`, `clairvoyance`, `backstabdmg`, `created`, `elitematerial`, `ldonsellbackrate`, `scriptfileid`, `expendablearrow`, `powersourcecapacity`, `bardeffect`, `bardeffecttype`, `bardlevel2`, `bardlevel`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardname`, `bardunk7`, `UNK214`, `UNK219`, `UNK220`, `UNK221`, `heirloom`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `placeable`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `epicitem`) VALUES (1001, 0, 'Cloth Cap', 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '0', 65535, 4278190080, '0', 0, 0, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, 639, 'IT63', 0, 10, 5, 0, 0, 0, 'Cloth Cap', 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 65535, 0, 0, 0, 0, 1, 0, 1, -1, 0, 4, -1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2012-12-27 10:34:27', '', 0, 0, 0, 0, 1, 0, 0, '', 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, NULL, '2012-04-01 05:58:31', NULL, '13THFLOOR', 0, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 1, '00000000000000000000', 0, '', -1, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2003-10-09 13:57:50', 0, 70, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -256, 255, 0, 0, 0, 0, 0, 0, 0, 0);

I can look at the column values and see if something is causing an issue.

[Akkadius]

What has probably happened is that shared_memory isn't being properly reloaded.

If you ever ran the #hotfix command there is a variable called "hotfix" in the table "variables" that contains the hotfix prefix. That needs to get wiped out and all of the files in shared_memory need to be deleted before you rerun shared memory and your issue should go away.

[Excuses]

Originally Posted by Akkadius

What has probably happened is that shared_memory isn't being properly reloaded.

If you ever ran the #hotfix command there is a variable called "hotfix" in the table "variables" that contains the hotfix prefix. That needs to get wiped out and all of the files in shared_memory need to be deleted before you rerun shared memory and your issue should go away.

Well, it has happened again, this way looks a bit healthier to do.

is the #hotfix command ingame or through cmd?

shared_memory is suppose to be re-run everytime you create a new item? or create, editing, even npcs?

[Excuses]

Uleat,

This is one item that is causing the crash;

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Jan 04, 2016 at 07:41 PM
-- Server version: 5.1.73-community
-- PHP Version: 5.5.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `peq`
--

-- --------------------------------------------------------

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(11) NOT NULL DEFAULT '0',
  `minstatus` smallint(5) NOT NULL DEFAULT '0',
  `Name` varchar(64) NOT NULL DEFAULT '',
  `aagi` int(11) NOT NULL DEFAULT '0',
  `ac` int(11) NOT NULL DEFAULT '0',
  `accuracy` int(11) NOT NULL DEFAULT '0',
  `acha` int(11) NOT NULL DEFAULT '0',
  `adex` int(11) NOT NULL DEFAULT '0',
  `aint` int(11) NOT NULL DEFAULT '0',
  `artifactflag` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `asta` int(11) NOT NULL DEFAULT '0',
  `astr` int(11) NOT NULL DEFAULT '0',
  `attack` int(11) NOT NULL DEFAULT '0',
  `augrestrict` int(11) NOT NULL DEFAULT '0',
  `augslot1type` tinyint(3) NOT NULL DEFAULT '0',
  `augslot1visible` tinyint(3) DEFAULT NULL,
  `augslot2type` tinyint(3) NOT NULL DEFAULT '0',
  `augslot2visible` tinyint(3) DEFAULT NULL,
  `augslot3type` tinyint(3) NOT NULL DEFAULT '0',
  `augslot3visible` tinyint(3) DEFAULT NULL,
  `augslot4type` tinyint(3) NOT NULL DEFAULT '0',
  `augslot4visible` tinyint(3) DEFAULT NULL,
  `augslot5type` tinyint(3) NOT NULL DEFAULT '0',
  `augslot5visible` tinyint(3) DEFAULT NULL,
  `augslot6type` tinyint(3) NOT NULL DEFAULT '0',
  `augslot6visible` tinyint(3) NOT NULL DEFAULT '0',
  `augtype` int(11) NOT NULL DEFAULT '0',
  `avoidance` int(11) NOT NULL DEFAULT '0',
  `awis` int(11) NOT NULL DEFAULT '0',
  `bagsize` int(11) NOT NULL DEFAULT '0',
  `bagslots` int(11) NOT NULL DEFAULT '0',
  `bagtype` int(11) NOT NULL DEFAULT '0',
  `bagwr` int(11) NOT NULL DEFAULT '0',
  `banedmgamt` int(11) NOT NULL DEFAULT '0',
  `banedmgraceamt` int(11) NOT NULL DEFAULT '0',
  `banedmgbody` int(11) NOT NULL DEFAULT '0',
  `banedmgrace` int(11) NOT NULL DEFAULT '0',
  `bardtype` int(11) NOT NULL DEFAULT '0',
  `bardvalue` int(11) NOT NULL DEFAULT '0',
  `book` int(11) NOT NULL DEFAULT '0',
  `casttime` int(11) NOT NULL DEFAULT '0',
  `casttime_` int(11) NOT NULL DEFAULT '0',
  `charmfile` varchar(32) NOT NULL DEFAULT '',
  `charmfileid` varchar(32) NOT NULL DEFAULT '',
  `classes` int(11) NOT NULL DEFAULT '0',
  `color` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `combateffects` varchar(10) NOT NULL DEFAULT '',
  `extradmgskill` int(11) NOT NULL DEFAULT '0',
  `extradmgamt` int(11) NOT NULL DEFAULT '0',
  `price` int(11) NOT NULL DEFAULT '0',
  `cr` int(11) NOT NULL DEFAULT '0',
  `damage` int(11) NOT NULL DEFAULT '0',
  `damageshield` int(11) NOT NULL DEFAULT '0',
  `deity` int(11) NOT NULL DEFAULT '0',
  `delay` int(11) NOT NULL DEFAULT '0',
  `augdistiller` int(11) NOT NULL DEFAULT '0',
  `dotshielding` int(11) NOT NULL DEFAULT '0',
  `dr` int(11) NOT NULL DEFAULT '0',
  `clicktype` int(11) NOT NULL DEFAULT '0',
  `clicklevel2` int(11) NOT NULL DEFAULT '0',
  `elemdmgtype` int(11) NOT NULL DEFAULT '0',
  `elemdmgamt` int(11) NOT NULL DEFAULT '0',
  `endur` int(11) NOT NULL DEFAULT '0',
  `factionamt1` int(11) NOT NULL DEFAULT '0',
  `factionamt2` int(11) NOT NULL DEFAULT '0',
  `factionamt3` int(11) NOT NULL DEFAULT '0',
  `factionamt4` int(11) NOT NULL DEFAULT '0',
  `factionmod1` int(11) NOT NULL DEFAULT '0',
  `factionmod2` int(11) NOT NULL DEFAULT '0',
  `factionmod3` int(11) NOT NULL DEFAULT '0',
  `factionmod4` int(11) NOT NULL DEFAULT '0',
  `filename` varchar(32) NOT NULL DEFAULT '',
  `focuseffect` int(11) NOT NULL DEFAULT '0',
  `fr` int(11) NOT NULL DEFAULT '0',
  `fvnodrop` int(11) NOT NULL DEFAULT '0',
  `haste` int(11) NOT NULL DEFAULT '0',
  `clicklevel` int(11) NOT NULL DEFAULT '0',
  `hp` int(11) NOT NULL DEFAULT '0',
  `regen` int(11) NOT NULL DEFAULT '0',
  `icon` int(11) NOT NULL DEFAULT '0',
  `idfile` varchar(30) NOT NULL DEFAULT '',
  `itemclass` int(11) NOT NULL DEFAULT '0',
  `itemtype` int(11) NOT NULL DEFAULT '0',
  `ldonprice` int(11) NOT NULL DEFAULT '0',
  `ldontheme` int(11) NOT NULL DEFAULT '0',
  `ldonsold` int(11) NOT NULL DEFAULT '0',
  `light` int(11) NOT NULL DEFAULT '0',
  `lore` varchar(80) NOT NULL DEFAULT '',
  `loregroup` int(11) NOT NULL DEFAULT '0',
  `magic` int(11) NOT NULL DEFAULT '0',
  `mana` int(11) NOT NULL DEFAULT '0',
  `manaregen` int(11) NOT NULL DEFAULT '0',
  `enduranceregen` int(11) NOT NULL DEFAULT '0',
  `material` int(11) NOT NULL DEFAULT '0',
  `herosforgemodel` int(11) NOT NULL DEFAULT '0',
  `maxcharges` int(11) NOT NULL DEFAULT '0',
  `mr` int(11) NOT NULL DEFAULT '0',
  `nodrop` int(11) NOT NULL DEFAULT '0',
  `norent` int(11) NOT NULL DEFAULT '0',
  `pendingloreflag` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `pr` int(11) NOT NULL DEFAULT '0',
  `procrate` int(11) NOT NULL DEFAULT '0',
  `races` int(11) NOT NULL DEFAULT '0',
  `range` int(11) NOT NULL DEFAULT '0',
  `reclevel` int(11) NOT NULL DEFAULT '0',
  `recskill` int(11) NOT NULL DEFAULT '0',
  `reqlevel` int(11) NOT NULL DEFAULT '0',
  `sellrate` float NOT NULL DEFAULT '0',
  `shielding` int(11) NOT NULL DEFAULT '0',
  `size` int(11) NOT NULL DEFAULT '0',
  `skillmodtype` int(11) NOT NULL DEFAULT '0',
  `skillmodvalue` int(11) NOT NULL DEFAULT '0',
  `slots` int(11) NOT NULL DEFAULT '0',
  `clickeffect` int(11) NOT NULL DEFAULT '0',
  `spellshield` int(11) NOT NULL DEFAULT '0',
  `strikethrough` int(11) NOT NULL DEFAULT '0',
  `stunresist` int(11) NOT NULL DEFAULT '0',
  `summonedflag` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `tradeskills` int(11) NOT NULL DEFAULT '0',
  `favor` int(11) NOT NULL DEFAULT '0',
  `weight` int(11) NOT NULL DEFAULT '0',
  `UNK012` int(11) NOT NULL DEFAULT '0',
  `UNK013` int(11) NOT NULL DEFAULT '0',
  `benefitflag` int(11) NOT NULL DEFAULT '0',
  `UNK054` int(11) NOT NULL DEFAULT '0',
  `UNK059` int(11) NOT NULL DEFAULT '0',
  `booktype` int(11) NOT NULL DEFAULT '0',
  `recastdelay` int(11) NOT NULL DEFAULT '0',
  `recasttype` int(11) NOT NULL DEFAULT '0',
  `guildfavor` int(11) NOT NULL DEFAULT '0',
  `UNK123` int(11) NOT NULL DEFAULT '0',
  `UNK124` int(11) NOT NULL DEFAULT '0',
  `attuneable` int(11) NOT NULL DEFAULT '0',
  `nopet` int(11) NOT NULL DEFAULT '0',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `UNK127` int(11) NOT NULL DEFAULT '0',
  `pointtype` int(11) NOT NULL DEFAULT '0',
  `potionbelt` int(11) NOT NULL DEFAULT '0',
  `potionbeltslots` int(11) NOT NULL DEFAULT '0',
  `stacksize` int(11) NOT NULL DEFAULT '0',
  `notransfer` int(11) NOT NULL DEFAULT '0',
  `stackable` int(11) NOT NULL DEFAULT '0',
  `UNK134` varchar(255) NOT NULL DEFAULT '',
  `UNK137` int(11) NOT NULL DEFAULT '0',
  `proceffect` int(11) NOT NULL DEFAULT '0',
  `proctype` int(11) NOT NULL DEFAULT '0',
  `proclevel2` int(11) NOT NULL DEFAULT '0',
  `proclevel` int(11) NOT NULL DEFAULT '0',
  `UNK142` int(11) NOT NULL DEFAULT '0',
  `worneffect` int(11) NOT NULL DEFAULT '0',
  `worntype` int(11) NOT NULL DEFAULT '0',
  `wornlevel2` int(11) NOT NULL DEFAULT '0',
  `wornlevel` int(11) NOT NULL DEFAULT '0',
  `UNK147` int(11) NOT NULL DEFAULT '0',
  `focustype` int(11) NOT NULL DEFAULT '0',
  `focuslevel2` int(11) NOT NULL DEFAULT '0',
  `focuslevel` int(11) NOT NULL DEFAULT '0',
  `UNK152` int(11) NOT NULL DEFAULT '0',
  `scrolleffect` int(11) NOT NULL DEFAULT '0',
  `scrolltype` int(11) NOT NULL DEFAULT '0',
  `scrolllevel2` int(11) NOT NULL DEFAULT '0',
  `scrolllevel` int(11) NOT NULL DEFAULT '0',
  `UNK157` int(11) NOT NULL DEFAULT '0',
  `serialized` datetime DEFAULT NULL,
  `verified` datetime DEFAULT NULL,
  `serialization` text,
  `source` varchar(20) NOT NULL DEFAULT '',
  `UNK033` int(11) NOT NULL DEFAULT '0',
  `lorefile` varchar(32) NOT NULL DEFAULT '',
  `UNK014` int(11) NOT NULL DEFAULT '0',
  `svcorruption` int(11) NOT NULL DEFAULT '0',
  `skillmodmax` int(11) NOT NULL DEFAULT '0',
  `UNK060` int(11) NOT NULL DEFAULT '0',
  `augslot1unk2` int(11) NOT NULL DEFAULT '0',
  `augslot2unk2` int(11) NOT NULL DEFAULT '0',
  `augslot3unk2` int(11) NOT NULL DEFAULT '0',
  `augslot4unk2` int(11) NOT NULL DEFAULT '0',
  `augslot5unk2` int(11) NOT NULL DEFAULT '0',
  `augslot6unk2` int(11) NOT NULL DEFAULT '0',
  `UNK120` int(11) NOT NULL DEFAULT '0',
  `UNK121` int(11) NOT NULL DEFAULT '0',
  `questitemflag` int(11) NOT NULL DEFAULT '0',
  `UNK132` text NOT NULL,
  `clickunk5` int(11) NOT NULL DEFAULT '0',
  `clickunk6` varchar(32) NOT NULL DEFAULT '',
  `clickunk7` int(11) NOT NULL DEFAULT '0',
  `procunk1` int(11) NOT NULL DEFAULT '0',
  `procunk2` int(11) NOT NULL DEFAULT '0',
  `procunk3` int(11) NOT NULL DEFAULT '0',
  `procunk4` int(11) NOT NULL DEFAULT '0',
  `procunk6` varchar(32) NOT NULL DEFAULT '',
  `procunk7` int(11) NOT NULL DEFAULT '0',
  `wornunk1` int(11) NOT NULL DEFAULT '0',
  `wornunk2` int(11) NOT NULL DEFAULT '0',
  `wornunk3` int(11) NOT NULL DEFAULT '0',
  `wornunk4` int(11) NOT NULL DEFAULT '0',
  `wornunk5` int(11) NOT NULL DEFAULT '0',
  `wornunk6` varchar(32) NOT NULL DEFAULT '',
  `wornunk7` int(11) NOT NULL DEFAULT '0',
  `focusunk1` int(11) NOT NULL DEFAULT '0',
  `focusunk2` int(11) NOT NULL DEFAULT '0',
  `focusunk3` int(11) NOT NULL DEFAULT '0',
  `focusunk4` int(11) NOT NULL DEFAULT '0',
  `focusunk5` int(11) NOT NULL DEFAULT '0',
  `focusunk6` varchar(32) NOT NULL DEFAULT '',
  `focusunk7` int(11) NOT NULL DEFAULT '0',
  `scrollunk1` int(11) NOT NULL DEFAULT '0',
  `scrollunk2` int(11) NOT NULL DEFAULT '0',
  `scrollunk3` int(11) NOT NULL DEFAULT '0',
  `scrollunk4` int(11) NOT NULL DEFAULT '0',
  `scrollunk5` int(11) NOT NULL DEFAULT '0',
  `scrollunk6` varchar(32) NOT NULL DEFAULT '',
  `scrollunk7` int(11) NOT NULL DEFAULT '0',
  `UNK193` int(11) NOT NULL DEFAULT '0',
  `purity` int(11) NOT NULL DEFAULT '0',
  `evoitem` int(11) NOT NULL DEFAULT '0',
  `evoid` int(11) NOT NULL DEFAULT '0',
  `evolvinglevel` int(11) NOT NULL DEFAULT '0',
  `evomax` int(11) NOT NULL DEFAULT '0',
  `clickname` varchar(64) NOT NULL DEFAULT '',
  `procname` varchar(64) NOT NULL DEFAULT '',
  `wornname` varchar(64) NOT NULL DEFAULT '',
  `focusname` varchar(64) NOT NULL DEFAULT '',
  `scrollname` varchar(64) NOT NULL DEFAULT '',
  `dsmitigation` smallint(6) NOT NULL DEFAULT '0',
  `heroic_str` smallint(6) NOT NULL DEFAULT '0',
  `heroic_int` smallint(6) NOT NULL DEFAULT '0',
  `heroic_wis` smallint(6) NOT NULL DEFAULT '0',
  `heroic_agi` smallint(6) NOT NULL DEFAULT '0',
  `heroic_dex` smallint(6) NOT NULL DEFAULT '0',
  `heroic_sta` smallint(6) NOT NULL DEFAULT '0',
  `heroic_cha` smallint(6) NOT NULL DEFAULT '0',
  `heroic_pr` smallint(6) NOT NULL DEFAULT '0',
  `heroic_dr` smallint(6) NOT NULL DEFAULT '0',
  `heroic_fr` smallint(6) NOT NULL DEFAULT '0',
  `heroic_cr` smallint(6) NOT NULL DEFAULT '0',
  `heroic_mr` smallint(6) NOT NULL DEFAULT '0',
  `heroic_svcorrup` smallint(6) NOT NULL DEFAULT '0',
  `healamt` smallint(6) NOT NULL DEFAULT '0',
  `spelldmg` smallint(6) NOT NULL DEFAULT '0',
  `clairvoyance` smallint(6) NOT NULL DEFAULT '0',
  `backstabdmg` smallint(6) NOT NULL DEFAULT '0',
  `created` varchar(64) NOT NULL DEFAULT '',
  `elitematerial` smallint(6) NOT NULL DEFAULT '0',
  `ldonsellbackrate` smallint(6) NOT NULL DEFAULT '0',
  `scriptfileid` smallint(6) NOT NULL DEFAULT '0',
  `expendablearrow` smallint(6) NOT NULL DEFAULT '0',
  `powersourcecapacity` smallint(6) NOT NULL DEFAULT '0',
  `bardeffect` smallint(6) NOT NULL DEFAULT '0',
  `bardeffecttype` smallint(6) NOT NULL DEFAULT '0',
  `bardlevel2` smallint(6) NOT NULL DEFAULT '0',
  `bardlevel` smallint(6) NOT NULL DEFAULT '0',
  `bardunk1` smallint(6) NOT NULL DEFAULT '0',
  `bardunk2` smallint(6) NOT NULL DEFAULT '0',
  `bardunk3` smallint(6) NOT NULL DEFAULT '0',
  `bardunk4` smallint(6) NOT NULL DEFAULT '0',
  `bardunk5` smallint(6) NOT NULL DEFAULT '0',
  `bardname` varchar(64) NOT NULL DEFAULT '',
  `bardunk7` smallint(6) NOT NULL DEFAULT '0',
  `UNK214` smallint(6) NOT NULL DEFAULT '0',
  `UNK219` int(11) NOT NULL DEFAULT '0',
  `UNK220` int(11) NOT NULL DEFAULT '0',
  `UNK221` int(11) NOT NULL DEFAULT '0',
  `heirloom` int(11) NOT NULL DEFAULT '0',
  `UNK223` int(11) NOT NULL DEFAULT '0',
  `UNK224` int(11) NOT NULL DEFAULT '0',
  `UNK225` int(11) NOT NULL DEFAULT '0',
  `UNK226` int(11) NOT NULL DEFAULT '0',
  `UNK227` int(11) NOT NULL DEFAULT '0',
  `UNK228` int(11) NOT NULL DEFAULT '0',
  `UNK229` int(11) NOT NULL DEFAULT '0',
  `UNK230` int(11) NOT NULL DEFAULT '0',
  `UNK231` int(11) NOT NULL DEFAULT '0',
  `UNK232` int(11) NOT NULL DEFAULT '0',
  `UNK233` int(11) NOT NULL DEFAULT '0',
  `UNK234` int(11) NOT NULL DEFAULT '0',
  `placeable` int(11) NOT NULL DEFAULT '0',
  `UNK236` int(11) NOT NULL DEFAULT '0',
  `UNK237` int(11) NOT NULL DEFAULT '0',
  `UNK238` int(11) NOT NULL DEFAULT '0',
  `UNK239` int(11) NOT NULL DEFAULT '0',
  `UNK240` int(11) NOT NULL DEFAULT '0',
  `UNK241` int(11) NOT NULL DEFAULT '0',
  `epicitem` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`, `augslot5type`, `augslot5visible`, `augslot6type`, `augslot6visible`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `herosforgemodel`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `UNK012`, `UNK013`, `benefitflag`, `UNK054`, `UNK059`, `booktype`, `recastdelay`, `recasttype`, `guildfavor`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`, `lorefile`, `UNK014`, `svcorruption`, `skillmodmax`, `UNK060`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`, `augslot5unk2`, `augslot6unk2`, `UNK120`, `UNK121`, `questitemflag`, `UNK132`, `clickunk5`, `clickunk6`, `clickunk7`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `UNK193`, `purity`, `evoitem`, `evoid`, `evolvinglevel`, `evomax`, `clickname`, `procname`, `wornname`, `focusname`, `scrollname`, `dsmitigation`, `heroic_str`, `heroic_int`, `heroic_wis`, `heroic_agi`, `heroic_dex`, `heroic_sta`, `heroic_cha`, `heroic_pr`, `heroic_dr`, `heroic_fr`, `heroic_cr`, `heroic_mr`, `heroic_svcorrup`, `healamt`, `spelldmg`, `clairvoyance`, `backstabdmg`, `created`, `elitematerial`, `ldonsellbackrate`, `scriptfileid`, `expendablearrow`, `powersourcecapacity`, `bardeffect`, `bardeffecttype`, `bardlevel2`, `bardlevel`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardname`, `bardunk7`, `UNK214`, `UNK219`, `UNK220`, `UNK221`, `heirloom`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `placeable`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `epicitem`) VALUES
(132482, 0, 'Stone of Lord Darish', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '0', 0, 4278190080, '0', -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Stone of Lord Darish', -1, 0, 0, 0, 0, 0, 0, 507, 'IT507', 0, 6, 0, 0, 0, 0, 'Stone of Lord Darish', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, 0, -1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2016-01-04 15:33:00', '', 0, 0, 0, 0, 1, 0, 0, '', 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, NULL, '2016-01-03 14:39:28', NULL, 'CUSTOM', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '00000000000000000000', 0, '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '201613143928', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD UNIQUE KEY `ID` (`id`),
  ADD KEY `name_idx` (`Name`),
  ADD KEY `lore_idx` (`lore`),
  ADD KEY `minstatus` (`minstatus`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[Uleat]

Thanks for posting that!


Does item id 41525 "Quill of the Fury" also cause the same crash, perchance?

[Excuses]

Will try now

[Excuses]

Originally Posted by Uleat

Thanks for posting that!


Does item id 41525 "Quill of the Fury" also cause the same crash, perchance?

No it does not, works fine.

In total, i have create 6 items. which all 6 are used in a quest, but i am removing 3 of them

edit: all 6 items i have created crash the player it is looted. I have ran #hotfix, and all appriopriate sequences (i hope)

[Uleat]

I'm looking for differences in field values between what you posted and existing items.

Here are a few so far:

SELECT * FROM `items` WHERE `material` = '-1'
SELECT * FROM `items` WHERE `itemtype` = '6'

Since that other item didn't fail for you, you may try looking at the `created` column.

The insert query that you posted shows a malformed timestamp.

`updated` = '2016-01-04 15:33:00'
`verified` = '2016-01-03 14:39:28'
`created` = '201613143928'

[Excuses]

I'll give that a shot

[Excuses]

Ok no luck there either, might it be best if i just edit current items instead of making new ones?

Tested by changing the timestamp and material, still does it. TBH im quite stuck now

[Akkadius]

My post had the answer, just saying.

[Excuses]

I did run shared_memory, several times and also hotfix but neither solve the problem. Can u shed some light on the proprer procedure? I have read the wiki maybe i missed a part.

[Excuses]

Originally Posted by Akkadius

What has probably happened is that shared_memory isn't being properly reloaded.

If you ever ran the #hotfix command there is a variable called "hotfix" in the table "variables" that contains the hotfix prefix. That needs to get wiped out and all of the files in shared_memory need to be deleted before you rerun shared memory and your issue should go away.

Did that, any new items made still crash out.

cleaned the hotfix_ prefix in hotfix_name (variables)
deleted shared folder data, rerun shared_memory.

Still crashes:(

[Akkadius]

Make sure that when you do all that, that all world and zone processes are closed before running shared_memory and booting your server once again.

Anytime you crash on a shared load like that its related to shared memory referencing invalid id's

[Excuses]

So when it says Zone: current hotfix_ in use, what does that relate to?

I must be doing something wrong, deleted and created a brand new item, did this, and still crashes.

I create the item through PEQ Editor