Customer Order History suddenly missing

[blue-grape]

When logged in to my account at my site I don't see Previous Orders under My Account. I don't have a "view" button at all. I have made purchases so I should see my order history.

Also my gift certificate balance vanished from my shopping cart.

Both the previous orders and the gift certificate balance were working a few months ago when I last logged into my site. I haven't got any addons.

I am using v1.3.9h

I don't have a clue where to start looking to fix both problems.

Can anyone help me?

[lat9]

It sounds like you've got a PHP-related error on your site; I'd start with this tutorial (especially the bits about the debug log files).

[blue-grape]

I changed back to the Classic template to see if that fixed the problem. It didn't. There is still no Order History and no Gift Certificate funs in the shopping cart.

I am not running any addons at all.

My cache folder only has two files in it, no debug files at all.

Because the Classic template is showing exactly the same problem as my custom template, maybe the problem is a corrupt file on the server somwhere.

Past orders are showing in admin and they are in the database.

Can anybody tell me which core files I should upload again to fix this problem?

[DrByte]

What PHP version is your server running? Was it recently changed?

[blue-grape]

My host says the PHP version hasn't changed. I'm fed up with my host so I'm going to move my site and I'll do a clean install with version 5 of Zen Cart. I hope to start the move and install over the weekend.

[blue-grape]

What PHP version is your server running? Was it recently changed?

I got a new host. I have installed version 5 of Zen Cart. I imported my database and the same problem exists.

The server info is MySQL Version:5.0.91 and PHP Version:5.2.12

I haven't edited one file on this new install. I have the classic template exactly as it was installed. I don't want to customize anything until I can get the previous orders to display on the My Account page.

As I said, if I look at the database all the previous orders are there but something must be broken somewhere.

Can anybody help me?

[blue-grape]

I just logged into my old host and myPHP admin.

Near the bottom of the page is a notice "The additional features for working with linked tables have been deactivated. To find out why click here"

$cfg['Servers'][$i]['pmadb'] not OK
$cfg['Servers'][$i]['relation'] ... not OK
General relation features: Disabled

$cfg['Servers'][$i]['table_info'] ... not OK
Display Features: Disabled

$cfg['Servers'][$i]['table_coords'] ... not OK
$cfg['Servers'][$i]['pdf_pages'] ... not OK
Creation of PDFs: Disabled

$cfg['Servers'][$i]['column_info'] ... not OK
Displaying Column Comments: Disabled
Bookmarked SQL query: Disabled
Browser transformation: Disabled

$cfg['Servers'][$i]['history'] ... not OK
SQL history: Disabled

$cfg['Servers'][$i]['designer_coords'] ... not OK
Designer: Disabled


I didn't disable anything, the host has done it I have opened a ticket asking can the tables be enabled again. I don't have much hope of them being helpful.

Can anybody tell me how I can enable the tables again on my new host?

[blue-grape]

I'm stumped! I did some surfing of this forum about tables being disabled and DrByte said it won't affect the store.

Well, my site is only 3 months old. My first database backup, works with the customers previos orders working on the newly installed test site as it should. When I import the databases from February and March to my test site the previous orders don't show up on the My Account customers page.

Can anybody help me?

[DrByte]

I got a new host

But this was broken *before* changing hosts, right?

I have installed version 5 of Zen Cart. I imported my database and the same problem exists.

Did you happen to test about the problem BEFORE you imported your database?

I just logged into my old host and myPHP admin.

Near the bottom of the page is a notice "The additional features for working with linked tables have been deactivated. To find out why click here"

$cfg['Servers'][$i]['pmadb'] not OK
$cfg['Servers'][$i]['relation'] ... not OK
General relation features: Disabled

$cfg['Servers'][$i]['table_info'] ... not OK
Display Features: Disabled

$cfg['Servers'][$i]['table_coords'] ... not OK
$cfg['Servers'][$i]['pdf_pages'] ... not OK
Creation of PDFs: Disabled

$cfg['Servers'][$i]['column_info'] ... not OK
Displaying Column Comments: Disabled
Bookmarked SQL query: Disabled
Browser transformation: Disabled

$cfg['Servers'][$i]['history'] ... not OK
SQL history: Disabled

$cfg['Servers'][$i]['designer_coords'] ... not OK
Designer: Disabled

That's got nothing to do with Zen Cart. Those are phpMyAdmin issues.

I didn't disable anything, the host has done it I have opened a ticket asking can the tables be enabled again. I don't have much hope of them being helpful.

It won't make any difference with your Zen Cart customer data.

[DrByte]

I'm stumped! I did some surfing of this forum about tables being disabled and DrByte said it won't affect the store.

Well, my site is only 3 months old. My first database backup, works with the customers previos orders working on the newly installed test site as it should. When I import the databases from February and March to my test site the previous orders don't show up on the My Account customers page.

Can anybody help me?

Have you been futzing with character set settings and utf8 etc?
Your symptoms sound like you've got mixed character set settings which are causing confusion and errors. Ref: https://www.zen-cart.com/tutorials/i...hp?article=414