I cant add records to my table

asked 2019-08-06 11:01:57 +0200

m3th0s gravatar image

I am using MySQL database

I created a new connection with LibreOffice base using database "inventory"

I created a new table called Assets with values like (assetID, mfr, model, serial) with assetID marked auto-increment and "Integer" datatype (showing a key on the row)

I saved Assets table

Opened assets table to enter data

virtually all options are greyed out cannot add any information at all.

Verified all the table info was indeed created via MySQL Workbench application.

Verified user has full access to database.

I googled and watched videos all night.

Everyone says its missing a key.

Mine is not, so what could be the problem?

Thanks for your help!

-M3th0s

edit retag flag offensive close merge delete

Comments

It does appear to be something specific to windows. I opened the same file on linux and was able to add tables pefectly fine. maybe a problem with the connector. I tried to download a mysql native connector for windows but when i install it says its not for this machine. so im not sure what is providing the mysql connector in windows because there is no extension listed for it.. whatever it is, it does not appear to work on windows. any ideas?

m3th0s gravatar imagem3th0s ( 2019-08-06 20:41:10 +0200 )edit

Have you tried a JDBC or ODBC connector?

Ratslinger gravatar imageRatslinger ( 2019-08-15 04:04:35 +0200 )edit

Not sure what your prob. is, but I've had similar frustrations with this, so understand your frustration. I don't use Windows anymore, but as I recall you do need to match the bit size of connector and LO, i.e. 32 bit connector for 32 bit LO, or 64 bit connector for 64 bit LO. Also I can't recall, but at least in Linux there is a way of testing the database using mysql command. Perhaps there is something like this for Win too. Also I use HeidiSQL, as a 2nd way into the database, and for setup and editing the structure, which I like better than the workbench thing.

EasyTrieve gravatar imageEasyTrieve ( 2019-08-15 16:24:18 +0200 )edit

Ratslinger, No i have not. I am not familiar with them and I haven't solved what/why the native Mysql connector doesn't work right. I'll seek alternatives after I have either solved it or determined it simply does not and will not work on windows. Even then it works as it should in linux so i will just not use windows if i cant find a solve..

m3th0s gravatar imagem3th0s ( 2019-08-20 07:22:31 +0200 )edit

EasyTrieve, I think you might be on to something.. maybe the windows connector is 32bit only.. I am going to install 32bit libreoffice and test that... It's at least a plausible theory. Would explain why when i try to install the windows connector i get "this is not for this machine". Although i would have expected if there was no 32bit you would not have the option in the 64 bit version. In linux the option does not exist until you "apt install libreoffice-mysql-connector" then the module is loaded and listed in extensions then the option for direct connect is there. in windows there is an option to direct connect and there are zero extensions for Mysql listed.... I'll let you know what I find.

m3th0s gravatar imagem3th0s ( 2019-08-20 07:32:19 +0200 )edit

@m3th0s,

It appears you are not using a current version of LO. In current versions, even in Linux, the native MySQL SBDC connector is pre-installed. LO is now using the MariaDB connector and installing another SDBC connector is fruitless. The MariaDB connector had its' problems for me and although JDBC and ODBC connectors worked they were slower and I completely abandoned MySQL for PostgreSQL.

Please see this post -> LibreOffice 6.2: Release Notes

Ratslinger gravatar imageRatslinger ( 2019-08-20 17:45:56 +0200 )edit

Ratslinger, I am using the current version. Testing every option is only fruitless if you don't do it or refuse to try. Abandoning the problem doesn't solve it either. It could be they just broke something in recent versions which could explain why the linux version works fine. repositories are rarely the latest version... or its just localized to windows all together...I will look into PostgreSQL. I have no desire to use it but the way oracle is handling mysql its probably a good idea to go ahead and move to it. Thanks for the help!

m3th0s gravatar imagem3th0s ( 2019-08-20 18:52:34 +0200 )edit

@m3th0s,

You did not read my comment correctly. It states that installing another SDBC connector in the newer LO releases is "fruitless" since the newly included MariaDB connector overrides it completely.

Not certain of anyone ever testing "every" option in a similar situation. I tried a lot with this one before switching. Wasn't worth the time.

Ratslinger gravatar imageRatslinger ( 2019-08-20 22:30:19 +0200 )edit