Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order Created without Customer Details


JOD

Recommended Posts

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

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

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

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...