Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
3 posts
|
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. |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
3 posts
|
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? |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Administrator
5128 posts
|
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
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
3 posts
|
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
|
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Administrator
5128 posts
|
OK, got it, so for now I'll close that issue.
Alex
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
Free forum by Nabble | Edit this page |