Help installing RC2 with web installer

Squiz Matrix Installation
1

Hi,


I'm trying to install MySource Matrix RC2 on RHEL3AS. I updated php to 3.4.8, and I'm using mysql 3.23.58 with INNODB tables activated. All required pear modules are installed.



I first encountered this error:


[quote]MySource Error 

File: /www/htdocs/mysource_matrix_installer/steps/databasecreate.inc Line: 344

Message: DB Error: unknown error

CREATE TABLE sq_asset_indexing (value VARCHAR(160) NOT NULL,assetid VARCHAR(15) NOT NULL,component VARCHAR(160) DEFAULT '',type VARCHAR(160) NOT NULL DEFAULT 'word',score INT UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY(value,assetid,component,type,score)) TYPE=innodb [nativecode=1171 ** All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead][/quote]



I found a few references to this error message in other topics. It was supposed to be addressed in RC2, but it seems it's still there!



I tried to edit tables.xml as was suggested in another post (http://forums.matrix.squiz.net/index.php?showtopic=24) and restarted the installation, and now I have this error:


[quote]MySource Error 

File: /www/htdocs/mysource_matrix_installer/steps/databasecreate.inc Line: 344

Message: DB Error: unknown error

CREATE TABLE sq_asset_workflow (assetid VARCHAR(140) NOT NULL,schemaid VARCHAR(15) NOT NULL DEFAULT 0,workflow LONGTEXT NOT NULL DEFAULT NULL,access CHAR(1) NOT NULL DEFAULT '0',PRIMARY KEY(assetid,schemaid)) TYPE=innodb [nativecode=1067 ** Invalid default value for 'workflow'][/quote]



Any idea what I can do at this point?



Thanks!

2

I highly recommend using PostgreSQL instead of MySQL. PostgreSQL ships as rhdb with RHEL3. MySQL v3.23 is not a supported DB platform for MySource Matrix.

3

Well, after reading the last error message more carefully, I edited again the tables.xml file, and this time, I only changed the following lines instead of changing all occurence of allow_null="1" to allow_null="0" as I did the first time, and now the installation worked great!

    --- mysource_matrix_3-1-0-RC2/core/db/tables.xml        2004-10-06 01:04:49.000000000 -0400
    +++ matrix/core/db/tables.xml   2004-10-18 16:14:39.000000000 -0400
    @@ -1177,7 +1177,7 @@
                                    
                                    ID of the asset to which this keydata applies to.
                            
    -                       
    +                       
                                    VARCHAR(255)
                                    
                                            VARCHAR(160)
    @@ -1233,7 +1233,7 @@
                                    
                                    ID of the asset to which this component-weighting applies to.
                            
    -                       
    +                       
                                    VARCHAR(255)
                                    
                                            VARCHAR(160)


Not sure what is the impact of this change but at least I can begin to test Matrix now!
:)
4

Yeah, MySQL is fine for testing Matrix, but as it doesn't yet support transactions and rollback, we don't recommend using it for a production system.