Bad Server Response - Upgrade Advanced Extension To 1.29.0

[Pablo]

Hello!

We were upgrading the advanced extension pack from 1.28.8 to 1.29.0. When finishing the upgrade, the screen went blank and a "Bad Server Response" error appears.

When we look at the error logs, it appears:

[2018-03-12 01:35:41] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO)" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/EntityManager.php line 138 {"exception":"[object] (PDOException(code: 1045): SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO) at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/EntityManager.php:138)"} []
[2018-03-12 01:35:42] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 72 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:72)"} []
[2018-03-12 01:35:43] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []
[2018-03-12 01:35:44] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 72 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:72)"} []
[2018-03-12 01:40:41] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 72 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:72)"} []
[2018-03-12 01:40:43] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 72 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:72)"} []
[2018-03-12 01:45:56] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []
[2018-03-12 01:45:56] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []
[2018-03-12 01:46:24] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []
[2018-03-12 01:46:24] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []
[2018-03-12 01:47:36] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []
[2018-03-12 01:47:36] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []
[2018-03-12 01:47:41] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []
[2018-03-12 01:47:41] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list'" at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.acceptance_status_meetings' in 'field list' at /home3/linkport/public_html/backoffice9alliancev5/application/Espo/ORM/DB/Mapper.php:114)"} []

We were SO CLOSE to reach the last version!

Can you please help us?

Thanks a lot.

[yuri]

Hi Pablo,

What EspoCRM version?

You can remove file application/Espo/Modules/Advanced/Resources/metadata/entityDefs/User.json

then run

php clear_cache.php

[Pablo]

Hi yuri ,

It worked! Now we have access.

However, at the "Contacts" tab, we see the error: "Error 500: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contact.acceptance_status_meetings' in 'field list'". We think it's related to the original error.

We are using EspoCRM 4.6.0. Could this be related to the version? Should we upgrade EspoCRM?

Thanks again.

[yuri]

Hi Pablo,

If you update EspoCRM it will work. Anyway in the next advanced pack release the backward compatibility issue will be fixed.

[Pablo]

Hi yuri .

It worked perfect. We had some issues from EspoCRM 4.8.4 to 5.0.5 but with your permissions instructions here, we were able to fix the issue.

Thanks a lot for your time and effort.

Best regards.