Column 'username' not found error when searching or showing form summary

I have an interesting issue with my setup with MySQL using version 4.3 I can successfully create forms and save data to the tables, but when I go to the summary of published forms, the summary of a specific form or search, I get a search error. The server.log reports:

14:44:32,265 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http--127.0.0.1-8080-67) error caught {controller: "oxf:/apps/fr/page-flow.xml", method: "POST", path: "/fr/service/mysql/search/orbeon/builder"}
14:44:32,281 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http--127.0.0.1-8080-67) 
+----------------------------------------------------------------------------------------------------------------------+
|An Error has Occurred                                                                                                 |
|----------------------------------------------------------------------------------------------------------------------|
|Column 'username' not found.                                                                                          |
|----------------------------------------------------------------------------------------------------------------------|
|Application Call Stack                                                                                                |
|----------------------------------------------------------------------------------------------------------------------|
|oxf:/apps/fr/page-flow.xml                                                        |reading page view data output |  59|
|······················································································································|
|element=<service path="/fr/service/mysql/search/([^/^.]+)/([^/^.]+)" view="persistence/mysql/search.xpl"/>            |
|view   =persistence/mysql/search.xpl                                                                                  |

Each of the 4 tables does have a username column but none of the records in the definition or data tables have a username value.

I'm not sure where to go with this since the error indicates that a column is missing that is clearly in the tables. Any help would be appreciated.

Right now I'm accessing my forms directly with http://localhost:8080/orbeon/fr/orbeon/builder/summary 
I have not setup any authentication or users, is this required?

It should just work out-of-the-box. Could you try editing the log4j.xml to set the SQLProcessor in debug mode:

    <category name="org.orbeon.oxf.processor.sql.SQLProcessor">
        <priority value="debug"/>
    </category>

Then restart Tomcat, access the summary page again, and the faulty SQL should show in the orbeon.log. Could you copy-paste it here?

Alex

I got it working by downgrading to 4.2. I think I'll leave it at this version for now unless there's a big advantage to 4.3

OK, got it, so for now I'll close that issue.

Alex