Intermittent problems reading (and writing?) from the database. I think?

Upgraded 1.38a to 1.53 this last weeekend.

Upgraded Database, PHP to 5.4

Had some trouble with some ez pages not loading content from the database - supsected an outdated plugin somwhere but fixed by copy/paste from the database back into ez pages. content did stick.

Now, I have an order for command! candles and the customer has ordered in the past. This order and the customer's past orders are missing the text from their petition. Also, I had a customer say they 'couldn't add the apartment number' for some reason yet when i go to Orders > Customers and pull up their profile, I can see the apt number. I click "update" and go back to the customer's order and surprise! there's the apt number where it wasn't before.

I'm not really sure what is causing that and hoping I can get some answers. I would be disappointed if we ended up shipping packages that didn't have needed apt number when the customer put in the data correctly. :(

I'm not sure which log file to paste. I have a mail.log, access.log.current and a bunch of .gz zipped files.

Thanks for any insight.

gachogavacho:

Upgraded 1.38a to 1.53 this last weeekend.

Upgraded Database, PHP to 5.4

Had some trouble with some ez pages not loading content from the database - supsected an outdated plugin somwhere but fixed by copy/paste from the database back into ez pages. content did stick.

Now, I have an order for command! candles and the customer has ordered in the past. This order and the customer's past orders are missing the text from their petition. Also, I had a customer say they 'couldn't add the apartment number' for some reason yet when i go to Orders > Customers and pull up their profile, I can see the apt number. I click "update" and go back to the customer's order and surprise! there's the apt number where it wasn't before.

I'm not really sure what is causing that and hoping I can get some answers. I would be disappointed if we ended up shipping packages that didn't have needed apt number when the customer put in the data correctly. :(

I'm not sure which log file to paste. I have a mail.log, access.log.current and a bunch of .gz zipped files.

Thanks for any insight.

Not sure if in the upgrade process the field lengths of the database entries is/was adjusted or if their is a maximum value that was potentially exceeded in entry, but the database table field lengths can be adjusted in myphpadmin. Most likely the change(s) made to the user data may need to be made on the orders table as well. The mmaximum values are under configuration on the admin page.

As for logs, hopefully by now you have found out that ZC error logs are now provided in the logs folder instead of previously being in the cache folder. More than likely the .gz zipped files are compressed versions of your database and should not be posted for the public to see.

gachogavacho:

Upgraded 1.38a to 1.53 this last weeekend.
Had some trouble with some ez pages not loading content from the database - supsected an outdated plugin somwhere but fixed by copy/paste from the database back into ez pages. content did stick.

Now, I have an order for command! candles and the customer has ordered in the past. This order and the customer's past orders are missing the text from their petition. Also, I had a customer say they 'couldn't add the apartment number' for some reason yet when i go to Orders > Customers and pull up their profile, I can see the apt number. I click "update" and go back to the customer's order and surprise! there's the apt number where it wasn't before.

I'm not really sure what is causing that and hoping I can get some answers

I'm guessing that this a character set problem.

http://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-8859-1-to-utf8

I suggest that you make the changes needed to stay with LATIN1.

Cheers
RodG

Rod,

I thought this as a character set problem also since I had some products that had accents in the text. example: Obatalá Candle - Setting of Lights. In 1.38a, I had no problems. But I looked at my database backup and it looks like it was set to UTF8 anyway before upgrade.

RodG:

I'm guessing that this a character set problem.

http://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-8859-1-to-utf8

I suggest that you make the changes needed to stay with LATIN1.

Cheers
RodG

and MC, if the field length is the problem, would it omit the entire text or just exclude whatever is too long? I guess if the entire entry is too big, it would junk it?

gachogavacho:

Rod,

I thought this as a character set problem also since I had some products that had accents in the text. example: Obatalá Candle - Setting of Lights. In 1.38a, I had no problems. But I looked at my database backup and it looks like it was set to UTF8 anyway before upgrade.

and MC, if the field length is the problem, would it omit the entire text or just exclude whatever is too long? I guess if the entire entry is too big, it would junk it?

It would truncate the text, but what is odd is that you described the ability to look up one piece of information and everything was there. It's something that others in the past have indicated to happen/be a fix, so I thought I would suggest it as well ahead of fully understanding the conditions being observed.

RodG,

This was the solution. I was missing the following code, even though I swear my Config file had it. Apparently they were the old config files from my previous install 1.38a of Zen Cart

define('DB_CHARSET', 'utf8'); 

Thank you everyone for your help!

RodG:

I'm guessing that this a character set problem.

http://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-8859-1-to-utf8

I suggest that you make the changes needed to stay with LATIN1.

Cheers
RodG