On Fri, Mar 8, 2024 at 3:08 AM RjOllos <[email protected]> wrote: > > On Wednesday, March 6, 2024 at 5:48:04 AM UTC-8 Jun Omae wrote: > > On Wed, Mar 6, 2024 at 10:28 PM Andreas <[email protected]> wrote: > > I would like to backup our Trac 1.2.5 installation with the following > > command: > > > > sudo trac-admin /var/lib/trac/prod hotcopy /var/lib/trac/prod_backup > > > > > > I get the following result: > > > > Fehler: ProgrammingError: (1064, "You have an error in your SQL syntax; > > check the manual that corresponds to your MySQL server version for the > > right syntax to use near 'system WHERE name = 'trachours.db_version'' > ^^^^^^^^^ > > at line 1") > > That is an issue of TracHoursPlugin, not Trac. Please report it to > maintainers of the plugin. > > > I believe the issue may have been fixed: > https://trac-hacks.org/changeset/16795 > > So it's possible upgrading TracHours to the latest trunk version will resolve > the issue.
The issue is caused by SYSTEM became a reserved word in MySQL 8 and MariaDB 10.3. Could you please try attached patch? -- Jun Omae <[email protected]> (大前 潤) -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CAEVLMajc3h9ePn9oKsf4O5wOzgDAk-ewTtLUwvN0UBCZnN3-LQ%40mail.gmail.com.
trachoursplugin-mysql8.diff
Description: Binary data
