Forum OpenACS Development: XoWiki: ERROR: row "p_new" has no field "page_order"

Request notifications

Hi (Gustaf...)!

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''

Cheers,

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';
   "
Collapse
Posted by Victor Guerra on
Dear Frank,

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?

Best,

Collapse
Posted by Frank Bergmann on
Hi Victor,

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.

Cheers,
Frank