Error after updating to 2.7

Ask your questions here.
Post Reply
alino99
Posts: 36
Joined: 17 Jun 2019, 20:27
Name: Alin
Location: London

Error after updating to 2.7

Post by alino99 »

Good morning,

I have tried to update to 2.7 and now I have this error after login:

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: /index.php?module=dashboard/

I've tried to update to 2.8 too, but the error stills the same.

Any idea on how can I resolve this?

Thanks

User avatar
support
Site Admin
Posts: 3775
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error after updating to 2.7

Post by support »

Which version do use before?

Did you update database? If so then just run this query in phpmyadmin

Code: Select all

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

alino99
Posts: 36
Joined: 17 Jun 2019, 20:27
Name: Alin
Location: London

Re: Error after updating to 2.7

Post by alino99 »

I think 2.6. Yes, I did. The error occurred after using the links to update the db.

How do I run the query? Thank you

User avatar
support
Site Admin
Posts: 3775
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error after updating to 2.7

Post by support »

Go to control panel on your hosing and find link to phpmyadmin where you can run query manually.

alino99
Posts: 36
Joined: 17 Jun 2019, 20:27
Name: Alin
Location: London

Re: Error after updating to 2.7

Post by alino99 »

I run the query and still have this after login:

Database Error: 1146 - Table 'hrcomp.app_ext_pivot_calendars' doesn't exist
Query: select * from app_ext_pivot_calendars order by sort_order, name
Page: /index.php?module=dashboard/

User avatar
support
Site Admin
Posts: 3775
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error after updating to 2.7

Post by support »

Well, it main you did not update database for extension
See install\db_updates\ext\ext_2.6.sql
You can find updates here. Exclude

Code: Select all

ALTER TABLE `app_ext_ipages` ADD `assigned_to` TEXT NOT NULL AFTER `users_groups`;
from this file and run in phpmyadmin

alino99
Posts: 36
Joined: 17 Jun 2019, 20:27
Name: Alin
Location: London

Re: Error after updating to 2.7

Post by alino99 »

I have tried and it says

SQL query:


ALTER TABLE `app_ext_ipages` ADD `assigned_to` TEXT NOT NULL AFTER `users_groups`
MySQL said: Documentation

#1060 - Duplicate column name 'assigned_to'

alino99
Posts: 36
Joined: 17 Jun 2019, 20:27
Name: Alin
Location: London

Re: Error after updating to 2.7

Post by alino99 »

If I run the 2.8 extension update using the link it says:

ALTER TABLE `app_ext_ganttchart` ADD `skin` VARCHAR(32) NOT NULL AFTER `default_view`
1054
Unknown column 'default_view' in 'app_ext_ganttchart'

User avatar
support
Site Admin
Posts: 3775
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error after updating to 2.7

Post by support »

alino99 wrote:
24 Jan 2021, 02:05
I have tried and it says

SQL query:


ALTER TABLE `app_ext_ipages` ADD `assigned_to` TEXT NOT NULL AFTER `users_groups`
MySQL said: Documentation

#1060 - Duplicate column name 'assigned_to'
It's because you have already run manually ALTER TABLE `app_ext_ipages` ADD `assigned_to` TEXT NOT NULL AFTER `users_groups` in php my admin

So open install\db_updates\ext\ext_2.6.sql find line
ALTER TABLE `app_ext_ipages` ADD `assigned_to` TEXT NOT NULL AFTER `users_groups`;
and remove it from file and then run again without this line.
install\db_updates\ext\ext_2.6.sql

Post Reply