All Low Variables Content (200 entries) has Disappeared on Save
We have a site with about 200 Low Variables. The client reports that he went in and added content to two existing variables and when he hit the save button, every single variable on the page lost its content. The variables are there, but no content. Because we're using these for translation on the site, the entire site is now down.
I swapped out the exp_low_variables table from a backed up database and that did not help.
EE 2.4 LV 2.0.3 (however, when this happened it was 2.02, but I upgraded as part of my restoration efforts.)
Replies
Low 15 Mar 2012 19:03
Hmm... I can't think of a reason why that would happen at all... If you go to Design > Templates > Global Variables, can you see the variables plus content there? If you lost the content somehow, it should be in the exp_global_variables table.
If you can, please send me some super admin login credentials so I can take a look myself. You can send it to hi at gotolow dot com.
budparr 15 Mar 2012 19:22
The variables show up, but not the content. I just emailed you the credentials. And thanks for the quick response - I know it's late for you.
Low 16 Mar 2012 09:57
For continuity: restoring a backup of the exp_global_variables table helped.
Why the content was deleted is now under investigation.
James 31 Dec 2013 07:04
I just had a similar issue happen to me. I saved and everything that was in a plain text field was gone. Anything that was in a Wygwam field or Matrix field was not erased.
Low 31 Dec 2013 08:21
Were there a lot of vars on a single page? I can think of no reason why LV would empty out a POST like that; it'd have to be environmental somehow.
James 31 Dec 2013 08:35
16 total fields in that particular group. 1 Wygwam field (that stayed in tact). 1 Matrix with 6 columns (1 text field, 1 Structure field, and 4 Wygwam) and 4 rows.
I believe total there is around 120 total variables across 18 groups. But none of the other variables in the other groups were affected.
Low 31 Dec 2013 08:36
Can you reproduce the problem at all, or was it a one-off? Also, what are you EE, LV and PHP versions? Can you tell whether mod_security is active on your server?
James 31 Dec 2013 08:52
Seems to be a one-off at the moment. It was just a variable save (which I have done quite a few times before). I'm on EE 2.7.3, LV 2.4.0, PHP 5.3.10. Not sure about mod_security. I don't see it mentioned in php info.
Low 31 Dec 2013 09:13
Any other info you can think of? What was the contents of the var you saved? Any other add-ons installed?
I'm away for NYE today and tomorrow, so I won't be able to investigate fully until Jan 2nd.
James 3 Jan 2014 19:08
Hmmm... in terms of the big ones, Structure and Transcribe.
The contents were fairly mixed: html, exp:channel:entries tags, and some js.
I haven't had an issue since that one time. I was able to get the variables table restored from a backup that wasn't too old. The only thing I can think of was perhaps a memory issue when it was saving to the db?
Low 4 Jan 2014 11:30
Well, hard to debug on my side. Can't replicate, so it'll have to be some sort of environmental issue.
Only the vars in the group are saved in one go, so memory shouldn't really be an issue. You could always increase it on your htaccess as a precaution. For now, I'd just keep an eye on it...