[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 Buovjaga changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |WORKSFORME --- Comment #11 from Buovjaga --- Thanks a lot. Then I think we can close this. It is unfortunate that this glitch existed, but good to know the db can be fixed. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609
--- Comment #10 from Robert Großkopf ---
(In reply to Buovjaga from comment #9)
>
> But can the database be fixed in any way?
The database has to be opened with LO 7.1 or an older version of LO. There must
be a field, which is defined with length 30, but contains 35 characters.
1.
A query like
SELECT * FROM "Table" WHERE CHAR_LENGTH("Text") > 30
should show this field.
The value must be changed.
2. other solution
Table must be edited. Looking for the field, which is set to 30 characters and
change it to 35 characters.
After this changes you could open the database also in LO 7.2 an newer
versions.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 --- Comment #9 from Buovjaga --- (In reply to Robert Großkopf from comment #8) > This problem could only be solved by opening the database with an older > version of LO like LO 7.1. > > The length of the field has been calculated wrong in older versions of > Firebird internal database. See bug 108082 But can the database be fixed in any way? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||8082 CC||rob...@familiegrosskopf.de --- Comment #8 from Robert Großkopf --- This problem could only be solved by opening the database with an older version of LO like LO 7.1. The length of the field has been calculated wrong in older versions of Firebird internal database. See bug 108082 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #7 from Buovjaga --- (In reply to Julien Nabet from comment #6) > What about changing the structure of the table so it'll accept more than 30 > characters? Setting to needinfo. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 Julien Nabet changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||3859 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 --- Comment #6 from Julien Nabet --- What about changing the structure of the table so it'll accept more than 30 characters? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 --- Comment #5 from Julien Nabet --- Brant: I had forgotten about your email so I'm copying/pasting here so everyone have the information: " If 7.2 is not made more forgiving to text field string lengths in excess of the amount specified in the odb table master file, then users will have to make sure that specified string length for each text field is at least equal to the maximum length in the table for that field. Exporting to a calc spreadsheet, copying the field headings out to the right, using the LEN and Max functions and then updating the odb master file using 7.1 [upload file format length importing into 7.2] appears to solve the problem. The error I posted showed the master file specified 30 but base 7.2 found a string length of 35. I found 10 specified and a 12 maximum field length and 20 specified and a 28 maximum. Each text field has to be corrected. I know that I was lazy in that I used the auto feature for 10/100/1000 rows with an upload of 31,000 rows. In 7.0 and 7.1 that was not a problem, a file upload with with string lengths in excess of the specified amount would upload/open and it does not appear to have truncated the data. " -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 --- Comment #4 from Julien Nabet --- I'm not sure there's a bug here. Was it expected LO accepts a string with a length superior to the definition? I mean, would Firebird client would have accepted this? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 --- Comment #3 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 --- Comment #2 from Brant Maltby --- *string right truncation *expected length 30, actual 35 The error appears to be text field strings in excess of the specified field length in the table master file. 7.0 & 7.1 are forgiving in uploading and file opening, 7.2 is not. To fix, use the Calc LEN function in calc to calculate the string length of each text field. Open the odf file in 7.1 and correct the specified text field string lengths, for each text field as appropriate. The odf file should then open in 7.2. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'
https://bugs.documentfoundation.org/show_bug.cgi?id=143609 Julien Nabet changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||serval2...@yahoo.fr --- Comment #1 from Julien Nabet --- Would it be possible to have an example file? Since attachments are public, attach a file with no private/confidential part or sanitize it with 7.0 or 7.1 LO version (see https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
