Email and Invitations Sending issues "Error 500"...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • naserak
    Junior Member
    • Nov 2014
    • 6

    Email and Invitations Sending issues "Error 500"...

    Hi there,
    Thanks for the great software, simple and comprehensive...
    SMTP setup is correct and "Send Test Email" works fine...
    I'm getting an error when sending emails and when sending Invitations...
    We have a dedicated server and we control our WHM...
    -------------
    I am getting an error 500 when trying to send an email... this is the Log
    ( [controller] => Email ) , InputData: {"assignedUserId":"1","assignedUserName":"Admin"," isHtml":true,"status":"Sending","attachmentsIds":[],"attachmentsNames":{},"attachmentsTypes":{},"to": "naserak1@gmail.com","parentType":"Account","paren tName":"test","parentId":"5477dc85ab872","name":"C ase has been created","selectTemplateName":null,"selectTemplate Id":null,"body":"<p>{Person.name},</p><p>Case '{Case.name}' has been created with number {Case.number} and assigned to Admin.</p>","from":"aknaser@gmail.com","bcc":"","cc":""} - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rgk_espo_crm.email' doesn't exist [] [] [2014-11-28 14:16:40] Espo.ERROR: Display Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rgk_espo_crm.email' doesn't exist, Code: 42S02 URL: /crm/api/v1/Email [] [] -----------------------
    I am also getting error 500 when trying to send Invitations:
    ( [controller] => Meeting [action] => sendInvitations ) , InputData: {"id":"5477e50bc53f6"} - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rgk_espo_crm.email' doesn't exist [] [] [2014-11-28 14:25:13] Espo.ERROR: Display Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rgk_espo_crm.email' doesn't exist, Code: 42S02 URL: /crm/api/v1/Meeting/action/sendInvitations [] [] --------------

    We really appreciate your help...
  • yuri
    Member
    • Mar 2014
    • 8495

    #2
    Hi

    2.7.0 or 2.7.1 ?
    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

    • yuri
      Member
      • Mar 2014
      • 8495

      #3
      Maybe something with database? Check if email table exists. If it does, maybe it's broken. Then try to repair it.
      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

      • naserak
        Junior Member
        • Nov 2014
        • 6

        #4
        Version 2.7.0

        Comment

        • naserak
          Junior Member
          • Nov 2014
          • 6

          #5
          I see these tables...
          email_account
          email_address
          email_email_address
          email_template
          and all give the message "
          The storage engine for the table doesn't support r..." when I try to repair the table...

          is there a 2.7.1? I downloaded the latest from the website 2 days ago, it was 2.7.0 ...
          I can reinstall the whole thing if a better version is out there!
          Thanks

          Comment

          • naserak
            Junior Member
            • Nov 2014
            • 6

            #6
            I just downloaded 2.7.1 ... The installation page is giving 404 error page the.../install/index.php is not loading...

            Comment

            • yuri
              Member
              • Mar 2014
              • 8495

              #7
              There is no email table. That's the cause of your problem. Something with your database.


              Regarding 404 - maybe wrong permissions? http://blog.espocrm.com/administrati...stall-espocrm/
              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

              Working...