Hi!
I’m using omeka classic version 2.8 in XAMP architecture. But attempting to install the collection tree plugin is showing a fatal error as following:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Column ‘id’ cannot be null in C:\xampp\htdocs\omeka\application\libraries\Zend\Db\Statement\Mysqli.php:215
Stack trace:
#0 C:\xampp\htdocs\omeka\application\libraries\Zend\Db\Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 C:\xampp\htdocs\omeka\application\libraries\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 C:\xampp\htdocs\omeka\application\libraries\Omeka\Db.php(80): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `om…’, Array)
#3 C:\xampp\htdocs\omeka\application\libraries\Omeka\Db.php(257): Omeka_Db->__call(‘query’, Array)
#4 C:\xampp\htdocs\omeka\application\libraries\Omeka\Record\AbstractRecord.php(541): Omeka_Db->insert(‘omeka_collectio…’, Array)
#5 C:\xampp\htdocs\omeka\plugins\CollectionTree\CollectionTreePlugin.php(90): Omeka_Record_AbstractRecord->save()
#6 C:\xampp\htdocs\omeka\application\libraries\Omeka\Plugin\Broker.php(142): CollectionTreePlugin->hookInstall(Array)
#7 C:\xampp\htdocs\omeka\application\libraries\Omeka\Plugin\Installer.php(126): Omeka_Plugin_Broker->callHook(‘install’, Array, Object(Plugin))
#8 C:\xampp\htdocs\omeka\application\controllers\PluginsController.php(95): Omeka_Plugin_Installer->install(Object(Plugin))
#9 C:\xampp\htdocs\omeka\application\libraries\Zend\Controller\Action.php(516): PluginsController->installAction()
#10 C:\xampp\htdocs\omeka\application\libraries\Zend\Controller\Dispatcher\Standard.php(308): Zend_Controller_Action->dispatch(‘installAction’)
#11 C:\xampp\htdocs\omeka\application\libraries\Zend\Controller\Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 C:\xampp\htdocs\omeka\application\libraries\Zend\Application\Bootstrap\Bootstrap.php(105): Zend_Controller_Front->dispatch()
#13 C:\xampp\htdocs\omeka\application\libraries\Zend\Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#14 C:\xampp\htdocs\omeka\application\libraries\Omeka\Application.php(73): Zend_Application->run()
#15 C:\xampp\htdocs\omeka\admin\index.php(28): Omeka_Application->run()
#16 {main}
Any solution to figure out what’s going wrong?
Thanks in advance.
Can you share the details from your System Information screen (it’s linked in the footer of every admin page)?
Sure. Here it is as follows:
User
Browser Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36
Role super
System
Omeka 2.8
PHP 7.4.24 (apache2handler)
OS Windows NT 10.0 AMD64
MySQL Server 10.4.21
MySQL Client mysqlnd 7.4.24
Apache Apache/2.4.51 (Win64) OpenSSL/1.1.1l PHP/7.4.24
PHP Extensions
Regular apache2handler, bcmath, bz2, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, readline, Reflection, session, SimpleXML, SPL, standard, tokenizer, xml, xmlreader, xmlwriter, zip, zlib
Plugins
ClickableLinksPlus 1.3.2
ConnectedCarousel 2.2
ExhibitBuilder 3.4.3
OaipmhHarvester 2.0.2
PdfEmbed 1.0.1
ShortcodeCarousel 1.0.1
SimplePages 3.1.3
YouTubeImport 1.3
Themes
AOD-master 1.0
AvantTheme-master 1.1
BellerExhibit-main 1.0
ChinaLocal-Omeka-Theme-master 2.0
Deco-master
KDNPTheme-master 2.3.1
Napoleon-Theme-Omeka-master 0.1
Omeka-theme-Bootstrap-master 2.2.1
Omeka-theme-Scribe-master 2.0
OmekaMutterTheme-master 2.1.1
Philly-master 1.0
annespencertheme-main 2.6.1
avantgarde-master 1
baki-omeka-theme-master 1.1
berlin 2.7
berlin-cliotropic-master 1.3
bigstuff-master 1.0
bridgingcultures-master 0.1
burke-master 2
curatescape 3.4.6
cville_rally_theme-master 0.0.1
default 2.6.5
digital-chicago-omeka-theme-OLD-master 1.0
foundation 1.2.1 (current)
hvd-dh-omeka-theme-main 1.0.2
ibss-theme-master 2.2.1
indipetae-master 2.4.1
kardec-theme-master 1.0
northfield-master 2.1
omeka-IDHP-Made_Minimal-master 1
omeka-isaw-theme-master 0.1
omeka-theme-bgsu-master 1.0
omeka-theme-flex-classic-main 0.0.1
omeka-theme-perinum-master 0.1.0
omeka-theme-projproj-new-theme 1.1.1
omeka_asu_theme-master 2.0
santa-fe 2.5.1
sckls-omeka-master 1.1.0
seasons 2.6
siue-omeka-theme-master 0.5
takeback-master 1.0
theme-bigpicture-master 1.5.3
theme-curatescape-master
theme-customeka-master 2.2
theme-uwmspl-master 1.1.0
uccdigital-master 1.1.1
ucsc-exhibits-theme-master 2.1.1
Hmm, that’s definitely odd.
Can you tell, do you have a table called omeka_collection_trees in your database? It looks like maybe you have an old table there that’s messing up the installer.
Yes, I found one table named the same as you mentioned. So, should I drop it or anything you suggest?
This topic was automatically closed after 250 days. New replies are no longer allowed.