Add new Quote Error After ver 4.8 Update

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pmontanez
    Member
    • Dec 2016
    • 81

    Add new Quote Error After ver 4.8 Update

    Good Day Yuri

    Thanks for the above release, However I'm getting an error message when trying to a Add a new Quote to one of my existing Accounts, so basically I'm unable to add any new quotes. Here is the error log info:

    PHP Code:
    [2017-08-04 13:49:40] Espo.ERROR: API [POST]:/:controller, Params:Array (     [controller] => Quote ) , InputData: {"accountId":"585c041a667e10d1d","account$
    [2017-08-04 13:49:40] Espo.ERROR: Display Error: SQLSTATE[HY000]: General error: 1100 Table 'workflow' was not locked with LOCK TABLES, Code: HY000 URL: /cr$
    [2017-08-04 13:49:50] Espo.ERROR: API [POST]:/:controller, Params:Array (     [controller] => Quote ) , InputData: {"accountId":"585c041a667e10d1d","account$
    [2017-08-04 13:49:50] Espo.ERROR: Display Error: SQLSTATE[HY000]: General error: 1100 Table 'workflow' was not locked with LOCK TABLES, Code: HY000 URL: /cr$ 
    
    Any Ideas?

    Thanks
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hello
    Did you create any field with 'number' type for Quote entity? Or any other customization related with Quote or Workflow?

    Comment

    • pmontanez
      Member
      • Dec 2016
      • 81

      #3
      Hey Tanya, Yes, there are several customs "Number" fields on the Quote entity -

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        Hello
        We found the bug and now fixing it. Thanks

        Clear Cache in Administration > Create any record in any entity, where you don't have any number field > After that you can create quotes.
        It's old bug, but we didn't meet it before
        Last edited by tanya; 08-04-2017, 03:04 PM.

        Comment

        • pmontanez
          Member
          • Dec 2016
          • 81

          #5
          Hey tanya - It worked !! Thanks for the help -

          Comment

          Working...