3.2.2 --> 4.0.1 Upgrade: Error when editing Items

mcyzyk · June 16, 2023, 6:50pm

I just upgraded Omeka-S from 3.2.2 to 4.01 and thought I had ironed all the kinks out. But one of our curators just reported not being able to edit Items. I put our instance into Development mode, and here is the error:

Laminas\ServiceManager\Exception\ServiceNotCreatedException
Service with name “dataType” could not be created. Reason: Could not convert database value “Advertisement Chart …” to Doctrine Type json

Details:

Doctrine\DBAL\Types\ConversionException: Could not convert database value "Advertisement Chart ..." to Doctrine Type json in /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ConversionException.php:36 
Stack trace:
#0 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/JsonType.php(63): Doctrine\DBAL\Types\ConversionException::conversionFailed()
#1 /var/www/html/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php(457): Doctrine\DBAL\Types\JsonType->convertToPHPValue()
#2 /var/www/html/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php(314): Doctrine\ORM\Internal\Hydration\AbstractHydrator->gatherRowData()
#3 /var/www/html/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php(143): Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData() 
#4 /var/www/html/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php(268): Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData() 
#5 /var/www/html/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1194): Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll() 
#6 /var/www/html/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1135): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() 
#7 /var/www/html/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(871): Doctrine\ORM\AbstractQuery->execute() 
#8 /var/www/html/omeka-s/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult() 
#9 /var/www/html/omeka-s/application/src/Api/Adapter/AbstractEntityAdapter.php(327): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() 
#10 /var/www/html/omeka-s/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search() 
#11 /var/www/html/omeka-s/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute() 
#12 /var/www/html/omeka-s/modules/CustomVocab/Module.php(221): Omeka\Api\Manager->search() 
#13 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): CustomVocab\Module->addDataTypesToValueAnnotatingConfig()
#14 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners() 
#15 /var/www/html/omeka-s/application/src/Service/ViewHelper/DataTypeFactory.php(25): Laminas\EventManager\EventManager->triggerEvent() 
#16 /var/www/html/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(615): Omeka\Service\ViewHelper\DataTypeFactory->__invoke() 
#17 /var/www/html/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(234): Laminas\ServiceManager\ServiceManager->doCreate()
#18 /var/www/html/omeka-s/vendor/laminas/laminas-servicemanager/src/AbstractPluginManager.php(171): Laminas\ServiceManager\ServiceManager->get() 
#19 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(386): Laminas\ServiceManager\AbstractPluginManager->get() 
#20 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(404): Laminas\View\Renderer\PhpRenderer->plugin() 
#21 /var/www/html/omeka-s/application/view/common/value-annotation-sidebar.phtml(14): Laminas\View\Renderer\PhpRenderer->__call() 
#22 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/o...') 
#23 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Helper/Partial.php(63): Laminas\View\Renderer\PhpRenderer->render() 
#24 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Laminas\View\Helper\Partial->__invoke() 
#25 /var/www/html/omeka-s/application/view/common/resource-fields.phtml(46): Laminas\View\Renderer\PhpRenderer->__call() 
#26 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/o...') 
#27 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Helper/Partial.php(63): Laminas\View\Renderer\PhpRenderer->render() 
#28 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Laminas\View\Helper\Partial->__invoke() 
#29 /var/www/html/omeka-s/application/view/omeka/admin/item/form.phtml(26): Laminas\View\Renderer\PhpRenderer->__call() 
#30 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/o...') 
#31 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Helper/Partial.php(63): Laminas\View\Renderer\PhpRenderer->render() 
#32 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Laminas\View\Helper\Partial->__invoke() 
#33 /var/www/html/omeka-s/application/view/omeka/admin/item/edit.phtml(25): Laminas\View\Renderer\PhpRenderer->__call() 
#34 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/o...') 
#35 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render() 
#36 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render() 
#37 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren() 
#38 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render() 
#39 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render() 
#40 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners()
#41 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent() 
#42 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest() 
#43 /var/www/html/omeka-s/index.php(21): Laminas\Mvc\Application->run() 
#44 {main}

