[support] discounts and SQL error (a lot)

[Joel Willers]

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 at drupal.org [mailto:support-bounces at 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 ...

-- 
Regards,
 Luc
_________________________

http://www.dzinelabs.com

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

-- 
[ Drupal support list | http://lists.drupal.org/ ]