Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2008
    Posts
    8
    Plugin Contributions
    0

    help question Changes in Admin not written to database tables correctly

    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.

  2. #2
    Join Date
    Apr 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: Changes in Admin not written to database tables correctly

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

  3. #3
    Join Date
    Jul 2005
    Posts
    537
    Plugin Contributions
    0

    Default Re: Changes in Admin not written to database tables correctly

    Quote Originally Posted by lhollo View Post
    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.

  4. #4
    Join Date
    Apr 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: Changes in Admin not written to database tables correctly

    Magic quotes is off in our PHP settings.

  5. #5
    Join Date
    Jul 2005
    Posts
    537
    Plugin Contributions
    0

    Default Re: Changes in Admin not written to database tables correctly

    What browsers have you tried this with?

  6. #6
    Join Date
    Apr 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: Changes in Admin not written to database tables correctly

    IE 7.0, Mozilla Firefox 2.0, Apple Safari 3.1

  7. #7
    Join Date
    Apr 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: Changes in Admin not written to database tables correctly

    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!

  8. #8
    Join Date
    Apr 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: Changes in Admin not written to database tables correctly

    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.

 

 

Similar Threads

  1. After upgrading database site not displaying correctly
    By spawnie69 in forum Upgrading to 1.5.x
    Replies: 19
    Last Post: 12 Feb 2016, 02:41 AM
  2. v150 Discount on Invoices Not Posting to Database Correctly
    By FloridaGoFishing in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 7
    Last Post: 31 Jul 2013, 08:53 PM
  3. Create Database, Tables and Drop Database or Tables
    By elwood cordery in forum General Questions
    Replies: 3
    Last Post: 17 Aug 2009, 04:03 PM
  4. ZenCart database setup error -12263 and Could not fetch schema tables
    By Xulayman in forum Installing on a Windows Server
    Replies: 4
    Last Post: 21 Aug 2007, 07:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR