Emergency - Please Help!!!!

[ljh23]

Please help! I am so lost here! I ran a test the other day on my site, and everything seemed to be working fine. Then yesterday I received 2 orders, and all the product information was blank. Subtotal and shipping came out on the order. I also received all of the customer's information. But on the invoice where it gives the product it says 0. I had my host restore me back to the day that I had my successful tests, thinking maybe I had changed something and just didn't remember. Now all orders are still coming through as 0. I'm not sure if I am having a clash with my contributions, or whta. These are the contributions that I have installed, hopefully I can remember them!...

QTPro w/Attribute Sorter

Featured products

Zone World

Coupon & Gift Voucher

Point Rewards

Instant Message

 

I jusst have no idea where to even start to look for my problem. Any suggestions? Thanks in advance!

[kgt]

Do you have something like phpmyadmin installed? Can you look and see if the order information exists in the database?

[ljh23]

Do you have something like phpmyadmin installed?  Can you look and see if the order information exists in the database?

<{POST_SNAPBACK}>

 

Thanks for the suggestion, but I did already try that. It just has the order # in there, with 0 next to it. I have checked every place that I can think of to try to pull up the orders, and they all come up 0. any other suggestions?

Thanks!

[satish]

Thanks for the suggestion, but I did already try that. It just has the order # in there, with 0 next to it. I have checked every place that I can think of to try to pull up the orders, and they all come up 0. any other suggestions?

Thanks!

<{POST_SNAPBACK}>

Hello,

Please set the default values in some field to something different it might that when an insert occurs as all values are blank so db takes it as zero.If you change and get the default value then you have some idea to move on.

Else you need to check or just paste all the order related pages.

 

Satish Mantri

[ljh23]

Hello,

Please set the default values in some field to something different it might that when an insert occurs as all values are blank so db takes it as zero.If you change and get the default value then you have some idea to move on.

Else you need to check or just paste all the order related pages.

 

Satish Mantri

<{POST_SNAPBACK}>

I guess I am having a hard time figuring out what you would like me to do? I have compared my tables against a friend of mine's and our tables are the same (her site is running fine). I have also compared our order and orders files. I could only find minor differences due to the fact that we do not have all of the same contributions installed. I have compared admin/orders.php, admin/includes/classes/order.php, and catalog/includes/classes/orders.php. I can post these if that is what you are looking for. Did I get all the files? Or did I miss some? Thanks!

[ljh23]

I guess I am having a hard time figuring out what you would like me to do? I have compared my tables against a friend of mine's and our tables are the same (her site is running fine). I have also compared our order and orders files. I could only find minor differences due to the fact that we do not have all of the same contributions installed. I have compared admin/orders.php, admin/includes/classes/order.php, and catalog/includes/classes/orders.php. I can post these if that is what you are looking for. Did I get all the files? Or did I miss some? Thanks!

<{POST_SNAPBACK}>

 

Can anyone offer some help here? Thanks!

[ljh23]

Can anyone offer some help here? Thanks!

<{POST_SNAPBACK}>

 

OK I got my site back up and going. I was having a clash with some of my contributions. I have qtpro working great, and I also have my points rewards working. Does anyone know how I can put the code back in for my coupons? I am having a problem on the catalog/checkout_confirmation.php page. Here is the chunk of code that I have

// load the selected payment module
 require(DIR_WS_CLASSES . 'payment.php');
//  if ($credit_covers) $payment=''; //ICW for CREDIT CLASS. Removed in v5.13 cause variable not yet set at this point
 $payment_modules = new payment($payment);
//ICW ADDED FOR CREDIT CLASS SYSTEM
 require(DIR_WS_CLASSES . 'order_total.php');

 require(DIR_WS_CLASSES . 'order.php');
 $order = new order;

 $payment_modules->update_status();
//ICW ADDED FOR CREDIT CLASS SYSTEM
 $order_total_modules = new order_total;
//ICW ADDED FOR CREDIT CLASS SYSTEM
 $order_total_modules->collect_posts();
//ICW ADDED FOR CREDIT CLASS SYSTEM
 $order_total_modules->pre_confirmation_check();

// ICW CREDIT CLASS Amended Line - Rigadin amended 2nd line in v5.13
//  if ( ( is_array($payment_modules->modules) && (sizeof($payment_modules->modules) > 1) && !is_object($$payment) ) || (is_object($$payment) && ($$payment->enabled == false)) ) {
//    tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL'));
 if ( (is_array($payment_modules->modules)) && (sizeof($payment_modules->modules) > 1) && (!is_object($$payment)) && (!$credit_covers) ) {
   tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error=ccerr&error=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL'));  // Rigadin in v5.13: modified error coding in URL
 }

 if (is_array($payment_modules->modules)) {
   $payment_modules->pre_confirmation_check();
 }

 

And here is the code from the coupon that is supposed to be in the same space.

 

// load the selected shipping module
 require(DIR_WS_CLASSES . 'shipping.php');
 $shipping_modules = new shipping($shipping);
//ICW Credit class amendment Lines below repositioned
//  require(DIR_WS_CLASSES . 'order_total.php');
//  $order_total_modules = new order_total;
##### Points/Rewards  Module v1.20 check for error BOF #######
//force customers to select other payment method if the points total not enough to cover the cost.
// if ( ( is_array($payment_modules->modules) && (sizeof($payment_modules->modules) > 1) && !is_object($$payment) ) || (is_object($$payment) && ($$payment->enabled == false)) ) {
  if ( (is_array($payment_modules->modules)) && (sizeof($payment_modules->modules) > 1) && (!is_object($$payment)) && ($customer_shopping_points_spending * REDEEM_POINT_VALUE < $order->info['total'] ) || (is_object($$payment) && ($$payment->enabled == false)) ) {
   tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL'));
 }
// customer can't use points over the order total         
  if ($customer_shopping_points_spending * REDEEM_POINT_VALUE > $order->info['total']) {
      $customer_shopping_points_spending = 0;
   tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(REDEEM_SYSTEM_ERROR_POINTS_OVER), 'SSL'));
 }
########  Points/Rewards  Module v1.20 EOF #################*/

 if (is_array($payment_modules->modules)) {
   $payment_modules->pre_confirmation_check();
 }

// load the selected shipping module
 require(DIR_WS_CLASSES . 'shipping.php');
 $shipping_modules = new shipping($shipping);

 require(DIR_WS_CLASSES . 'order_total.php');
 $order_total_modules = new order_total;

 

If anyone knows hoe I can get all three of these to work together, I would love to know!

Thanks!