Posted by mfb on November 26, 2005 at 11:03pm
Jump to:
| Project: | Subscription |
| Version: | master |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
The subscription_subscriptions table has a column `condition`, which is now a reserved word in MySQL 5.0. This patch adds the necessary backticks.
Otherwise you will have an error when loading the schema, or if it is already loaded, errors like:
user error: 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 'condition' at line 1
query: SELECT s.*,c.name,c.id FROM subscription_subscriptions s LEFT JOIN subscription_channels c ON s.cid=c.cid WHERE c.daily=0 ORDER BY uid, cid, object, condition in /civicspace/includes/database.mysql.inc on line 66.
| Attachment | Size |
|---|---|
| subscription_1.patch | 3.95 KB |
Comments
#1
I think someone needs to confirm the backticks don't mess up pgsql before this gets committed.
#2
The CVC module for 4.7 as of 4/4/06 still contains this error. When running under sql 5.0.x we get the error:
ERROR 1064 (42000) at line 28: 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 'condition text NOT NULL,
Do you have an updated patch for the 4.7 - 4/4/06 version of the module?
#3
Try the latest CVS. It might take 12 hours or so for the tarball package to update, though. I don't know if this module is still maintained or not to know if I should tag it for the DRUPAL-4-7 branch or not.
#4
Updated CVS works. Module running on MySQL 5.0.18. Drupal 4.7 RC2. Thx - James
#5
this has been committed to head - marking fixed.
#6