Changes between Initial Version and Version 1 of Ticket #11484, comment 13
- Timestamp:
- Jan 7, 2014, 11:54:32 PM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #11484, comment 13
initial v1 15 15 16 16 ''Trac detected an internal error: 17 {{{ 17 18 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 'restrict\n FROM\n smp_project' at line 2")'' 19 }}} 18 20 19 21 Error caused by mysql call in build 13548 of SimpleMultiProject … … 24 26 25 27 ''Trac detected an internal error: 28 {{{ 26 29 OperationalError: (1054, "Unknown column 'restrict' in 'field list'")'' 30 }}} 27 31 28 32 Edit trac.db via MySQL Workbench … … 31 35 32 36 ''Shell: 37 {{{#!sh 33 38 host@comp:/var/lib/trac/x$ trac-admin /var/lib/trac/x/ upgrade 34 39 Upgrading SimpleMultiProject database schema 35 40 SimpleMultiProject database schema version is 4, should be 5 36 41 OperationalError: (1060, "Duplicate column name 'closed'")'' 42 }}} 37 43 38 44 Edit trac.db via MySQL Workbench 39 45 Table-SMP_Project -> Remove "Closed" Column 40 Reinstall SMP by Shell -> trac-admin /trac-instance/ upgrade46 Reinstall SMP by Shell -> `trac-admin /trac-instance/ upgrade` 41 47 42 48 = Good To Go! … … 44 50 Thanks for the help! 45 51 JR 46 47 48 49 50