Installing from mysource_3-22-2.tar.gz
Host system SunOS 5.10 Generic sun4u sparc SUNW,Sun-Fire-V240
PHP 5.3.0, Postgresql 8.4.0, Apache 2.2.11 (but we haven’t got to that stage yet)
Using instructions at http://matrix.squiz.net/resources/installation, http://matrix.squiz.net/resources/installation and http://matrix.squiz.net/resources/installation
Installing from command line, install/step_01.php and install/step_02.php reported no errors and postgresql database for Matrix is setup apparently OK.
Precursor to install/step_03.php, install/compile_locale.php, reported no errors.
install/step_03.php fails with PHP error but nothing obviously wrong, to my untutored eye, in the .inc files associated with the failure.
PHP is not my forte (yet) so any ideas as to cause? Any advice much appreciated.
Edited output from install/step_03.php script to terminal reads as follows (full terminal transcripts for all operations available if needed):
[www-ftel-2!/misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix]:php install/step_03.php /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix
PHP Deprecated: Assigning the return value of new by reference is deprecated in /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/install/step_03.php on line 79
Deprecated: Assigning the return value of new by reference is deprecated in /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/install/step_03.php on line 79
PHP Deprecated: Function set_magic_quotes_runtime() is deprecated in /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/include/init.inc on line 30
Deprecated: Function set_magic_quotes_runtime() is deprecated in /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/include/init.inc on line 30
Generating install key…
----------------------------------
snip
----------------------------------
Your system’s install key is [ snip ]
----------------------------------
<?php
define(‘SQ_CONF_PEAR_PATH’, SQ_SYSTEM_ROOT.’/php_includes’);
$inc_dir = ini_get(‘include_path’);
$inc_dir = (substr($inc_dir, 0, 2) == ‘.:’) ? ‘.:’.SQ_CONF_PEAR_PATH.’:’.substr($inc_dir, 2) : SQ_CONF_PEAR_PATH.’:’.$inc_dir;
ini_set(‘include_path’, $inc_dir);
big snip
define(‘SQ_SSLA_HEADER_VALUE’, ‘’);
define(‘SQ_SSLA_FORCE_SECURE’, false);
?>
----------------------------------
------------------------------------
Installing Package_Manager_Core:
------------------------------------
0 => metadata_field
1 => metadata_field_wysiwyg
2 => metadata_field_hierarchy
big snip
267 => log_report
268 => design_area_menu_recursive
269 => design_area_menu_stalks
270 => thumbnail
Fatal error: Call to undefined method Trigger_Action_Set_Design_Parse_File_Edit_Fns::Trigger_Action_Edit_Fns() in /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/assets/system/triggers/trigger_action_types/trigger_action_set_design_parse_file/trigger_action_set_design_parse_file_edit_fns.inc on line 40
[www-ftel-2!/misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix]:
Matrix has not been tested with 5.3 yet (we still need to support 5.1). If you can downgrade to a 5.2 version, you shouldn't get any errors.
Can you suggest a dot release of 5.2 or 5.1 that will definitely work.
I have just clean installed PHP 5.2.10 from source and, after dealing with its own quirks (described at: http://www.pear-forum.org/topic2301.html), I get the response below from running Matrix’ install/step_03.php after the necessary precursors apparently ran successfully.
I guess I will now have to try PHP 5.2.9 with some trepdiation as www.php.net lists it and prior PHP 5 releases as being unsupported.
[www-ftel-2!/misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix]:php install/step_03.php /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix
Generating install key…
----------------------------------
big snip
260 => cron_job_metadata_triggers
±-----------------------------------------------------------------------------------------------------------------------+
| MySource Notice |
|------------------------------------------------------------------------------------------------------------------------|
| 2008-01-01 00:00:00 is not a valid date/time. The field value has been adjusted to the closest valid value. [SYS0311] |
±-----------------------------------------------------------------------------------------------------------------------+
261 => cron_job_future_permission
262 => cron_job_expired_workflow
263 => web_folder
264 => web_folder_users
265 => web_folder_designs
266 => web_folder_media
267 => log_report
268 => design_area_menu_recursive
269 => design_area_menu_stalks
270 => thumbnail
Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[22008]: Datetime field overflow: 7 ERROR: date/time field value out of range: “0000-07-30 13:45:23”’ in /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/lib/DAL/DAL.inc:611
Stack trace:
#0 /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/lib/DAL/DAL.inc(611): PDOStatement->execute()
#1 /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/include/internal_message.inc(299): DAL::execPdoQuery(Object(PDOStatement))
#2 /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/include/asset.inc(337): Internal_Message->send()
#3 /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/assets/system/root_folder/root_folder.inc(69): Asset->create(Array)
#4 /misc/WWW/apache-2/apache-2.2.11/server-specific/www-fte in /misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix/core/lib/DAL/DAL.inc on line 611
[www-ftel-2!/misc/WWW/apache-2/apache-2.2.11/server-specific/www-ftel-2.ftel.co.uk-80/php-apps/mysource_matrix]
I don't think your new issue is PHP related, but I have not seen it before. Maybe someone else has.
contrary to expectations, and having clean installed PHP 5.2.9 from source and going through the whole Matrix installation process from the start with it, the Matrix install/step_03.php script ran without complaint .
There are still other problems to be resolved but the first hurdle seems to have been passed and this appeal for help is closed as far as I am concerned.
In summary the following installed: mysource_3-22-2.tar.gz on PHP 5.2.9, Postgresql 8.4.0, Apache 2.2.11 on SunOS 5.10 Generic sun4u sparc SUNW,Sun-Fire-V240
But the above recipe failed if PHP 5.2.10 or PHP 5.3.0 was substituted for PHP 5.2.9