Hi,
Lee provided me with an evaluation version of the full product. Should I just copy this over the directory structure in htdocs or is there a special installation script? I used the RC2 install script that work successfully for the basic version but it bombs out.
regards,
Ian
The install process is the same no matter how many additional modules you have. The full product is just a bunch of extra asset types and packages that need to be installed.
Where is the install script bombing out?
Hi,
I get to step 15 and then the following error appears almost immediately;
MySource Error
DB Error: unknown error
CREATE TABLE sq_asset_link_tree (treeid TEXT NOT NULL DEFAULT '',linkid INT NOT NULL,num_immediate_kids INT NOT NULL,PRIMARY KEY(treeid)) [nativecode=1170 ** BLOB column 'treeid' used in key specification without a key length]
MYSQL TABLE TYPE SET
------------------
As I mentioned, everything is set up correctly and I can reinstall the base RC2 version without problems, once the database is emptied.
Thanks,
Ian
That query is for the PostgreSQL version. The newest versions of MySource Matrix no longer support MySQL. You may have a new development version.
Can you check the core/include/version.inc file to see what version number is listed on both systems that you now have.
Hi,
The version inc file in the full version contains
<?php
define('SQ_SYSTEM_VERSION', '3.1.0 RC2');
define('SQ_SYSTEM_SHORT_NAME', 'MySource');
define('SQ_SYSTEM_LONG_NAME', 'Squiz MySource v'.SQ_SYSTEM_VERSION.' (Matrix)');
define('SQ_SYSTEM_URL', 'http://matrix.squiz.net/');
define('SQ_REQUIRED_PHP_VERSION', '4.3.0');
?>
The version.inc file in the basic version contains
<?php
define('SQ_SYSTEM_VERSION', '3.1.0 RC2 b3');
define('SQ_SYSTEM_SHORT_NAME', 'MySource');
define('SQ_SYSTEM_LONG_NAME', 'Squiz MySource v'.SQ_SYSTEM_VERSION.' (Matrix)');
define('SQ_SYSTEM_URL', 'http://matrix.squiz.net/');
define('SQ_REQUIRED_PHP_VERSION', '4.3.0');
?>
Thanks again,
Ian
Judging from the lack of a build number at the end of it (as in the 'b3' at the end of the public release version), the 'full version' you have would be a dev version which does not support MySQL.
Yep, thats correct. You'll need to switch to a PostgreSQL database to use the full version you have.
Hi,
I have postgresql 8 installed (winxp) and am getting the following message at step 11.
DB Error: extension not found when connecting to database.
Could not get database handler for dsn pgsql://superianpost:superianpost@localhost/matrixpost
I've checked in pgAdmin and I shows the database as created:
CREATE DATABASE matrixpost
WITH OWNER = superianpost
ENCODING = 'UNICODE'
TABLESPACE = pg_default;
GRANT ALL ON DATABASE matrixpost TO public;
GRANT ALL ON DATABASE matrixpost TO superianpost;
Any ideas about what's going wrong.
Thanks,
Ian
I usually get that error when postgre module in PHP either isn't installed or isn't enabled in the php.ini
You will want to check this out.
Create a phpinfo page somewhere on the server and see if there is any mention of postgres in the output (other than the configure line)
Hi,
It's not showing up in phpinfo.php.
This is in my php.ini file;
---------------------------------------
[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On
; Detect broken persistent links always with pg_pconnect(). Need a little overhead.
pgsql.auto_reset_persistent = Off
; Maximum number of persistent links. -1 means no limit.
pgsql.max_persistent = -1
; Maximum number of links (persistent+non persistent). -1 means no limit.
pgsql.max_links = -1
; Ignore PostgreSQL backends Notice message or not.
pgsql.ignore_notice = 0
; Log PostgreSQL backends Noitce message or not.
; Unless pgsql.ignore_notice=0, module cannot log notice message.
pgsql.log_notice = 0
-----------------------------------
and 'php_pgsql.dll' in there in my extensions folder.
Is there somewhere else I need to include a reference?
Thanks,
Ian
Hi,
I found the extension in my php.ini. I should look before I post.
I'll try the install again.
Cheers,
ian
Hi,
it almost worked but I received this error at the last step;
PHP Warning
update([SYSTEM_ROOT]/core\assets/metadata/metadata_fields/metadata_field_select/metadata_field_select.inc): failed to open stream: No such file or directory
Installing package_manager_core:
0 => bodycopy 1 => bodycopy_container 2 => bodycopy_div 3 => bodycopy_table 4 => bridge 5 => content_type 6 => content_type_wysiwyg 7 => design_area 8 => design_area_asset_lineage 9 => design_area_body 10 => design_area_colourise_image 11 => design_area_constant_button 12 => design_area_custom_image 13 => design_area_datetime 14 => design_area_declared_vars 15 => design_area_head 16 => design_area_linked_css 17 => design_area_login_form 18 => design_area_metadata 19 => design_area_nest_content 20 => design_area_menu_type 21 => file 22 => image 23 => pdf_file 24 => thumbnail 25 => word_doc 26 => folder 27 => layout 28 => metadata_field 29 => metadata_field_date 30 => metadata_field_select
Fatal error: update(): Failed opening required 'c:\program files\apache group\apache\htdocs\matrixpost\mysource_matrix/core\assets/metadata/metadata_fields/metadata_field_select/metadata_field_select.inc' (include_path='.;c:/program files/apache group/apache/htdocs/matrixpost/mysource_matrix/php_includes;C:\php\pear;c:/php/includes') in c:\program files\apache group\apache\htdocs\matrixpost\mysource_matrix\core\include\asset_management.inc on line 158
So close!
Ian
Quick question: Does that file (c:\program files\apache group\apache\htdocs\matrixpost\mysource_matrix/core\assets/metadata/metadata_fields/metadata_field_select/metadata_field_select.inc) exist?
Hi,
I'm not at the right pc at the moment but am keen to get this working and will let you know tomorrow.
Thanks,
Ian
Hi,
no, that file doesn't exist. Only the file;
metadata_field_select_management.inc
exists.
regards,
Ian
I'd check your download. The following files should exist in that folder:
asset.xml
edit_interface_create.xml
edit_interface_screen_details.xml
edit_interface_screens.xml
edit_interface_static_screen_settings.xml
icon.png
metadata_field_select.inc
metadata_field_select_edit_fns.inc
metadata_field_select_management.inc
Hi,
it looks like it's the known bug where "0000644" is appended to the files in question. I'll fix these up and try again.
regards,
Ian
Hi,
I got a bit further. On populating the database tables I received a dump to the browser (below). I then restarted apache to invoke the correct aliases. Unfortunately, on starting up http://localhost/_admin I get;
MySource Error
Unable to get Root Folder Asset
The Postgresql db contains 51 tables and the plpgsql language is activated for the db.
Here’s the dump from the browser which was the last thing shown during the web based installation. Thanks - Ian
----------------------------
Installing package_manager_core:
0 => bodycopy 1 => bodycopy_container 2 => bodycopy_div 3 => bodycopy_table 4 => bridge 5 => content_type 6 => content_type_wysiwyg 7 => design_area 8 => design_area_asset_lineage 9 => design_area_body 10 => design_area_colourise_image 11 => design_area_constant_button 12 => design_area_custom_image 13 => design_area_datetime 14 => design_area_declared_vars 15 => design_area_head 16 => design_area_linked_css 17 => design_area_login_form 18 => design_area_metadata 19 => design_area_nest_content 20 => design_area_menu_type 21 => file 22 => image 23 => pdf_file 24 => thumbnail 25 => word_doc 26 => folder 27 => layout 28 => metadata_field 29 => metadata_field_date 30 => metadata_field_select 31 => metadata_field_text 32 => metadata_schema 33 => metadata_section 34 => page 35 => page_standard 36 => report 37 => report_asset_counter 38 => report_incomplete_metadata 39 => site 40 => authentication 41 => authentication_folder 42 => authentication_default 43 => cache_manager 44 => cron_job 45 => cron_manager 46 => cron_job_future_lineage 47 => cron_job_future_status 48 => designs_folder 49 => layout_manager 50 => remap_manager 51 => root_folder 52 => system_management_folder 53 => trash_folder 54 => inbox 55 => user 56 => user_group 57 => workspace 58 => workflow_schema 59 => workflow_step 60 => workflow_step_condition 61 => design 62 => design_area_menu_normal 63 => design_area_menu_recursive 64 => design_area_menu_stalks 65 => design_css 66 => design_css_customisation 67 => design_customisation 68 => login_design 69 => system_user_group 70 => backend_user 71 => system_user 72 => root_user
Sounds like you’re running out of memory/time when running the final web installer step. I would recommend trying the CLI-based installer as this usually doesn’t experience the same problem. At this point, you should just run the step_03.php (as the web installer has already completed steps 1 and 2 of the CLI installer).
Is there a parameter that I can set in one of the files to overcome the timeout problem? I don't really feel comfortable doing a cli install plus I'm using windows.
Thanks,
Ian