Announcement

Collapse
No announcement yet.

Error 500

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

  • Error 500

    Hello,

    We have encountered an Error 500 after the last upgrade to last version. We have set PHP version to 7.2 and it works for a while then after a period (1-2 days) it gives an Error 500. The workaround is to set PHP version to 7.3, but again it works for a couple of days and the workaround is to set back to 7.2. And we keep doing this but the error does not go away.

    Do you have any solutions for this situation?

  • #2
    Hello Cris,
    Can you tell us more about your instance?
    First tell us what you see in logs.
    You can find logs in /data/logs/

    Comment


    • #3
      With EspoCRM I haven't run into any error 500 Error yet, with other CRM I did, usually to do with file permission or low setting in your PHP. Aside from the log emilod mention, see if there any error in your cPanel or Apache error.

      Also try using php 7.1 maybe, see if that help. And rebuild file in Administration setting.

      Comment


      • #4
        Hello Cris,
        the latest EspoCRM version should work w/o problems on PHP v7.1., 7.2 and 7.3 as well. Could you provide the EspoCRM error log file with this error description from the /data/logs/ directory as emillod suggested?

        Comment


        • #5
          Hello,

          Thank you for the replies. Here are the logs from yesterday when we encountered the error:

          [2020-01-07 13:55:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:55:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:55:03] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:55:03] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:55:04] Espo.ERROR: CronManager: Failed job running, job [5e148d3eef8d99367]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []
          [2020-01-07 13:55:05] Espo.ERROR: CronManager: Failed job running, job [5e148d7a669026371]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []
          [2020-01-07 13:56:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:56:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:56:03] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:56:03] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:56:03] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:56:04] Espo.ERROR: CronManager: Failed job running, job [5e148d7a669026371]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []
          [2020-01-07 13:57:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:57:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:57:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:57:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:57:03] Espo.ERROR: CronManager: Failed job running, job [5e148df2e42095e2c]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []
          [2020-01-07 13:58:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:58:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:58:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:58:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:58:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:58:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:58:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:58:04] Espo.ERROR: CronManager: Failed job running, job [5e148df2e42095e2c]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []
          [2020-01-07 13:58:05] Espo.ERROR: CronManager: Failed job running, job [5e148e2e6eb39c827]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []
          [2020-01-07 13:59:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:59:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:59:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:59:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:59:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:59:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []
          [2020-01-07 13:59:03] Espo.ERROR: CronManager: Failed job running, job [5e148e2e6eb39c827]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []


          Comment


          • #6
            I assume this statement throws the error 500:
            Code:
            [2020-01-07 13:59:03] Espo.ERROR: CronManager: Failed job running, job [5e148e2e6eb39c827]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []
            Please check the IMAP configs.

            Comment


            • #7
              Originally posted by Maximus View Post
              I assume this statement throws the error 500:
              Code:
              [2020-01-07 13:59:03] Espo.ERROR: CronManager: Failed job running, job [5e148e2e6eb39c827]. Error Details: Job CheckInboundEmails 56fcfa18a77e45e22: [0] cannot connect to host ; error = fsockopen(): unable to connect to ssl://cloud313.mxserver.ro:993 (Connection refused) (errno = 0 ) [] []
              Please check the IMAP configs.
              Thanks for the reply. Might this affect also the need to change the PHP version?

              Comment


              • #8
                The CRON jobs are using the PHP CLI that is not the same as a web server PHP. EspoCRM supports PHP 7.1, 7.2, and 7.3 as well on the webserver level. For the CLI we suggest you to use PHP v.7.2.
                To check the webserver PHP version you can in Administration -> System Requirements.
                To check the CLI PHP version you can by running this command in the terminal
                Code:
                php -v
                Also, please make sure that IMAP settings are OK by making a test connection.

                Comment


                • #9
                  Originally posted by Maximus View Post
                  The CRON jobs are using the PHP CLI that is not the same as a web server PHP. EspoCRM supports PHP 7.1, 7.2, and 7.3 as well on the webserver level. For the CLI we suggest you to use PHP v.7.2.
                  To check the webserver PHP version you can in Administration -> System Requirements.
                  To check the CLI PHP version you can by running this command in the terminal
                  Code:
                  php -v
                  Also, please make sure that IMAP settings are OK by making a test connection.
                  Thanks for the reply. We made the updates for the IMAP and made a test connection with success. Regarding PHP version it says 7.2.22 in System Requirements and in our CPanel it says 7.2.

                  Comment


                  • #10
                    The Error 500 appeared again. This time in logs appears:

                    [2020-01-08 17:31:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []

                    In CPANEL error appears:

                    2020-01-08 16:33:34.661513 [INFO] [5339] [92.81.102.79:61396] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 16:33:34.661497 [INFO] [5339] [92.81.102.79:61396] File not found [/home/regro/public_html/crm/cid:5b2939d6b7f39d052]

                    2020-01-08 16:33:32.951451 [INFO] [5339] [92.81.102.79:61397] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 16:33:32.951433 [INFO] [5339] [92.81.102.79:61397] File not found [/home/regro/public_html/crm/cid:5b2939d6b7f39d052]

                    2020-01-08 16:29:09.064885 [INFO] [5339] [92.81.102.79:53582-2#APVH_regnet.ro] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 16:29:09.064866 [INFO] [5339] [92.81.102.79:53582-2#APVH_regnet.ro] File not found [/home/regro/public_html/crm/FAE91123-FE0B-4016-81CE-32CE47A0375D]

                    2020-01-08 16:29:08.443907 [INFO] [5339] [92.81.102.79:53579-25#APVH_regnet.ro] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 16:29:08.443891 [INFO] [5339] [92.81.102.79:53579-25#APVH_regnet.ro] File not found [/home/regro/public_html/crm/FAE91123-FE0B-4016-81CE-32CE47A0375D]

                    2020-01-08 16:29:03.437902 [INFO] [5339] [92.81.102.79:53579-23#APVH_regnet.ro] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 16:29:03.437883 [INFO] [5339] [92.81.102.79:53579-23#APVH_regnet.ro] File not found [/home/regro/public_html/crm/FAE91123-FE0B-4016-81CE-32CE47A0375D]

                    2020-01-08 16:28:58.906765 [INFO] [5339] [92.81.102.79:53579-15#APVH_regnet.ro] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 16:28:58.906745 [INFO] [5339] [92.81.102.79:53579-15#APVH_regnet.ro] File not found [/home/regro/public_html/crm/FAE91123-FE0B-4016-81CE-32CE47A0375D]

                    2020-01-08 16:28:51.720268 [INFO] [5339] [92.81.102.79:53582] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 16:28:51.720248 [INFO] [5339] [92.81.102.79:53582] File not found [/home/regro/public_html/crm/FAE91123-FE0B-4016-81CE-32CE47A0375D]

                    2020-01-08 14:11:00.772263 [INFO] [17055] [194.60.254.128:23586] File not found [/home/regro/public_html/403.shtml]

                    2020-01-08 14:09:21.724017 [INFO] [17055] [92.81.102.79:60016] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 14:09:21.724000 [INFO] [17055] [92.81.102.79:60016] File not found [/home/regro/public_html/crm/D840D276-26D1-4ABC-9FB4-C392017B6180]

                    2020-01-08 14:04:07.944818 [INFO] [17055] [92.81.102.79:59965] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 14:04:07.944786 [INFO] [17055] [92.81.102.79:59965] File not found [/home/regro/public_html/crm/D840D276-26D1-4ABC-9FB4-C392017B6180]

                    2020-01-08 10:33:01.279568 [INFO] [15997] [82.78.246.133:58367-63#APVH_regnet.ro] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 10:33:01.279540 [INFO] [15997] [82.78.246.133:58367-63#APVH_regnet.ro] File not found [/home/regro/public_html/crm/FBD5CCC1-6A21-4555-9BEF-D0AE4AA4A550]

                    2020-01-08 10:32:56.904088 [INFO] [15997] [82.78.246.133:58367] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 10:32:56.904071 [INFO] [15997] [82.78.246.133:58367] File not found [/home/regro/public_html/crm/FBD5CCC1-6A21-4555-9BEF-D0AE4AA4A550]

                    2020-01-08 10:29:54.835251 [INFO] [15997] [82.78.246.133:58355-57#APVH_regnet.ro] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 10:29:54.835226 [INFO] [15997] [82.78.246.133:58355-57#APVH_regnet.ro] File not found [/home/regro/public_html/crm/FBD5CCC1-6A21-4555-9BEF-D0AE4AA4A550]

                    2020-01-08 10:29:38.730459 [INFO] [15997] [82.78.246.133:3842] File not found [/home/regro/public_html/404.shtml]

                    2020-01-08 10:29:38.730425 [INFO] [15997] [82.78.246.133:3842] File not found [/home/regro/public_html/crm/FBD5CCC1-6A21-4555-9BEF-D0AE4AA4A550]

                    2020-01-08 01:08:12.526529 [INFO] [11871] [134.255.57.200:55724] File not found [/home/regro/public_html/403.shtml]

                    [Wed Jan 8 01:08:12 2020] [error] [client 134.255.57.200] ModSecurity: Access denied with code 403, [Rule: 'TX:RBL_IP' '!@rbl nxdomain.v2.rbl.imunify.com.'] [id "77140164"] [rev "1"] [msg "Infectors: PHP Injection Low value||MVN:RBL lookup of 01-08.134.255.57.200.infectors.v2.rbl.imunify.com._v4 succeeded.||T:LITESPEED||MV:RBL lookup of 01-08.134.255.57.200.infectors.v2.rbl.imunify.com._v4 succeeded.||PC:243||SC:/home/regro/public_html/index.php"] [severity "WARNING"] [tag "o"] [tag "i360"]


                    Comment


                    • #11
                      What did you do to generate an error 500?
                      The records in the CPanel's log are bothering me. EspoCRM doesn't have such files, so if it not your requests, please write to your customer support.

                      Comment


                      • #12
                        Originally posted by Maximus View Post
                        What did you do to generate an error 500?
                        The records in the CPanel's log are bothering me. EspoCRM doesn't have such files, so if it not your requests, please write to your customer support.
                        It seems that Espo gives the same errors in the logs:

                        [2020-01-09 09:15:29] Espo.ERROR: (403) GET /crm/?entryPoint=attachment&id=5c86296c355139414; line: 61, file: /home/regnetro/public_html/crm/application/Espo/EntryPoints/Attachment.php [] []
                        [2020-01-09 09:16:02] Espo.WARNING: E_WARNING: A non-numeric value encountered {"code":2,"message":"A non-numeric value encountered","file":"/home/regnetro/public_html/crm/vendor/mtdowling/cron-expression/src/Cron/AbstractField.php","line":94} []

                        Might these be the problem?

                        Comment


                        • #13
                          The Error 403 is an access error that means you do not have permission to this data. The last record is just a warning. I don't think that this is a problem, that's why I need to know what did you do to make the error 500 appear. Also, could you provide the screenshots with the error? Also, if the EspoCRM log file has other records then we want to check it. Perhaps there is something else. All this information should help us to understand what a functionality causes the error 500 and give you tips of how to fix it.
                          Thanx.

                          Comment


                          • #14
                            Originally posted by Maximus View Post
                            The Error 403 is an access error that means you do not have permission to this data. The last record is just a warning. I don't think that this is a problem, that's why I need to know what did you do to make the error 500 appear. Also, could you provide the screenshots with the error? Also, if the EspoCRM log file has other records then we want to check it. Perhaps there is something else. All this information should help us to understand what a functionality causes the error 500 and give you tips of how to fix it.
                            Thanx.
                            Thanks for the message. Here is the log file: https://wetransfer.com/downloads/478...ecipient_email

                            Comment


                            • #15
                              I can't reproduce this the error. Could you tell me when this error is appearing? What are you doing to reproduce it?

                              Comment

                              Working...
                              X