Installation problem : pma__cental columns has too many primary keys

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
rprevost
Veteran Member
Posts: 47
Joined: 2018-05-30 22:09

Installation problem : pma__cental columns has too many primary keys

Post by rprevost » 2018-06-18 19:40

Hello to you all.
I am trying to create a new project from an existing mysql file. This is the fourth time I do this so:
1. I deleted the content of the folder on the web server
2. I deleted the content of the existing target folder on the desktop
3. Checked after refresh that both folders are empty.
4. Launched Appgini and chose import from mysql.
5. Generated the php file since I could not access the database from outside.
6. Opend the import.php file using the browser.
7. All looked just fine.
8. Saved the import(1).axp file to the folder on the desktop.
9. On the server, the file is named import.axp
10. Launched Appgini and opened the import(1).axp file.
11. Saw that all tables were there.
12. Generated PHP code.
Then got this error message : Table 'pma__central_columns' has too many primary keys. Only one primary key is allowed per table.
Looked at other pma tables and saw that some other tables have too many primary keys.

Can someone can light my lantern here because I am in the dark?
Regards,
rp

rprevost
Veteran Member
Posts: 47
Joined: 2018-05-30 22:09

Re: Installation problem : pma__cental columns has too many primary keys

Post by rprevost » 2018-06-18 19:42

Forgot to write that I am using a paid version. 5.7.2

rprevost
Veteran Member
Posts: 47
Joined: 2018-05-30 22:09

Re: Installation problem : pma__cental columns has too many primary keys

Post by rprevost » 2018-06-18 19:50

pma_central_columns has primary keys for: db_name and col_name fields
pma__navigationhiding has primary keys for: username, item_name, item_type, db_name and table_name
pma__relation has primary keys for: master_db, master_table and master_field
pma_table_coords has primary keys for: db_name, table_name and pdf_page_number
pma_table_info has primary keys for: db_name and table_name
pma__table_uiprefs has primary keys for: username, db_name and table_name
pma__tracking has primary keys for: db_name, table_name and version
pma__usergroups has primary keys for: usergroup, tab, allowed
pma__users has primary keys for: username and usergroup

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Installation problem : pma__cental columns has too many primary keys

Post by pbottcher » 2018-06-18 20:36

Hi,

can you check in your project the fields mentioned below for the different tables. If multiple have the primary key set, you need to reduce it to only one per table.
primary_key.JPG
primary_key.JPG (32.49 KiB) Viewed 2055 times
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

Post Reply