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.
Database Error: 1146
-
- Posts: 174
- Joined: 23 Feb 2021, 16:31
- Name: Edi Supriyadi
- Location: BDG Indonesia
Re: Database Error: 1146
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.
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
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Error: 1146
After copy database you have to update it to v3I then copied the backup of my main installation
-
- Posts: 38
- Joined: 02 Nov 2020, 09:50
- Name: John Ownby-Hibner
- Location: Medford, USA
- Company Name: Bear and Badger Club LLC
- Contact:
Re: Database Error: 1146
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
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
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Error: 1146
You have to update database fo extension too.
-
- Posts: 38
- Joined: 02 Nov 2020, 09:50
- Name: John Ownby-Hibner
- Location: Medford, USA
- Company Name: Bear and Badger Club LLC
- Contact:
Re: Database Error: 1146
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
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
-
- Posts: 38
- Joined: 02 Nov 2020, 09:50
- Name: John Ownby-Hibner
- Location: Medford, USA
- Company Name: Bear and Badger Club LLC
- Contact:
Re: Database Error: 1146
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
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Error: 1146
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