Database Error After Upgrade to ver. 1.8 Beta1

Post Reply
shandybt
Posts: 53
Joined: 29 Jul 2016, 12:31
Name: Shandy Banyutresna
Location: Indonesia, Jakarta
Company Name: PT. Kimia Farma
Contact:

Database Error After Upgrade to ver. 1.8 Beta1

Post by shandybt »

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?
shandybt
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

Post by shandybt »

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]
User avatar
support
Site Admin
Posts: 6186
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database Error After Upgrade to ver. 1.8 Beta1

Post by support »

You did not upgrade database, read the instruction
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
shandybt
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

Post by shandybt »

thank you sir... :D :D :D
Post Reply