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
Comment #1
bojanz commentedThanks, fixed in CVS. The next release will be nice ;)