Closed catapultam-habeo closed 2 years ago
Kinglykrab
commented
2 years ago Unable to replicate this crash.
Have tried multiple different spell bucket names such as Skeleton, Skeleton123, Skeleton Stuff, and Skeleton12''''4234523fsafsdfz__21321~!@#@#!#$%.
Not getting any crashes at all with #scribespells.
catapultam-habeo
commented
2 years ago -- version 5.1.2
-- https://www.phpmyadmin.net/
--
-- Host: mariadb
-- Generation Time: Mar 07, 2022 at 09:42 PM
-- Server version: 10.6.5-MariaDB-1:10.6.5+maria~focal
-- PHP Version: 8.0.15
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
--
-- Database: `peq`
--
--
-- Dumping data for table `spell_buckets`
--
INSERT INTO `spell_buckets` (`spellid`, `key`, `value`) VALUES
(666, 'Alter Plane: Hate', 'enabled'),
(1196, 'Ancient: Lcea\\\'s Lament', 'enabled'),
(1197, 'Ancient: Lullaby of Shadow', 'enabled'),
(1326, 'Ring of the Combines', 'enabled'),
(1517, 'Circle of the Combines', 'enabled'),
(1936, 'Manifest Elements', 'enabled'),
(1944, 'Summon Orb', 'enabled'),
(2109, 'Ancient: High Priest\\\'s Bulwark', 'enabled'),
(2112, 'Ancient: Feral Avatar', 'enabled'),
(2113, 'Ancient: Scourge of Nife', 'enabled'),
(2114, 'Ancient: Master of Death', 'enabled'),
(2115, 'Ancient: Lifebane', 'enabled'),
(2116, 'Ancient: Destruction of Ice', 'enabled'),
(2117, 'Ancient: Greater Concussion', 'enabled'),
(2118, 'Ancient: Shock of Sun', 'enabled'),
(2119, 'Ancient: Burnout Blaze', 'enabled'),
(2120, 'Ancient: Eternal Rapture', 'enabled'),
(2121, 'Ancient: Chaotic Visions', 'enabled'),
(2122, 'Ancient: Gift of Aegolism', 'enabled'),
(2125, 'Ancient: Legacy of Blades', 'enabled'),
(2126, 'Ancient: Starfire of Ro', 'enabled'),
(3497, 'Ancient: MGB True South', 'enabled'),
(4252, 'Xalirilan\\\'s Lesser Appraisal', 'enabled'),
(4253, 'Xalirilan\\\'s Appraisal', 'enabled'),
(4254, 'Xalirilan\\\'s Greater Appraisal', 'enabled'),
(4255, 'Wuggan\\\'s Lesser Appraisal', 'enabled'),
(4256, 'Wuggan\\\'s Appraisal', 'enabled'),
(4257, 'Wuggan\\\'s Greater Appraisal', 'enabled'),
(4258, 'Iony\\\'s Lesser Augury', 'enabled'),
(4259, 'Iony\\\'s Augury', 'enabled'),
(4260, 'Iony\\\'s Greater Augury', 'enabled'),
(4261, 'Reebo\\\'s Lesser Augury', 'enabled'),
(4262, 'Reebo\\\'s Augury', 'enabled'),
(4263, 'Reebo\\\'s Greater Augury', 'enabled'),
(4264, 'Xalirilan\\\'s Lesser Discombobulation', 'enabled'),
(4265, 'Xalirilan\\\'s Discombobulation', 'enabled'),
(4266, 'Xalirilan\\\'s Greater Discombobulation', 'enabled'),
(4267, 'Wuggan\\\'s Lesser Discombobulation', 'enabled'),
(4268, 'Wuggan\\\'s Discombobulation', 'enabled'),
(4269, 'Wuggan\\\'s Greater Discombobulation', 'enabled'),
(4270, 'Iony\\\'s Lesser Exorcism', 'enabled'),
(4271, 'Iony\\\'s Exorcism', 'enabled'),
(4272, 'Iony\\\'s Greater Exorcism', 'enabled'),
(4273, 'Reebo\\\'s Lesser Exorcism', 'enabled'),
(4274, 'Reebo\\\'s Exorcism', 'enabled'),
(4275, 'Reebo\\\'s Greater Exorcism', 'enabled'),
(4276, 'Xalirilan\\\'s Lesser Extrication', 'enabled'),
(4277, 'Xalirilan\\\'s Extrication', 'enabled'),
(4278, 'Xalirilan\\\'s Greater Extrication', 'enabled'),
(4279, 'Wuggan\\\'s Lesser Extrication', 'enabled'),
(4280, 'Wuggan\\\'s Extrication', 'enabled'),
(4281, 'Wuggan\\\'s Greater Extrication', 'enabled'),
(4282, 'Iony\\\'s Lesser Cleansing', 'enabled'),
(4283, 'Iony\\\'s Cleansing', 'enabled'),
(4284, 'Iony\\\'s Greater Cleansing', 'enabled'),
(4285, 'Reebo\\\'s Lesser Cleansing', 'enabled'),
(4286, 'Reebo\\\'s Cleansing', 'enabled'),
(4287, 'Reebo\\\'s Greater Cleansing', 'enabled'),
(4971, 'Ancient: Chaos Chant', 'enabled'),
(4972, 'Ancient: Frozen Chaos', 'enabled'),
(4973, 'Ancient: Chaos Censure', 'enabled'),
(4974, 'Ancient: Chaos Frost', 'enabled'),
(4975, 'Ancient: Chaos Madness', 'enabled'),
(4976, 'Ancient: Chaos Vortex', 'enabled'),
(4977, 'Ancient: Force of Chaos', 'enabled'),
(4978, 'Ancient: Seduction of Chaos', 'enabled'),
(4979, 'Ancient: Chaotic Pain', 'enabled'),
(4980, 'Ancient: Burning Chaos', 'enabled'),
(4981, 'Ancient: Strike of Chaos', 'enabled'),
(4982, 'Ancient: Bite of Chaos', 'enabled'),
(5016, 'Ancient: Chaos Cry', 'enabled'),
(5018, 'Ancient: Chaos Strike', 'enabled'),
(5020, 'Ancient: Phantom Chaos', 'enabled'),
(5032, 'Ancient: Cry of Chaos', 'enabled'),
(5279, 'Ancient: Pious Conscience', 'enabled'),
(5299, 'Ancient: Force of Jeron', 'enabled'),
(5319, 'Ancient: North Wind', 'enabled'),
(5340, 'Ancient: Bite of Muram', 'enabled'),
(5369, 'Ancient: Glacier Frost', 'enabled'),
(5388, 'Ancient: Call of Power', 'enabled'),
(5418, 'Ancient: Ancestral Calling', 'enabled'),
(5441, 'Ancient: Curse of Mori', 'enabled'),
(5463, 'Ancient: Core Fire', 'enabled'),
(5498, 'Ancient: Nova Strike', 'enabled'),
(5523, 'Ancient: Neurosis', 'enabled'),
(5543, 'Ancient: Savage Ice', 'enabled'),
(6140, 'Ancient: Hallowed Light', 'enabled'),
(6141, 'Ancient: Chlorobon', 'enabled'),
(6142, 'Ancient: Wilslik\\\'s Mending', 'enabled'),
(6143, 'Ancient: Touch of Orshilak', 'enabled'),
(6144, 'Ancient: Voice of Muram', 'enabled'),
(6145, 'Ancient: Veil of Pyrilonus', 'enabled'),
(6146, 'Ancient: Spear of Gelaqua', 'enabled'),
(6502, 'Unpack Brewer\\\'s Still', 'enabled'),
(7681, 'Focus Spellcaster\\\'s Empowering Essence', 'enabled'),
(8235, 'Circle of Undershore', 'enabled'),
(8236, 'Undershore Portal', 'enabled'),
(8237, 'Ring of Undershore', 'enabled'),
(8238, 'Undershore Gate', 'enabled'),
(8239, 'Translocate: Undershore', 'enabled'),
(8965, 'Circle of Arcstone', 'enabled'),
(8966, 'Arcstone Portal', 'enabled'),
(8967, 'Ring of Arcstone', 'enabled'),
(8968, 'Arcstone Gate', 'enabled'),
(8969, 'Translocate: Arcstone', 'enabled'),
(9175, 'Fist of the Sunderock Spires', 'enabled'),
(9443, 'Sunderock Geyser', 'enabled'),
(9953, 'Zephyr: The Steppes', 'enabled'),
(9954, 'Circle of The Steppes', 'enabled'),
(9955, 'Ring of The Steppes', 'enabled'),
(9956, 'Zephyr: Blightfire Moors', 'enabled'),
(9957, 'Circle of Blightfire Moors', 'enabled'),
(9958, 'Ring of Blightfire Moors', 'enabled'),
(10092, 'Sunderock Springwater', 'enabled'),
(10093, 'Sunderock Springwater Rk. II', 'enabled'),
(10094, 'Sunderock Springwater Rk. III', 'enabled'),
(10877, 'Translocate: Sunderock Springs', 'enabled'),
(10878, 'Sunderock Springs Portal', 'enabled'),
(10879, 'Sunderock Springs Gate', 'enabled'),
(10880, 'Translocate: Blightfire Moors', 'enabled'),
(10881, 'Blightfire Moors Portal', 'enabled'),
(10882, 'Blightfire Moors Gate', 'enabled'),
(11980, 'Zephyr: Buried Sea', 'enabled'),
(11981, 'Circle of Buried Sea', 'enabled'),
(11982, 'Ring of Buried Sea', 'enabled'),
(24775, 'Zephyr: Undershore', 'enabled'),
(24776, 'Zephyr: Arcstone', 'enabled'),
(24956, 'Lizard Liver', 'enabled'),
(24957, 'A Little Luck', 'enabled'),
(25694, 'Zephyr: Combines', 'enabled'),
(27749, 'Primary Anchor Gate', 'enabled'),
(27750, 'Translocate: Primary Anchor', 'enabled'),
(27751, 'Primary Anchor Portal', 'enabled'),
(27752, 'Teleport Primary Anchor ', 'enabled'),
(27753, 'Secondary Anchor Gate', 'enabled'),
(27754, 'Translocate: Secondary Anchor', 'enabled'),
(27755, 'Secondary Anchor Portal', 'enabled'),
(27756, 'Teleport Secondary Anchor ', 'enabled'),
(27757, 'Primary Anchor Push', 'enabled'),
(27758, 'Secondary Anchor Push', 'enabled'),
(27779, 'Primary Anchor Ring', 'enabled'),
(27780, 'Zephyr: Primary Anchor', 'enabled'),
(27781, 'Primary Anchor Circle', 'enabled'),
(27782, 'Secondary Anchor Ring', 'enabled'),
(27783, 'Zephyr: Secondary Anchor', 'enabled'),
(27784, 'Secondary Anchor Circle', 'enabled'),
(31991, 'Heroic Leap', 'enabled'),
(33099, 'Teleport Guild Hall Anchor', 'enabled'),
(38001, 'Heroic Leap', 'enabled'),
(41188, 'Teleport Guild Hall Anchor', 'enabled');
COMMIT;here is the contents of my spell buckets table
Kinglykrab
commented
2 years ago Should be resolved here: https://github.com/EQEmu/Server/pull/2043
commit 9f0989e is causing a zone crash when (auto) scribing (some?) spells. Reverting this commit allows for scribing w\ use of spell buckets to omit to work successfully.
This does seem to be somewhat related to the contents of the spell buckets table (emptying the table prevents the crash), but removing the spell mentioned in the below stack trace (2112) does not correct the issue (it is just the alphabetical top of the spell list, I think, this was shaman 1-60), nor does removing all spells with non-alphanumeric characters in their names.