Installation Error On Step 15

Hello.
Whrn I press NEXT i see:



MySource Error

DB Error: unknown error

CREATE TABLE sq_asset_editing_access (userid VARCHAR(140) NOT NULL DEFAULT 0,type_code VARCHAR(140),screen VARCHAR(100),section VARCHAR(100),PRIMARY KEY(userid,type_code,screen,section)) [nativecode=1171 ** All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead]





MYSQL TABLE TYPE SET




I refresh the page:



DATABASE TABLE COLUMN CACHING COMPLETE



hmm… :frowning:



On Step 17 i have 3 errors:



MySource Warning

DB Error: no such table

DELETE FROM sq_asset_indexing_weightings_default WHERE type_code = 'asset' [nativecode=1146 ** Table 'matrix.sq_asset_indexing_weightings_default' doesn't exist]





MySource Warning

DB Error: no such table

INSERT INTO sq_internal_message (messageid, userto, userfrom, subject, body, type, priority, status, sent, parameters) VALUES (1, 0, 0, 'Install', 'Core Package FAILED', 'install.system', 3, 'U', '2004-07-03 20:59:05', '') [nativecode=1146 ** Table 'matrix.sq_internal_message' doesn't exist]





MySource Error

DB Error: unknown error

ROLLBACK [nativecode=1196 ** Warning: Some non-transactional changed tables couldn't be rolled back]





Help, please =))

Could you let us know what version of MySQL you're running?

:smiley:
NICE QUESTION! B)

THANKS!!!!

IT WORKS!!!

Um… what did I say?! :slight_smile:


Matrix requires InnoDB support, so I'm guessing it was a MySQL version problem? Did you upgrade?

Yes. :smiley:
4.0.12 to 4.0.20.

Installation finished.



But now I can’t open admin page. Alias “_ADMIN” don’t work.

Root url is http://192.168.14.13 (my local server) and when I try to open

http://192.168.14.13, i have 404. :frowning:

When you go to http://192.168.14.13 do you get a MySource error about no URL being found, or do you get a 404 as well?


Also, did you use alias matches or symlinks for the install?

Yes. I got


"MySource Notice

URL "192.168.14.13" not found"




And I use aliases.

In step 5, what did you set the Site Root URL as?

Also, check the last Alias line. It should look something like this:

    Alias "/" "/path/to/matrix/core/web/index.php/"


Note the trailing / at the end of the path. :)

2 Marc Mcintyre: 192.168.14.13
2 Avi Miller: Yes, alias already with trailing space.



:unsure:


There shouldn't be a space, just a / (slash) character after index.php.

But, the curious part of this is that the _admin "alias" is in fact not an alias at all. Part of the processing of Matrix determines whether the _admin ( or _edit) modifier is in place.

Check to make sure that there is no "_admin" alias in your Apache conf. Some web hosting software may already trap this alias. In which case, you can modify [i]matrix_root/data/private/conf/main.inc[/i] and change the _admin identifier to something else which doesn't conflict with an existing alias.

[quote]Whrn I press NEXT i see:


MySource Error 

DB Error: unknown error

CREATE TABLE sq_asset_editing_access (userid VARCHAR(140) NOT NULL DEFAULT 0,type_code VARCHAR(140),screen VARCHAR(100),section VARCHAR(100),PRIMARY KEY(userid,type_code,screen,section)) [nativecode=1171 ** All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead] 





MYSQL TABLE TYPE SET
[/quote]



I had this issue too. If upgrading isn't an option you can patch mysource/core/db/tables.xml with this diff to allow you to get past this stage. Obviously this isn't an officially supported patch but the dev guys might want to check it out for compatibility with the supported db versions. We're running 3.23.58 here.


    --- /var/www/mysource_matrix_3-1-0-RC1/core/db/tables.xml       2004-06-22 09:09:14.000000000 +1000
    +++ /var/www/mysource_matrix_installer/this     2004-08-11 16:52:28.000000000 +1000
    @@ -831,7 +831,7 @@
                                    0
                                    
                            
    -                       
    +                       
                                    VARCHAR(255)
                                    
                                            VARCHAR(140)
    @@ -839,13 +839,13 @@
                                    
                                    The type code of the asset type which we are restricting access to. Set to NULL to allow access to all asset types.
                            
    -                       
    +                       
                                    VARCHAR(100)
                                    
                                    
                                    The screen we are restricting access to. Set to NULL to allow access to all screens.
                            
    -                       
    +                       
                                    VARCHAR(100)
                                    
                                    
    @@ -1152,7 +1152,7 @@
                                    
                                    ID of the asset to which this keydata applies to.
                            
    -                       
    +                       
                                    VARCHAR(255)
                                    
                                            VARCHAR(160)
    @@ -1208,7 +1208,7 @@
                                    
                                    ID of the asset to which this component-weighting applies to.
                            
    -                       
    +                       
                                    VARCHAR(255)
                                    
                                            VARCHAR(160)
    @@ -1348,4 +1348,4 @@
                            
                    
            
    -
    \ No newline at end of file
    +


Regards,
Gold