SimpleMultiProjectPlugin and MySQL not Working
|Reported by:||rauchenwald@…||Owned by:||falkb|
Description (last modified by rjollos)
trac-admin /path/to/env upgrade
the same "Error" occurs like in ticket http://trac-hacks.org/ticket/9729
SimpleMultiProject database schema version: 1 initialized. SimpleMultiProject database schema is out of date: False Database is up to date, no upgrade necessary.
Trying 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.
When adding tables manually using:
CREATE TABLE `smp_project` ( `id_project` INT(64) NOT NULL, `name` VARCHAR(512) NOT NULL, `description` VARCHAR(2048) NOT NULL DEFAULT '', PRIMARY KEY (`id_project`) ) COLLATE='utf8_bin' ENGINE=MyISAM; CREATE TABLE `smp_milestone_project` ( `id` INT(64) NOT NULL, `milestone` VARCHAR(512) NOT NULL, `id_project` INT(64) NOT NULL, PRIMARY KEY (`id`) ) COLLATE='utf8_bin' ENGINE=MyISAM;
the 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
ALTER TABLE `smp_project` CHANGE COLUMN `id_project` `id_project` INT(64) NOT NULL AUTO_INCREMENT FIRST;
now adding projects works fine BUT -> after logout the "admin" button is still visible to anonymous and shows the project settings.
also there is no option to add/choose project when clicking on admin->milestones->edit milestone
so after all there are some things not correct when using MySQL as Database...
btw: using Trac 0.12.3 under http://trac.rc-hosting.net
Change History (11)
comment:9 Changed 17 months ago by falkb
- Owner changed from crossroad to falkb
- Status changed from new to assigned
comment:10 Changed 17 months ago by mig
- Resolution set to fixed
- Status changed from assigned to closed