Error after updating to 2.7

[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

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

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

[support]

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

[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/

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

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]

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'

[support]

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

[alino99]

Hi,

I am still struggling with this issue.

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

Is there any chance I can give you ftp access?

Thanks