Make sure you are using updated versions of all modules. Check the issue queue for similar reports.
After that, I would say that the module has a glitch in it. This seems like a complicated specific issue that really belongs in the issue cue. If you can find the coding error, you should apply a patch. You could also offer to pay someone to fix it (sponsoring bug fixes was a common item discussed at DrupalCon). Otherwise, you'll have to wait for the issue cue.
Sorry to be the bearer of bad news. It can be tough using open source products at times. You might have to push forward without the module.
Joel
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Luc Sent: Wednesday, May 11, 2011 7:06 PM To: Drupal support list Subject: [support] discounts and SQL error (a lot)
Good evening list,
Using drupal with ubercart i installed the "uc discounts alt" module. When i create the necessary CCK field as per instructions and save it, i get the following error:
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 ') SELECT vid, nid, 0, FROM content_type_product' at line 1 query: INSERT INTO content_field_codeless_discount (vid, nid, delta, ) SELECT vid, nid, 0, FROM content_type_product in /xxxx/xxxxx/public_html/projects/drupal/sites/all/modules/cck/includes/content.admin.inc on line 1549.
The field however gets saved and i can set the permissions for it.
I can also add a discount without any problem.
However when i create a new product i get this:
user warning: Duplicate entry '64-0' for key 1 query: INSERT INTO content_field_codeless_discount (vid, nid, delta) VALUES (64, 64, 0) in /xxx/xxxx/public_html/projects/drupal/sites/all/modules/cck/content.module on line 1213. user warning: Duplicate entry '64-0' for key 1 query: INSERT INTO content_field_discounted_price (vid, nid, delta) VALUES (64, 64, 0) in /xxxx/xxxx/public_html/projects/drupal/sites/all/modules/cck/content.module on line 1213.
Ofcourse when removing the module, i get no error for adding a new product.
I posted an issue on the modules page several days ago but it seems everybody there is asleep.
Could some nice soul explain what's happening? I'm bouncing my head against the wall ...