The SQL statement on line 126 in uc_directdebit has an S missing, so INSERT fails:

db_query( "INSERT INTO {uc_directdebit} (order_id, data) VALUE (%d, '%s')", $order_id, $data);

Fix is obvious, add an S to VALUE :)

Comments

NaX’s picture

NaX commented
Status: Active » Reviewed & tested by the community
TSE’s picture

TSE commented

i just installed the dev Last updated: February 25, 2011 without using the fix for line 126 (adding "s" to "value"). It works as it should, all values are stored in the db. Since your fix sounds good to me i tried it also with the fixed version and it worked also.

Now Im just wondering whats correct ;) If anybody could teach me...

NaX’s picture

NaX commented

I think it is mySQL version dependant. I think "values" is the more correct going forward and I think "value" has been deprecated but I am not sure.