Bugzilla – Attachment 145703 Details for
Bug 120576
CRASH: Base crash without any notice with the option to migrate the embedded database from HDBSQL to FIREBIRD.
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
console traces
console.txt (text/plain), 6.36 KB, created by
Julien Nabet
on 2018-10-14 12:39:46 UTC
(
hide
)
Description:
console traces
Filename:
MIME Type:
Creator:
Julien Nabet
Created:
2018-10-14 12:39:46 UTC
Size:
6.36 KB
patch
obsolete
>warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Statement.cxx:122: isc_dsql_execute failed >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: >*unsuccessful metadata update >*CREATE VIEW View_Label_Media failed >*Dynamic SQL Error >*SQL error code = -804 >*Function unknown >*TRUNCATE >caused by >'CREATE VIEW "View_Label_Media" ("ID","No","Count_3","Barcode_EAN13_ID") AS SELECT "ID", ( SELECT COUNT( "ID" ) FROM "Media" WHERE "ID" <= "a"."ID" ) AS "No", MOD( ( SELECT COUNT( "ID" ) FROM "Media" WHERE "ID" < "a"."ID" ), 3 ) AS "Count_3", "ID" || MOD( 10 - MOD( ( ( TRUNCATE( "ID", - 11 ) / 100000000000 - TRUNCATE( "ID", - 12 ) / 100000000000 ) + 3 * ( TRUNCATE( "ID", - 10 ) / 10000000000 - TRUNCATE( "ID", - 11 ) / 10000000000 ) + ( TRUNCATE( "ID", - 9 ) / 1000000000 - TRUNCATE( "ID", - 10 ) / 1000000000 ) + 3 * ( TRUNCATE( "ID", - 8 ) / 100000000 - TRUNCATE( "ID", - 9 ) / 100000000 ) + ( TRUNCATE( "ID", - 7 ) / 10000000 - TRUNCATE( "ID", - 8 ) / 10000000 ) + 3 * ( TRUNCATE( "ID", - 6 ) / 1000000 - TRUNCATE( "ID", - 7 ) / 1000000 ) + ( TRUNCATE( "ID", - 5 ) / 100000 - TRUNCATE( "ID", - 6 ) / 100000 ) + 3 * ( TRUNCATE( "ID", - 4 ) / 10000 - TRUNCATE( "ID", - 5 ) / 10000 ) + ( TRUNCATE( "ID", - 3 ) / 1000 - TRUNCATE( "ID", - 4 ) / 1000 ) + 3 * ( TRUNCATE( "ID", - 2 ) / 100 - TRUNCATE( "ID", - 3 ) / 100 ) + ( TRUNCATE( "ID", - 1 ) / 10 - TRUNCATE( "ID", - 2 ) / 10 ) + 3 * ( "ID" - TRUNCATE( "ID", - 1 ) ) ), 10 ), 10 ) AS "Barcode_EAN13_ID" FROM "Media" AS "a" ORDER BY "ID"' > >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Statement.cxx:122: isc_dsql_execute failed >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: >*unsuccessful metadata update >*CREATE VIEW View_MediaID_Title_Author failed >*Dynamic SQL Error >*SQL error code = -804 >*Function unknown >*IFNULL >caused by >'CREATE VIEW "View_MediaID_Title_Author" ("ID_Title_Author","ID") AS SELECT "Media"."ID" || ' - ' || "Media"."Title" || ' - by ' || IFNULL( "Author"."LastName", '?' ) || IFNULL( ', ' || "Author"."FirstName", '' ) AS "ID_Title_Author", "Media"."ID" FROM "Media" LEFT JOIN ( SELECT "Media_ID", MIN( "Author_ID" ) AS "Author_ID_Min" FROM "rel_Media_Author" WHERE "Author_Sort" < 2 GROUP BY "Media_ID" ) AS "Media_MainAuthor" ON "Media"."ID" = "Media_MainAuthor"."Media_ID" LEFT JOIN "Author" ON "Media_MainAuthor"."Author_ID_Min" = "Author"."ID" ORDER BY "Title" ASC' > >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: >*Dynamic SQL Error >*SQL error code = -104 >*Token unknown - line 1, column 388 >*LIMIT >caused by >'isc_dsql_prepare' > >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Statement.cxx:122: isc_dsql_execute failed >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: >*unsuccessful metadata update >*CREATE VIEW View_Media_complete failed >*Dynamic SQL Error >*SQL error code = -804 >*Function unknown >*IFNULL >caused by >'CREATE VIEW "View_Media_complete" ("ID","Title","No","Subtitle","Length","Edition","Pub_Year","Comment","Price","Mediastyle","Loantime","Category","Description","Author_Sort","Author","Author_Add","Town","Publisher") AS SELECT "Media"."ID", "Media"."Title", "Subtitle"."No", "Subtitle"."Subtitle", "Subtitle"."Length", "Media"."Edition", "Media"."Pub_Year", "Media"."Comment", "Media"."Price", "Mediastyle"."Mediastyle", "Mediastyle"."Loantime", "Category"."Category", "Category"."Description", "rel_Media_Author"."Author_Sort", "Author"."LastName" || IFNULL( ', ' || "Author"."FirstName", '' ) AS "Author", "Author_Add"."Author_Add", "Town"."Town", "Publisher"."Publisher" FROM "Media" LEFT JOIN "Subtitle" ON "Media"."ID" = "Subtitle"."Media_ID" LEFT JOIN "Category" ON "Media"."Category_ID" = "Category"."ID" LEFT JOIN "Mediastyle" ON "Media"."Mediastyle_ID" = "Mediastyle"."ID" LEFT JOIN "Town" ON "Media"."Town_ID" = "Town"."ID" LEFT JOIN "rel_Media_Author" ON "rel_Media_Author"."Media_ID" = "Media"."ID" LEFT JOIN "Author_Add" ON "rel_Media_Author"."Author_Add_ID" = "Author_Add"."ID" LEFT JOIN "Author" ON "rel_Media_Author"."Author_ID" = "Author"."ID" LEFT JOIN "Publisher" ON "Media"."Publisher_ID" = "Publisher"."ID"' > >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Statement.cxx:122: isc_dsql_execute failed >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: >*unsuccessful metadata update >*CREATE VIEW View_Media_Search_Result failed >*Dynamic SQL Error >*SQL error code = -204 >*Table unknown >*View_Media_complete >caused by >'CREATE VIEW "View_Media_Search_Result" ("ID","Title") AS SELECT DISTINCT "ID", "Title" FROM "View_Media_complete" WHERE UCASE( "Title" ) LIKE IFNULL( ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ), UCASE( "Title" ) ) OR UCASE( "Subtitle" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Edition" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Comment" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Mediastyle" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Category" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Description" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Author" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Author_Add" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Town" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" ) OR UCASE( "Publisher" ) LIKE ( SELECT '%' || UCASE( "SearchItem" ) || '%' FROM "Search" )' > >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: >*Dynamic SQL Error >*SQL error code = -104 >*Token unknown - line 1, column 144 >*CHAR >caused by >'isc_dsql_prepare' > >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: >*Dynamic SQL Error >*SQL error code = -104 >*Token unknown - line 1, column 316 >*, >caused by >'isc_dsql_prepare' > >warn:connectivity.firebird:6802:6802:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: >*Dynamic SQL Error >*SQL error code = -104 >*Token unknown - line 1, column 490 >*'dd' >caused by >'isc_dsql_prepare' >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 120576
: 145703 |
145704