Tweet
Hello,
I'm not sure in anyone can help, but i have recently installed the advance pack extension on espocrm. i'm now unable to rebuild database or and new field with out "error 500 see log file...
Log file below
[2016-05-04 16:52:03] Espo.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Converter.php","line":266} []
[2016-05-04 16:52:03] Espo.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Converter.php","line":266} []
[2016-05-04 16:52:10] Espo.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Converter.php","line":266} []
[2016-05-04 16:52:10] Espo.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Converter.php","line":266} []
[2016-05-04 16:52:10] Espo.ALERT: Rebuild database fault: exception 'PDOException' with message 'SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'm_f1_objective_to_cover'' in /opt/bitnami/apps/espocrm/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /opt/bitnami/apps/espocrm/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('ALTER TABLE `op...') #1 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Schema.php(209): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `op...') #2 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/DataManager.php(90): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/DataManager.php(59): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Controllers/Admin.php(51): Espo\Core\DataManager->rebuild() #5 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/ControllerManager.php(116): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Slim\Http\Request)) #6 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Application.php(226): Espo\Core\ControllerManager->process('Admin', 'rebuild', Array, '', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}(NULL) #8 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Slim.php(1175): call_user_func(Object(Closure), NULL) #9 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Slim.php(1315): Slim\Slim->applyHook('slim.before.dis...') #10 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #11 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #12 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Api/Auth.php(105): Slim\Middleware\MethodOverride->call() #13 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Api/Slim.php(42): Espo\Core\Utils\Api\Auth->call() #14 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Application.php(88): Espo\Core\Utils\Api\Slim->run() #15 /opt/bitnami/apps/espocrm/htdocs/api/v1/index.php(33): Espo\Core\Application->run() #16 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'ALTER TABLE `opportunity` ADD m_f1_objective_to_cover VARCHAR(255) DEFAULT NULL': SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'm_f1_objective_to_cover'' in /opt/bitnami/apps/espocrm/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /opt/bitnami/apps/espocrm/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(PDOException), 'ALTER TABLE `op...', Array) #1 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Schema.php(209): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `op...') #2 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/DataManager.php(90): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/DataManager.php(59): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Controllers/Admin.php(51): Espo\Core\DataManager->rebuild() #5 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/ControllerManager.php(116): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Slim\Http\Request)) #6 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Application.php(226): Espo\Core\ControllerManager->process('Admin', 'rebuild', Array, '', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}(NULL) #8 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Slim.php(1175): call_user_func(Object(Closure), NULL) #9 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Slim.php(1315): Slim\Slim->applyHook('slim.before.dis...') #10 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #11 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #12 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Api/Auth.php(105): Slim\Middleware\MethodOverride->call() #13 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Api/Slim.php(42): Espo\Core\Utils\Api\Auth->call() #14 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Application.php(88): Espo\Core\Utils\Api\Slim->run() #15 /opt/bitnami/apps/espocrm/htdocs/api/v1/index.php(33): Espo\Core\Application->run() #16 {main} [] []
[2016-05-04 16:52:10] Espo.ERROR: API [POST]:/Admin/rebuild, Params:Array ( ) , InputData: - Error while rebuilding database. See log file for details. [] []
[2016-05-04 16:52:10] Espo.ERROR: Display Error: Error while rebuilding database. See log file for details., Code: 500 URL: /espocrm/api/v1/Admin/rebuild [] []
Please help!
I'm not sure in anyone can help, but i have recently installed the advance pack extension on espocrm. i'm now unable to rebuild database or and new field with out "error 500 see log file...
Log file below
[2016-05-04 16:52:03] Espo.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Converter.php","line":266} []
[2016-05-04 16:52:03] Espo.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Converter.php","line":266} []
[2016-05-04 16:52:10] Espo.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Converter.php","line":266} []
[2016-05-04 16:52:10] Espo.WARNING: E_WARNING: Invalid argument supplied for foreach() {"code":2,"message":"Invalid argument supplied for foreach()","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Converter.php","line":266} []
[2016-05-04 16:52:10] Espo.ALERT: Rebuild database fault: exception 'PDOException' with message 'SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'm_f1_objective_to_cover'' in /opt/bitnami/apps/espocrm/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /opt/bitnami/apps/espocrm/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('ALTER TABLE `op...') #1 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Schema.php(209): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `op...') #2 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/DataManager.php(90): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/DataManager.php(59): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Controllers/Admin.php(51): Espo\Core\DataManager->rebuild() #5 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/ControllerManager.php(116): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Slim\Http\Request)) #6 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Application.php(226): Espo\Core\ControllerManager->process('Admin', 'rebuild', Array, '', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}(NULL) #8 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Slim.php(1175): call_user_func(Object(Closure), NULL) #9 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Slim.php(1315): Slim\Slim->applyHook('slim.before.dis...') #10 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #11 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #12 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Api/Auth.php(105): Slim\Middleware\MethodOverride->call() #13 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Api/Slim.php(42): Espo\Core\Utils\Api\Auth->call() #14 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Application.php(88): Espo\Core\Utils\Api\Slim->run() #15 /opt/bitnami/apps/espocrm/htdocs/api/v1/index.php(33): Espo\Core\Application->run() #16 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'ALTER TABLE `opportunity` ADD m_f1_objective_to_cover VARCHAR(255) DEFAULT NULL': SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'm_f1_objective_to_cover'' in /opt/bitnami/apps/espocrm/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /opt/bitnami/apps/espocrm/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(PDOException), 'ALTER TABLE `op...', Array) #1 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Database/Schema/Schema.php(209): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `op...') #2 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/DataManager.php(90): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/DataManager.php(59): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Controllers/Admin.php(51): Espo\Core\DataManager->rebuild() #5 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/ControllerManager.php(116): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Slim\Http\Request)) #6 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Application.php(226): Espo\Core\ControllerManager->process('Admin', 'rebuild', Array, '', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}(NULL) #8 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Slim.php(1175): call_user_func(Object(Closure), NULL) #9 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Slim.php(1315): Slim\Slim->applyHook('slim.before.dis...') #10 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #11 /opt/bitnami/apps/espocrm/htdocs/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #12 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Api/Auth.php(105): Slim\Middleware\MethodOverride->call() #13 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/Api/Slim.php(42): Espo\Core\Utils\Api\Auth->call() #14 /opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Application.php(88): Espo\Core\Utils\Api\Slim->run() #15 /opt/bitnami/apps/espocrm/htdocs/api/v1/index.php(33): Espo\Core\Application->run() #16 {main} [] []
[2016-05-04 16:52:10] Espo.ERROR: API [POST]:/Admin/rebuild, Params:Array ( ) , InputData: - Error while rebuilding database. See log file for details. [] []
[2016-05-04 16:52:10] Espo.ERROR: Display Error: Error while rebuilding database. See log file for details., Code: 500 URL: /espocrm/api/v1/Admin/rebuild [] []
Please help!