no such function: concat

[Peter van Hoof]

I recently upgraded our trac installation from a very old version to
1.2.2 and simultaneously changed the database from mysql -> sqlite. Most
of the site works fine, but when I go to "View Tickets" -> option 3, I
get "OperationalError: no such function: concat"

http://wiki.nublado.org/report/3

Can somebody help me with this? Is it a configuration problem?

[Ryan Ollos]

SQL has a different dialect for each database type. Limitations of Trac reports are discussed in (1).

TracMigrate (2) helps with converting reports. However it does not appear to replacement of "concat" with SQLite concatentation operator ||. Report {3} doesn't use concat so you've modified the report. You'll need to change the report to use valid SQLite syntax (3).

- Ryan

(1) https://trac.edgewall.org/wiki/TracReports

(2) https://trac-hacks.org/wiki/TracMigratePlugin

(3) https://www.techonthenet.com/sqlite/functions/concatenate.php

[Peter van Hoof]

> TracMigrate (2) helps with converting reports. However it does not
> appear to replacement of "concat" with SQLite concatentation operator
> ||. Report {3} doesn't use concat so you've modified the report. You'll
> need to change the report to use valid SQLite syntax (3).
>
> - Ryan
>
> (1) https://trac.edgewall.org/wiki/TracReports
> (2) https://trac-hacks.org/wiki/TracMigratePlugin
> (3) https://www.techonthenet.com/sqlite/functions/concatenate.php

Thanks for your explanation! It turned out there was exactly one place
in the database where concat() was used, so I fixed it by hand. Now the
database seems to be working fine. Now let's hope I will not run into
similar problems with other dialect incompatibilities...