Forum .LRN Q&A: Problem installing dotlrn packages - Error apears when installing static portlets

Hi,

I'm not sure if the static portlets have been ported yet but during installation of the packages I get.

Request Error

	psql:static-core.sql:194: ERROR:  triggered data change 
violation on relation "acs_privilege_hierarchy_index"

    invoked from within
"db_source_sql_file -callback $callback $path/$file_path"
    (procedure "apm_package_install_data_model" line 32)
    invoked from within
"apm_package_install_data_model -callback $callback -data_model_files 
$data_model_files $spec_file_path"
    (procedure "apm_package_install" line 19)
    invoked from within
"apm_package_install -install_path $install_path  -callback 
apm_ns_write_callback -load_data_model  -data_model_files 
$data_model_files $spec_file"
    ("foreach" body line 36)
    invoked from within
"foreach pkg_info $pkg_install_list {
    set spec_file [pkg_info_spec $pkg_info]
    if { [catch {
	array set version [apm_read_package_info_file $spe..."
    ("uplevel" body line 34)

when the apm installation reaches the static portal/portlets.

Best,

I had the same problem. Regretably it breaks the whole installation. What I mean is that if you mount dotlrn in the site map, it gives you another error so I guess the static portal DM is requirement.

I believe this thread is related.

I was wondering, what version of postgres are you using. I am
currently on Postgres 7.1.3. I read somewhere, probably in this
bboard that they are using Postgres 7.2 in developing dotlrn (please
correct me if I am wrong).

I am going to try using Postgres 7.2 a little later to see if I
still get the same problems

Thanks Yon,

You are right. I just finished installing dotLrn on Postgres 7.2 without any problems.

However, I would like to further understand the nature of why it works on 7.2 and not on 7.1.3. I noticed that there are some workarounds posted somewhere in this bboard -- some of them simply suggests removing the dbtransaction {} statment on the offending code. But that did not work on all cases for me . It worked for me in the dotlrn-init.tcl but it did not work in the code to add new users where i encountered the same problem.

I hope someone will be kind enough to explain.

Thanks,