So to preface things, I'm trying to get the latest version of these scripts to run in PostgreSQL, and after patching up a few PostgreSQL compatibility issues, I'm running into this error when trying to place an order for a membership (PayPal in PayPal sandbox mode, if it matters?):
- warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "full_name" violates not-null constraint in /home/rewards/public_html/dev2/includes/database.pgsql.inc on line 139.
- user warning: query: INSERT INTO ms_orders (uid, status, order_type, gateway, amount, currency, secured, recurring_schedule, data, created, modified) VALUES (3, 'checkout', 'recurring', '', '0', 'USD', 1, 'a:0:{}', 'a:0:{}', 1273371785, 1273371785) in /home/rewards/public_html/dev2/sites/default/modules/moneyscripts/ms_core/ms_core.module on line 1726.
And looking at line 1726 of ms_code.module ... it does indeed appear that it is trying to insert an order without the full_name field, which is marked as NON NULL in the database schema... thus not being permitted...
Changing this field to accept null values fixes the immediate problem of the modules simply not working and allows me to buy memberships on my test site...
I think I'm still running into some lingering issues with this however... all sorts of fun database errors from Anonymous that I'm still going through...
I'm guessing perhaps MySQL doesn't abort so forcibly on this? thus letting the subsequently invoked hooks fix the problem?
This problem occurred when I upgraded from v6.x.6.4. A user gets it when he tries to purchase, but I can add a user from the "Membership Plans Manager". I think it's a gateway issue.