Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2006
    Posts
    200
    Plugin Contributions
    0

    Default sql tables won't update from admin

    I finally upgraded to the latest version of zen and it went very easily for the most part. I am having one issue though. I *think* it actually started when I noticed something funky with my testimonial manager after dong the security update. So I checked and saw there was an upgrade for the testimonials manager and did that. Now when I try to update something from the admin panel, for example, change the config-regulations-confirm terms and conditions during checkout, I toggle and hit "update" and the cart just goes back to the main page without actually updating the sql table. Same goes for changing text in the define pages editor.

    I thought doing the upgrade my fix my problem but it didn't. Does that mean it's something in the testimonial manager module? Ideas on how I can fix this? As a work around, I've just been doing changes in the sql table directly but that isn't really convenient. TIA!
    Zen Cart: Diva Knitting

  2. #2
    Join Date
    Feb 2009
    Posts
    124
    Plugin Contributions
    0

    Default Re: sql tables won't update from admin

    First of all I would BACKUP your site and SQL database in case what I suggest messes up your site.

    Remove everything to do with testimonial manager from your site. Do the admin changes save then? If so, you've at least narrowed it down to TM being the culprit.

  3. #3
    Join Date
    Jan 2008
    Posts
    1,711
    Plugin Contributions
    7

    Default Re: sql tables won't update from admin

    Are you sure you installed the security patch correctly? One of the symptoms of an incorrect security patch installation is not being able to save changes in the admin panel.

  4. #4
    Join Date
    Mar 2006
    Posts
    200
    Plugin Contributions
    0

    Default Re: sql tables won't update from admin

    Quote Originally Posted by Steven300 View Post
    Are you sure you installed the security patch correctly? One of the symptoms of an incorrect security patch installation is not being able to save changes in the admin panel.
    I guess that's possible, but now that I've done the upgrade to 1.8 wouldn't that go away? The security update was included with 1.8a right?
    Zen Cart: Diva Knitting

  5. #5
    Join Date
    Mar 2006
    Posts
    200
    Plugin Contributions
    0

    Default Re: sql tables won't update from admin

    Quote Originally Posted by plymgary1 View Post
    First of all I would BACKUP your site and SQL database in case what I suggest messes up your site.

    Remove everything to do with testimonial manager from your site. Do the admin changes save then? If so, you've at least narrowed it down to TM being the culprit.
    I was hoping there would be an easy answer but that was next on my list to try.
    Zen Cart: Diva Knitting

  6. #6
    Join Date
    Mar 2006
    Posts
    200
    Plugin Contributions
    0

    Default Re: sql tables won't update from admin

    Quote Originally Posted by Steven300 View Post
    Are you sure you installed the security patch correctly? One of the symptoms of an incorrect security patch installation is not being able to save changes in the admin panel.
    Just for fun I ran the security patch again before I started deleting stuff...voila, fixed! Thank you so much Steven300. Glad it was an easy fix for once :)
    Zen Cart: Diva Knitting

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    67,622
    Plugin Contributions
    6

    Default Re: sql tables won't update from admin

    Thanks for the update that your Update and editing issues in the Admin were the result of not having the security patch installed correctly ...

    Be sure to review the List of Security Patches to ensure that you are current and up to date:
    http://www.zen-cart.com/forum/showthread.php?t=131115
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

 

 

Similar Threads

  1. cannot login to admin after php update to v5
    By bangsters in forum General Questions
    Replies: 22
    Last Post: 26 Jun 2009, 07:09 PM
  2. Using Navicat to update tables ?
    By tony_sar in forum General Questions
    Replies: 6
    Last Post: 2 Dec 2008, 12:26 AM
  3. Changes in Admin not written to database tables correctly
    By lhollo in forum Basic Configuration
    Replies: 7
    Last Post: 7 May 2008, 05:32 PM
  4. fresh database update, which tables?
    By raimond in forum Upgrading from 1.2 to 1.3.x
    Replies: 4
    Last Post: 25 May 2006, 09:39 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
  •