After updating, orders are not visible in the admin.

I have changed all my database files manually from 1.3.9 to 1.5.4. All files were added succesfully. But for some reason, if I look at the admin frontpage then I see the latest orders but when I click at customers-orders I see no order at all..:

http://www.bio-box.nl/images/blankorders.jpg

Do you happen to know which databasefile is not right? All the order-database-files looks ok into phpmyadmin.

Not sure why this thread had to be begun instead of the [uri="https://www.zen-cart.com/showthread.php?219473-After-updating-orders-are-not-visible-in-the-admin"]previous/duplicate thread[/url], but here goes.

Are you saying that you individually modified the database for every change made between ZC 1.3.9 and ZC 1.5.4 instead of permitting the zc_install database only upgrade process to perform the database upgrade?

Further in doing this, you splt your database into multiple files in which to make this modification?

Wow, talk about taking the long way around to your elbow. To get something done.

I have tried it before to update the website through the zc_install, but then I received a lot of errors and it didn't work very well.
I had installed a new webstore in 1.5.4. and then I thought it would be simple to transfer the 1.3.9. database files to the 1.5.4 database, but then I receive an error that I had an old database. So I indeed changed everything manually. Everything works fine, except that I cannot see a list with orders in the admin.

if you can see the orders table using phpMyadmin, and they are not showing up on the admin side, there is probably a table that you missed during your manual conversion.

if you want to pursue this avenue that you have traveled, you need to track down the sql statement in the admin side that generates the view into the orders. once you have found that sql statement, you can run that manually in phpMyadmin and see where you went wrong.

for example, in a straight v1.5.4 download, on line 821 in /admin/orders.php i see the following line commented out:

//echo '<BR><BR>I SEE A: ' . $orders_query_raw . '<BR><BR>';

uncomment the line:

echo '<BR><BR>I SEE A: ' . $orders_query_raw . '<BR><BR>';

go to the orders page, and find that sql statement and run that in phpMyadmin and perhaps that will give you some clues as to where you went askew in your conversion.

good luck!

carlwhat:

if you can see the orders table using phpMyadmin, and they are not showing up on the admin side, there is probably a table that you missed during your manual conversion.

if you want to pursue this avenue that you have traveled, you need to track down the sql statement in the admin side that generates the view into the orders. once you have found that sql statement, you can run that manually in phpMyadmin and see where you went wrong.

for example, in a straight v1.5.4 download, on line 821 in /admin/orders.php i see the following line commented out:

//echo '<BR><BR>I SEE A: ' . $orders_query_raw . '<BR><BR>';

> 
> uncomment the line:
> ```php
echo '<BR><BR>I SEE A: ' . $orders_query_raw . '<BR><BR>';

go to the orders page, and find that sql statement and run that in phpMyadmin and perhaps that will give you some clues as to where you went askew in your conversion.

good luck!

This will obviously help with this particular issue to at least identify missing data/return rows; however, one might question how many other issues were caused by manually performing this upgrade and what else was missed?

What "errors" were received? Typically in the auto-upgrade process there are messages posted to the display that serve as informational items only: can't change this column/field because it was already modified, field was not deleted because it already was deleted, field can not be created because it was already created. If there were errors after this process as in operation of the store, then those were caused/introduced by other plugins and either their continued existence un-upgraded, because they are no longer supported, or because the file upgrade process was not thoroughly performed (again possibly because of manually attempting to do too much editing versus using the base code and applying the desired plugins/modifications as suggested in https://www.zen-cart.com/entry.php?3)