user warning: You have an error in your SQL syntax
looseSpark - September 8, 2008 - 15:53
| Project: | Ubercart Manufacturers |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
I added the uc_manufacturers module to an existing installation of Drupal 5.9 + Ubercart 1.0 and have since started getting the following MySql warnings on several pages:
user warning: You have an error in your SQL syntax near 'ON m.tid = t.tid WHERE m.tid = 37' at line 1 query: SELECT m.*, t.* FROM drp5_uc_manufacturers m JOIN drp5_term_data t ON m.tid = t.tid WHERE m.tid = 37 in /public_html/test/drupal-5.9/includes/database.mysql.inc on line 172.This particular warning comes on the product node (view and edit) and on the manufacturer settings page. It goes away when I deactivate the uc_manufacturers module.
I am using Linux/Apache, PHP Version 4.3.10, MySQL 3.23.56.
Thanks for the help.