[support] discounts and SQL error (a lot)

[Luc]

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 ...

-- 
Regards,
 Luc
_________________________

http://www.dzinelabs.com

My bookmarks:
http://delicious.com/Dzinelabs