Where are the order comments?!

[freaknigh]

It is vital that I have the customers additional comments on the order and this latest version is hiding them from me!!

 

Torture!!!!!! It used to be there in the older versions!!

 

Please tell me where these comments are stored and how i can get to them.

[Nullachtfuffzehn]

What versions are you talking of and where were those comments located in the earlier versions in opposite to the new? I'm running several different stores with different versions and can see the comments in any of them.

[ljk]

Hi,

 

I am using 2.2RC1 with modification. When I am in the Delivery Information page (checkout_shipping.php) I go and enter a comment and press continue. When I get to the next page, Payment Information (checkout_payment.php) the comment field is blank. I have done a compare on these 2 files with the original 2.2RC1 files and they are the same. I also did a compare on application_top.php and it is the same.

 

Any ideas of what other files I would look at to see what is happening to the comments between pages?

 

Thanks for any help.

[Ordep_]

Hi,

 

I am using 2.2RC1 with modification. When I am in the Delivery Information page (checkout_shipping.php) I go and enter a comment and press continue. When I get to the next page, Payment Information (checkout_payment.php) the comment field is blank. I have done a compare on these 2 files with the original 2.2RC1 files and they are the same. I also did a compare on application_top.php and it is the same.

 

Any ideas of what other files I would look at to see what is happening to the comments between pages?

 

Thanks for any help.

 

 

 

 

Hi !

 

I'am having the same problem... it's getting on my nervs... If anyone could help that would be great !

 

Thanks again !

[pfilias]

This seems to be a problem with the latest version(s) of osCommerce. From another post, I found this:

 

In checkout_payment.php you need to make the following two code changes:

 

After this line:

  if (!tep_session_is_registered('comments')) tep_session_register('comments');

 

Add this:

	if (isset($HTTP_POST_VARS['comments']) && tep_not_null($HTTP_POST_VARS['comments'])) {
	$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);
	}

 

So it looks like:

  if (!tep_session_is_registered('comments')) tep_session_register('comments');
if (isset($HTTP_POST_VARS['comments']) && tep_not_null($HTTP_POST_VARS['comments'])) {
	$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);
	}

 

And then, where the form is constructd, find this:

<td><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>

 

And change it to:

<td><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5', $comments); ?></td>

 

So it looks like this:

<tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5', $comments); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>

[gretchenwf]

You can also just get rid of the comments box on one of the pages. I know on my site if comments were entered on the first checkout page, they would get overwritten if the comments field was left blank on the second page. I also didn't need comments on both pages, so I removed them from checkout_payment.php.

[locaincb]

You can also just get rid of the comments box on one of the pages. I know on my site if comments were entered on the first checkout page, they would get overwritten if the comments field was left blank on the second page. I also didn't need comments on both pages, so I removed them from checkout_payment.php.

 

 

I am having a little different problem with the comments. They are showing up from checkout_shipping to checkout_payment but they are not showing up in the confirmation emails. I looked into the checkout_process.php file and see that comments is supposed to be part of the email text that is generated, however when I look in to classes/order.php I don't see where there is an sql statement for the TABLE_ORDERS_STATUS_HISTORY where comments is held ->The file is not getting the comments from this table??? AM I off my rocker here? Any advice would be appreciated. THANKS

[locaincb]

I am having a little different problem with the comments. They are showing up from checkout_shipping to checkout_payment but they are not showing up in the confirmation emails. I looked into the checkout_process.php file and see that comments is supposed to be part of the email text that is generated, however when I look in to classes/order.php I don't see where there is an sql statement for the TABLE_ORDERS_STATUS_HISTORY where comments is held ->The file is not getting the comments from this table??? AM I off my rocker here? Any advice would be appreciated. THANKS

 

Okay so after further testing comments are not being added to the orders_status_history table at all! Would this have to do with using Paypal Direct???

 

Anyone?