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