Announcement

Collapse
No announcement yet.

Error 500 after upgrade

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Hi,

    try to make from CLI : php rebuild.php

    Regards

    Comment


    • #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


      • #4
        Hi,

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

        Comment


        • #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

          Working...
          X