AdminConfigurationany sub-category --> missing page data

I've tested v1.3.8 on MySQL 6.0.11 and can't replicate the problems you described with regard to the configuration screen entries not appearing.
My guess is that you've got corrupt data in one of those 2 tables.

DrByte:

I've tested v1.3.8 on MySQL 6.0.11 and can't replicate the problems you described with regard to the configuration screen entries not appearing.
My guess is that you've got corrupt data in one of those 2 tables.

thanks for following up. i attempted the following on a seperate server (web server2: ms2003sp2, iis6):

On web server2:

1. uninstall ii6 -- force httcfg to NOT listen on all ip's and ports
2. install wampserver 2.0 (apache 2.2, php 5.3, mysql 5.0.45, phpmyadmin 2.11)
3. install zencart 1.3.8 (same install files as on server1)-- partial success, admin page does not load at all, other pages show detruncate?? (sp?) errors (something to do with 5.3), from further reading on the forum it seems zencart 1.3.8 does not like php 5.3 at all
4. uninstalled wampserver 2.0
5. installed wampserver 1.7 (apache 2.2, php 5.2.5, mysql 5.0.45,phpmyadmin 2.11)
6. installed zencart 1.3.8 -- everything works, all pages including configuration page :clap:
   

   a. the only error i am getting is with SMTP: the following address failed. i put in all the smtp info on the bottom of the email config page (username, pw, smtp addy, etc) but it still fails

7. i'm using the same zencart install files on server2 as i am on server1
   

   a. this includes the already moded TYPE=MyISAM with ENGINE=MyISAM in mysql_zencart.sql

8. I am opting at this time not to downgrade serve1 from mysql 6.0.3 to 5.X since i have those couple live databases.

jazznuts699:

2. install wampserver 2.0 (apache 2.2, php 5.3, mysql 5.0.45, phpmyadmin 2.11)

3. install zencart 1.3.8 (same install files as on server1)-- partial success, admin page does not load at all, other pages show detruncate?? (sp?) errors (something to do with 5.3), from further reading on the forum it seems zencart 1.3.8 does not like php 5.3 at all
   Correct.
   jazznuts699:

4. installed zencart 1.3.8 -- everything works, all pages including configuration page
   

   a. the only error i am getting is with SMTP: the following address failed. i put in all the smtp info on the bottom of the email config page (username, pw, smtp addy, etc) but it still fails

   Did you use v1.3.8? or the newer v1.3.8a?

If you used the older v1.3.8a, then you'll need to make a fix to the smtp class: http://www.zen-cart.com/forum/showthread.php?t=82570

If your email problems persist, then I'd be double-checking the address you're sending to, as well as all the send-from settings (address, smtp credentials, etc) and check the mailserver app's logs to find out the reason for the rejections.

jazznuts699:

7. i'm using the same zencart install files on server2 as i am on server1
   

   a. this includes the already moded TYPE=MyISAM with ENGINE=MyISAM in mysql_zencart.sql

   
   I thought v1.3.8/a already had that. Regardless, ENGINE is the correct term to use, so carry on.

DrByte:

Correct.
Did you use v1.3.8? or the newer v1.3.8a?

I thought v1.3.8/a already had that. Regardless, ENGINE is the correct term to use, so carry on.

here are my specs on server2 right off the version link in the admin page:

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
PHP Version: 5.2.5 (Zend: 2.2.0)
Database: MySQL 5.0.45-community-nt
HTTP Server: Apache/2.2.6 (Win32) PHP/5.2.5

i pulled the latest download from the site the other day - unless it changed since i first posted this post... i've had to update the sql file with ENGINE -- so not sure about that.

the email address's are correct as are all the smtp settings. i will look at the link you mentioned above.

DrByte:

Correct.
If you used the older v1.3.8a, then you'll need to make a fix to the smtp class: http://www.zen-cart.com/forum/showthread.php?t=82570

this code is already in the class.smtp.php file as seen below right out of that file

 
    //Added for Gmail support CER
    if($this->Protocol != '') $host = $this->Protocol."://".$host; 

i'll switch to PHP and see how that works

jazznuts699:

here are my specs on server2 right off the version link in the admin page:

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
PHP Version: 5.2.5 (Zend: 2.2.0)
Database: MySQL 5.0.45-community-nt
HTTP Server: Apache/2.2.6 (Win32) PHP/5.2.5

i pulled the latest download from the site the other day
Should be fine with that combination of software versions.

so far now luck with mail

smtp/smtpauth --> recipient failed
php --> Email Error: Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport.
sendmail --> no errors but no mail either (tried 2 different email addresses)

EDIT; here are my settings

E-Mail Transport Method sendmail
E-Mail Linefeeds LF
Use MIME HTML When Sending Emails false
Send E-Mails true
Email Archiving Active? false
E-Mail Friendly-Errors false
Email Address (Displayed to Contact you) [email protected]
Email Address (sent FROM) [email protected]
Emails must send from known domain? No
Email Admin Format? TEXT
Send Copy of Order Confirmation Emails To [email protected]
Send Copy of Create Account Emails To - Status 0
Send Copy of Create Account Emails To [email protected]
Send Copy of Tell a Friend Emails To - Status 0
Send Copy of Tell a Friend Emails To [email protected]
Send Copy of Customer GV Send Emails To - Status 0
Send Copy of Customer GV Send Emails To [email protected]
Send Copy of Admin GV Mail Emails To - Status 0
Send Copy of Customer Admin GV Mail Emails To [email protected]
Send Copy of Admin Discount Coupon Mail Emails To - Status 0
Send Copy of Customer Admin Discount Coupon Mail Emails To [email protected]
Send Copy of Admin Orders Status Emails To - Status 0
Send Copy of Admin Orders Status Emails To [email protected]
Send Notice of Pending Reviews Emails To - Status 0
Send Notice of Pending Reviews Emails To [email protected]
Set "Contact Us" Email Dropdown List
Allow Guest To Tell A Friend false
Contact Us - Show Store Name and Address 1
Send Low Stock Emails 0
Send Low Stock Emails To [email protected]
Display "Newsletter Unsubscribe" Link? true
Audience-Select Count Display true
SMTP Email Account Mailbox [email protected]
SMTP Email Account Password ************
SMTP Email Mail Host smtp.mydomain.com
SMTP Email Mail Server Port 587
Convert currencies for Text emails £,£:€,€

Set your Email Transport to SMTPAUTH.
What happens if you try a different port than 587? Maybe 465 or 25 or 26 ?
http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Email_Problems

i went back to smtpauth -- reentered all the smtp/usr/pw/address info and changed port back to 25. Now it works. I think it was probably a typo somewhere, most likely the pw -- but i could have sworn i retyped it a half dozen times... moving along nicely now :clap:

i found that link earlier and was reading it line by line.. hehe...

thanks for keeping up with me.

now i need to find out why my VAT mod is not adding taxes to non business entity customers :( but thats a different ball of wax

edit: Cool. Glad you got it sorted out!

Ya, that other issue probably deserves a separate discussion ... perhaps in the addon's own support thread?