JOD Posted August 17, 2016 Share Posted August 17, 2016 I've just received a customer order and the Customer Details are blank but he Shipping and Billing Addresses have been populated. The customer paid via SagePay but had an existing account that had been set up when using Checkout with Amazon Inline I've looked at some other customer accounts that previously ordered using Amazon and they also seem corrupted. When I browse the database using PhpMyAdmin the tables look fine, but if I try to display from the OSC Customer panel they won't display, if I edit all their fields are blank I recently upgraded from OSC 2.2 to OSC 2.3.4 Responsive and Amazon Inline is no longer available I am running on my own Ubuntu server on PHP and MySQL 5.5 Is there anything odd about the way customer accounts were created by Amazon Inline? Link to comment Share on other sites More sharing options...
JOD Posted August 18, 2016 Author Share Posted August 18, 2016 I've just had another order with same issue. In the Order Table the customers_address_format_id is set to 0 for both orders. Any ideas would be greatly appreciated .... Link to comment Share on other sites More sharing options...
JOD Posted August 18, 2016 Author Share Posted August 18, 2016 The second order paid using PayPal Express and account was originally created for order paid for by SagePay, so the Amazon link may be a Red Herring ... Link to comment Share on other sites More sharing options...
JOD Posted August 18, 2016 Author Share Posted August 18, 2016 I found these errors in one of my apache logs, which look like they are thrown when I try to display the customer record: [Thu Aug 18 13:27:12.596348 2016] [:error] [pid 11816] [client 192.168.0.243:62128] FastCGI: server "/usr/lib/cgi-bin/php5-fcgi-ftpjhb" stderr: PHP message: PHP Warning: array_merge(): Argument #1 is not an array in /catalog_path/Admin/customers.php on line 706, referer: https://julianhainesbowls.uk/shop/Admin/customers.php?search=maria&page=1&cID=12897[Thu Aug 18 13:27:12.596670 2016] [:error] [pid 11816] [client 192.168.0.243:62128] FastCGI: server "/usr/lib/cgi-bin/php5-fcgi-ftpjhb" stderr: PHP message: PHP Warning: array_merge(): Argument #2 is not an array in /catalog_path/Admin/customers.php on line 708, referer: https://julianhainesbowls.uk/shop/Admin/customers.php?search=maria&page=1&cID=12897[Thu Aug 18 13:27:12.596732 2016] [:error] [pid 11816] [client 192.168.0.243:62128] FastCGI: server "/usr/lib/cgi-bin/php5-fcgi-ftpjhb" stderr: PHP message: PHP Warning: reset() expects parameter 1 to be array, null given in /catalog_path/Admin/includes/classes/object_info.php on line 17, referer: https://julianhainesbowls.uk/shop/Admin/customers.php?search=maria&page=1&cID=12897[Thu Aug 18 13:27:12.596825 2016] [:error] [pid 11816] [client 192.168.0.243:62128] FastCGI: server "/usr/lib/cgi-bin/php5-fcgi-ftpjhb" stderr: PHP message: PHP Warning: Variable passed to each() is not an array or object in /catalog_path/Admin/includes/classes/object_info.php on line 18, referer: https://julianhainesbowls.uk/shop/Admin/customers.php?search=maria&page=1&cID=12897 Link to comment Share on other sites More sharing options...
burt Posted August 18, 2016 Share Posted August 18, 2016 This means that data is missing for the Customer from either the customers table or the customers_info table. Any customer must have data in both, as the c.customers_id <=> ci.customers_info_id is the link. So it might be that there is a mismatch on customers_id (unlikely) or it might be that data is missing from one or the other table (likely). Have a look in phpmyadmin at both table for one of these problematic customers and see (or not) what data you have... Link to comment Share on other sites More sharing options...
JOD Posted August 18, 2016 Author Share Posted August 18, 2016 Thanks a million burt I assume that customers_default_address_id in the customer table should map to a valid address_book_id in the address_book table and it looks like herein lies the problem o:) Link to comment Share on other sites More sharing options...
burt Posted August 18, 2016 Share Posted August 18, 2016 I had forgotten about the address_book table. That too. Link to comment Share on other sites More sharing options...
JOD Posted August 18, 2016 Author Share Posted August 18, 2016 I had forgotten about the address_book table. That too. Unfortunately so had I, when I tried to be clever with my upgrade .... :blush: Appreciate your help :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.