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.

Comments

maulwuff’s picture

maulwuff commented
Status: Active » Closed (won't fix)

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.

timidri’s picture

timidri commented
Status: Closed (won't fix) » Active

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

maulwuff’s picture

maulwuff commented

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.

maulwuff’s picture

maulwuff commented
Status: Active » Closed (fixed)

changing from active to closed, as this is by an unsupported patch.