EQEmulator Forums
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Crashing When Logging In (https://www.eqemulator.org/forums/showthread.php?t=40311)

Uleat 01-04-2016 06:26 PM
If you do find the specific item(s) causing the issue, please post an export using:

[CMD Prompt]
Code:
mysqldump -t -u MyUserName -pMyPassword MyDatabase items --where="id = n"
changing the 'My' info appropriately..

-- or --

[HeidiSQL SQL Inserts Export]
Code:
SELECT * FROM `items` WHERE `id` = n;
and export the results using 'SQL Inserts' option..


..where
Code:
n
is the item id causing the issue.


It should look something like this:
Quote:
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:
Quote:
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 01-04-2016 07:19 PM
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 01-04-2016 07:45 PM
Quote:
Originally Posted by Akkadius (Post 246265)
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 01-04-2016 09:40 PM
Uleat,

This is one item that is causing the crash;

Code:
-- 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 01-04-2016 10:00 PM
Thanks for posting that!


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

Excuses 01-04-2016 10:38 PM
Will try now

Excuses 01-04-2016 10:44 PM
Quote:
Originally Posted by Uleat (Post 246280)
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 01-04-2016 11:26 PM
I'm looking for differences in field values between what you posted and existing items.

Here are a few so far:
Code:
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.
Quote:
`updated` = '2016-01-04 15:33:00'
`verified` = '2016-01-03 14:39:28'
`created` = '201613143928'

Excuses 01-05-2016 12:02 AM
I'll give that a shot

Excuses 01-05-2016 12:08 AM
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 01-05-2016 12:29 AM
My post had the answer, just saying.

Excuses 01-05-2016 12:39 AM
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 01-05-2016 12:50 AM
Quote:
Originally Posted by Akkadius (Post 246265)
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 01-05-2016 03:00 AM
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 01-05-2016 05:02 PM
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


All times are GMT -4. The time now is 07:50 AM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.