Hello brmassa! Thank you very much for your great module, it really is a life saver!
There is a bug when you update a variation:

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 'delete = 'Delete' , vid = '2' WHERE vid = 2' at line 1 query: UPDATE ec_live_variation SET name = 'Color' , description = '' , image = '' , listtype = '0' , showprice = '0' , weight = '0' , submit = 'Submit' , delete = 'Delete' , vid = '2' WHERE vid = 2 in mysite.com\includes\database.mysql.inc on line 121.

I have pinpointed the error in line 1087 of ec_live_subproducts.module
db_query("UPDATE {ec_live_variation} SET ". implode(",", $sql) ." WHERE vid = %d", $sql_args);
Unfortunately I am still learning sql...I wish I could fix it.
I am using mysql 5 and php 4, running Drupal 4.7.5 if that helps. Any help is greatly appreciated!

Comments

demetrice’s picture

demetrice commented

I'm also getting this bug and hoping you can stomp it out soon. I run php 4, mysql 4 and drupal 4.7.6. i've been following/using this module for a while, and it's great. keep it up.

baraban’s picture

baraban commented

This is an easy bug to fix, but there is another bug hiding right behind this one, which is a bit tougher...

brmassa’s picture

brmassa commented
Status: Active » Fixed

Guys,

this module for Drupal 4.7 is no longer supported, but its already fixed.

regards,

massa

killes@www.drop.org’s picture

killes@www.drop.org commented
Status: Fixed » Closed (fixed)