Attachment 145703 Details for Bug 120576 – console traces

console traces

console.txt (text/plain), 6.36 KB, created by Julien Nabet on 2018-10-14 12:39:46 UTC

(hide)

Description:

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'
>

Actions: View

Attachments on bug 120576: 145703 | 145704