search

simov / express-admin

MySQL, MariaDB, PostgreSQL, SQLite admin for Node.js
MIT License
1.18k stars 223 forks source link

Database tables not rendering #128

Closed tkodev closed 7 years ago

tkodev commented 7 years ago

I'm using express-admin to create a mysql database adminstration portal. Currently only 6 of 17 tables are displayed yet the rest refuse to render. The tables rendered are always the same ones, as well as the ones missing. They are not missing alphabetically / as per db order as they are missing almost randomly. Chrome inspector show they are entirely missing from the HTML markup.

The DB is MariaDB (mysql compatible) and it contains foreign keys matching to other tables in the database.

Any clue to what I should do? I am stuck. Let me know what data to provide, thanks.

tkodev commented 7 years ago

I just tested it on another database and it does the same thing. Is this intended behaviour ?

Thanks

tkodev commented 7 years ago

Tables need to have a primary / unique key or they will not be displayed. Please add it to the documentation 👍