What?
A quick article for Joomla CMS version 3.x on resolving a menu item alias conflict:

Warning
Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent

You will need:

• Access to the Joomla Administration Panel (to check for and remove expired menu items)
• A good database administrator who is comfortable with making changes to the database

What?
A quick article on how to set a password using the database tools for super users.

Why?
It happens to us all, especially me. I like to use different passwords for every site but this came up as a client had lost their super user password.

How?
This method is reliant on having access to the database of your Joomla website.

Applies to

• Joomla CMS v2.5.14

What?
This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked).

If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and they would be able to login. Was the problem authentication? Restricted access to a component? A load of blab on ACL managers?

How?
In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root".

APPLIES TO Joomla 2.5.x

Why?
I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For obvious reasons, these cannot be hardcoded.

What?
A quick article on how to use the where clause in a joomla database query.

Why?
In response to a member, I use the old form where I can include the whole SQL statement:

$db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true')

Method #1 - chain:

What?
Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why?

Why?
I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS.

How?
I could just type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your Joomla website. Access the page from a browser and you should get all your users listed... For security reasons, delete the file after you have used it.

IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO ACCESS!!! DELETE IT AFTER USE.

What?
Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and for v2.5.x

This article applies to Joomla 1.5.x, 2.5.x and 3.x.

What?
This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install.

How?
Source: Joomla! • View topic - Cannot get recaptcha to display on registration form...
There are two solutions I have found that fix the problem: