Forum OpenACS Development: Re: ]project-open[ V4.0 on OpenACS 5.6: OpenACS Upgrade Issues

]po[ V4.0 has just come out in it's first "dev-1" version with OpenACS 5.6.0 as a base.

I'm now running ]po[ on a PG 8.4 database since a few days for personal development. I've fixed a number of queries particularly in the time sheet system (parts still unchanged since ACS 3.4...), but everything else seems to work.

You'd need to pull the code from CVS though, because we haven't yet released an "update installer" for the current version. The current HEAD is very stable already, we're using it with a major European bank and a few other customers in production...

Cheers,
Frank

same errors

They are fixed in CVS "HEAD". Please see the instructions on whttp://www.project-open.org/documentation/developers_cvs_checkout. HEAD is pretty stable now, so there is little risk for you.

HUGE issue

Not with ]project-open[ (I believe...). We don't use the permission system in the same way as dotLrn. Permission in ]po[ are mostly _calculated_ at runtime. We use OpenACS permissions just for storing basic configuration information. My development server has only 2700 entries in acs_permissions. Having said all this: We don't have many customers in production yet on 8.4., so there may still be some surprises.

PostgreSQL 9

That will also be a major issue for us, going through several thousand SQL queries... A nightmare. I'm already thinking about a semiautomatic solution.

Cheers!
Frank

I'm sorry if I'm asking too many questions here. Please let me know if I should forward it to PO forums.

My system configuration wasn't working somehow, and now I've found the problem: the table im_dynfield_layout is empty.

I was following the isntructions trying to create Internal company and I got the following error:

Error with callback '_form_fill':

When I got to the code I saw that line 1114 in intranet-dynfield/tcl/intranet-dynfield-procs.tcl having the following operation:


db_foreach attributes $attributes_sql {

# Check if the elements as disabled in the layout page
if {$page_url_exists_p && "" == $page_url} { continue }
(...)


This query is making that object_type var is set to null value. I've dig into the SQL files and I couldn't find insert in default layouts for im_companies. Did I miss something?

I can also see this message in my /intranet-dynfield/ URL:


There are invalid DynFields in the system for the following object types.
These DynFields won't be shown.
im_company: default_bill_template_id
im_company: default_delnote_template_id
im_company: default_invoice_template_id
im_company: default_payment_days
im_company: default_payment_method_id
im_company: default_po_template_id
im_company: default_vat
im_invoice: canned_note_id
im_material: file_type_id
im_project: final_company
Please check these DynFields and make sure that every DynField has a "Pos-Y" value
by editing the DynField and specifying a value. You can use '0' as a default.


Can you give me any guidance on this?