Changes in Admin not written to database tables correctly

[lhollo]

New installation: Zen Cart 1.3.8a, Database Patch Level: 1.3.8; Database: MySQL 5.0.22; PHP Version: 5.1.6 (Zend: 2.1.0)

I am able to use my admin console. When I make any changes to the tables, i.e. template_select, admin, or categories, the new string values are not being written to the appropriate field.

For example, I added a new user. An entry appears in the admin list but the name and email are blank. When I open MySQL Query Browser and check the contents of the admin table, the new user has been added, and the password in present, but the name and email fields are blank and the admin_level is 0. I have been using the Query Browser to update the tables with the desired information in order to move ahead with my store, but need to find out why this is happening.

Any ideas?

Thanks.

[lhollo]

What is ZenCart's recommended magic quotes setting in PHP?

[chucksssss]

What is ZenCart's recommended magic quotes setting in PHP?

Magic Quotes should be off.
That's always best-practice anyway. In fact, newer versions of PHP have Magic Quotes disabled by default, and an upcoming version of PHP isn't even going to have magic-quote support, if I've read correctly.

[lhollo]

Magic quotes is off in our PHP settings.

[chucksssss]

What browsers have you tried this with?

[lhollo]

IE 7.0, Mozilla Firefox 2.0, Apple Safari 3.1

[lhollo]

Looks like we had an issue with our secure server installation.

I have set up ZenCart on a different server and it is working fine.

Great product--keep up the good work!

[lhollo]

I wanted to follow up with the true issue.

We had tried to reinstall this on the secure server and ran into the problem again.

SOLUTION:

In the admin/includes/configure.php file, check the following:

/* If you desire your *entire* admin to be SSL-protected, make sure you use a "https:" URL for all 4 of the following:
*/
define('HTTP_SERVER', 'http://localhost');
define('HTTPS_SERVER', 'https://localhost');
define('HTTP_CATALOG_SERVER', 'http://localhost');
define('HTTPS_CATALOG_SERVER', 'https://localhost');

We changed all 4 to 'https:...' and everything worked fine.

We also changed these settings in the includes/configure.php, even though that comment wasn't present.