On Fri, Sep 1, 2017 at 1:36 AM, Peter van Hoof <p.vanh...@oma.be> wrote:
> 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? 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 -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscr...@googlegroups.com. To post to this group, send email to trac-users@googlegroups.com. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
