Advice on "recent orders" not showing

[ideasgirl]

But my template is no longer working, it doesn't show all side boxes etc in the page, is this common or am i doing something wrong?

When you install a template (or change it), all your boxes are reset causing them to be turned off. You have to go to the "Layout Boxes Controller" and rearrange them again. Maybe that's your problem?

[ideasgirl]

thank you so much for your support, i decided to give an update a try since the version incompatibilietes with mysql 5 in the new server.

So this is caused because of PHP5?

A customer is having same issue, and he's on a PHP5.2 server... Any recommendations?

[Mochino]

When you install a template (or change it), all your boxes are reset causing them to be turned off. You have to go to the "Layout Boxes Controller" and rearrange them again. Maybe that's your problem?

My problem was that the old server was running a 1.2. version, so the whole template crashed when trying to load in the new version.

------------------
So this is caused because of PHP5?

A customer is having same issue, and he's on a PHP5.2 server... Any recommendations?
-----------------------

The error was caused due to migration of database from mysql 4 to mysql 5, my advice would be to upgrade to the latest version of zencart, as always backing up your database prior to anything.

[ideasgirl]

The error was caused due to migration of database from mysql 4 to mysql 5, my advice would be to upgrade to the latest version of zencart, as always backing up your database prior to anything.

Customer is running latest version with all patches.

[Mochino]

Customer is running latest version with all patches.

Just to be sure, are talking about recent orders not showing up, or a template crash?

[ideasgirl]

I am talking about orders not showing up. The template mention was to help the fellow member...

[Mochino]

I am talking about orders not showing up. The template mention was to help the fellow member...

From what i've researched, the Orders Total module is the one that manages which recent orders are showing up, so:

first thing i tried was to check if it was enabled, after that, i made a test order (you can try setting up the Credit card payment module so it won't be tried to charged and you will be allowed to test them)

After that, i tried uninstalling and reinstalling it (re uploading the module to check corruption of the file, that way i was sure it was not a problem with the file

Then, check via phpMyadmin or Mysql Query Browser, the contents of the database table (i can't remember which one it was, but it was something like: orders, total)

If that doesn't help, try checking if there was a file structure change in the server, maybe the host server somehow changed their structure so the path to the customer's package changed before the /web folder

I don't know if there's a way in which you guys would be able to see the log file of the application (mysql or zencart's one, in case it exists), maybe it can help you to find an error.

I guess what i would do after that is to create a mirror database, and reinstalling the software in another path, and then adding every plugin or template the actual software has setp by step and checking it it's broking something, please, if you find the problem, tell me what was wrong, it would be interesting to know.

[ideasgirl]

Apparently SOMEONE changed those setting defaults of total order...etc. I changed them back and made a test... It appeared. Let's see what happen on next order.

Is there a way to make the other order that weren't appearing to appear? (is there a magic trick?). (I can go to the database and change stuff if it's necessary).

Thanks!

[Mochino]

Apparently SOMEONE changed those setting defaults of total order...etc. I changed them back and made a test... It appeared. Let's see what happen on next order.

Is there a way to make the other order that weren't appearing to appear? (is there a magic trick?). (I can go to the database and change stuff if it's necessary).

Thanks!

From what i could guess you would had to: Either re-process them as already payed somehow, or manually add what those values would look like in the table registry of orders.

I wish i could help you more but i've been working with zencart for just about a week.

Glad i could help.

[DrByte]

The error was caused due to migration of database from mysql 4 to mysql 5, my advice would be to upgrade to the latest version of zencart, as always backing up your database prior to anything.

Sometimes when converting between MySQL versions the export/import may lose the auto_increment settings on the tables. This is common between MySQL 3 and MySQL 4 ... haven't seen it when going from 4 to 5, but I suppose it's possible.
Ajeh suggested checking auto-increment issues earlier.