Error text not found for this code and locale [SYS

altstudio · February 5, 2006, 10:24am

Hi,

I've been struggling through the installation of Matrix for the past couple of days due to setup incompatibilities, lack of knowledge of postgresql etc. I think I finally have all the components in place - here is the configuration:

MacOSX - 10.4.4

PostgreSQL 8.1

PHP 4.3.11

Installed packages, channel pear.php.net:

=========================================

Package Version State

Archive_Tar 1.3.1 stable

Auth 1.2.3 stable

Auth_PrefManager 1.1.4 stable

Cache 1.5.4 stable

Cache_Lite 1.6.0 stable

Console_Getopt 1.2 stable

DB 1.7.6 stable

DB_DataObject 1.8.2 stable

Date 1.4.6 stable

Event_Dispatcher 1.0.0 stable

File_Archive 1.5.3 stable

HTML_CSS 0.2.0 stable

HTML_Common 1.2.2 stable

HTML_Javascript 1.1.1 stable

HTML_Menu 2.1.1 stable

HTML_Progress 1.2.5 stable

HTML_QuickForm 3.2.5 stable

HTML_QuickForm_Controller 1.0.5 stable

HTML_QuickForm_advmultiselect 1.1.0 stable

HTML_Table 1.6.1 stable

HTML_Table_Matrix 1.0.9 stable

HTML_Template_Flexy 1.2.4 stable

HTML_Template_IT 1.1.3 stable

HTTP 1.4.0 stable

HTTP_Client 1.0.0 stable

HTTP_Download 1.1.1 stable

HTTP_Header 1.2.0 stable

HTTP_Request 1.3.0 stable

Log 1.9.3 stable

MIME_Type 1.0.0 stable

Mail 1.1.9 stable

Mail_Mime 1.3.1 stable

Mail_Queue 1.1.3 stable

Net_SMTP 1.2.7 stable

Net_Socket 1.0.6 stable

Net_URL 1.0.14 stable

Net_UserAgent_Detect 2.1.0 stable

PEAR 1.4.6 stable

PHP_Compat 1.5.0 stable

Pager 2.3.4 stable

Pager_Sliding 1.6 stable

System_Command 1.0.4 stable

XML_HTMLSax 2.1.2 stable

XML_Parser 1.2.7 stable

XML_RPC 1.4.5 stable

XML_Tree 1.1 stable

So I admit I went a little crazy with the pure joy of installing pear packages from the command line…

Now my problem lies in the fact that when executing step_02.php from the command line installer I get the following error

[quote]----------------------------------

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

| MySource Error |

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

| Error text not found for this code and locale [SYS0270] |

| array ( |

| 0 => ‘DB Error: unknown error |

| – creates a function that grants access to the secondary user. |

| – This function should be called after all the tables in the system |

| – have been created |

| CREATE OR REPLACE FUNCTION sq_grant_access(character varying) RETURNS TEXT AS \’ |

| DECLARE |

| user_name ALIAS FOR $1; |

| table RECORD; |

| tablename TEXT; |

| BEGIN |

| FOR table IN SELECT c.relname AS name FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (\’\‘r\’\’,\’\‘v\’\’,\’\‘S\’\’,\’\’\’\’) AND n.nspname NOT IN (\’\‘pg_catalog\’\’, \’\‘pg_toast\’\’) AND pg_catalog.pg_table_is_visible(c.oid) LOOP |

| tablename=table.name; |

| RAISE NOTICE \’\‘tablename is %\’\’, tablename; |

| EXECUTE \’\‘GRANT ALL ON \’\’ || quote_ident(tablename) || \’\’ TO \’\’ || quote_ident(user_name::text); |

| END LOOP; |

| RETURN \’\‘access granted.\’\’; |

| END; |

| \’ |

| LANGUAGE plpgsql; [nativecode=ERROR: |

±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+[/quote]

Now after trawling through these forums I found a reference to this error here

The suggestion is to upgrade XML_Tree to the latest version. As you can see above the version is 1.1. I notice that in your php_includes folder there is a newer version XML_Tree 1.4.10.1.

I have uninstalled the XML_Tree package via pear, hoping that this would mean the version in the installation would be used. I have tried running the installation again, but I still get the same error message.

I have tried completely deleting the matrix directory and they putting a clean version there to work with just in case the cache held some info regarding the errors (yes, grasping at straws).

Any suggestions of how I can get past this error.

Any help is appreciated.

Colin Burns

Avi_Miller · February 5, 2006, 8:36pm

You need to add the PL/pgSQL languange to your database:

$ path/to/pgsql/bin/createlang -U postgres plpgsql <db_name>

Then step_02.php will be able to create the functions properly.

altstudio · February 6, 2006, 7:13am

[quote]You need to add the PL/pgSQL languange to your database:

$ path/to/pgsql/bin/createlang -U postgres plpgsql <db_name>

Then step_02.php will be able to create the functions properly.

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

Thanks - I did think I had PL/pgSQL installed for that database, but with my knowledge of postgreSQL (which is only the last two days worth) I doubt I have any leg to stand on

Thanks for the help, I’ll update the thread if that solves the problem.

Kind Regards,

Colin

altstudio · February 6, 2006, 11:21pm

Solved the problem - thank-you