Next Laminas\ServiceManager\Exception\ServiceNotCreatedException: Service with name "dataType" could not be created. Reason: Could not convert database value "Advertisement Chart ..." to Doctrine Type json in /var/www/html/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php:622 
Stack trace: 
#0 /var/www/html/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(234): Laminas\ServiceManager\ServiceManager->doCreate() 
#1 /var/www/html/omeka-s/vendor/laminas/laminas-servicemanager/src/AbstractPluginManager.php(171): Laminas\ServiceManager\ServiceManager->get() 
#2 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(386): Laminas\ServiceManager\AbstractPluginManager->get() 
#3 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(404): Laminas\View\Renderer\PhpRenderer->plugin() 
#4 /var/www/html/omeka-s/application/view/common/value-annotation-sidebar.phtml(14): Laminas\View\Renderer\PhpRenderer->__call() 
#5 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/o...') 
#6 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Helper/Partial.php(63): Laminas\View\Renderer\PhpRenderer->render() 
#7 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Laminas\View\Helper\Partial->__invoke() 
#8 /var/www/html/omeka-s/application/view/common/resource-fields.phtml(46): Laminas\View\Renderer\PhpRenderer->__call() 
#9 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/o...') 
#10 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Helper/Partial.php(63): Laminas\View\Renderer\PhpRenderer->render() 
#11 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Laminas\View\Helper\Partial->__invoke() 
#12 /var/www/html/omeka-s/application/view/omeka/admin/item/form.phtml(26): Laminas\View\Renderer\PhpRenderer->__call() 
#13 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/o...') 
#14 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Helper/Partial.php(63): Laminas\View\Renderer\PhpRenderer->render() 
#15 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Laminas\View\Helper\Partial->__invoke() 
#16 /var/www/html/omeka-s/application/view/omeka/admin/item/edit.phtml(25): Laminas\View\Renderer\PhpRenderer->__call() 
#17 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/o...') 
#18 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render() 
#19 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render() 
#20 /var/www/html/omeka-s/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren() 
#21 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render() 
#22 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render() 
#23 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners() 
#24 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent() 
#25 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest() 
#26 /var/www/html/omeka-s/index.php(21): Laminas\Mvc\Application->run() 
#27 {main}

Not sure what this means! Advice appreciated,

Mark

jflatnes · June 16, 2023, 7:41pm

Can you share what modules you’re using and their versions? This looks like it’s related to the CustomVocab module. If there’s anything interesting in how you upgraded CustomVocab, please share that as well.

mcyzyk · June 16, 2023, 8:34pm

Thanks! I just installed CustomVocab version 2.0.0 this morning.

Here are our modules:

Advanced Search Plus (archived, replaced by Advanced Search) version 3.3.5.7 by Daniel Berthereau
Error: Advanced Search Plus (archived, replaced by Advanced Search) requires Omeka S ^3.0.0
Api Info version 3.4.9.8 by Daniel Berthereau
Block Plus version 3.4.16 by Daniel Berthereau
Bulk Edit version 3.4.20 by Daniel Berthereau
Bulk Export version 3.4.18 by Daniel Berthereau
Collecting version 1.10.0 by Omeka Team
CSSEditor version 1.3.1 by Omeka Team
CSV Import version 2.4.1 by Omeka Team and Daniel Berthereau
Custom Ontology version 3.4.5.1 by Daniel Berthereau
Custom Vocab version 2.0.0 by Omeka Team
Dspace Connector version 1.6.1 by Omeka Team
Easy Admin version 3.4.10 by Daniel Berthereau
Easy Install (archived, replaced by Easy Admin) version 3.3.7 by Daniel Berthereau .
Error: Easy Install (archived, replaced by Easy Admin) requires Omeka S ^3.1.0
EasyAdmin-3.4.10
Error: invalid config/module.ini file
Export version 1.5.0 by Laura Eiford
Error: Export requires Omeka S ^1.0.0 || ^2.0.0 || ^3.0.0
File Sideload version 1.7.1 by Omeka Team and Daniel Berthereau
Google Analytics version 1.3 by Libnamic
Johns Hopkins Block Module version 1.0 Adds block for use in creating content
jQueryUI version 1.12.1 by BibLibre
Log version 3.4.15 by Daniel Berthereau
Mapping version 1.9.0 by Omeka Team
Metadata Browse version 1.6.0 by Omeka Team
OAI-PMH Repository version 3.4.6 by Daniel Berthereau
PDF Embed version 1.2.1 by John Flatness
Reference version 3.4.42 by Daniel Berthereau
Simple Carousel version 1.3.0 by ESnark
Error: Simple Carousel requires Omeka S ^3.0.0
Timeline version 3.4.18 by Daniel Berthereau

