Posted by sgreimer on
URL: https://discuss.orbeon.com/Column-username-not-found-error-when-searching-or-showing-form-summary-tp4657308.html

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.