MariaDB errors initializing SMP
|Reported by:||johna||Owned by:||falkb|
Description (last modified by rjollos)
Trac 1.0.1 Genshi 0.7 (without speedups) MySQL server: "5.5.32-MariaDB", client: "5.1.54", thread-safe: 1 MySQLdb 1.2.3c1 Pygments 1.6 Python 2.6.6 (r266:84292, Nov 22 2013, 12:16:22) [GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] pytz 2013.8 setuptools 0.6 Subversion 1.7.4 (r1295709) jQuery 1.7.2
After installation of the plugin and restart of the server, the database update fails. The culprit appears to be in line 154 of environmentSetup.py:
cursor.execute("""ALTER TABLE smp_project ADD restrict TEXT""")
This change appears to fix this issue. (adding backtiks to "restrict")
cursor.execute("""ALTER TABLE smp_project ADD `restrict` TEXT""")
Created a new environment and ran update. It indicated success, but none of the smp_ tables in the database have data.
[root@fw-svn01 Testing]# trac-admin /home/trac/Testing upgrade Upgrading SimpleMultiProject database schema SimpleMultiProject database schema version is 0, should be 5 Upgrade done. You may want to upgrade the Trac documentation now by running: trac-admin /home/trac/Testing wiki upgrade
Additonally, there is the following error in the console.
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'restrict\n FROM\n smp_project' at line 2")
This shows up in: Manage Projects -> Projects and the "Timeline", "Roadmap", "View Tickets", and "New Ticket" items.
I've not been able to test this against MySQL, but it may be that "restrict" is a restricted word for MariaDB.
Change History (30)
Changed 14 months ago by anonymous
comment:28 Changed 14 months ago by falkb
- Keywords testing removed
- Resolution set to fixed
- Status changed from accepted to closed