jflatnes · June 16, 2023, 8:51pm

And how’d you do the upgrade, the usual manual process of deleting the old module’s folder and replacing it with the new one then clicking Upgrade in the interface? Or any other process?

Basically it looks like the upgrade that Custom Vocab is supposed to do didn’t happen, and I’m trying to figure out why that might be. If you happen to know or remember what version of Custom Vocab you had installed before, that could also help.

mcyzyk · June 16, 2023, 9:10pm

Thanks, John, Yes that was how I did the upgrade of these modules, but put the new ones in place, then clicked Upgrade.

The previous version we were running of this plugin was 1.3.1.

Mark

jflatnes · June 16, 2023, 9:18pm

Hmmm, okay. Thanks for that info.

I’m still not quite sure what’s going on here… what would help a lot, if you can provide it, would be a MySQL dump of your custom_vocab table, either from before or after the upgrade. I’d be looking to reproduce the problem (with a “before” dump) or see what upgrade steps look like they’ve happened and which haven’t (with an “after” dump).

mcyzyk · June 17, 2023, 3:39pm

John, here below (it won’t let me upload them at attachments) are two SQL Dumps of that table, OLD and NEW. Thanks for looking at this!

From what I’m seeing, that plugin was only used by an old project that is no longer active. I could delete the Site, then delete this plugin???

Mark

##############################################

OLD

-- MySQL dump 10.13  Distrib 8.0.33, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: omekasprod
-- ------------------------------------------------------
-- Server version	8.0.33-0ubuntu0.20.04.2

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `custom_vocab`
--

