Database Error

[enishemed]

I have updated to version 2.8_Beta1 and extensiton 2.8_Beta1. When try to RESTORE DB FROM FILE, the following error occured. I aslo tried form phpMyAdmin.

Code: Select all

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

[support]

You did not update database for extension.

[enishemed]

I have updated the update database for extension. The error remains.

You did not update database for extension.

[support]

When try to RESTORE DB FROM FILE

Which database you have restored? I think after database was restored you have to update it to 2.8 again.

[enishemed]

I retry the intallation and update. Followed the following steps.

First:
1. Install 2.7.2
2. Install 2.7.2 ext
3. Restore DB from file (existing data from live application)
4. Rewrite all files from rukovoditel_2.8_beta1.zip
5. If you are using Extension then rewrite all files from rukovoditel_ext_2.8_beta1.zip in /plugins folder
6. Run /install/autoupdate/from_2.7_to_2.8.php
7. If you are using Extension then run /install/ext_autoupdate/from_2.7_to_2.8.php
8. Remove /install folder

and has the following error.

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

Second:
1. Install 2.7.2
2. Install 2.7.2 ext
3. Rewrite all files from rukovoditel_2.8_beta1.zip
4. If you are using Extension then rewrite all files from rukovoditel_ext_2.8_beta1.zip in /plugins folder
5. Run /install/autoupdate/from_2.7_to_2.8.php
6. If you are using Extension then run /install/ext_autoupdate/from_2.7_to_2.8.php
7. Remove /install folder
8. Restore DB from file (existing data from live application)

and has the following error.

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

Third
1. Clone installation 2.7.2 and 2.7.2 ext using Softaculous (with existing data from live application)
2. Rewrite all files from rukovoditel_2.8_beta1.zip
3. If you are using Extension then rewrite all files from rukovoditel_ext_2.8_beta1.zip in /plugins folder
4. Run /install/autoupdate/from_2.7_to_2.8.php
5. If you are using Extension then run /install/ext_autoupdate/from_2.7_to_2.8.php
6. Remove /install folder

and has the following error.

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

Don't know what to do else?

[support]

See:

Code: Select all

install\db_updates\update_2.8.sql
install\db_updates\ext\ext_2.8.sql

This is fresh sql files for updates.
run them in phpmyadmin after db restore.
Hope this will help.

[enishemed]

It works yes, thanks very much