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
Handles slideshows and templates
The image file system can be checked to match the database. Also the configuration can be checked here.
Delete database entries and database structure
Raw database zone
A window to the pure content of the database (lists)
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
(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.
(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
(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.
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
(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
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.