Currently unable to handle this request. HTTP ERROR 500

Software Support
1

I am getting error while upgrades the: 3.1.0.1 to 3.3.0.6.

Error : This page isn’t working csvtujournal.in is currently unable to handle this request. HTTP ERROR 500

Fatal error : Uncaught Doctrine\DBAL\Schema\SchemaException: There is no column with name ‘assoc_id’ on table ‘citations’. in /home/csvtujou/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:86 Stack trace: #0 /home/csvtujou/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php(711): Doctrine\DBAL\Schema\SchemaException::columnDoesNotExist(‘assoc_id’, ‘citations’) #1 /home/csvtujou/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(884): Doctrine\DBAL\Schema\Table->getColumn(‘assoc_id’) #2 /home/csvtujou/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/RenameColumn.php(30): Illuminate\Database\Connection->getDoctrineColumn(‘citations’, ‘assoc_id’) #3 /home/csvtujou/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php(40): Illuminate\Database\Schema\Grammars\RenameColumn::compile(Object(Illuminate\Database\Schema\Grammars\MySqlGrammar), in /home/csvtujou/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php on line 86

3

Hi @JyotiKant,

Can you perform an upgrade from a command line and show the output? citations table indeed doesn’t contain assoc_id column and I don’t remember this call in the upgrade script.

5

Uncaught Doctrine\DBAL\Schema\SchemaException: There is no column with name ‘assoc_id’ on table ‘citations’ I get the same error when trying to update from 3.1.0.1 to 3.3.6.
If they could solve the problem, it would be of great help

6

Hi @Ciencias_Forestales,

Was the upgrade process successful? what is the output of the upgrade script?

7

I did not finish the update process, it sends a 500 error Fatal error : Uncaught Doctrine\DBAL\Schema\SchemaException: There is no column with name ‘assoc_id’ on table ‘citations’. in C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Schema\SchemaException.php:86 Stack trace: #0 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Schema\Table.php(711): Doctrine\DBAL\Schema\SchemaException::columnDoesNotExist(‘assoc_id’, ‘citations’) #1 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(884): Doctrine\DBAL\Schema\Table->getColumn(‘assoc_id’) #2 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Grammars\RenameColumn.php(30): Illuminate\Database\Connection->getDoctrineColumn(‘citations’, ‘assoc_id’) #3 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Grammars\Grammar.php(40): Illuminate\Database\Schema\Grammars\RenameColumn::compile(Object(Illuminate\Database\Schema\Grammars\MySqlGrammar), Object(Illuminate\Database\Schema\Blueprint), Object(Illuminate\Support\Fluent), Object(Illuminate\Database\MySqlConnection)) #4 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php(128): Illuminate\Database\Schema\Grammars\Grammar->compileRenameColumn(Object(Illuminate\Database\Schema\Blueprint), Object(Illuminate\Support\Fluent), Object(Illuminate\Database\MySqlConnection)) #5 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php(101): Illuminate\Database\Schema\Blueprint->toSql(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #6 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #7 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint)) #8 C:\xampp\htdocs\prueba2\lib\pkp\classes\db\DBDataXMLParser.inc.php(104): Illuminate\Database\Schema\Builder->table(‘citations’, Object(Closure)) #9 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(534): DBDataXMLParser->{closure}(Object(Illuminate\Database\MySqlConnection)) #10 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(562): Illuminate\Database\Connection->Illuminate\Database{closure}() #11 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(539): Illuminate\Database\Connection->withFreshQueryLog(Object(Closure)) #12 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Capsule\Manager.php(200): Illuminate\Database\Connection->pretend(Object(Closure)) #13 C:\xampp\htdocs\prueba2\lib\pkp\classes\db\DBDataXMLParser.inc.php(105): Illuminate\Database\Capsule\Manager::__callStatic(‘pretend’, Array) #14 C:\xampp\htdocs\prueba2\lib\pkp\classes\install\Installer.inc.php(390): DBDataXMLParser->parseData(‘dbscripts/xml/u…’) #15 C:\xampp\htdocs\prueba2\lib\pkp\classes\install\Installer.inc.php(251): Installer->executeAction(Array) #16 C:\xampp\htdocs\prueba2\lib\pkp\classes\install\Installer.inc.php(174): Installer->executeInstaller() #17 C:\xampp\htdocs\prueba2\lib\pkp\classes\install\form\UpgradeForm.inc.php(43): Installer->execute() #18 C:\xampp\htdocs\prueba2\lib\pkp\pages\install\InstallHandler.inc.php(130): UpgradeForm->execute() #19 C:\xampp\htdocs\prueba2\lib\pkp\classes\core\PKPRouter.inc.php(395): InstallHandler->installUpgrade(Array, Object(Request)) #20 C:\xampp\htdocs\prueba2\lib\pkp\classes\core\PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false) #21 C:\xampp\htdocs\prueba2\lib\pkp\classes\core\Dispatcher.inc.php(144): PKPPageRouter->route(Object(Request)) #22 C:\xampp\htdocs\prueba2\lib\pkp\classes\core\PKPApplication.inc.php(364): Dispatcher->dispatch(Object(Request)) #23 C:\xampp\htdocs\prueba2\index.php(68): PKPApplication->execute() #24 {main} thrown in C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Schema\SchemaException.php on line 86

