Announcement

Collapse
No announcement yet.

Error Log form Group Email

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

  • Error Log form Group Email

    Getting this error in my log. Cannot get the Group Email to receive anything.

    Code:
    [2018-02-05 01:20:09] Espo.ERROR: Display Error: cannot connect to host ; error = fsockopen(): unable to connect to ssl://imap.google.com:993 (php_network_getaddresses: getaddrinfo failed: Name or service not known) (errno = 0 ), Code: 0 URL: /espocrm/api/v1/InboundEmail/action/testConnection [] []
    [2018-02-05 01:20:17] Espo.WARNING: E_WARNING: mkdir(): File exists {"code":2,"message":"mkdir(): File exists","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/File/Manager.php","line":396,"context":{"path":"data/cache/application/acl","permission":"509","recursive":true,"fullPat h ":"data/cache/application/acl","defaultPermissions":{"dir":"0775","file":"0 6 64","user":1,"group":1}}} []
    [2018-02-05 01:20:17] Espo.ERROR: API [GET]:/Stream, Params:Array ( ) , InputData: - Permission denied: unable to create a folder on the server - data/cache/application/acl [] []
    [2018-02-05 01:20:17] Espo.ERROR: Display Error: Permission denied: unable to create a folder on the server - data/cache/application/acl, Code: 500 URL: /espocrm/api/v1/Stream?maxSize=50&offset=0&sortBy=number&asc=false [] []
    [2018-02-05 01:20:25] Espo.ERROR: API [POST]:/:controller/action/:action, Params:Array ( [controller] => InboundEmail [action] => testConnection ) , InputData: {"host":"imap.google.com","port":"993","ssl":tr ue, "username":"info@phlebfinders.com","password": null ,"id":"*****"} - cannot connect to host ; error = fsockopen(): unable to connect to ssl://imap.google.com:993 (php_network_getaddresses: getaddrinfo failed: Name or service not known) (errno = 0 ) [] []
    [2018-02-05 01:20:25] Espo.ERROR: Display Error: cannot connect to host ; error = fsockopen(): unable to connect to ssl://imap.google.com:993 (php_network_getaddresses: getaddrinfo failed: Name or service not known) (errno = 0 ), Code: 0 URL: /espocrm/api/v1/InboundEmail/action/testConnection [] []
    [2018-02-05 01:24:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
    [2018-02-05 01:28:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
    [2018-02-05 01:32:01] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
    [2018-02-05 01:36:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
    Last edited by bradaks; 02-05-2018, 02:48 AM.

  • #2
    I repaired my SQL and did a rebuild. No luck.

    Comment


    • #3
      Hello.
      try imap.gmail.com

      Comment


      • #4
        I did that as well after realizing I goofed that up. After doing that, I get the error:
        [2018-02-05 01:24:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []

        Comment


        • #5
          Does selected folder (INBOX or other one) exist?

          Comment


          • #6
            Here is what happens with INBOX selected:
            [2018-02-05 15:48:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Import Message w/ PhpMimeMailParser): [HY000] SQLSTATE[HY000]: General error: 1100 Table 'hourly_rate_currency_alias' was not locked with LOCK TABLES [] []


            When I have just [Gmail] selected it only has the folder error.

            Comment


            • #7
              So Inbox actually fetched 3 emails. And then I get the same error again:

              [2018-02-05 17:25:02] Espo.ERROR: EmailAccount 5a7892d2d83e90016 (Import Message w/ PhpMimeMailParser): [HY000] SQLSTATE[HY000]: General error: 1100 Table 'hourly_rate_currency_alias' was not locked with LOCK TABLES [] []

              Comment


              • #8
                Is this table internal? (Do you have entity HourlyRateCurrencyAlias)?

                Comment


                • #9
                  I do not have a table named that. There is an hourlyRateCurrency Varchar field in the email entity, but this is not one I created.

                  Comment


                  • #10
                    Remove this field with Entity Manager, please. It's not a good idea to add a field to this Entity

                    Comment


                    • #11
                      Thank you so much for helping me troubleshoot this. Not sure how that got in there, but I appreciate the work you did to help out. It works great now.

                      Comment

                      Working...
                      X