Moved Site - Compatibility Issues?

I moved a 1.3.9h Zen Cart from a server running

Apache version 2.2.15
MySQL version 5.0.92-community
PHP version 5.2.13

to one running

Apache:2.2.19
MySQL5.1.52
PHP:5.2.17

Now, I'm getting sporadic issues of customer names and addresses not showing up in the Admin home panel and on the orders themselves.

Is the only option for fixing this to upgrade? We do need to upgrade and this is in the plans for the near future but I've heard about setting a database to be backwards compatible to temporarily solve the problem.

Any advice on this would be appreciated.

janellez:

Apache:2.2.19
MySQL5.1.52
PHP:5.2.17
There are no known compatibility issues with those.

Compare this setting between the two servers.

Admin > Tools > Server/Version Info

search for: memory_limit

Is it at least 64M on both?

Rob - yep - 64M on both. I'm at a loss as to know what to do.

http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Diagnosing_Obscure_Issues
https://www.zen-cart.com/tutorials/index.php?article=100

DrByte:

http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Diagnosing_Obscure_Issues
https://www.zen-cart.com/tutorials/index.php?article=100

Thank you - I appreciate it. I did follow each of the instructions in the second link and have moved three separate Zen Cart sites from the server in question to the new server in question without running into this issue before.

I'll try an upgrade this weekend (which will require me to look at the files closely anyway as this site has so many mods).

Your posts could use a little more detail.

Your very first line says you're using v1.3.9h. And, v1.3.9h happens to be the latest version of Zen Cart as of today, and as such your various posts about "needing to upgrade" and "will try an upgrade" don't make sense.

Also, you said you're experiencing missing information in certain circumstances. A lot more detail there would be helpful, including exactly WHAT kinds of information are missing, WHERE they're missing, what payment modules are being used in those problematic cases, and as much detailed information about patterns or commonalities between problematic situations as you can possibly share. Patterns are extremely helpful. Exact steps to recreate the problem are also very very useful.

Ugh - I'm sorry. The cart is 1.3.9d.

The items missing are random customer names and addresses from orders. This is apparent on the Admin Home Page in the New Orders section and when you look at the orders in the orders or SuperOrders list. The Customer Address field will be blank but the Billing or Shipping address fields will have data in them.

Since I started this thread, it hasn't happened again but it has happened on four orders since the move.

Yes, upgrading will help. There were some problems akin to that in earlier editions of the 1.3.9 series.

I upgraded the site this weekend and it seems to have solved the issue of customer names not showing in the New Orders section of Admin Home. However, now, I have entire customer records without any information in them. When I look at said customer record in the database, the data is there, in its entirety.

Have I missed a step, a bug fix?

http://www.zen-cart.com/forum/showthread.php?p=953964#post953964

I appreciate the suggestion and had already made those changes in the hope they would help - nada.

Remember, the host is running -

Apache:2.2.19
MySQL5.1.52
PHP:5.2.17

It sounds like maybe they're not.

What version information appears when you go to Admin->Tools->Server Info ?

Also, what language are you using this with?
And what CHARSET have you defined in your language files?

Zen Cart 1.3.9h
Database Patch Level: 1.3.9d

Server OS: Linux 2.6.38.7 Database: MySQL 5.1.52
Server Date: 07/26/2011 18:12:41 Database Date: 07/26/2011 18:12:41
HTTP Server: Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.8r DAV/2 mod_fcgid/2.3.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP Version: 5.2.17 (Zend: 2.2.0)

Using with English. CHARSET is iso-8859-1. Could this be a database issue with character set?

Maybe. Maybe not. What's the character set of your database data?

I believe it's latin1_swedish_ci.

Updated the CHARSET in the database to UTF-8 and in the language files. No luck. I still have entire customer records that show blank fields (when the data is clearly in the database).

Most peculiar.
I can't replicate your problem.

I appreciate your help. If I get to the bottom of this, I'll update this post. If the database wasn't so large and the problem wasn't so sporadic, it'd probably be easier to diagnose and fix.

Someone suggested I check my error logs and I'm coming up with the following -

[01-Aug-2011 09:08:10] PHP Warning: array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #1 is not an array in /home/xyz/public_html/fakeadmin/customers.php on line 1099
[01-Aug-2011 09:08:10] PHP Warning: array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #2 is not an array in /home/xyz/public_html/fakeadmin/customers.php on line 1101
[01-Aug-2011 09:08:10] PHP Warning: reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object in /home/xyz/public_html/fakeadmin/includes/classes/object_info.php on line 29
[01-Aug-2011 09:08:10] PHP Warning: Variable passed to each() is not an array or object in /home/xyz/public_html/fakeadmin/includes/classes/object_info.php on line 30

in addition -

[01-Aug-2011 07:45:38] PHP Warning: Invalid argument supplied for foreach() in /home/xyz/public_html/includes/modules/shipping/usps.php on line 278

After the upgrade I was having trouble with international shipping so I installed the module USPS Shipping Module Update - RateV4 - IntlRateV2.

Can any of these be related to the missing info?