search

iCAPLyon1 / WikiBundle

Wiki plugin for Claroline Connect
2 stars 3 forks source link

Wiki broken after upgrade #2

Closed clarophil closed 10 years ago

clarophil commented 10 years ago

After upgrade of claroline core 2.1.8, the wiki is broken

"Doctrine\DBAL\DBALException" thrown with message : "An exception occurred while executing 'SELECT i0.id AS id0, i0.visible AS visible1, i0_.creation_date AS creationdate2, i0.deleted AS deleted3, i0_.deletion_date AS deletiondate4, i0.lft AS lft5, i0.lvl AS lvl6, i0.rgt AS rgt7, i0.root AS root8, i1.id AS id9, i1.title AS title10, i1.text AS text11, i1_.creation_date AS creation_date12 FROM icapwikisection i0 INNER JOIN icapwikicontribution i1 ON i0_.active_contributionid = i1.id WHERE i0.root = ? AND (i0.deleted = ? OR i0.deleted IS NULL) ORDER BY i0.root ASC, i0.lft ASC' with params [1, 0]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i0.deleted' in 'field list'" (500 Internal Server Error) at n/a in /home/cctest/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 at Doctrine\DBAL\DBALException::driverExceptionDuringQuery in /home/cctest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 701 at Doctrine\DBAL\Connection->executeQuery in /home/cctest/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php line 50 at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute in /home/cctest/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 286 at Doctrine\ORM\Query->_doExecute in /home/cctest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 794 at Doctrine\ORM\AbstractQuery->execute in /home/cctest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 586 at Doctrine\ORM\AbstractQuery->getArrayResult in /home/cctest/vendor/icap/wiki-bundle/Icap/WikiBundle/Repository/SectionRepository.php line 37 at Icap\WikiBundle\Repository\SectionRepository->buildSectionTree in /home/cctest/vendor/icap/wiki-bundle/Icap/WikiBundle/Controller/WikiController.php line 49 at Icap\WikiBundle\Controller\WikiController->viewAction in line at call_user_func_array in /home/cctest/app/bootstrap.php.cache line 2815 at Symfony\Component\HttpKernel\HttpKernel->handleRaw in /home/cctest/app/bootstrap.php.cache line 2789 at Symfony\Component\HttpKernel\HttpKernel->handle in /home/cctest/app/bootstrap.php.cache line 2918 at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle in /home/cctest/app/bootstrap.php.cache line 2220 at Symfony\Component\HttpKernel\Kernel->handle in /home/cctest/web/app.php line 19at n/a in /home/cctest/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 at Doctrine\DBAL\DBALException::driverExceptionDuringQuery in /home/cctest/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 701 at Doctrine\DBAL\Connection->executeQuery in /home/cctest/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php line 50 at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute in /home/cctest/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 286 at Doctrine\ORM\Query->_doExecute in /home/cctest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 794 at Doctrine\ORM\AbstractQuery->execute in /home/cctest/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 586 at Doctrine\ORM\AbstractQuery->getArrayResult in /home/cctest/vendor/icap/wiki-bundle/Icap/WikiBundle/Repository/SectionRepository.php line 37 at Icap\WikiBundle\Repository\SectionRepository->buildSectionTree in /home/cctest/vendor/icap/wiki-bundle/Icap/WikiBundle/Controller/WikiController.php line 49 at Icap\WikiBundle\Controller\WikiController->viewAction in line at call_user_func_array in /home/cctest/app/bootstrap.php.cache line 2815 at Symfony\Component\HttpKernel\HttpKernel->handleRaw in /home/cctest/app/bootstrap.php.cache line 2789 at Symfony\Component\HttpKernel\HttpKernel->handle in /home/cctest/app/bootstrap.php.cache line 2918 at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle in /home/cctest/app/bootstrap.php.cache line 2220 at Symfony\Component\HttpKernel\Kernel->handle in /home/cctest/web/app.php line 19

ptsavdar commented 10 years ago

According to the error message, it looks like the database is not in the same version as the sources of the wiki. Have you run the command "claroline:update" after the composer update (In order to execute the migration files and create the new fields in the database)?

clarophil commented 10 years ago

Thanks a lot it works