Created attachment 87557 [details] Package with database and Calc-document for the data - copy and paste Open the package of the attachment. There is a database with 3 different tables. The tables differ in the field-type of the primary-key-field "ID". There is also a Calc-document with data for this tables. Mark The data of one of the tables in the Calc-document and try to paste them to one table of the database. The tables with an integer or smallinteger primary-key won't accept the data: Warning Incorrect type for setString Continue anyway? OK, lets continue. One row would be added with, but the ID isn't the ID of the original table. When you paste to the table Name_Varchar it would work. Seems there are only characters allowed when pasting to Base-Firebird.
I see this on Linux with master commit 95e95e0, fetched 2013-09-19. Will somebody with Windows or Mac please test, so that we can tell whether other platforms are afflicted? Thanks, Terry.
I am using LibreOffice Version 4.2.5.2 on Windows and have this issue too.
No one wants to fix this problem? The bug still exists in 4.3.0.4 (Windows)...
Adding self to CC if not already on
Is it possible, that LibreOffice Base will be discontinued? Since 2 years no one of the developer team fix this issue. In 5.0.1 for Windows the problem still exists when using Firebird. HSQL works. So I use a HSQL-Version to copy/paste the data from Calc (HTML or RTF import) and then import the table with copy/paste to Firebird (Datasource Table). This is the only way to insert data from a Calc table and it is a very complicated procedure.
Confirming on Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99 Locale: fr.UTF-8 OSX 10.11.5
On pc Debian x86-64 with master sources updated today, I gave a try but I only could paste the whole data in the same cell. Must have missed something I suppose. Anyway, it seems we're on a middle of a transition. We won't upgrade to a newer HSQLDB version because we want to invest on Firebird but this last one is still experimental. Moreover, an upgrade to Firebird 3.0 would arrive soon (I don't know when).
With master sources updated today, I can't see tables. Indeed, I got this error: warn:connectivity.firebird:4258:1:connectivity/source/drivers/firebird/Util.cxx:52: firebird_sdbc error: *unsupported on-disk structure for file /tmp/lu21wdtc.tmp/lu21wdth.tmp/firebird.fdb; found 11.2, support 12.0 caused by 'isc_attach_database' warn:legacy.osl:4258:1:svtools/source/uno/genericunodialog.cxx:314: OGenericUnoDialog::OnDialogDying: where does this come from? warn:connectivity.firebird:4258:1:connectivity/source/drivers/firebird/Util.cxx:52: firebird_sdbc error: *unsupported on-disk structure for file /tmp/lu21wdtc.tmp/lu21wdti.tmp/firebird.fdb; found 11.2, support 12.0 caused by 'isc_attach_database'
(In reply to Julien Nabet from comment #8) > With master sources updated today, I can't see tables. > Indeed, I got this error: > warn:connectivity.firebird:4258:1:connectivity/source/drivers/firebird/Util. > cxx:52: firebird_sdbc error: > *unsupported on-disk structure for file > /tmp/lu21wdtc.tmp/lu21wdth.tmp/firebird.fdb; found 11.2, support 12.0 > caused by > 'isc_attach_database' That's because of the update to Firebird 3.0; I just documented that in https://wiki.documentfoundation.org/ReleaseNotes/5.3#Base
Could you please document the commands necessary to convert an fdb file to the archive format using a Firebird server? Thanks.
Never mind. See http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-upgrade-secdb.html. The third step is apparently not necessary. 1. Extract firebird.fdb from the database folder of the odb file 2. With a Firebird 2.5 server installation run: gbak -user sysdba -pas masterkey -b {host/path}firebird.fdb firebird25.fbk 3. With a Firebird 3.0 server installation run: gbak -user sysdba -pas masterkey -c firebird25.fbk {host/path}firebird.fdb 4. Replace firebird.fdb in the database folder of the odb file with the newly generated firebird.fdb
Nothing changed. Bug also appears with new internal Firebird 3.0. Version: 5.3.0.0.alpha0+ Build ID: e7324c5705eaa38a2c9aa0636f01a73f033ba4d6 CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-10-20_06:12:58 Locale: de-DE (de_DE.UTF-8); Calc: group
Created attachment 128685 [details] Version 3.0 of original odb file I used Lionel's tip for the convert: - install Firebird 2.5 - uncompress odb file - gbak -backup firebird.fdb firebird.fbk - rm firebird.fdb - change owner and rights of the file firebird.bk - recompress all the elements (with the brand new firebird.fbk) - change extension from zip to odb (see https://bugs.documentfoundation.org/show_bug.cgi?id=70506#c15)
On pc Debian x86-64 with master sources updated today but when pasting in Name_VarcharID, LO put all the content in the first cell (ID). Whatever I selected 1 row or all the rows (without header) of non special character part from ods file.
Ok, I succeeded in reproducing this. I had tried to paste after having opened the table instead of pasting in table directly. I noticed this on console when trying to paste in one of the tables with integer/smallinteger primary key: warn:legacy.osl:7313:1:connectivity/source/commontools/TTableHelper.cxx:239: lcl_sanitizeColumnDescs: database did provide invalid ORDINAL_POSITION values!
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Nothing changed. Couldn't copy integer values from Calc to Base with Firebird 3.0. Tested with Version: 5.4.3.2 Build-ID: 92a7159f7e4af62137622921e809f8546db437e5 CPU-Threads: 4; Betriebssystem:Linux 4.4; UI-Render: Standard; VCL: kde4; Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Tamas Bunth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9ccc1f59446bc4a16b6d090a3b556e184eb5f159 tdf#70425 Firebird: accept integers in setDouble It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tamas Bunth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9585521c28b74dec36522a6501ca670b8e14c7ca tdf#70425 do not close cursor explicitly It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Hello. Will this go into 6.0 as well?
(In reply to Gerhard Schaber from comment #20) > Hello. Will this go into 6.0 as well? About 6.0, I tried to merge the 2 quoted patches for this, it's on review on gerrit: https://gerrit.libreoffice.org/#/c/47543/
Tamas Bunth committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=25c751bc92534dca545d75ca348e895e2c335551&h=libreoffice-6-0 tdf#70425 suppress error of closing closed cursor It will be available in 6.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.