Forum OpenACS Development: XoWiki: ERROR: row "p_new" has no field "page_order"
I'm getting the following error after installing XoWiki 0.144 on a fresh OpenACS 5.7 installation with AOLserver 4.5.1 and XoTCL-Core 0.124.
I had to patch OpenACS 5.7.0 in order to be able to install the CR:
RCS file: /home/cvsroot/acs-content-repository/sql/postgresql/content-type.sql,v retrieving revision 1.4 diff -r1.4 content-type.sql 96,98c96 < create_type__name_method, < v_temp_p, < ''f'' --- > create_type__name_method 375,382c373 < ''f'', < not v_column_exists, < null, < null, < null, < null, < null, < create_attribute__column_spec --- > ''f''
Frank--- [27/Apr/2012:17:22:30][17331.3086940864][-main-] Error: Ns_PgExec: result status: 7 message: ERROR: row "p_new" has no field "page_order" CONTEXT: compilation of PL/pgSQL function "xowiki_page_f" near line 22 SQL statement "create or replace function xowiki_page_f (p_new xowiki_pagei) returns void as ' declare v_revision_id integer; begin select content_revision__new( p_new.title, p_new.description, now(), p_new.mime_type, p_new.nls_language, case when p_new.text is null then p_new.data else p_new.text end, content_symlink__resolve(p_new.item_id), p_new.revision_id, now(), p_new.creation_user, p_new.creation_ip, p_new.object_package_id ) into v_revision_id; insert into xowiki_page ( page_id, page_order ) values (v_revision_id, p_new.page_order); return; end;' language 'plpgsql'; "
I just doubled checked installation of core packages from HEAD and 5-7 branch + xotcl friends and everything worked ok for me, I am not able to reproduce the eror you describe here :S. Strange.
Could you please tell me what version of PG are you using?
Thanks for inquiring, we're running on PG 8.4.10.
I've now downgraded to OpenACS 5.3 and copied the contents from an existing installation. Maybe I'll upgrade to OpenACS 5.7 now.
I just went through the normal installation routines as I wanted to build a fresh system for non-]po[ use.