Error on install / MySQL-Fehler bei beiden Versionen:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tables int(10) not null default 0, chairrows int(10) not nu query: CREATE TABLE reservation ( vid int(10) unsigned NOT NULL default '0', nid int(10) unsigned NOT NULL default '0', tables int(10) not null default 0, chairrows int(10) not null default 0, seatspertable int(10) not null default 0, seatsperrow int(10) not null default 0, pricenormal decimal(6,2) not null default '0.00', pricereduced decimal(6,2) not null default '0.00', PRIMARY KEY (vid, nid), KEY `reservation_nid` (nid) ) DEFAULT CHARACTER SET utf8 ; in /var/www/web13/html/includes/database.mysql.inc on line 172.
Comments
Comment #1
maulwuff commentedthanks for reporting.
Which mysql-version do you use? I tested the first table on MySQL - 5.0.18-nt, and it passed.
Please try, if this version runs for you. I quoted all default values.
(it's the whole reservation.install)
Comment #2
maulwuff commentedComment #3
mo6Support for mysqli en pgsql is missing in the install file. When using mysqli, the database tables are not created and the module throws an error when creating an reservation node.
Comment #4
dargrego commentedI have the same situation - using mysqli database tables are not created. I created them by hand in phpMyAdmin, I was able to create a Reservation content type but then reserving seats was impossible - next error.
Drupal 5.16, MySQL 5.0.51b, PHP 5.2.6, XAMPP on localhost
Comment #5
maulwuff commentedsorry, I've got no clue on mysqli or pgsql. Therefore it's missing. If anyone wants to provide a patch, you are welcome to do so ;)
Comment #6
maulwuff commentedComment #7
davisben