Error after upgrade

Post Reply
rmcdonald
Investor
Investor
Posts: 417
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud
Contact:

Error after upgrade

Post by rmcdonald »

Hi we upgraded two sites no problem but on the third we are getting the following error

Database Error: 1054 - Unknown column 'assigned_to' in 'where clause'
Query: select * from app_ext_ipages where parent_id=0 and (find_in_set(0,users_groups) or find_in_set(1,assigned_to)) order by sort_order, name
Page: /iridiumHR/index.php?module=dashboard/

We have done twice and completed the database updates ?
User avatar
support
Site Admin
Posts: 6231
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error after upgrade

Post by support »

Make sure you have update database for extension . If so and you steel have this error, then run manually next query

Code: Select all

ALTER TABLE `app_ext_ipages` ADD `assigned_to` TEXT NOT NULL AFTER `users_groups`;
Post Reply