SimpleMultiProjectPlugin and MySQL not Working

[rauchenwald@…]

When trying:

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

[anonymous]

thanks for the report problems found. You ask excuse for not correct yet, I hope to work soon on these improvements.

regards

[falkb]

Currently, only sqlite is supported/tested. I haven't found a sufficiently good page explaining what exactly must be done for a port to MySQL. Anyway, most stuff is in model.py, patch for it is welcome.

[mig]

In MySQL the length of VARCHAR is mandatory!

In Rev. 11731 the summary-field is missing. (The following patch fixes the issue for mysql).

simplemultiproject/environmentSetup.py

@@ -16 +16 @@
 db_version = 4
 
 tables = [
-    Table('smp_project', key = 'id') [
+    Table('smp_project', key = 'id_project') [
         Column('id_project', type = 'integer', auto_increment = True),
-        Column('name',type = 'varchar'),
-        Column('description',type='varchar')
+        Column('name', type = 'varchar(255)'),
+        Column('summary', type='varchar(255)'),
+        Column('description', type='varchar(255)')
     ],
     Table('smp_milestone_project',key = 'id') [
         Column('id', type = 'integer', auto_increment = True),
-        Column('milestone',type = 'varchar'),
+        Column('milestone', type = 'varchar(255)'),
         Column('id_project',type = 'integer')
     ],
 ]
@@ -32 +33 @@
     # Added with version 2
     Table('smp_version_project',key = 'id') [
         Column('id', type = 'integer', auto_increment = True),
-        Column('version',type = 'varchar'),
+        Column('version',type = 'varchar(255)'),
         Column('id_project',type = 'integer')
 
     ],

[anonymous]

Micha, does this plugin work for you with MySQL now?

[falkb]

Thanks for the patch, though I wonder if this is still compatible with the other supported database types, like SqLite (?). And as someone already asked, is this all to get the plugin running with MySQL? I can't test it but don't want to apply blindly.

[mig]

Yes it works for me: @ mysql-5.1.62 . Trac 0.12

I haven't tested on other dbms.

Micha

[falkb]

OK, then I'm going to test the patch with my SQLite system by trial'n'error.

[falkb]

(In [11785]) Refs #9912: applied proposed patch of Micha Glave, but changed it a bit, because for compat reasons, table column 'summary' is added on upgrade from version 3 to 4. Please, test this commit and report if it still works with MySQL.

[mig]

works as expected with mysql!

trac > trac-admin . upgrade 
SimpleMultiProject database schema version: 4 initialized.
SimpleMultiProject database schema version: 0 installed.
SimpleMultiProject database schema is out of date: True
SimpleMultiProject database schema version: 4 initialized.
SimpleMultiProject database schema version: 0 installed.
SimpleMultiProject database schema is out of date: True
Upgrading SimpleMultiProject database schema
Upgrading SimpleMultiProject database schema
Upgrade done.

Micha

[falkb]

Cool, thank you!