DROP TABLE IF EXISTS `custom_vocab`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `custom_vocab` (
  `id` int NOT NULL AUTO_INCREMENT,
  `item_set_id` int DEFAULT NULL,
  `owner_id` int DEFAULT NULL,
  `label` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `terms` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8533D2A5EA750E8` (`label`),
  KEY `IDX_8533D2A5960278D7` (`item_set_id`),
  KEY `IDX_8533D2A57E3C61F9` (`owner_id`),
  CONSTRAINT `FK_8533D2A57E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `user` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_8533D2A5960278D7` FOREIGN KEY (`item_set_id`) REFERENCES `item_set` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_vocab`
--

LOCK TABLES `custom_vocab` WRITE;
/*!40000 ALTER TABLE `custom_vocab` DISABLE KEYS */;
INSERT INTO `custom_vocab` VALUES (6,NULL,1,'apwa: Gender',NULL,'Female\nMale\nOther\nTrans\nNo information'),(7,NULL,1,'apwa: Sexual Orientation',NULL,'Bisexual\nHeterosexual\nHomosexual\nOther\nNo information'),(8,NULL,1,'apwa: Yes No',NULL,'Yes\nNo\nNo information'),(9,NULL,1,'apwa: Ethnicity',NULL,'African American\nAsian American\nLatina/o / Hispanic\nMultiracial\nNative American\nOther\nPacific Islander\nWhite (non-Hispanic)\nNo information'),(10,NULL,1,'apwa: Religion',NULL,'Buddhist\nChristian\nHindu\nIslamic\nJewish\nNative\nNone\nOther\nNo information'),(11,NULL,1,'apwa: Relationship to Prison',NULL,'Correctional Officer\nFormerly incarcerated\nIncarcerated\nOther\nStaff\nTeacher\nVolunteer\nNo information'),(12,NULL,1,'apwa: Incarceration Number',NULL,'First\nNot first\nNo information'),(13,NULL,1,'apwa: Prison Location',NULL,'Alabama\nAlaska\nArizona\nArkansas\nCalifornia\nColorado\nConnecticut\nDelaware\nDistrict of Columbia\nFlorida\nGeorgia\nHawaii\nIdaho\nIllinois\nIndiana\nIowa\nKansas\nKentucky\nLouisiana\nMaine\nMaryland\nMassachusetts\nMichigan\nMinnesota\nMississippi\nMissouri\nMontana\nNebraska\nNevada\nNew Hampshire\nNew Jersey\nNew Mexico\nNew York\nNorth Carolina\nNorth Dakota\nOhio\nOklahoma\nOregon\nPennsylvania\nRhode Island\nSouth Carolina\nSouth Dakota\nTennessee\nTexas\nUtah\nVermont\nVirginia\nWashington\nWest Virginia\nWisconsin\nWyoming\nNo information'),(14,NULL,1,'apwa: Facility Type',NULL,'Federal Facility\nState Facility\nJail Facility\nNo information'),(15,NULL,1,'apwa: Management Type',NULL,'Private (for-profit)\nPublic\nNo information'),(16,NULL,1,'apwa: Security Type',NULL,'Minimum\nMedium\nMaximum\nSupermax\nMultilevel\nDeath Row\nNo information'),(17,NULL,1,'apwa: Digitize',NULL,'Yes\nNo\nUnsure'),(18,NULL,1,'apwa: Form Category',NULL,'electronic resource\nglobe\nkit\nmap\nmicroform\nmotion picture\nnonprojected graphic\nnotated music\nprojected graphic\nremote-sensing image\nsound recording\ntactile material\ntext\nunspecified\nvideorecording'),(19,NULL,1,'apwa: Type of Resource',NULL,'cartographic\nmixed material\nmoving image\nnotated music\nsoftware, multimedia\nsound recording\nsound recording-musical\nsound recording-nonmusical\nstill image\ntext\nthree dimensional object'),(20,NULL,1,'apwa: Language',NULL,'English\nSpanish'),(21,NULL,1,'apwa: Physical Location',NULL,'American Prison Writing Archive, Burke Library, Hamilton College, Clinton, New York, United States'),(22,NULL,1,'apwa: Genre',NULL,'abstract or summary\nart original\nart reproduction\narticle\natlas\nautobiography\nbibliography\nbiography\nbook\ncalendar\ncatalog\nchart\ncomic or graphic novel\ncomic strip\nconference publication\ndatabase\ndictionary\ndiorama\ndirectory\ndiscography\ndrama\nencyclopedia\nessay\nfestschrift\nfiction\nfilmography\nfilmstrip\nfinding aid\nflash card\nfolktale\nfont\ngame\ngovernment publication\ngraphic\nglobe\nhandbook\nhistory\nhymnal\nhumor, satire\nindex\ninstruction\ninterview\nissue\njournal\nkit\nlanguage instruction\nlaw report or digest\nlegal article\nlegal case and case notes\nlegislation\nletter\nloose-leaf\nmap\nmemoir\nmicroscope slide\nmodel\nmotion picture\nmultivolume monograph\nnewspaper\nnovel\nnumeric data\noffprint\nonline system or service\npatent\nperiodical\npicture\npoetry\nprogrammed text\nrealia\nrehearsal\nremote sensing image\nreporting\nreview\nscript\nseries\nshort story\nslide\nsound\nspeech\nstandard or specification\nstatistics\nsurvey of literature\ntechnical drawing\ntechnical report\nthesis\ntoy\ntransparency\ntreaty\nvideorecording\nweb site\nyearbook'),(23,NULL,1,'apwa: Note',NULL,'American Prison Writing Archive, Burke Library, Hamilton College, Clinton, New York, United States'),(24,4377,60,'Type',NULL,'Advertisement\nChart\nGraph\nIllustration\nLogo\nMap\nPhotograph\nTable\nText');
/*!40000 ALTER TABLE `custom_vocab` 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 */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 2023-06-17 14:48:52

#########################################################

NEW

-- MySQL dump 10.19  Distrib 10.3.39-MariaDB, for Linux (x86_64)
--
-- Host: mysql.mse.jhu.edu    Database: omekasprod
-- ------------------------------------------------------
-- Server version	10.3.39-MariaDB-log

/*!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_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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 */;

--
-- Table structure for table `custom_vocab`
--

DROP TABLE IF EXISTS `custom_vocab`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_vocab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_set_id` int(11) DEFAULT NULL,
  `owner_id` int(11) DEFAULT NULL,
  `label` varchar(190) NOT NULL,
  `lang` varchar(190) DEFAULT NULL,
  `terms` longtext DEFAULT NULL COMMENT '(DC2Type:json)',
  `uris` longtext DEFAULT NULL COMMENT '(DC2Type:json)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8533D2A5EA750E8` (`label`),
  KEY `IDX_8533D2A5960278D7` (`item_set_id`),
  KEY `IDX_8533D2A57E3C61F9` (`owner_id`),
  CONSTRAINT `FK_8533D2A57E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `user` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_8533D2A5960278D7` FOREIGN KEY (`item_set_id`) REFERENCES `item_set` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_vocab`
--

LOCK TABLES `custom_vocab` WRITE;
/*!40000 ALTER TABLE `custom_vocab` DISABLE KEYS */;
INSERT INTO `custom_vocab` VALUES (6,NULL,1,'apwa: Gender',NULL,'[\"Female\",\"Male\",\"Other\",\"Trans\",\"No information\"]',NULL),(7,NULL,1,'apwa: Sexual Orientation',NULL,'[\"Bisexual\",\"Heterosexual\",\"Homosexual\",\"Other\",\"No information\"]',NULL),(8,NULL,1,'apwa: Yes No',NULL,'[\"Yes\",\"No\",\"No information\"]',NULL),(9,NULL,1,'apwa: Ethnicity',NULL,'[\"African American\",\"Asian American\",\"Latina\\/o \\/ Hispanic\",\"Multiracial\",\"Native American\",\"Other\",\"Pacific Islander\",\"White (non-Hispanic)\",\"No information\"]',NULL),(10,NULL,1,'apwa: Religion',NULL,'[\"Buddhist\",\"Christian\",\"Hindu\",\"Islamic\",\"Jewish\",\"Native\",\"None\",\"Other\",\"No information\"]',NULL),(11,NULL,1,'apwa: Relationship to Prison',NULL,'[\"Correctional Officer\",\"Formerly incarcerated\",\"Incarcerated\",\"Other\",\"Staff\",\"Teacher\",\"Volunteer\",\"No information\"]',NULL),(12,NULL,1,'apwa: Incarceration Number',NULL,'[\"First\",\"Not first\",\"No information\"]',NULL),(13,NULL,1,'apwa: Prison Location',NULL,'[\"Alabama\",\"Alaska\",\"Arizona\",\"Arkansas\",\"California\",\"Colorado\",\"Connecticut\",\"Delaware\",\"District of Columbia\",\"Florida\",\"Georgia\",\"Hawaii\",\"Idaho\",\"Illinois\",\"Indiana\",\"Iowa\",\"Kansas\",\"Kentucky\",\"Louisiana\",\"Maine\",\"Maryland\",\"Massachusetts\",\"Michigan\",\"Minnesota\",\"Mississippi\",\"Missouri\",\"Montana\",\"Nebraska\",\"Nevada\",\"New Hampshire\",\"New Jersey\",\"New Mexico\",\"New York\",\"North Carolina\",\"North Dakota\",\"Ohio\",\"Oklahoma\",\"Oregon\",\"Pennsylvania\",\"Rhode Island\",\"South Carolina\",\"South Dakota\",\"Tennessee\",\"Texas\",\"Utah\",\"Vermont\",\"Virginia\",\"Washington\",\"West Virginia\",\"Wisconsin\",\"Wyoming\",\"No information\"]',NULL),(14,NULL,1,'apwa: Facility Type',NULL,'[\"Federal Facility\",\"State Facility\",\"Jail Facility\",\"No information\"]',NULL),(15,NULL,1,'apwa: Management Type',NULL,'[\"Private (for-profit)\",\"Public\",\"No information\"]',NULL),(16,NULL,1,'apwa: Security Type',NULL,'[\"Minimum\",\"Medium\",\"Maximum\",\"Supermax\",\"Multilevel\",\"Death Row\",\"No information\"]',NULL),(17,NULL,1,'apwa: Digitize',NULL,'[\"Yes\",\"No\",\"Unsure\"]',NULL),(18,NULL,1,'apwa: Form Category',NULL,'[\"electronic resource\",\"globe\",\"kit\",\"map\",\"microform\",\"motion picture\",\"nonprojected graphic\",\"notated music\",\"projected graphic\",\"remote-sensing image\",\"sound recording\",\"tactile material\",\"text\",\"unspecified\",\"videorecording\"]',NULL),(19,NULL,1,'apwa: Type of Resource',NULL,'[\"cartographic\",\"mixed material\",\"moving image\",\"notated music\",\"software, multimedia\",\"sound recording\",\"sound recording-musical\",\"sound recording-nonmusical\",\"still image\",\"text\",\"three dimensional object\"]',NULL),(20,NULL,1,'apwa: Language',NULL,'[\"English\",\"Spanish\"]',NULL),(21,NULL,1,'apwa: Physical Location',NULL,'[\"American Prison Writing Archive, Burke Library, Hamilton College, Clinton, New York, United States\"]',NULL),(22,NULL,1,'apwa: Genre',NULL,'[\"abstract or summary\",\"art original\",\"art reproduction\",\"article\",\"atlas\",\"autobiography\",\"bibliography\",\"biography\",\"book\",\"calendar\",\"catalog\",\"chart\",\"comic or graphic novel\",\"comic strip\",\"conference publication\",\"database\",\"dictionary\",\"diorama\",\"directory\",\"discography\",\"drama\",\"encyclopedia\",\"essay\",\"festschrift\",\"fiction\",\"filmography\",\"filmstrip\",\"finding aid\",\"flash card\",\"folktale\",\"font\",\"game\",\"government publication\",\"graphic\",\"globe\",\"handbook\",\"history\",\"hymnal\",\"humor, satire\",\"index\",\"instruction\",\"interview\",\"issue\",\"journal\",\"kit\",\"language instruction\",\"law report or digest\",\"legal article\",\"legal case and case notes\",\"legislation\",\"letter\",\"loose-leaf\",\"map\",\"memoir\",\"microscope slide\",\"model\",\"motion picture\",\"multivolume monograph\",\"newspaper\",\"novel\",\"numeric data\",\"offprint\",\"online system or service\",\"patent\",\"periodical\",\"picture\",\"poetry\",\"programmed text\",\"realia\",\"rehearsal\",\"remote sensing image\",\"reporting\",\"review\",\"script\",\"series\",\"short story\",\"slide\",\"sound\",\"speech\",\"standard or specification\",\"statistics\",\"survey of literature\",\"technical drawing\",\"technical report\",\"thesis\",\"toy\",\"transparency\",\"treaty\",\"videorecording\",\"web site\",\"yearbook\"]',NULL),(23,NULL,1,'apwa: Note',NULL,'[\"American Prison Writing Archive, Burke Library, Hamilton College, Clinton, New York, United States\"]',NULL),(24,4377,60,'Type',NULL,'Advertisement\nChart\nGraph\nIllustration\nLogo\nMap\nPhotograph\nTable\nText',NULL);
/*!40000 ALTER TABLE `custom_vocab` 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 */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 2023-06-17 11:03:14

jflatnes · June 17, 2023, 4:12pm

Thanks, Mark.

This is great, and definitely points to what the problem is. We’ll keep you posted on when we have a fix available.

jflatnes · June 21, 2023, 4:35pm

Okay, there’s a new version of Custom Vocab, 2.0.1, that should fix your issue here.

mcyzyk · June 21, 2023, 5:23pm

Thanks! That fixed it.

Appreciatively,

Mark

jflatnes · June 21, 2023, 7:22pm

Thanks for your help identifying the issue and confirming it’s fixed for you.