Joomla 3.x. Troubleshooter. CSS files are missing in template manager

This tutorial is going to show you how to add a query to the database in order to have CSS files available for editing from Joomla admin panel.

Joomla 3.x. Troubleshooter. CSS files are missing in template manager

In some cases CSS editor is missing in Joomla 3.x. admin panel. You can see the list of files, but they can not be edited.
You can go to Extensions -> Templates Manager -> Templates, choose the default theme – ThemeXXXX to check:

We should follow these steps for troubleshooting the issue:

1. First of all, we need to check database and prefix table for the website. From Joomla Admin Panel, go to System -> Global Configuration -> Server tab to check the database name and table prefix:

   

2. Go to phpMyAdmin -> Select the right database name for this joomla website from the left side:

   

   We should make a backup for this database just in case. Click Export tab -> then click Go button -> Click OK button and save .sql file.

   

3. Open SQL tab:

   

   Add the code below to the content box:

   ?

   1 2	UPDATE `jos_extensions` SET `params` = '{"template_positions_display":"0","upload_limit":"2","image_formats":"gif,bmp,jpg,jpeg,png","source_formats":"txt,less,ini,xml,js,php,css","font_formats":"woff,ttf,otf","compressed_formats":"zip"}' WHERE `jos_extensions`.`extension_id` =20;

   Make sure you replace all ‘jos_‘ with your prefix table that you have checked from step 1. Press ‘Go‘ button:

   

4. Log into Joomla admin panel. Go to Extensions -> Template Manager‘ -> Templates -> ThemeXXXX. Refresh the page to see that now we have access to the template css files:

   

Feel free to check the detailed video tutorial below:

Joomla 3.x. Troubleshooter. CSS files are missing in template manager