Step2 - DB or PEAR issues?

mthaddon · June 14, 2006, 4:01pm

I'm getting the following error at step 2.

±-----------------------------------------------------------------------------------------------------------------+

| MySource Error |

|------------------------------------------------------------------------------------------------------------------|

| Error occurred [SYS0270] |

| Array |

| ( |

| [0] => DB Error: no such table |

| SELECT type_code, version, name, instantiable, allowed_access, parent_type, dir, customisation, description, lvl |

| FROM sq_ast_typ [nativecode=ERROR: relation "sq_ast_typ" does not exist] |

| [1] => 151 |

| [2] => [SYSTEM_ROOT]/core/include/asset_manager.inc |

| ) |

| |

±-----------------------------------------------------------------------------------------------------------------+

From what I can see on other posts, this could be related to PEAR (although the error message itself looks like a database error). I've verified PostgreSQL connection parameters

I've made sure I have all the PEAR modules installed as per the requirements, so hopefully it's not that that's holding me up. I should mention that I am using Ubuntu Breezy, which had php5 installed, so I had to change my /etc/alternatives/php to point to php4 (this got rid of a bunch of other errors I was getting). So, I'm sure I'm using php4, but I'm not sure how I confirm that my php4 install is pulling the correct PEAR modules.

Any help appreciated.

Thanks, Tom

Marc_Mcintyre · June 14, 2006, 10:51pm

I'm pretty sure that step 02 does not perform any SELECT queries. It just installs relations. Are you sure that you are not running step 03 ?

mthaddon · June 15, 2006, 8:07am

[quote]I’m pretty sure that step 02 does not perform any SELECT queries. It just installs relations. Are you sure that you are not running step 03 ?
[right][post=“10456”]<{POST_SNAPBACK}>[/post][/right][/quote]

Pretty sure, yep:

mthaddon@ubuntu:~/projects/squiz/mysource_matrix$ php install/step_02.php .

±-----------------------------------------------------------------------------------------------------------------+

| MySource Error |

|------------------------------------------------------------------------------------------------------------------|

| Error occurred [SYS0270] |

| Array |

| ( |

| [0] => DB Error: no such table |

| SELECT type_code, version, name, instantiable, allowed_access, parent_type, dir, customisation, description, lvl |

| FROM sq_ast_typ [nativecode=ERROR: relation “sq_ast_typ” does not exist] |

| [1] => 151 |

| [2] => /home/mthaddon/projects/squiz/mysource_matrix/core/include/asset_manager[SYSTEM_ROOT]inc |

| ) |

| |

±-----------------------------------------------------------------------------------------------------------------+

gsherwood · June 15, 2006, 10:29pm

Did you try installing before and have it fail on you? Matrix may think it is installed and is trying to upgrade itself rather than do the initial table install.

Try deleting the installation and starting again so we can be sure we are looking at the first installation error.

mthaddon · June 20, 2006, 9:26am

[quote]Did you try installing before and have it fail on you? Matrix may think it is installed and is trying to upgrade itself rather than do the initial table install.

Try deleting the installation and starting again so we can be sure we are looking at the first installation error.

[right][post=“10497”]<{POST_SNAPBACK}>[/post][/right][/quote]

Deleted and reinstalled, and all seems fine. I seem to be missing the icons in the admin screen under asset types, but hopefully I can figure that out soon enough…

Avi_Miller · June 20, 2006, 8:53pm

[quote]Deleted and reinstalled, and all seems fine. I seem to be missing the icons in the admin screen under asset types, but hopefully I can figure that out soon enough…
[right][post=“10585”]<{POST_SNAPBACK}>[/post][/right][/quote]

Usually this means the System Root URL and the URL you’re actually using to access the Administration Interface are wrong. Or the “__lib” or “__data” aliases in Apache are wrong. Can you post your main.inc file and httpd.conf VirtualHost block for Matrix?

mthaddon · June 21, 2006, 8:29am

[quote]Usually this means the System Root URL and the URL you’re actually using to access the Administration Interface are wrong. Or the “__lib” or “__data” aliases in Apache are wrong. Can you post your main.inc file and httpd.conf VirtualHost block for Matrix?
[right][post=“10591”]<{POST_SNAPBACK}>[/post][/right][/quote]

main.inc:

<?php

