Overview

All contents and settings created and modified in the widgets are stored in a history table. Each time you save the configuration screen of a widget, a backup copy is stored. By default, the last 20 validations are stored.

These backups can be restored at any time.

 

Instructions

If you are using the pro plan or premium plan, you can recover the old contents in the configuration screen of the widget. If you are using the free plan, you can do a manual recovery if you have mysql skill, or you can buy the pro or premium plan of NextGenEditor to do it easilly in the screens. Even if you buy the plan after you content is lost, you will be able to recover it.

 

- Go in the configuration screen of the widget. Either in your editor, click on the widget icon and the NGE button in the editor toolbar, either in frontend, unlock the page, and click on the configuration button on the small toolbar over the widget.

- Choose a recovery date to see its preview.

- Click on the "Recover" button

 

 

 

Manual recovery

History recovery in the screen is only available in pro and premium plans. But you can have critical situations where your content is lost. You can do it anyway by yourself.

In your Joomla mysql database, all the widgets are stored in the #__nge_parts table. All history is stored in the #__nge_parts_history. You can find the old contents and settings in the history table, and copy them in the current table.

- Find the current widget id, for example searching a word or some text.The field "id" contains the id you are looking for. : mywidgetid. The fields "part" and 'created" by can help you to find the good record.

SELECT * FROM myprefix_nge_parts WHERE content like "%mytext%" 

 

- Find the old content : find the backup id in the field "id" : mybackupid.

SELECT * FROM myprefix_nge_parts_history WHERE part_id = mywidgetid ORDER BY created DESC

 

- Replace current content and/or settings by the old one : "content" field contain all contents, "params" field contains all settings (options and display)

UPDATE myprefix_nge_parts SET content = (SELECT content FROM myprefix_nge_parts_history WHERE id= mybackupid), params=(SELECT params FROM myprefix_nge_parts_history WHERE id= mybackupid) WHERE id=mywidgetid