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

sql tables won't update from admin

Locked
Results 1 to 7 of 7
This thread is locked. New replies are disabled.
02 Aug 2009, 22:33
#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!
03 Aug 2009, 00:45
#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.
03 Aug 2009, 00:50
#3
steven300 avatar

steven300

Totally Zenned

Join Date:
Jan 2008
Posts:
1,564
Plugin Contributions:
0

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.
03 Aug 2009, 02:21
#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?
03 Aug 2009, 02:22
#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.
03 Aug 2009, 02:30
#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 :)
06 Aug 2009, 15:40
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
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