Changes between Initial Version and Version 1 of Ticket #9912


Ignore:
Timestamp:
Mar 20, 2012, 5:21:38 AM (13 years ago)
Author:
Ryan J Ollos
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #9912 – Description

    initial v1  
    1 Wenn tryin
     1When trying:
     2{{{
     3trac-admin /path/to/env upgrade
     4}}}
    25
    3 trac-admin /path/to/env upgrade
     6the same "Error" occurs like in ticket http://trac-hacks.org/ticket/9729
    47
    5 the same "Error" occours like in ticket http://trac-hacks.org/ticket/9729
    6 
     8{{{
    79SimpleMultiProject database schema version: 1 initialized.
    810SimpleMultiProject database schema is out of date: False
    911Database is up to date, no upgrade necessary.
     12}}}
    1013
    11 Tryin to add the required tables with the attached file (http://trac-hacks.org/attachment/ticket/9729/load_db.sql) failes cause MySQL uses other synthax.
     14Trying to add the required tables with the attached file (http://trac-hacks.org/attachment/ticket/9729/load_db.sql) fails cause MySQL uses other syntax.
    1215
    13 Whenn adding tables manually using:
     16When adding tables manually using:
    1417
     18{{{
    1519CREATE TABLE `smp_project` (
    1620        `id_project` INT(64) NOT NULL,
    … …  
    3034COLLATE='utf8_bin'
    3135ENGINE=MyISAM;
     36}}}
    3237
    3338the option "projects" is visible in Admin section of trac, but when tryin to add the second project a error occurs, so using the following code via phpMyAdmin
    3439
     40{{{
    3541ALTER TABLE `smp_project`
    3642        CHANGE COLUMN `id_project` `id_project` INT(64) NOT NULL AUTO_INCREMENT FIRST;
     43}}}
    3744
    3845now adding projects works fine BUT -> after logout the "admin" button is still visible to anonymous and shows the project settings.