Blank comments field in order_status_history

Hello,

Finally upgrading from 1.2.1 to newest 1.3.9h!

I did the database upgrade successfully, one update at a time.

But now I noticed that when I add a new comment on orders.php on the admin side, the comment comes out blank and the status doesn't update either.

I checked my database via phpmyadmin and in the table zen_orders_status_history the fields are always as follows:

orders_status_id = 0
customer_notified = 0
comments = BLANK

I am just wondering which file inputs the data into the database?

P.S.
I checked the cache folder and the the error doesn't trigger a DEBUG file (no file created today).

Thanks everyone for reading!

Finally upgrading from 1.2.1 to newest 1.3.9h!

I did the database upgrade successfully, one update at a time.
No mention of how you did the set of files???

Did you install 1.3.9h first and then import your live DB and upgrade it?

drbyday:

But now I noticed that when I add a new comment on orders.php on the admin side...

I am just wondering which file inputs the data into the database?You already answered your question. /admin/orders.php

kobra:

No mention of how you did the set of files???

Did you install 1.3.9h first and then import your live DB and upgrade it?

Sorry, yes, I did a fresh install of 1.3.9.h, then I imported my database and did the upgrades one by one using zc_install folder.

DrByte:

You already answered your question. /admin/orders.php

Yes I found the mysql insert code in orders.php and it looks good (matches database structure). I dont think that is the issue.

Any suggestions for troubleshooting this problem? Thanks guys for your help.

Your server information

kobra:

Your server information

Server OS: Linux 2.6.18-238.9.1.el5
Database: MySQL 5.0.92-community-log
HTTP Server: LiteSpeed

php ???

kobra:

php ???

I knew I was missing something! Sorry!

PHP Version: 5.2.17 (Zend: 2.2.0)

PHP Version: 5.2.17 (Zend: 2.2.0)
1.2.1 to newest 1.3.9h!
Your version info shows there is not an issue with versioning

How did you upgrade???

The tutorial outlines a NEW install of the current version with it's own DB

I suspect you have something - files crossed up or??

https://www.zen-cart.com/tutorials/index.php?article=108

kobra:

Your version info shows there is not an issue with versioning

How did you upgrade???

The tutorial outlines a NEW install of the current version with it's own DB

I suspect you have something - files crossed up or??

https://www.zen-cart.com/tutorials/index.php?article=108

I am testing with a fresh version of 1.3.9h.

The database I upgraded (the 1.2.1 database) went smoothly using the zc_intall folder.

I may have made some small changes to the original 1.2.1 database (via some installed modules). Should I put the database back to 1.2.1 form before upgrading? Do you think that would help? Or should that not matter?

I may have made some small changes to the original 1.2.1 database (via some installed modules). Should I put the database back to 1.2.1 form before upgrading? Do you think that would help?

Or should that not matter?
Can not comment as any custom work file or DB is not addressed in an upgrade - - ZenCart upgrade script is not aware of your custom changes

kobra:

Can not comment as any custom work file or DB is not addressed in an upgrade - - ZenCart upgrade script is not aware of your custom changes

Fair enough. Do you have any suggestions or pointers on where I should start to troubleshoot?

I am testing with a fresh version of 1.3.9h.

Do you have any suggestions or pointers on where I should start to troubleshoot?
If records added to a table or a new table added the fresh set of files will not be addressing any custom records or tables so there should not be a problem

As you are seeing an issue,, You need to review what you have changed

Compare all your files vs originals, and compare your database schema against the master schema. Fix whatever's mismatched after you figure out why.

related: http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Diagnosing_Obscure_Issues

Ok I think I resolved it.

I upgraded a clean copy of a 1.2.1 database to the current version, and everything worked perfectly so I knew it was a database issue.

Then I analyzed the differences between a fresh copy of 1.2.1 and my current 1.2.1 data schema. It turns out I added customers_fax in the orders.php outlined in this guide:

http://www.zen-cart.com/forum/showthread.php?t=52555

So I just followed this guide again with my fresh 1.3.9h files and upgraded my database again and it worked!

:clap: