Unknown column 'last_modified' in 'field list' in Orbeon 4.3.1 PE

Hello,

I just wondering why i get "Unknown column 'last_modified' in 'field list'" when i use Orbeon 4.3.1 with DDL script 4.4.

When i use the 4.3 script the summary page works fine, but can not save form in database due to "Unknown column 'groupname'...

Can anyone clarify why this error appears?

Error log:

09:10:24,966 ERROR [org.orbeon.oxf.processor.sql.SQLProcessor] (http--127.0.0.1-8080-9) PreparedStatement:

                                                select
                                                    last_modified,
                                                    t.xml xml
                                                from orbeon_form_definition t
                                                    where app =  ?
                                                    and form =  ?
                                                    and last_modified = (
                                                        select max(last_modified) from orbeon_form_definition
                                                        where app =  ?
                                                        and form =  ?
                                                    )
                                                    and deleted = 'N'
                                           
09:10:24,982 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http--127.0.0.1-8080-9) error caught {controller: "oxf:/apps/fr/page-flow.xml", method: "GET", path: "/fr/service/mysql/crud/orbeon/library/form/form.xhtml"}
09:10:25,029 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http--127.0.0.1-8080-9)
+----------------------------------------------------------------------------------------------------------------------+
|An Error has Occurred                                                                                                 |
|----------------------------------------------------------------------------------------------------------------------|
|Unknown column 'last_modified' in 'field list'                                                                        |
|----------------------------------------------------------------------------------------------------------------------|
|Application Call Stack                                                                                                |
|----------------------------------------------------------------------------------------------------------------------|
|oxf:/apps/fr/persistence/mysql/crud.xpl                                           |executing XSLT transformation |    |
|oxf:/apps/fr/page-flow.xml                                                        |reading page model data output|  55|
|······················································································································|
|element=<service path="/fr/service/mysql/crud/([^/]+/[^/]+/(form/[^/]+|(data|draft)/([^/]+/[^/]+)?))" model="persisten|
|model  =persistence/mysql/crud.xpl                                                                                    |
|----------------------------------------------------------------------------------------------------------------------|
|oxf:/apps/fr/persistence/mysql/crud.xpl                                           |executing processor           | 243|
|······················································································································|
|element=<p:processor name="oxf:http-serializer">[...]</p:processor>                                                   |
|name   ={http://www.orbeon.com/oxf/processors}http-serializer                                                         |

javaudvikling wrote

I just wondering why i get "Unknown column 'last_modified' in 'field list'" when i use Orbeon 4.3.1 with DDL script 4.4.

Are you talking of the DDL linked below?

https://github.com/orbeon/orbeon-forms/blob/master/src/resources/apps/fr/persistence/relational/ddl/mysql-4_4.sql

I wouldn't recommend using this with 4.3.1, as the new form_version column added in 4.4 wasn't there in 4.3.1, and since it's a "not null" column, you'll get errors on inserts.

Have you tried just using the 4.3 DDL (linked below), without setting the oxf.fr.support-owner-group and oxf.fr.support-autosave, i.e. leaving them to their default value (which is false)?

https://github.com/orbeon/orbeon-forms/blob/master/src/resources/apps/fr/persistence/relational/ddl/mysql-4_3.sql

Alex

Hi Alex,

thanks for your answer.
I haven't changed the default value for oxf.fr.support-owner-group and oxf.fr.support-autosave.

When I use the DDL 4.3 script with 4.3.1 get following error "|Column 'username' not found." when i go to the summary page.
When i press save i get following error "|Unknown column 'groupname' in 'field list' ".

I have tried following:

1. upgradet Mysql from 4.3. to 4.4.
2. set the value to "true" for oxf.fr.support-owner-group and oxf.fr.support-autosave.

After this the summary page works fine, but when i try to save i get the following error:

09:21:14,023 ERROR [org.orbeon.oxf.processor.sql.SQLProcessor] (http--127.0.0.1-8080-4) PreparedStatement:

                                                        insert into orbeon_form_data
                                                        (
                                                            created,
                                                            last_modified_time,
                                                            last_modified_by,
                                                            app, form,
                                                            document_id,
                                                            deleted
                                                            , draft, xml, username, groupname
                                                        )
                                                        values
                                                        (
                                                             ? ,
                                                             ? ,
                                                             ? ,
                                                             ? ,
                                                             ? ,
                                                             ? ,
                                                            'N'
                                                           
                                                                , 'N'
                                                           
                                                                ,  ?
                                                                ,  ?
                                                                ,  ?
                                                        )
                                                   
09:21:14,039 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http--127.0.0.1-8080-4) error caught {controller: "oxf:/apps/fr/page-flow.xml", method: "PUT", path: "/fr/service/mysql/crud/orbeon/builder/data/d0e6587d2dcdea9c319a8da2a3d84a6677796d4e/data.xml"}
09:21:14,101 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http--127.0.0.1-8080-4)
+----------------------------------------------------------------------------------------------------------------------+
|An Error has Occurred                                                                                                 |
|----------------------------------------------------------------------------------------------------------------------|
|Field 'form_version' doesn't have a default value  


So will you recommend I use 4.2 until you release Orbeon v4.4?

Ps. I'm new to Orbeon, I got the assignment of configuring a dev Orbeon environment.


 

I'm sorry for all those issues. Then for now, I would recommend you use 4.2 or wait for 4.4, which at this point we're planning to release by the end of next week. Is this something that can work for you?

Alex

Hi Alex,

Thanks for your answer.
I can work with 4.2 and I'm look forward to work with rel. 4.4.
Right now I'm in a POC where we are learning Orbeon and testing its capabilities, because we will implement it for the biggest Danish public sector, where we have to transform over 600 pdf dokument to online forms using Orbeon.
So in that relation I will asking some questions in this forum.. or if you recommend another orbeon forum, please send me a link...

Regards
Balatharan

Hi Balatharan,

Sure, either this forum or Stack Overflow (if appropriate, tagged with "orbeon"), are good places. Looking forward to seeing you around here,

Alex