Orders table not populating

[pbechard]

Hi everyone,

I'm a new member, but have been using OSCommerce for a few months now. Seems like a pretty good product.

 

I discovered a problem this week when the first couple orders finally came in. The order details are not getting entered into the Orders / Orders_products tables. I also do not received any emails telling me an order has been placed.

 

I'm using osCommerce 2.2 Milestone 2 Update 051113, with a couple contributions added on (cDynamic_Meta_Tags v1.5, MVS V1.0 - Multiple Shipping Zone). Hosted on Win2K with IIS 5, PHP 4.3.3, and MySQL 4.1.16-nt

 

Checkout system is using standard Paypal functionality as the only option. The payment goes through PayPal no problem, and currently that's the only method I am informed of a new order.

 

I am not sure where to start looking / tracking to see why the insert into the Orders tables is failing. Any suggestions about what the problem could be?

 

Thanks!

 

Peter

[davidinottawa]

I am not sure where to start looking / tracking to see why the insert into the Orders tables is failing. Any suggestions about what the problem could be?

 

did you try inserting into the db through the back end/ you can run this through phpMyAdmin;

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('980', 'jon doe', '', '1243 david cres', '', 'montreal', '90028', 'Ontario', 'CA', '514 555 3555', '[email protected]', '1', 'Jon Doe', '', '1243 david cres', '', 'montreal', '90028', 'Ontario', 'CA', '1', 'Jon Doe', '', '1243  david cres', '', 'montreal', '90028', 'Ontario', 'CA', '1', 'I prefer to fax or phone my credit card information.', '', '', '', '', now(), '1', 'CAD', '1.00000000')

 

you can also dump out the array in the checkout_process.php file

you could try something like this (untested) :

 

after this :

  tep_db_perform(TABLE_ORDERS, $sql_data_array);
 $insert_id = tep_db_insert_id();
 $size = sizeof($order_totals);

 

print out the insert array :

  foreach ($sql_data_array as $value) {
  echo $value.'<br>';
 }
 exit;

 

david

[pbechard]

SOLUTION: I've been able to trace it back to the customers not clicking on the "Return to Merchant" button in Paypal, which will subsequently put the order in the ORDERS table. I also found this forum post, which advises to install the PayPal IPN contribution:

 

Forum Post:

http://www.oscommerce.com/forums/index.php?sho...=246618&hl=

 

PayPal IPN:

http://www.oscommerce.com/community/contributions,2679

 

 

 

Thanks to David for his suggestions. They helped too.

 

Peter