Dear Support,
I've been update to ver. 1.8 beta1 and its show :
Database Error: 1054 - Unknown column 'r.header_sort_order' in 'order clause'
Query: select r.*,e.name as entities_name,e.parent_id as entities_parent_id from app_reports r, app_entities e where e.id=r.entities_id and ((r.created_by='19' and r.reports_type='standard' and r.in_header=1) ) order by r.header_sort_order, r.dashboard_sort_order, r.name
Page: /export/index.php?module=dashboard/
Please, how can I solved it?
Database Error After Upgrade to ver. 1.8 Beta1
-
- Posts: 53
- Joined: 29 Jul 2016, 12:31
- Name: Shandy Banyutresna
- Location: Indonesia, Jakarta
- Company Name: PT. Kimia Farma
- Contact:
Re: Database Error After Upgrade to ver. 1.8 Beta1
Here is The Log file
/export/index.php?module=users/login
1. SET sql_mode = '' [0.000]
2. select * from app_configuration [0.000]
3. select * from app_fields_choices [0.000]
4. select * from app_global_lists_choices [0.000]
5. select e.* from app_entity_1 e order by e.field_8, e.field_7 [0.000]
6. SHOW PRIVILEGES [0.000]
7. select value from app_sessions where sesskey = '4181fc64af41cb775a917cdb2b122ad1' and expiry > '1485175429' [0.000]
8. select * from app_entity_1 where id='19' and field_5=1 [0.000]
9. select * from app_users_configuration where users_id='19' [0.000]
/export/index.php?module=users/login
1. SET sql_mode = '' [0.000]
2. select * from app_configuration [0.000]
3. select * from app_fields_choices [0.000]
4. select * from app_global_lists_choices [0.000]
5. select e.* from app_entity_1 e order by e.field_8, e.field_7 [0.000]
6. SHOW PRIVILEGES [0.000]
7. select value from app_sessions where sesskey = '4181fc64af41cb775a917cdb2b122ad1' and expiry > '1485175429' [0.000]
8. select * from app_entity_1 where id='19' and field_5=1 [0.000]
9. select * from app_users_configuration where users_id='19' [0.000]
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Error After Upgrade to ver. 1.8 Beta1
You did not upgrade database, read the instruction
http://rukovoditel.net/blog/en/?p=162#more-162
http://rukovoditel.net/blog/en/?p=162#more-162
Do database backup
Rewrite all fields from rukovoditel_1.8_beta1.zip
If you are using Extension then rewrite all files from rukovoditel_ext_1.4_beta1.zip in /plugins folder
Run /install/autoupdate/from_1.7_to_1.8.php
Run /install/autoupdate/data_perpare_from_1.7_to_1.8.php
Wait response OK for all Entities
If you are using Extension then run /install/ext_autoupdate/from_1.3_to_1.4.php
Remove /install folder
-
- Posts: 53
- Joined: 29 Jul 2016, 12:31
- Name: Shandy Banyutresna
- Location: Indonesia, Jakarta
- Company Name: PT. Kimia Farma
- Contact:
Re: Database Error After Upgrade to ver. 1.8 Beta1
thank you sir...