I am installing into Plesk 7.5 on Fedora.
I have removed the open_base_dir restriction for the vhost and safe mode is off.
I have installed PL/pgSQL into the database.
I get all the way to step 14 and get the following error…
MySource Error
[ASSERT EXCEPTION] DB Error: syntax error
CREATE INDEX sq_ast_attr_val_concat ON sq_ast_attr_val ((assetid || '~' || attrid)) [nativecode=ERROR: parser: parse error at or near "(" at character 57] (LINE 263 IN [SYSTEM_ROOT]/core/lib/db_install/db_install.inc)
Any help would be greatly appreciated.
Versions of postgres less than 7.4 don't support that index. You'll have to find it in the core/db/tables.xml file and comment it out (or delete it entirely). It will be in a format similar to
[quote]<index name="concat">
<column name="(assetid || '~' || attrid)" />
</index>[/quote]
core/db/tables.xml does not exist. There is a tables.xml at core/assets/tables.xml.
I tried commenting out in this file which then produced the following error.
[ASSERT EXCEPTION] DB Error: unknown error
CREATE INDEX sq_ast_attr_val_assetid ON sq_ast_attr_val (assetid) [nativecode=ERROR: relation named "sq_ast_attr_val_assetid" already exists] (LINE 263 IN [SYSTEM_ROOT]/core/lib/db_install/db_install.inc)
Once you've commented it out, you'll have to reset your installation by dropping and recreating the database (don't forget to add PL/pgSQL!) and by erasing the file system and unpacking it again.
Ok, I have done all that and still get…
[ASSERT EXCEPTION] DB Error: unknown error
CREATE INDEX sq_ast_attr_val_assetid ON sq_ast_attr_val (assetid) [nativecode=ERROR: relation named "sq_ast_attr_val_assetid" already exists] (LINE 263 IN [SYSTEM_ROOT]/core/lib/db_install/db_install.inc)
Michael
Does anybody have a clue here, I have gone back to scratch a few times with new empty databases and still get the same thing.
With the original core/assets/tables.xml i get…
MySource Error
[ASSERT EXCEPTION] DB Error: syntax error
CREATE INDEX sq_ast_attr_val_concat ON sq_ast_attr_val ((assetid || '~' || attrid)) [nativecode=ERROR: parser: parse error at or near "(" at character 57] (LINE 263 IN [SYSTEM_ROOT]/core/lib/db_install/db_install.inc)
Then if I comment out
<index name="concat">
<column name="(assetid || '~' || attrid)" />
</index>
with a fresh copy of the matrix files, drop the database and recreate I get …
[ASSERT EXCEPTION] DB Error: unknown error
CREATE INDEX sq_ast_attr_val_assetid ON sq_ast_attr_val (assetid) [nativecode=ERROR: relation named "sq_ast_attr_val_assetid" already exists] (LINE 263 IN [SYSTEM_ROOT]/core/lib/db_install/db_install.inc)
I have not been able to try a CLI install as it is a hosted environment.
Your version of PostgreSQL doesn't support the concatenated index. You'll either need to upgrade PostgreSQL to 7.4 or higher, or change the tables.xml file in the Matrix source. There are lots of threads that cover this on the forum.
Also, if you drop the DB you need to delete the entire Matrix file structure and unpack it again – the installation creates a whole bunch of configuration files that need to be removed to install properly.
Looking at the other posts (as I should have before) I now have it working.
Thank you for your help.
No problemo. 