define(‘SQ_CONF_DB_DSN’, ‘pgsql://matrix@localhost/mysource_matrix’);

define(‘SQ_CONF_DB2_DSN’, ‘pgsql://matrix@localhost/mysource_matrix’);

define(‘SQ_CONF_DB3_DSN’, ‘pgsql://matrix_secondary@localhost/mysource_matrix’);

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);

define(‘SQ_CONF_BACKEND_SUFFIX’, ‘_admin’);

define(‘SQ_CONF_LIMBO_SUFFIX’, ‘_edit’);

define(‘SQ_CONF_NOCACHE_SUFFIX’, ‘nocache’);

define(‘SQ_CONF_ASSET_TREE_BASE’, 64);

define(‘SQ_CONF_ASSET_TREE_SIZE’, 4);

define(‘SQ_CONF_ASSET_CACHE_SIZE_WEB’, -1);

define(‘SQ_CONF_ASSET_CACHE_SIZE_CLI’, -1);

define(‘SQ_CONF_ROLLBACK_ENABLED’, ‘0’);

define(‘SQ_CONF_DEBUG’, 0);

define(‘SQ_CONF_SYSTEM_NAME’, ‘The System’);

define(‘SQ_CONF_SYSTEM_OWNER’, ‘’);

define(‘SQ_CONF_SYSTEM_ROOT_URLS’, ‘squiz.example.com’);

define(‘SQ_CONF_STATIC_ROOT_URL’, ‘squiz.example.com’);

define(‘SQ_CONF_WEB_PATH_SEPARATOR’, '’);

define(‘SQ_CONF_STATIC_ROOT_HTTP’, true);

define(‘SQ_CONF_STATIC_ROOT_HTTPS’, false);

define(‘SQ_CONF_DEFAULT_EMAIL’, ‘tom.haddon@example.com’);

define(‘SQ_CONF_TECH_EMAIL’, ‘tom.haddon@example.com’);

define(‘SQ_CONF_MAX_LOGIN_ATTEMPTS’, 3);

define(‘SQ_CONF_REFRESH_INTERVAL’, 120);

define(‘SQ_CONF_LOCK_LENGTH’, 600);

define(‘SQ_CONF_ASSET_MAP_ASSET_LIMIT’, 50);

define(‘SQ_CONF_SEND_CACHEABLE_HEADER’, ‘1’);

define(‘SQ_CONF_SEND_LAST_MODIFIED_HEADER’, ‘0’);

define(‘SQ_CONF_SEND_NOT_MODIFIED_HEADER’, ‘0’);

define(‘SQ_CONF_ERRORS_HIDE_FRONTEND’, false);

define(‘SQ_CONF_DEFAULT_FRONTEND_LANGUAGE’, ‘en’);

define(‘SQ_CONF_DEFAULT_BACKEND_LOCALE’, ‘en_AU’);

define(‘SQ_CONF_DEFAULT_CHARACTER_SET’, ‘iso-8859-1’);

define(‘SQ_CONF_ALLOW_IP_CHANGE’, ‘0’);

define(‘SQ_CONF_ALLOW_HTTP_LOGIN’, ‘0’);

define(‘SQ_CONF_ACCEPT_HTTP_CREDS’, ‘0’);

define(‘SQ_CONF_COMMIT_BUTTON_TEXT’, ‘Commit’);

define(‘SQ_CONF_LOG_EXTENSION’, ‘.log’);

define(‘SQ_CONF_LOG_FILE_SYSTEM’, ‘system’);

define(‘SQ_CONF_LOG_FILE_ERROR’, ‘error’);

ini_set(‘error_log’, SQ_LOG_PATH.’/’.SQ_CONF_LOG_FILE_ERROR.SQ_CONF_LOG_EXTENSION);

define(‘SQ_CONF_LOG_ERRORS’, true);

ini_set(‘log_errors’, ‘1’);

define(‘SQ_CONF_SESSION_GC_MAXLIFETIME’, 604800);

ini_set(‘session.gc_maxlifetime’, 604800);

define(‘SQ_CONF_EDITING_TIME’, 3600);

?>

Virtual Host conf:

<VirtualHost *>

DocumentRoot /home/mthaddon/projects/squiz/mysource_matrix/core/web

ServerName squiz.example.com

<Directory “/home/mthaddon/projects/squiz/mysource_matrix”>

Options Indexes FollowSymLinks

Order deny,allow

Deny from all

</Directory>

<Directory “/home/mthaddon/projects/squiz/mysource_matrix/core/web”>

Options Indexes FollowSymLinks

Order allow,deny

Allow from all

</Directory>

<Directory “/home/mthaddon/projects/squiz/mysource_matrix/core/lib”>

Options Indexes FollowSymLinks

Order allow,deny

Allow from all

</Directory>

<Directory “/home/mthaddon/projects/squiz/mysource_matrix/data/public”>

Options Indexes FollowSymLinks

Order allow,deny

Allow from all

</Directory>

<Directory “/home/mthaddon/projects/squiz/mysource_matrix/fudge”>

Options Indexes FollowSymLinks

Order allow,deny

Allow from all

</Directory>

Alias “/__data” “/home/mthaddon/projects/squiz/mysource_matrix/data/public”

Alias “/__lib” “/home/mthaddon/projects/squiz/mysource_matrix/core/lib”

Alias “/__fudge” “/home/mthaddon/projects/squiz/mysource_matrix/fudge”

Alias “/” “/home/mthaddon/projects/squiz/mysource_matrix/core/web/index.php/”

</VirtualHost>

Also, one other issue I’m having is that when I try to assign a design to a site I lock the site, and then hit “change” on the “System Defined Frontend Design” section, and I think it’s then meant to allow me to select something and/or flash red? This doesn’t happen.

Thanks, Tom

Thanks, Tom

Avi_Miller · June 21, 2006, 9:36am

[quote]define(‘SQ_CONF_STATIC_ROOT_URL’, ‘squiz.example.com’);
[right][post=“10618”]<{POST_SNAPBACK}>[/post][/right][/quote]

You need to remove the “squiz.example.com” here – you’re not using a seperate static webserver, so this is not necessary. I suspect its causing a lot of your problems, as Matrix is unable to find the images and javascript required for some of its functionality.

mthaddon · June 21, 2006, 10:34am

[quote]You need to remove the “squiz.example.com” here – you’re not using a seperate static webserver, so this is not necessary. I suspect its causing a lot of your problems, as Matrix is unable to find the images and javascript required for some of its functionality.
[right][post=“10619”]<{POST_SNAPBACK}>[/post][/right][/quote]

Great, thanks. Works a treat.