PayPal express transaction info displayed ahead of customer comments sometimes?

[abe23]

Hi Zen Cart gurus,

I'm having a problem where transaction information from PayPal express is being saved to the Zen Cart order status history before the customer comments.

This means that when I print an invoice, the comments section is full of PayPal transaction info, rather than the actual customer comments. Presumably because the Zen Cart invoice page just takes the first comments from the order status history.

This only happens in some orders; not all. Does anyone know the reason why and how it could be resolved?

One option is obviously to re-write the comments part of the invoice page so it ignores PayPal info, but this seems like a bit of a hack.

Many thanks for your help.

[DrByte]

It's impossible for the main comments to be stored *after* the payment summary comments are added.

However, it *is* possible that maybe you've lost or broken the indexes on your orders_status_history table (it can happen when exporting and importing when moving data between databases, etc esp if the mysql version is different). I suggest using phpMyAdmin to do a Repair Table process on that table. Then if that doesn't solve it, peek at the original mysql_zencart.sql file for the proper structure of the orders_status_history table and compare that with what you've got in your actual database. If there are any indexes missing you might want to put them in.

You didn't say what version of Zen Cart you're using, but of course upgrading to the latest version is always advisable.