Error 500 after upgrade

[dafnie]

I got a error 500 after upgrading from 5.5.6 to 5.6.1.

Error log:
"
[2019-05-10 06:53:07] Espo.ERROR: API [GET]:/Activities, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.date_end_date' in 'field list' [] [] [2019-05-10 06:53:07] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.date_end_date' in 'field list', Code: 42 URL: /api/v1/Activities?from=2019-05-05%2022:00&to=2019-05-12%2022:00&scopeList=Meeting%2CCall%2CTask&teamIdL ist=5b1907eeca5e581d6 [] [] [2019-05-10 06:53:21] Espo.ERROR: API [GET]:/Activities, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.date_end_date' in 'field list' [] [] [2019-05-10 06:53:21] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.date_end_date' in 'field list', Code: 42 URL: /api/v1/Activities?from=2019-04-28%2022:00&to=2019-06-09%2022:00&scopeList=Meeting%2CTask [] [] [2019-05-10 06:53:52] Espo.ERROR: API [GET]:/Activities, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.date_end_date' in 'field list' [] [] [2019-05-10 06:53:52] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.date_end_date' in 'field list', Code: 42 URL: /api/v1/Activities?from=2019-05-05%2022:00&to=2019-05-12%2022:00&scopeList=Meeting%2CCall%2CTask&teamIdL ist=5b1907eeca5e581d6 [] [] [2019-05-10 06:59:27] Espo.ERROR: API [GET]:/Activities, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.date_end_date' in 'field list' [] [] [2019-05-10 06:59:27] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'meeting.date_end_date' in 'field list', Code: 42 URL: /api/v1/Activities?from=2019-05-05%2022:00&to=2019-05-12%2022:00&scopeList=Meeting%2CCall%2CTask&teamIdL ist=5b1907eeca5e581d6 [] [] "
The error is the exact same as this related post https://forum.espocrm.com/forum/inst...ndar-error-500
I added the missing row "date_end_date" in the meeting table and everything work again. The row "date_start_date" was not missing.

I have Real Estate extension installed, no other extension.

Maybe there is something missing in your upgradescript?

php7.2
MariaDB version 10.2.23-MariaDB-cll-lve

[item]

Hi,

try to make from CLI : php rebuild.php

Regards

[dafnie]

Hi again
Sorry to say but I am still having trouble with the upgrade from 5.5.6 to 5.6.14.

Have tried rebuild.php in clii. Upgrading tried in CLI and WEB.

At URL https://SOME_DOMAIN/#RealEstatePrope...b0a77f36f684a0 i have no records in activities and history sidebar
I have this in google console
https://SOME_DOMAIN/api/v1/Activitie...art&order=desc
https://SOME_DOMAIN/api/v1/Activitie...art&order=desc

PHP Errorlog:
[01-Nov-2019 09:15:02 UTC] PHP Catchable fatal error: Argument 1 passed to Espo\Core\Container::get() must be an instance of Espo\Core\string, string given, called in /home/nanderse/public_html/notdrupal/maeglercrm/application/Espo/Core/Application.php on line 48 and defined in /home/nanderse/public_html/notdrupal/maeglercrm/application/Espo/Core/Container.php on line 41

[01-Nov-2019 09:30:02 UTC] PHP Catchable fatal error: Argument 1 passed to Espo\Core\Container::get() must be an instance of Espo\Core\string, string given, called in /home/nanderse/public_html/notdrupal/maeglercrm/application/Espo/Core/Application.php on line 48 and defined in /home/nanderse/public_html/notdrupal/maeglercrm/application/Espo/Core/Container.php on line 41

PHP: 7.2.23
MYSQL: 10.2.27-MariaDB-cll-lve
Apache Version 2.4.41
Extension: Real Estate 1.3.3

Hope you have a idea..

Greeeings From Carsten

[yuri]

Hi,

Seems your CLI PHP version is lesser than 7.1. Errors you provided indicate on that.

[dafnie]

Hi, thank for reply
This it what i get when running php -v PHP 7.2.23 (cli) (built: Oct 7 2019 17:52:16) ( NTS ) - "Not sure what you mean by CLI PHP version?) My bug is related to this one.. https://forum.espocrm.com/forum/inst...-6-0-error-500And yes my .htaccess file is modified in the upgrade process. I have tried reverting "data/.backup/upgrades/5dbdcd8f9b0a5dea7/files/.htaccess" to Espo root. But the bug is the same. Any idea where to go next?

This is my .htaccess
"

<ifModule mod_headers.c>
Header always set Access-Control-Allow-Methods "POST, GET, PUT, PATCH, DELETE"
</ifModule>

DirectoryIndex index.php index.html

<IfModule mod_rewrite.c>
RewriteEngine On

# PROTECTED DIRECTORIES
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^/?(data|api|client)/ - [F]

RewriteRule ^/?data/config\.php$ - [F]
RewriteRule ^/?data/logs/ - [F]
RewriteRule ^/?data/cache/ - [F]
RewriteRule ^/?data/upload/ - [F]
RewriteRule ^/?data/\.backup/ - [F]
RewriteRule ^/?application/ - [F]
RewriteRule ^/?custom/ - [F]
RewriteRule ^/?vendor/ - [F]
RewriteRule ^/?client/?$ - [F]
#END PROTECTED DIRECTORIES

RewriteRule .* - [E=HTTP_ESPO_CGI_AUTH:%{HTTP:Authorization}]

RewriteRule reset/?$ reset.html [QSA,L]

#by Cgjedde - Redirect http to https
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
</IfModule>

# BEGIN cPanel-generated php ini directives, do not edit
# Manual editing of this file may result in unexpected behavior.
# To make changes to this file, use the cPanel MultiPHP INI Editor (Home >> Software >> MultiPHP INI Editor)
# For more information, read our documentation (https://go.cpanel.net/EA4ModifyINI)
<IfModule php7_module>
php_flag display_errors Off
php_value max_execution_time 180
php_value max_input_time 180
php_value max_input_vars 1000
php_value memory_limit 256M
php_value post_max_size 50M
php_value session.gc_maxlifetime 5
php_value session.save_path "/var/cpanel/php/sessions/ea-php70"
php_value upload_max_filesize 50M
php_flag zlib.output_compression Off
</IfModule>
# END cPanel-generated php ini directives, do not edit

CacheEnable private /

# php -- BEGIN cPanel-generated handler, do not edit
# Set the “ea-php72” package as the default “PHP” programming language.
<IfModule mime_module>
AddHandler application/x-httpd-ea-php72 .php .php7 .phtml
</IfModule>
# php -- END cPanel-generated handler, do not edit
"