Unknown column 'min_cancel_hours' in 'field list' query: error when importing
Qwert302 - April 30, 2009 - 03:15
| Project: | MERCI (Manage Equipment Reservations, Checkout and Inventory) |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | kreynen |
| Status: | closed |
Jump to:
Description
First let me say that I am a noob. I get this error when attempting to import items via the import script, and then the items appear to be imported, but then nothing shows up when I go to make a reservation (the pulldown menu just says "buckets" and nothing is selectable). I'm not sure if adding the minimum cancellation hours feature broke the whole thing, or if I just can't figure out how to use this.
Also, the import script refers to an install.txt that I can't find.
Thanks.
#1
This was my mistake. In a rush to get a new version of MERCI pushed out to CVS, I neglected to include the update to the database in the install. This has been fixed in CVS. You can either wait for a new release to get rolled or make the SQL update yourself...
ALTER TABLE merci_resource_node ADD min_cancel_hours TINYINT NOT NULL DEFAULT '0';
ALTER TABLE merci_bucket_node ADD min_cancel_hours TINYINT NOT NULL DEFAULT '0';
#2
Automatically closed -- issue fixed for 2 weeks with no activity.