AppGini Community Forums

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

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

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

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.