Changes between Initial Version and Version 3 of Ticket #11461


Ignore:
Timestamp:
Dec 28, 2013, 12:11:31 AM (10 years ago)
Author:
Ryan J Ollos
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #11461 – Description

    initial v3  
     1{{{
    12Trac    1.0.1
    23Genshi  0.7 (without speedups)
     
    910Subversion      1.7.4 (r1295709)
    1011jQuery  1.7.2
     12}}}
    1113
    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
     14After 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
    1316cursor.execute("""ALTER TABLE smp_project ADD restrict TEXT""")
     17}}}
    1418
    15 This change appears to fix this issue.  (adding backtiks to "restrict")
    16 
     19This change appears to fix this issue. (adding backtiks to "restrict")
     20{{{#!python
    1721cursor.execute("""ALTER TABLE smp_project ADD `restrict` TEXT""")
     22}}}
    1823
    1924Created a new environment and ran update.  It indicated success, but none of the smp_ tables in the database have data.
    2025
     26{{{#!sh
    2127[root@fw-svn01 Testing]# trac-admin /home/trac/Testing upgrade
    2228Upgrading SimpleMultiProject database schema
     
    2733
    2834  trac-admin /home/trac/Testing wiki upgrade
     35}}}
    2936
    3037Additonally, there is the following error in the console.
    3138
     39{{{#!pycon
    3240ProgrammingError: (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")
    3341
     
    3745
    3846I've not been able to test this against MySQL, but it may be that "restrict" is a restricted word for MariaDB.
    39 
     47}}}