Ticket #16 (closed Defect: Will not be fixed)
Wrong column name in xcap_xml table
| Reported by: | sthijs | Owned by: | Mircea Amarascu |
|---|---|---|---|
| Priority: | Major | Milestone: | OpenXCAP 1.0 stable release |
| Component: | Interoperability | Version: | |
| Severity: | Non-critical | Keywords: | |
| Cc: |
Description
We're using openxcap (0.9.7) together with openser (1.2.0). When we installed openser the tables 'subscriber' and 'xcap_xml' were also created in the database. Except for the 'etag' column that needs to be added, there's also a difference in the column name where the xml data gets stored: openser -> xcap openxcap -> doc
We did not add the 'doc' column to the 'xcap_xml' table. This results in the following error: _mysql_exceptions.OperationalError: (1054, "Unknown column 'doc' in 'field list'")
Adding a column named 'doc' to the 'xcap_xml' table will probably solve this error, but if openser fetches the xml documents from another column this isn't the best solution. Can you fix this to also use the column 'xcap'?
