Warning occurs when making reservation
twowheeler - July 23, 2008 - 01:03
| Project: | Reservation |
| Version: | 5.x-1.0-beta2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Trying out the module, and I get this warning.
user warning: Unknown column '$seats' in 'where clause' query: SELECT rbid FROM reservation_reserved WHERE seat in ($seats) AND vid=238 in /var/www/drupal57/includes/database.mysql.inc on line 172.
The setup at the moment is zero tables, 6 rows of chairs and 20 seats per row. This is on drupal 5.8.
#1
Maybe I can answer my own question. Looks like you need double quotes instead of single quotes around line 752. Like this:
if (!db_num_rows(db_query(
"SELECT rbid FROM {reservation_reserved} WHERE seat in ($seats) AND vid=%d",
$node->vid)
)
#2
thanks for reporting this. It's fixed in HEAD already, but I didn't make a release for it :/
Will be processed in beta3
--project followup subject--
Automatically closed -- issue fixed for two weeks with no activity.
#3
Automatically closed -- issue fixed for two weeks with no activity.