AdminConfigurationany sub-category --> missing page data

I recently installed and setup zencart 1.3.8 on my ms2003 test box. the store works great and all the admin pages load properly except the configuration page. admin>configuration>any sub category (My Store, Minimum Values, Maximum Values...EZ-Pages Settings) -- any of these pages just load the header/footer with no data, please see attached image.

my specs:

zencart 1.3.8
php 5.2.5
MySQL 6.0.3
IIS/6.0
ms 2003 sp1

addons: tax exempt customer

this is another screen shot showing that all my other categories work, please advise

:wacko:

Your /admin/configuration.php file is probably damaged or contains bad content.

On some occasions some people have confused the /admin/includes/configure.php file with the /admin/configuration.php file. They are COMPLETELY different, and should not be mixed up. Maybe you mistakenly got things mixed up?

At the very least you probably need to re-upload the original /admin/configuration.php file.

DrByte:

Your /admin/configuration.php file is probably damaged or contains bad content.

On some occasions some people have confused the /admin/includes/configure.php file with the /admin/configuration.php file. They are COMPLETELY different, and should not be mixed up. Maybe you mistakenly got things mixed up?

At the very least you probably need to re-upload the original /admin/configuration.php file.

thanks for the follow-up however the configuration.php file has not been changed. Just to ensure i have the correct file i downloaded it again. no change. when i load the configuration page there is no data -- just the header and footer. should IUSR or any other user have rights other than read/read-execute to this file?

There are no special permissions required for that file.

How many records exist in the "configuration" table in your database? (You'll have to use phpMyAdmin to check that)

DrByte:

There are no special permissions required for that file.

if i reinstall zencart will it overwrite my template files? i loaded a few free templates as well as created some test products. also, i'm pretty sure i have all errors set to show in php.ini -- is there any other place/flag i need to set to show errors?

maybe i'm throwing an error but it's not being displayed.

DrByte:

How many records exist in the "configuration" table in your database? (You'll have to use phpMyAdmin to check that)

directly from phpMyAdmin -- so 575 records

Showing rows 0 - 29 (575 total, Query took 0.0014 sec)

Zen Cart turns PHP error suppression on by default.

You can tell it to log errors to a file by installing the debug log util mentioned here: https://www.zen-cart.com/tutorials/index.php?article=82

jazznuts699:

directly from phpMyAdmin -- so 575 records

Showing rows 0 - 29 (575 total, Query took 0.0014 sec)
Okay. And how many are in your "configuration_groups" table?

DrByte:

Okay. And how many are in your "configuration_groups" table?

26

Showing rows 0 - 25 (26 total, Query took 0.0008 sec)

here is the list

ID Title
1 My Store
2 Minimum Values
3 Maximum Values
4 Images
5 Customer Details
6 Module Options
7 Shipping/Packaging
8 Product Listing
9 Stock
10 Logging
11 Regulations
12 E-Mail Options
13 Attribute Settings
14 GZip Compression
15 Sessions
16 GV Coupons
17 Credit Cards
18 Product Info
19 Layout Settings
20 Website Maintenance
21 New Listing
22 Featured Listing
23 All Listing
24 Index Listing
25 Define Page Status
30 EZ-Pages Settings

Hmmm. The only way I can recreate the symptoms you described is to wipe out the contents of my configuration_groups table.

The configuration_group_id records from the configuration_groups table are in a one-to-many relationship with the configuration_group_id records in the configuration table. If those records get out of sync (which would be extremely odd in normal operation) then the same symptoms would occur.

You said this is a test site which is a copy of the live site, right? I'm frankly very disinterested in fixing problems on test sites because test servers are very seldom configured the same as properly functioning live servers, especially if they're on a small home/office PC. However, if your live site is working fine, and your test site is not, and maybe your database records didn't import properly, then perhaps doing a fresh backup of your live site and re-importing it to your test server (after first deleting all the tables on the test server) ... may be a help.

DrByte:

Hmmm. The only way I can recreate the symptoms you described is to wipe out the contents of my configuration_groups table.

The configuration_group_id records from the configuration_groups table are in a one-to-many relationship with the configuration_group_id records in the configuration table. If those records get out of sync (which would be extremely odd in normal operation) then the same symptoms would occur.

You said this is a test site which is a copy of the live site, right? I'm frankly very disinterested in fixing problems on test sites because test servers are very seldom configured the same as properly functioning live servers, especially if they're on a small home/office PC. However, if your live site is working fine, and your test site is not, and maybe your database records didn't import properly, then perhaps doing a fresh backup of your live site and re-importing it to your test server (after first deleting all the tables on the test server) ... may be a help.

this is a test site in prep to go live. once i have everything configured properly i will copy everything to live. as we stand now zencart is only installed on the test box thus i have no live db to go back to.

if i delete the configuration tables (configuration and configuration_group) would i be able to just recreate those two tables using sql scripts from the install folder zc_install (which has been removed as per install instructions)

When did this problem first show up?

DrByte:

When did this problem first show up?

i had this problem from the get go -- but not being familiar with zencart when i first installed it i thought it was normal.

i just whacked the entire db and reinstalled under a new db. install runs great except that due to my version of mysql i have to replace every instance of TYPE=MyISAM with ENGINE=MyISAM in mysql_zencart.sql else the sql install fails.

I also did this in the below files just in case:

mysql_upgrade_zencart_127_to_130.sql
mysql_upgrade_zencart_124_to_125.sql
mysql_upgrade_zencart_121_to_122.sql
mysql_upgrade_zencart_114_to_120.sql
mysql_upgrade_zencart_104_to_111.sql

none of the other upgrade sql files had any references to TYPE=MyISAM

long story short -- the problem i reported is recreated with a fresh install making me believe this is a bug.

jazznuts699:

... making me believe this is a bug.Fair enough.
Yours is the first I've seen of someone reporting the problem you mention, so if there is a bug, then it's unique to the combination of software on your test computer.

Zen Cart v1.3.8 was never tested for compatibility with MySQL 6, and as such may encounter some problems with it. So that may be the wildcard for you.

And, since MySQL 6.0.3 is presently experimental alpha code as far as MySQL is concerned, perhaps using an officially released version might give you better mileage.

Try using MySQL 5.something.

And, you don't need to edit those mysql_upgrade_*.sql files if you're not actually doing upgrades.

crap.... i was hoping this would be something else. i'm not trying to be 'fresh' about a bug or not a bug. We actually have one live website on this box which runs on mysql thus if i downgrade to 5.1 i may break something -- you know any sites that discuss how to downgrade (mysql documentation mentioned downgrading from 5.1 to 5.0 not 6.0.3 to 5.1). Our live box where zencart will go ultimately run is on mysql 5.0.37 but as mentioned before this box is on mysql v6.0.3.

Is there any reason why you can't set things up on your 5.0 server to use as your staging area? Then when it's ready to go, move it to the desired working live folder?

I don't have a MySQL 6 environment available to do any testing at this point, so can't offer much assistance in that area, at least not right now.

DrByte:

Is there any reason why you can't set things up on your 5.0 server to use as your staging area? Then when it's ready to go, move it to the desired working live folder?

it's not as much a problem as a hastle due to bandwidth -- this is because the box i wanted to stage everything at is in the US, while my live box is in EUROPE. And i am currently in the US. Thus having the ability to setup a box here then just copy over tables/files would be the best scenario :). When i RDP into the box in Europe everything is in slow motion :frusty:.

i think my best bet would be to downgrade to mysql 5.2 and go from there. i'll perform a full backup of the box and see where that takes me. thanks for your help.

Ya, the slo-mo challenge can be a bit of a pain.