Error message while saving first reservation
dbt - November 29, 2008 - 22:59
| Project: | Reservation |
| Version: | 5.x-1.0-beta3 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
After installing and enabling the module and adding the first reservation, while trying to save, the following message appears:
user warning: Table '<dbname>.reservation' doesn't exist query: SELECT tables, chairrows, seatspertable, seatsperrow, seatsaisle, generalseats, pricegeneral, pricegenred, pricetableseats, pricetablered, pricerowseats, pricerowred, discountamt, discountnum FROM reservation WHERE vid = 32 in /var/www/vhosts/<domain>/httpdocs/includes/database.mysqli.inc on line 156.
I have installed and enabled the module using drush. After seeing this message, I have disabled and enabled the module using the Drupal interface, but that did not help.
#1
Hi,
Your problem results from the patch twowheeler provided in #335194: Patch adding a general admission seating type & pricing options.
This patch is not revised or worked in yet. If you don't need the things it introduces, remove it (You may have to reinstall the module completely as it also affects the database)
This is not a Beta3-release error.
#2
I removed the patch but still no luck:
* user warning: Table '<dbname>.reservation' doesn't exist query: INSERT INTO reservation (vid, nid, tables, chairrows, seatspertable, seatsperrow, pricenormal, pricereduced) VALUES (40, 40, 18, 0, 7, 0, 0, 0) in /var/www/vhosts/<domain>/httpdocs/includes/database.mysqli.inc on line 156.* user warning: Table '<dbname>.reservation' doesn't exist query: SELECT tables, chairrows, seatspertable, seatsperrow, pricenormal, pricereduced FROM reservation WHERE vid = 40 in /var/www/vhosts/<domain>/httpdocs/includes/database.mysqli.inc on line 156.
Any hints?
Thanks,
Dimitri
#3
it seems as if the tables are missing now completely.
please try to disable reservation, uninstall it, and re-enable it afterwards.
edit:
please also run the update.php script after installing, as it adds a state-field to the adress block. I forgot to add the filed to the install routine. It's only in the update. sorry for that.
#4
changing from active to closed, as this is by an unsupported patch.