Moved Site - Compatibility Issues?

20 Jul 2011, 02:40

#1

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

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.

20 Jul 2011, 03:01

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Moved Site - Compatibility Issues?

janellez:

Apache:2.2.19
MySQL5.1.52
PHP:5.2.17

There are no known compatibility issues with those.

20 Jul 2011, 03:54

#3

website_rob

Inactive

Join Date:: Oct 2006
Posts:: 4,572
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

Compare this setting between the two servers.

Admin > Tools > Server/Version Info

search for: memory_limit

Is it at least 64M on both?

20 Jul 2011, 11:14

#4

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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

20 Jul 2011, 11:59

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Moved Site - Compatibility Issues?

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

20 Jul 2011, 14:30

#6

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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).

20 Jul 2011, 18:50

#7

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Moved Site - Compatibility Issues?

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.

22 Jul 2011, 02:04

#8

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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.

22 Jul 2011, 07:38

#9

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Moved Site - Compatibility Issues?

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

26 Jul 2011, 01:48

#10

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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?

26 Jul 2011, 02:09

#11

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Moved Site - Compatibility Issues?

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

26 Jul 2011, 11:08

#12

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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

26 Jul 2011, 18:13

#13

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Moved Site - Compatibility Issues?

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?

26 Jul 2011, 23:50

#14

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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?

26 Jul 2011, 23:54

#15

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Moved Site - Compatibility Issues?

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

27 Jul 2011, 00:05

#16

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

I believe it's latin1_swedish_ci.

28 Jul 2011, 11:42

#17

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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).

28 Jul 2011, 15:56

#18

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Moved Site - Compatibility Issues?

Most peculiar.
I can't replicate your problem.

29 Jul 2011, 11:23

#19

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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.

02 Aug 2011, 01:45

#20

janellez

Zen Follower

Join Date:: Sep 2007
Posts:: 128
Plugin Contributions:: 0

Re: Moved Site - Compatibility Issues?

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?