View Libreoffice Base queries to mysql

Question

I'm trying to create a table with a primary key from Libreoffice Base connected to MariaDB. A standard table with a primary, autogenerated (incrementing I presume) key.

But it fails with this message:

Error: 1064

You have an error in your SQL syntax; check the manual that corresponds to 
your MariaDB server version for the right syntax to use near
' PRIMARY KEY  ("ID"))' at line 1

Is there a way to view the query LibereOffice sends?

No, that's exactly the problem. The LibreOffice Base GUI makes an error, but I can't see the query. — Leif Neland, Sep 22 '20 at 12:16
Could you please enable audit logs or general logs of mariadb to capture exact query. — ROHIT KHURANA, Sep 22 '20 at 12:59

score 0 · Accepted Answer · answered Sep 22 '20 at 13:56

0

Enabling logging in the database, to table enabled me to see the faulty query.

SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';

answered Sep 22 '20 at 13:56

Leif Neland

1,416
1
17
40

View Libreoffice Base queries to mysql

1 Answers1