Announcement

Collapse
No announcement yet.

Cannot view any customer records after upgrade to 5.6.0

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

  • Cannot view any customer records after upgrade to 5.6.0

    Good Morning,

    I upgraded to 5.6.0 and when logged in as a "normal user" (non admin) I cannot view any of our customer records when clicked. When I click a customer name, instead of bringing me to their record it remains on the page. No error messages. It's as though i never even clicked it.

    When logged in as a admin everything works fine. i have the ability to click on a client record and it functions as it should.

    I have tried rebuilding with php rebuild which doesn't solve the issue
    I have checked permissions server side as well as roles of user and all is well on that side.
    I have tried creating a new user however the issue remains.

    Any help you can offer would be fantastic.

    Here are the latest logs from espo log file

    Code:
    [2019-04-04 02:54:15] Espo.ERROR: Display Error: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart', Code: 42 URL: /api/v1/Activities/User/5bbd7fb23ede706a7/history?maxSize=5&offset=0&orderBy=dateStart&order=desc [] []
    [2019-04-04 02:55:02] Espo.ERROR: API [GET]:/Activities/:scope/:id/:name, Params:Array (     [scope] => User     [id] => 5bbd7fb23ede706a7     [name] => history ) , InputData:  - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart' [] []
    [2019-04-04 02:55:02] Espo.ERROR: Display Error: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart', Code: 42 URL: /api/v1/Activities/User/5bbd7fb23ede706a7/history?maxSize=5&offset=0&orderBy=dateStart&order=desc [] []
    [2019-04-04 03:18:01] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] No such file or directory" at /var/www/vhosts/espocrm/application/Espo/ORM/EntityManager.php line 158 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /var/www/vhosts/espocrm/application/Espo/ORM/EntityManager.php:158)"} []
    [2019-04-04 03:20:51] Espo.ERROR: API [GET]:/:controller, Params:Array (     [controller] => User ) , InputData:  -  [] []
    [2019-04-04 03:20:51] Espo.ERROR: Display Error: , Code: 403 URL: /api/v1/User?select=salutationName%2CfirstName%2ClastName%2Cname%2CuserName%2CemailAddressIsOptedOut%2CemailAddress%2CemailAddressData%2CphoneNumberIsOptedOut%2CphoneNumber%2CphoneNumberData&maxSize=5&offset=0&orderBy=userName&order=asc&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5Bvalue%5D=active [] []
    [2019-04-04 03:26:59] Espo.ERROR: API [GET]:/Activities/:scope/:id/:name, Params:Array (     [scope] => User     [id] => 5ca2c7dff0670f994     [name] => history ) , InputData:  - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart' [] []
    [2019-04-04 03:26:59] Espo.ERROR: Display Error: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart', Code: 42 URL: /api/v1/Activities/User/5ca2c7dff0670f994/history?maxSize=5&offset=0&orderBy=dateStart&order=desc [] []
    [2019-04-04 03:27:48] Espo.ERROR: API [GET]:/Activities/:scope/:id/:name, Params:Array (     [scope] => User     [id] => 5ca2c7dff0670f994     [name] => history ) , InputData:  - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart' [] []
    [2019-04-04 03:27:48] Espo.ERROR: Display Error: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart', Code: 42 URL: /api/v1/Activities/User/5ca2c7dff0670f994/history?maxSize=5&offset=0&orderBy=dateStart&order=desc [] []
    [2019-04-04 03:28:10] Espo.ERROR: API [GET]:/Activities/:scope/:id/:name, Params:Array (     [scope] => User     [id] => 5ca2c7dff0670f994     [name] => history ) , InputData:  - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart' [] []
    [2019-04-04 03:28:10] Espo.ERROR: Display Error: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart', Code: 42 URL: /api/v1/Activities/User/5ca2c7dff0670f994/history?maxSize=5&offset=0&orderBy=dateStart&order=desc [] []
    [2019-04-04 03:29:48] Espo.ERROR: API [GET]:/Activities/:scope/:id/:name, Params:Array (     [scope] => User     [id] => 5ca57a2bcb1c493a0     [name] => history ) , InputData:  - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart' [] []
    [2019-04-04 03:29:48] Espo.ERROR: Display Error: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart', Code: 42 URL: /api/v1/Activities/User/5ca57a2bcb1c493a0/history?maxSize=5&offset=0&orderBy=dateStart&order=desc [] []
    [2019-04-04 03:30:01] Espo.ERROR: API [GET]:/Activities/:scope/:id/:name, Params:Array (     [scope] => User     [id] => 1     [name] => history ) , InputData:  - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart' [] []
    [2019-04-04 03:30:01] Espo.ERROR: Display Error: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dateStart', Code: 42 URL: /api/v1/Activities/User/1/history?maxSize=5&offset=0&orderBy=dateStart&order=desc [] []

  • #2
    Hello,
    Try to debug the problem. Press F12 in your browser, then switch to the 'network' tab, call the error again (click the customer name), and check if there appear red records. This is an error. Also, check the error description in the 'console' tab.

    Comment


    • #3

      I have a similar problem. All related activities in contacts cannot be displayed. I switched from php7.2 to 7.1 and it all worked. Whether it's an bug in ESPOcrm I don't know

      Comment


      • #4
        What php and mysql version do you have? Thanks.

        Comment


        • #5
          Originally posted by yurikuzn View Post
          What php and mysql version do you have? Thanks.
          I'm using 7.3. Looks like i'll be downgrading to 7.1 as dafnie confirmed working. I'll post results once the change in PHP version takes place.

          Comment


          • #6
            Originally posted by vangaugh View Post

            I'm using 7.3. Looks like i'll be downgrading to 7.1 as dafnie confirmed working. I'll post results once the change in PHP version takes place.
            Even after downgrading to 7.1, still no go. The only employees who have access are "managers" and above. Possible this is a permission issue since "normal" users cant access but managers can??

            Comment


            • #7
              we are facing the same problem with roles and permissions, i think this is global bug, hence everyone is facing the same issue. for us our sales managers can't view any of their team mates records although this is set for roles and permissions and used to work fine only after upgrade when this started happening.
              i hope this will be sorted with the coming version.

              Comment


              • yuri
                yuri commented
                Editing a comment
                This topic is not related to your problem.

            • #8
              I am sorry yuri

              Comment

              Working...
              X