Once a table is created in the base connected with Mysql,and if you want to make any changes in the tables created using base as frontend,it doesnot allow the changes to be made and during filling records in the table it gives error.
On which LO version are you? FYI, last stable one is 5.0.4
5.0.4
What is the error? Did it work in an older version?
Can't confirm with LO 5.4.0.2. Tested it with OpenSUSE 42.1 64 bit rpm Linux, MariaDB and direct connection to MariaDB. Could create a new table. Could input data. Could add a new field to the table. Please give a step by step-description. Could it be you created a table without primarykey?