Site maintenance: Sun 15 Nov, from 12:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / General Questions / sql tables won't update from admin

sql tables won't update from admin

Locked

Started by cherylkemp on 2 Aug 2009, 10:33 PM · Views: 2,151

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
2 Aug 2009, 10:33 PM
#1
cherylkemp avatar

cherylkemp

Zen Follower

Join Date:
Mar 2006
Posts:
179
Plugin Contributions:
0

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

3 Aug 2009, 12:45 AM
#2
plymgary1 avatar

plymgary1

Zen Follower

Join Date:
Feb 2009
Posts:
121
Plugin Contributions:
0

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 Aug 2009, 2:21 AM
#4
cherylkemp avatar

cherylkemp

Zen Follower

Join Date:
Mar 2006
Posts:
179
Plugin Contributions:
0

Re: sql tables won't update from admin

Steven300:

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

3 Aug 2009, 2:22 AM
#5
cherylkemp avatar

cherylkemp

Zen Follower

Join Date:
Mar 2006
Posts:
179
Plugin Contributions:
0

Re: sql tables won't update from admin

plymgary1:

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

3 Aug 2009, 2:30 AM
#6
cherylkemp avatar

cherylkemp

Zen Follower

Join Date:
Mar 2006
Posts:
179
Plugin Contributions:
0

Re: sql tables won't update from admin

Steven300:

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

6 Aug 2009, 3:40 PM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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 ... :smile:

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!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!