https://bugs.documentfoundation.org/show_bug.cgi?id=165929
Bug ID: 165929
Summary: MySQL/MariaDB direct Connection: Impossible to append
Data by Wizard to a Table in MariaDB
Product: LibreOffice
Version: 25.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 200047
--> https://bugs.documentfoundation.org/attachment.cgi?id=200047&action=edit
Screenshot of error when trying to append data to an existing table.
Open a Base file with connection to an internal database.
Create a table with a name like "tbl_Test" with some fields (ID, Name …)
Open a direct connection to MariaDB.
Move the table from first Base-file to the file with direct connection to
MariaDB, folder tables.
Let the wizard create the definition for the table "tbl_Test". Will work well
if you haven't created a varchar field with more than 255 characters.
"tbl_Test" will be created.
Now move the table from first Base-file a second time to file with direct
connection, directly to "tbl_Test" of direct connection.
Try to choose "Append data" and press "Next" or "Create". A error appears:
"This table name is not valid in the current database."
You could try to add the database mane to the tablename
("databasename.tbl_Test") but it didn't work also.
Tested with
Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: fddf2685c70b461e7832239a0162a77216259f22
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
