Tweet
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
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 [] []
Comment