We have hit the same issue, whilst carrying out a backup of our live site, which we then attempted to load onto a test machine, error given:
[size="1"][/size]Fatal error: Uncaught exception 'DALException' with message 'SQLSTATE[42883]: Undefined function: 7 ERROR: function sq_get_lineage_treeids(unknown, unknown, unknown, unknown) does not exist at character 46 HINT: No function matches the given name and argument types. You might need to add explicit type casts.' in /home/websites/mysource_matrix/core/lib/DAL/DAL.inc:658 Stack trace: #0 /home/websites/mysource_matrix/core/include/asset_manager.inc(3755): DAL::executePdoAssoc(Object(PDOStatement)) #1 /home/websites/mysource_matrix/core/include/general.inc(1489): Asset_Manager->getLinkLineages(13, 5, NULL, 'name', true) #2 /home/websites/mysource_matrix/core/include/asset_edit_interface.inc(723): get_asset_tag_line(13) #3 /home/websites/mysource_matrix/core/include/asset.inc(4982): Asset_Edit_Interface->paint(Object(Inbox), Object(Backend_Outputter), false) #4 /home/websites/mysource_matrix/core/assets/users/inbox/inbox.inc(163): Asset->paintBackend(Object(Backend_Outputter)) #5 /home/websites/mysource_matrix/core/include/ass in /home/websites/mysource_matrix/core/lib/DAL/DAL.inc on line 658[size="2"][/size]
I tried to re-run step_02 but that generated the following:
php /home/websites/mysource_matrix/install/step_02.php /home/websites/mysource_matrix
----------------------------------
<?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);
define('SQ_CONF_BACKEND_SUFFIX', '_admin');
define('SQ_CONF_LIMBO_SUFFIX', '_edit');
define('SQ_CONF_LOGIN_SUFFIX', '_login');
define('SQ_CONF_NOCACHE_SUFFIX', '_nocache');
define('SQ_CONF_RECACHE_SUFFIX', '_recache');
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', 'matrix.dartford.gov.uk
matrix.twkp.co.uk
www.dartford.gov.uk
dbc.twkp.co.uk
www.gravesham.gov.uk
gbc.twkp.co.uk
www.sevenoaks.gov.uk
sdc.twkp.co.uk
www.tmbc.gov.uk
tmbc.twkp.co.uk');
define('SQ_CONF_SYSTEM_PARENT_DOMAINS', '');
define('SQ_CONF_STATIC_ROOT_URL', '');
define('SQ_CONF_WEB_PATH_SEPARATOR', '-');
define('SQ_CONF_STATIC_ROOT_HTTP', '1');
define('SQ_CONF_STATIC_ROOT_HTTPS', '0');
define('SQ_CONF_DEFAULT_EMAIL', 'its@dartford.gov.uk');
define('SQ_CONF_TECH_EMAIL', 'its@dartford.gov.u');
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_ASSET_MAP_ASSET_DISPLAY_NAME', '%asset_short_name% (%asset_assetid%)');
define('SQ_CONF_SEND_CACHEABLE_HEADER', '0');
define('SQ_CONF_SEND_LAST_MODIFIED_HEADER', '0');
define('SQ_CONF_SEND_NOT_MODIFIED_HEADER', '0');
define('SQ_CONF_SEND_NO_CACHE_HEADER', '0');
define('SQ_CONF_SEND_404_CACHEABLE_HEADER', '0');
define('SQ_CONF_USE_HTTP_X_FORWARDED_FOR', '0');
define('SQ_CONF_FORWARDED_IP_PROXY_LIST', '');
define('SQ_CONF_ERRORS_LOG_TO_SYSLOG', '0');
define('SQ_CONF_ERRORS_SYSLOG_FACILITY', 'user');
define('SQ_CONF_ERRORS_HIDE_FRONTEND', '0');
define('SQ_CONF_DEFAULT_FRONTEND_LANGUAGE', 'en');
define('SQ_CONF_DEFAULT_BACKEND_LOCALE', 'en_GB');
define('SQ_CONF_DEFAULT_CHARACTER_SET', 'utf-8');
define('SQ_CONF_USE_LANG_CHAR_MAP', '0');
define('SQ_CONF_ALLOW_IP_CHANGE', '0');
define('SQ_CONF_ALLOW_HTTP_LOGIN', '0');
define('SQ_CONF_ENABLE_HTTP_LOGIN', '0');
define('SQ_CONF_ENABLE_EXTERNAL_AUTH_SYSTEMS', '1');
define('SQ_CONF_HTTP_LOGIN_VAR', 'REMOTE_USER');
define('SQ_CONF_ACCEPT_HTTP_CREDS', '0');
define('SQ_CONF_COMMIT_BUTTON_TEXT', 'Commit');
define('SQ_CONF_CONFIRM_SAVE_CHANGES', '1');
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', '1');
ini_set('log_errors', '1');
define('SQ_CONF_LOCKING_METHOD', 'default');
define('SQ_CONF_SESSION_HANDLER', '');
define('SQ_CONF_SESSION_GC_MAXLIFETIME', 604800);
ini_set('session.gc_maxlifetime', 604800);
define('SQ_CONF_EDITING_TIME', 3600);
define('SQ_CONF_NUM_DATA_DIRS', 20);
define('SQ_CONF_FORCE_SECURE_LOGIN_URLS', '');
define('SQ_CONF_WEB_MEMORY_LIMIT', '64');
define('SQ_CONF_CRON_MEMORY_LIMIT', '64');
define('SQ_CONF_USE_DEFAULT_SESSION_SAVE_PATH', '0');
define('SQ_CONF_CUSTOM_SESSION_SAVE_PATH', '');
define('SQ_CONF_ENABLE_ROLES_PERM_SYSTEM', '0');
define('SQ_CONF_ENABLE_ROLES_WF_SYSTEM', '0');
define('SQ_CONF_ENABLE_GLOBAL_ROLES', false);
define('SQ_CONF_NO_ASSET_SELF_LINKS', '0');
define('SQ_CONF_TIMEZONE', 'Europe/London');
define('SQ_CONF_FORCE_LOWERCASE_USERNAME', false);
define('SQ_LICENCE_INSTALL_KEY', '64def3f09d04c2275b960c8bcb4fe4c9');
define('SQ_LICENCE_WARRANTY_KEY', 'NjRkZWYzMDAxNDE0dWsyMDEyMDIwMw==');
define('SQ_CONF_COOKIE_OPTION_HTTP_ONLY', false);
define('SQ_CONF_COOKIE_OPTION_SECURE', false);
?>
----------------------------------
Fatal error: Uncaught exception 'DALException' with message 'DBError!:SQLSTATE[42704]: Undefined object: 7 ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.' in /home/websites/mysource_matrix/core/lib/DAL/DAL.inc:909
Stack trace:
#0 /home/websites/mysource_matrix/core/lib/db_install/db_install.inc(837): DAL::executeSql('-- creates a fu…')
#1 /home/websites/mysource_matrix/install/step_02.php(101): install_stored_relations('functions')
#2 {main}
thrown in /home/websites/mysource_matrix/core/lib/DAL/DAL.inc on line 909
Any ideas what is going wrong here?, I don't have a copy of the source files to hand as they are on a remote site
