On Fri, Mar 8, 2024 at 3:08 AM RjOllos <rjol...@gmail.com> 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 <muffe...@gmail.com> 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 <jun6...@gmail.com> (大前 潤) -- 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 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
