Error 500 after upgrade

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dafnie
    Senior Member
    • Dec 2015
    • 140
    #1

    Error 500 after upgrade

    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
    Tags: None
    • item
      Active Community Member
      • Mar 2017
      • 1476
      #2
      Hi,

      try to make from CLI : php rebuild.php

      Regards
      If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.​

        Comment

        • dafnie
          Senior Member
          • Dec 2015
          • 140
          #3
          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

            Comment

            • yuri
              Member
              • Mar 2014
              • 8440
              #4
              Hi,

              Seems your CLI PHP version is lesser than 7.1. Errors you provided indicate on that.
              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                Comment

                • dafnie
                  Senior Member
                  • Dec 2015
                  • 140
                  #5
                  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
                  "
                  Last edited by dafnie; 11-02-2019, 07:35 PM.

                    Comment

                    Previous template Next
                    Working...