Changes between Initial Version and Version 3 of Ticket #11461
- Timestamp:
- Dec 28, 2013, 12:11:31 AM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #11461 – Description
initial v3 1 {{{ 1 2 Trac 1.0.1 2 3 Genshi 0.7 (without speedups) … … 9 10 Subversion 1.7.4 (r1295709) 10 11 jQuery 1.7.2 12 }}} 11 13 12 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 14 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`: 15 {{{#!python 13 16 cursor.execute("""ALTER TABLE smp_project ADD restrict TEXT""") 17 }}} 14 18 15 This change appears to fix this issue. 16 19 This change appears to fix this issue. (adding backtiks to "restrict") 20 {{{#!python 17 21 cursor.execute("""ALTER TABLE smp_project ADD `restrict` TEXT""") 22 }}} 18 23 19 24 Created a new environment and ran update. It indicated success, but none of the smp_ tables in the database have data. 20 25 26 {{{#!sh 21 27 [root@fw-svn01 Testing]# trac-admin /home/trac/Testing upgrade 22 28 Upgrading SimpleMultiProject database schema … … 27 33 28 34 trac-admin /home/trac/Testing wiki upgrade 35 }}} 29 36 30 37 Additonally, there is the following error in the console. 31 38 39 {{{#!pycon 32 40 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") 33 41 … … 37 45 38 46 I've not been able to test this against MySQL, but it may be that "restrict" is a restricted word for MariaDB. 39 47 }}}