8

I need to know the place in the script where the problem occurs. Can you restore database from a backup and run upgrade from a command line, e.g., on your local machine? The output may contain hints where the problem occurs.

9

I restored the database again, I still get the same message, the procedure is done by downloading the ojs files via the web

Fatal error : Uncaught Doctrine\DBAL\Schema\SchemaException: There is no column with name ‘assoc_id’ on table ‘citations’. in C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Schema\SchemaException.php:86 Stack trace: #0 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Schema\Table.php(711): Doctrine\DBAL\Schema\SchemaException::columnDoesNotExist(‘assoc_id’, ‘citations’) #1 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(884): Doctrine\DBAL\Schema\Table->getColumn(‘assoc_id’) #2 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Grammars\RenameColumn.php(30): Illuminate\Database\Connection->getDoctrineColumn(‘citations’, ‘assoc_id’) #3 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Grammars\Grammar.php(40): Illuminate\Database\Schema\Grammars\RenameColumn::compile(Object(Illuminate\Database\Schema\Grammars\MySqlGrammar), Object(Illuminate\Database\Schema\Blueprint), Object(Illuminate\Support\Fluent), Object(Illuminate\Database\MySqlConnection)) #4 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php(128): Illuminate\Database\Schema\Grammars\Grammar->compileRenameColumn(Object(Illuminate\Database\Schema\Blueprint), Object(Illuminate\Support\Fluent), Object(Illuminate\Database\MySqlConnection)) #5 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Blueprint.php(101): Illuminate\Database\Schema\Blueprint->toSql(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #6 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar)) #7 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint)) #8 C:\xampp\htdocs\prueba2\lib\pkp\classes\db\DBDataXMLParser.inc.php(104): Illuminate\Database\Schema\Builder->table(‘citations’, Object(Closure)) #9 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(534): DBDataXMLParser->{closure}(Object(Illuminate\Database\MySqlConnection)) #10 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(562): Illuminate\Database\Connection->Illuminate\Database{closure}() #11 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(539): Illuminate\Database\Connection->withFreshQueryLog(Object(Closure)) #12 C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Capsule\Manager.php(200): Illuminate\Database\Connection->pretend(Object(Closure)) #13 C:\xampp\htdocs\prueba2\lib\pkp\classes\db\DBDataXMLParser.inc.php(105): Illuminate\Database\Capsule\Manager::__callStatic(‘pretend’, Array) #14 C:\xampp\htdocs\prueba2\lib\pkp\classes\install\Installer.inc.php(390): DBDataXMLParser->parseData(‘dbscripts/xml/u…’) #15 C:\xampp\htdocs\prueba2\lib\pkp\classes\install\Installer.inc.php(251): Installer->executeAction(Array) #16 C:\xampp\htdocs\prueba2\lib\pkp\classes\install\Installer.inc.php(174): Installer->executeInstaller() #17 C:\xampp\htdocs\prueba2\lib\pkp\classes\install\form\UpgradeForm.inc.php(43): Installer->execute() #18 C:\xampp\htdocs\prueba2\lib\pkp\pages\install\InstallHandler.inc.php(130): UpgradeForm->execute() #19 C:\xampp\htdocs\prueba2\lib\pkp\classes\core\PKPRouter.inc.php(395): InstallHandler->installUpgrade(Array, Object(Request)) #20 C:\xampp\htdocs\prueba2\lib\pkp\classes\core\PKPPageRouter.inc.php(246): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false) #21 C:\xampp\htdocs\prueba2\lib\pkp\classes\core\Dispatcher.inc.php(144): PKPPageRouter->route(Object(Request)) #22 C:\xampp\htdocs\prueba2\lib\pkp\classes\core\PKPApplication.inc.php(364): Dispatcher->dispatch(Object(Request)) #23 C:\xampp\htdocs\prueba2\index.php(68): PKPApplication->execute() #24 {main} thrown in C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Schema\SchemaException.php on line 86

10

Parse error : syntax error, unexpected token “return”, expecting “;” or “{” in C:\xampp\htdocs\prueba2\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Schema\SchemaException.php on line 87

Is the error that appears to me

11

I was able to solve the update from 3.1.01 to 3.3.0.6 updated to PHP Version 7.3.28, I wanted to do it in a version of PHP 8.0.7 and it was where I did not allow the update
va

12

Glad that you solved it and thanks for the update. Yeah, PHP 8.0 isn’t supported in 3.3.