Reference Module - Error when reinstalling or reverting to previous version

[jbmora]

Hello,
I installed the Reference Module version [3.4.37.3] and ran into the bug for the Skip Links not working as mentioned in the posts listed at the bottom.

To address this on my site, I thought I would revert to an older version of the module where the skip links were working.

However, when I try to reinstall an older version or the current version I just removed, it throws errors.

I need to reinstall this module soon and hopefully fix the Skip Link issue by using an older version. Any suggestions on how to address the errors and which version to use?

Thanks,
JB

Error Log

2022-07-15T15:23:03+00:00 ERR (3): PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘reference_metadata’ already exists in /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:53
Stack trace:
#0 /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(53): PDO->exec(‘CREATE TABLE r...') #1 /home/*******/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1567): Doctrine\DBAL\Driver\PDOConnection->exec('CREATE TABLE r…’)
#2 /home//public_html/modules/IiifServer/src/Generic/AbstractModule.php(293): Doctrine\DBAL\Connection->exec(‘CREATE TABLE `r…’)
#3 /home//public_html/modules/IiifServer/src/Generic/AbstractModule.php(84): Generic\AbstractModule->execSqlFromFile('/home//…')
#4 /home//public_html/application/src/Module/Manager.php(240): Generic\AbstractModule->install(Object(Laminas\ServiceManager\ServiceManager))
#5 /home//public_html/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install(Object(Omeka\Module\Module))
#6 /home//public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ModuleController->installAction()
#7 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#8 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#9 /home//public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#10 /home//public_html/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#11 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#12 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#13 /home//public_html/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#14 /home//public_html/index.php(21): Laminas\Mvc\Application->run()
#15 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘reference_metadata’ already exists in /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(58): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1567): Doctrine\DBAL\Driver\PDOConnection->exec(‘CREATE TABLE r...') #2 /home/*******/public_html/modules/IiifServer/src/Generic/AbstractModule.php(293): Doctrine\DBAL\Connection->exec('CREATE TABLE r…’)
#3 /home//public_html/modules/IiifServer/src/Generic/AbstractModule.php(84): Generic\AbstractModule->execSqlFromFile('/home//…')
#4 /home//public_html/application/src/Module/Manager.php(240): Generic\AbstractModule->install(Object(Laminas\ServiceManager\ServiceManager))
#5 /home//public_html/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install(Object(Omeka\Module\Module))
#6 /home//public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ModuleController->installAction()
#7 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#8 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#9 /home//public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#10 /home//public_html/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#11 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#12 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#13 /home//public_html/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#14 /home//public_html/index.php(21): Laminas\Mvc\Application->run()
#15 {main}

Next Doctrine\DBAL\Exception\TableExistsException: An exception occurred while executing ‘CREATE TABLE reference_metadata (
id INT AUTO_INCREMENT NOT NULL,
resource_id INT NOT NULL,
value_id INT NOT NULL,
field VARCHAR(190) NOT NULL,
lang VARCHAR(255) DEFAULT ‘’ NOT NULL,
is_public TINYINT(1) DEFAULT ‘1’ NOT NULL,
text LONGTEXT NOT NULL,
INDEX IDX_971E6F6B89329D25 (resource_id),
INDEX IDX_971E6F6BF920BBA2 (value_id),
INDEX idx_field (field),
INDEX idx_lang (lang),
INDEX idx_resource_field (resource_id, field),
INDEX idx_text (text(190)),
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB’:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘reference_metadata’ already exists in /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:57
Stack trace:
#0 /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDO\Exception))
#1 /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘An exception oc…’)
#2 /home//public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2214): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘CREATE TABLE r...', Array) #3 /home/*******/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1569): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'CREATE TABLE r…’)
#4 /home//public_html/modules/IiifServer/src/Generic/AbstractModule.php(293): Doctrine\DBAL\Connection->exec(‘CREATE TABLE `r…’)
#5 /home//public_html/modules/IiifServer/src/Generic/AbstractModule.php(84): Generic\AbstractModule->execSqlFromFile('/home//…')
#6 /home//public_html/application/src/Module/Manager.php(240): Generic\AbstractModule->install(Object(Laminas\ServiceManager\ServiceManager))
#7 /home//public_html/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install(Object(Omeka\Module\Module))
#8 /home//public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ModuleController->installAction()
#9 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#10 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#11 /home//public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#12 /home//public_html/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#13 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#14 /home//public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#15 /home//public_html/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#16 /home//public_html/index.php(21): Laminas\Mvc\Application->run()
#17 {main}

Skip Link Bug Posts:

Link to anchors in 'reference' page not working

I use pages with the ‘reference’ block, so that I can browse by a specific property. I have noticed that the link of the letters in the skiplink tab are not working, i.e. the page does not jump to the anchored letter when the user clicks on a letter. [Screenshot 2022-02-16 at 18-24-34 Browse by translated language · boslit · BOSLIT] Under further inspection I noticed that this happens because the ID assigned to the anchor itself is a capital letter (e.g. id="A") whilst the link of the skipli…

Reference Modules: the anchors are not working

Hi, I’ve been trying to setup the Reference Modules and I am not able to make the letters redirection work. The URL updates itself, but nothing happens on the page. I’ve read the Read me documentation in GitLab and it says that « Note that if headers are turned off, skiplinks do not work. » I don’t know where we can change that option. Can anyone help? If you want to see what is (not) happening, you can check this page: PLINE – Histoire des pratiques littéraires numériques au Québec · Explore…

[Daniel_KM]

There was an issue in skiplinks, that were lowercase or uppercase. This is fixed in last version.