Maintenance functions

The maintenance form supports with sub forms several functions to check and repair the rsgallery2 image and database universe.

Each grey array is a button to click on. In most cases a sub form will open where more info or actions are provided

Zones

• Rsgallery2 zone

  Handles slideshows and templates

• Repair zone

  The image file system can be checked to match the database. Also the configuration can be checked here.

• Danger zone

  Delete database entries and database structure

• Raw database zone

  A window to the pure content of the database (lists)

• Outdated zone

  Door to old view of functions like image/galleries lists

• Upgrade (from 1.x / 2.x) zone

  Helpers after upgrading RSG2 from previous J!x versions

Rsgallery2 zone

(1) Slideshow configuration

Edit and check the configuration parameters of installed slideshows. Leads to a separate view for the edit of slideshow parameter.
See separate maintenance document ""

(2) Comments list

Enters list view of comments

(3) Template manager

Actually not working. (2014-2018)
In older version it had the function to upload slideshows and templates for the display of the gallery in frontend. These could be edited or deleted also.

Repair zone

(1) Consolidate image database

The consistence of the database to image files can be checked here. The following view supports the check and repair of image orphans in database or as missing image files.

(See separate maintenance document "")

(2) Configuration Raw edit

Edit view of all config variables including internal settings. Prepared for debug and emergency situations. Lists all variables in alphabetical order. The values can be changed and saved.

(4) Regenerate display images

This option will regenerate either thumbnail or display images, based on the current configuration settings of thumbnail dimensions

(5) Optimize database

Reorganizes the physical storage of the database table data to reduce storage space and improve speed when accessing the table

Danger zone

(1) Purge tables (data) & delete all images

Supports the first step to remove RSGgallery2 completely.

Therefore the content (items) in all RSGaller2 tables are removed. Additionally the image files are deleted. The data structure is kept but is empty.

This can also be used to purge the data and start again empty with new images and new galleries.

If afterwards the component is de installed nothing shall be left and remind of RSGallery2

(2) Remove RSGallery2 tables and images The previous intention was to support the uninstall that by removing databases tables and image files. The side effect of this function was that Joomla! did start with error and RSGallery2 could not be uninstalled

Instead of using this function begin with above function 'Purge tables (data)' See following instruction for a complete remove

How to remove RSGALLERY2 completely

(1) Use Maintenance -> Purge tables

This removes the database content and the image files

(2) Prepare the remove of database table structure

Search in admin rsgallery2 folder \administrator\components\com_rsgallery2\sql\ for file uninstall.mysql.utf8.sql. Edit the file and remove the comments in front of the drop commands.

(3) Standard uninstall

Use finally standard Joomla uninstall to get rid of all parts of RSGallery2

Raw database zone

The buttons lead to the pure content view of the database lists

(1) Configuration variables

Shows a list with actual values of all configuration variables

(2) Images list

Shows a list with the database properties of all images. This contains more columns as the normal image view.

(3) Galleries list

Shows a list with the database properties of all galleries. This contains more columns as the normal image view.

(4) Comments list

Shows a list with the database properties of all comments. This contains more columns as the normal image view.

Outdated zone

Door to old view of functions like image/galleries lists These buttons lead to the previous views of RSG2 around 2013 or beginning of J3x
the functionality is not granted as this old code is not maintained any more. Still it may be a hint what has improved over this time

(1) Configuration

%

(2) Mange galleries

%

(3) Manage images

%

(4) Upload single images

%

(5) Consolidate database

Don't use. It is only listed for completeness

Upgrade (from 1.x / 2.x) zone

(1) Database

Repair missing database tables, table columns and ... This function reassigns the actual SQL definitions. Therefore new tables, new columns are added and not supported columns are removed

This is useful when upgrading from a real old version and general list can not be viewed

(2) Create gallery "access" field

On upgrade from 1.x this table field was missing. Here it will be created and all values set to one

(3) Delete RSG2 base language files

Deletes RSGallery2 languages files in joomla base language folders. The RSG2 base translation files are located in ...\administrator\languages. These may overwrite new RSG2 language items kept in component language folder.
Use this function when an update installation does not overwrite "old" base language files and translations do not appear or appear as old.