|
Cristi Constantin
|
September 25, 2013 at 2:47 am
Due to testing on another topic, I had accidentally reset my ‘events_organization_settings’ av_options. I restored a database backup containing sql instructions. Even so, my organization settings page is still empty. Even if I manually run a similar sql instruction, when I acces the page, the content of the database option is instantly reset.
<code>
update av_options set option_value = 'a:62:{s:12:"organi[...]'
where
option_name = 'events_organization_settings';
</code>
(sql is not complete, obviously)
|
|
Josh
|
September 26, 2013 at 11:16 am
Hi Cristi,
One thing you could do is check out how Event Espresso sets this table up. If you look at the events_organization_tbl_install() function in /includes/functions/database_install.php. One thing you could do is copy, adapt, and run a similar function one time to restore the ‘events_organization_settings’ table.
|
|
Cristi Constantin
|
September 28, 2013 at 7:04 am
I have managed to fix this. It is caused by improper sql backup and restore of columns containing multi-line data, like the email templates set in the organization page of Event Espresso. Otherwise said, everytime a newline (\r\n) is exported, the plugin which created the sql backup has written 2 characters representing \r\n (which translated as a newline), instead of writing 4 characters (\, r, \, n). This broke the imported data serialization and the settings could not be read by EE.
For reference, the plugin which caused the issue is Better WP Security (I have posted a bug description for them, maybe for other installations it works ok, though), and the plugin which created a good backup is BackWPup.
|
