Found another SQL error with Postresql.

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "cplus_uc_affiliate2_commission" LINE 1: INSERT cplus_uc_affiliate2_commission (order_id, aid, commis... ^ in /var/www/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: INSERT cplus_uc_affiliate2_commission (order_id, aid, commission, commission_notes) VALUES (10, 6, 4.975, 'Level 1 commission of 50% recorded for affiliate uid:6') in /var/www/drupal/sites/all/modules/uc_affiliate2/uc_affiliate2.module on line 1432.

This is similar to syntax errors already found and fixed.

The query that fails is:
db_query("INSERT {uc_affiliate2_commission} (order_id, aid, commission, commission_notes) VALUES (%d, %d, %f, '%s')", $order->order_id, $aff, $comm, $note);

It should be changed to:db_query("INSERT INTO {uc_affiliate2_commission} (order_id, aid, commission, commission_notes) VALUES (%d, %d, %f, '%s')", $order->order_id, $aff, $comm, $note);

Comments

bojanz’s picture

Status: Active » Fixed

Thanks, fixed in CVS. The next release will be nice ;)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.