Technology Blog

Joomla Frontend Module Editing and Artisteer

From Joomla 3.2, a "Super User" logged into the frontend should be able to edit website modules. This is a great feature that enable you to update the website without accessing the Joomla backend.


In order to use this feature you first need to enable that feature in "Global Configuration"


You can see the configuration setting in the image below, it is called "Mouse-over Edit Icons for........." as you see of the image below I have chosen to activat this feature for both modules and menus. (click on image to expand).




After that setting is configured, a user loggedon to the frontend should be able to see the edit button when hovering over a module on the site.


HOWEVER, if you like me are using Artisteer as your template creation tool, then you will still have a problem as Artisteer out of the box does not support the feature.


You will therefore have to add some additional code in Artisteer under the "Export options" - "CSS Options"


The code to be added is:

.icon-edit:before { content: url('../images/system/edit.png'); }


See picture below (click on image to expand):



Finally you need to save and export your amended template, and then install and activate this, and viola, you should now be able to use the new "Frontend Module Editing" feature on your Joomla website.



Joomla Content Versioning

Joomla is continously improving, and one of the new things introduced in Joomla 3.2 was something called Content Version Control.


Joomla content version activationContent Version Control means that Joomla can be configured to save the last e.g. 10 versions of each article.


I previously used a third party extension for this while on Joomla 2.5, but as this now is a part of Joomla core functionality it is even better.


The only thing you need to do is to activate this function.


Simply do the following to activate Content Version:

1) Login to Joomla Admin

2) Go to Article Manager

3) Click on OPTIONS ( Top right corner)

4) Click on "Editing Layout"

5) Enable Versions

6) Change "Maximum Versions" if you want more than 10 to be stored.

7) Save and Close


You should now have activated the Content Version Control.


From now on you will see a new button on the top of the Article Manager when working on an article. This button is called "Versions", you can click on that so see and rollback/revert to previous versions of your Joomla article. (See image below)

Joomla content version button

403 - You can not login to the site. Please, contact webmaster

A handful of times I have come across the following error after trying to login to the Joomla backend of a website:


403 - You can not login to the site. Please, contact webmaster


The problem is happening on sites I earlier had upgraded from Joomla 1.5 to Joomla 2.5 using the Jupgrade extension.


To solve this problem:

1) Take a backup of your site (just to be sure)

2) To sort this you simply have to login to your database via phpMyAdmin (In your Cpanel).

3) Here you will have to look for the table called "jos_categories" (You will here have to change "jos" to whatever your prefix is.

4) In _categories you will have to look for the column called "extension"

5) Change the name any rows under "extension" called "com_contact" to "com_contact_details"


You should hopefully now be sorted.

Save failed with the following error: You cannot remove your own Super Admin permissions

I have serveral times lately come across some user account related problems on Joomla 3.x. Typically this is happening on sites that I have migrated from Joomla 2.5.x, so the problems might be ocurring on that version as well.


The symptoms are the following:


1) A user cannot login to the frontend of the Joomla 3.x site. After entering the login details and clicking the login button, the user is simply lead back to the login screen, without being logged in to the site. (Funny enough, a superuser can login as normal, and does not seem to be affected.)


2) The other problem I have identified is when I try to add Google "2-factor authentication" for a user, and try saving this, then I receive the error: Save failed with the following error: You cannot remove your own Super Admin permissions


Basically the way to sort this problem is the following:


  1. You need to change a setting in the database. Use phpmyadmin which is provided on most Web hosting packages to access the MySQL database for your site.
  2. Locate the _assets table in your database.
  3. The first entry should be id # 1 and have a name of root.1 and a title of Root Asset.
  4. Edit this entry and change the lft column from a 1 to a zero.
  5. Save the change.


After performing the above steps I find that both problems above are gone.

Recovering your lost Joomla admin password

If you find yourself in the position of having lost your Joomla administrator password, then don't despair. This password can be reset directly in the database by entering phpMyAdmin on your webhosting account.  In phpMyAdmin the simplest option is to change the password in the database to a known value.

These instructions show how to manually change a password to the word "secret" :


1) Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.


2) Find and click on the table with "_users" appended in the list of tables (note: you may have a prefix that is not jos_, simply go to the _users table for your prefix).


3) Click on the "Browse" button in the top toolbar. This will show all of the users that are set up for this site.


4) Find the user whose password you want to change and press the Edit icon for this row.


5) A form will display that allows you to edit the password field.

Copy the value "d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199" into the password field and press the Go button.


6) phpMyAdmin should display the message "Affected rows: 1". At this point, the password should be changed to "secret".


7) Log in with this user and password and change the password of this user to a secure value. Check all of the users using the User Manager to make sure they are legitimate. If you have been hacked, you may want to change all of the passwords on the site.

Cleaning out the Joomla Redirect Links table

After a while the Joomla redirect links table tend to be cluttered with a lot of links, and you might want to remove all these as a part of your maintenance.


To clean out these can take an awful long time, and after these are deleted, you need to do the same again to clear out the trash.


However, the easiest way to clean out all these links and empty the redirect manager table alltogether is to simply empty the table #__redirect_links by using phpmyadmin.