Database Error: 1146

[Badger]

I got the following error after the upgrade.

Database Error: 1146 - Table 'adminbearbadger_crm.app_global_vars' doesn't exist
Query: select * from app_global_vars where is_folder=0
Page: /crm/index.php?module=users/login

I did a backup prior to the upgrade.

I set up a new database as v3.0, I was able to log in fine as a 'fresh' copy. I then copied the backup of my main installation to the second installation and did a restore to the 'new' installation. I'm getting the error on both installations now.

I'm not finding an app_global_vars table in either database.

[eddydeniro]

You can see the docs here https://docs.rukovoditel.net/index.php?p=63.
There are some new tables in v3.
Just access the related php file from your current instalation to run the query or you can copy the query and use phpmyadmin to create the tables.

[support]

I then copied the backup of my main installation

After copy database you have to update it to v3

[Badger]

Thanks, I must have skipped that when I upgraded last night at the end of the day. I just put a url to the file in a webbrowser and it upgraded. I'm back in.

I am experiencing some errors.

If I click on the Users entity in the menu, I get this error:

Database Error: 1146 - Table 'adminbearbadger_crmtst.app_ext_export_selected' doesn't exist
Query: select ep.* from app_ext_export_selected ep, app_entities e where ep.is_active=1 and e.id=ep.entities_id and find_in_set('menu_with_selected',ep.button_position) and ep.entities_id='1' and (find_in_set(0,users_groups) or find_in_set(1,assigned_to)) order by ep.sort_order, ep.name
Page: /crmtst/index.php?module=items/items&path=1

If I use this menu path: Application Structure>>Entities List>>Users and then click on the 'Form' tab, I get this error:

Database Error: 1054 - Unknown column 'parent_id' in 'where clause'
Query: select * from app_forms_tabs where parent_id=0 and entities_id=21 order by sort_order, name
Page: /crmtst/index.php?module=entities/forms&entities_id=21

[support]

You have to update database fo extension too.

[Badger]

I've run through updating the Extension.

I'm getting an error here:



The error occurs when I attempt to goto the FOrm Configuration on any entity. Otherwise no other errors now.

"Database Error: 1054 - Unknown column 'parent_id' in 'where clause'
Query: select * from app_forms_tabs where parent_id=0 and entities_id=22 order by sort_order, name
Page: /crm/index.php?module=entities/forms&entities_id=22"

I have noticed that there are 2 'Administrator' roles showing in the dropdown options


But only on in the User Groups

[Badger]

I did a complete 'clean' install using a new database. Everything installs correctly. When I attempt to restore data from a backup I created yesterday the system starts throwing errors.

[support]

I did a complete 'clean' install using a new database. Everything installs correctly. When I attempt to restore data from a backup I created yesterday the system starts throwing errors.

After backup restore you have to run db update again since database is not for version 3.0
https://www.rukovoditel.net/new_release.php?version=3.0