Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page Crashing When Logging In

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2016, 06:05 PM
Huppy's Avatar
Huppy
Demi-God
  
Join Date: Oct 2010
Posts: 1,332
Default
Something, I've done in the past, when I need a custom item for a quest, etc., which one could call it
a quick easy "cheat" (smirk), I find an item in the db from an expansion thats not in use and, without
changing the item ID, I edit everything else.
Reply With Quote
  #2  
Old 01-04-2016, 07:19 PM
Akkadius's Avatar
Akkadius
Administrator
  
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default
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.
Reply With Quote
  #3  
Old 01-04-2016, 07:45 PM
Excuses
Hill Giant
  
Join Date: Mar 2015
Posts: 126
Default
Quote:
Originally Posted by Akkadius View Post
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?
Reply With Quote
  #4  
Old 01-04-2016, 09:40 PM
Excuses
Hill Giant
  
Join Date: Mar 2015
Posts: 126
Default
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 */;
Reply With Quote
  #5  
Old 01-05-2016, 12:50 AM
Excuses
Hill Giant
  
Join Date: Mar 2015
Posts: 126
Default
Quote:
Originally Posted by Akkadius View Post
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:(
Reply With Quote
  #6  
Old 01-05-2016, 03:00 AM
Akkadius's Avatar
Akkadius
Administrator
  
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default
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
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

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 08:40 AM.

EQEmulator - Archive - Top

 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3