Change Your Joomla Database Login

This tutorial will show you how to change or verify the database login to your Joomla site. People will sometimes need to do this if:

  • Their site can't access the database
  • They've been hacked and need to make the site more secure

Login to Your Hosting Account

tutuploadsmedia_1274896908052.png

Access Your Database Area

tutuploadsmedia_1274896940023.png

Create a New Database User

tutuploadsmedia_1274897008597.png
Be sure to take a careful note of your password.

Add The New User To Your Database

tutuploadsmedia_1274897085048.png
Make sure to choose the correct user and the correct database, then click "Add".

Give the New User All Privileges

tutuploadsmedia_1274897116590.png

Login To Your File Manager

tutuploadsmedia_1274897157849.png

Open Configuration.php

tutuploadsmedia_1274897191808.png
This is the file that connects your Joomla files to your database. It needs to have the correct username and password.

Update the User and Password Details

tutuploadsmedia_1274897314476.png
Scroll down until you see the $user and $password fields. Insert the information you created earlier. Then click "Save" and check the front of your site to ensure everything is working correctly.

Take Your Joomla Site Offline

This is Part 1 of a series of tutorials on Joomla's offline page:

Joomla has a very nice feature that allows you to test your site in complete privacy. You might just need your site offline for a few minutes, you might want to show it privately to a client, or you might want to keep the site offline for weeks while you build it. Either way, this is a good solution.

Login To Your Joomla Site

tutuploadsmedia_1274895143528.png

Go to Global Configuration

tutuploadsmedia_1274895265250.png

Click on Site then Global Configuration

Site Offline

tutuploadsmedia_1274895329251.png

Set "Site Offline" to "Yes" and then click Save

Visit Your Site

tutuploadsmedia_1274895522044.png

Now when you visit the front of your site you'll see a screen like this. Anyone who has a Super Administrator, Administrator or Manager account can login and view the site as normal. Everyone else will only be able to see the splash. You can keep search engines, rivals and all other unwanted guests out of your site until you're ready.

If you'd like to take this one step further and customize your offline page with a new logo and text, click here for the next tutorial.

Video Showing How to Take Your Site Offline

Joomla Save and Apply Buttons

Save and Apply Buttons

tutuploadsmedia_1273793540132.png

Many, many screens in a Joomla site have both "Save" and "Apply" Buttons. This tutorial will show you the difference between the two.

Go to SIte >> Global Confiuration

tutuploadsmedia_1273793610525.png

Change the Site Name Field

tutuploadsmedia_1273793670174.png

Change the "Site Name" field to something different (this is just an example, you can try changing anything on any page with a Save and Apply button).

Click Apply

tutuploadsmedia_1273793742631.png
  1. Click on Apply
  2. Notice that there's a message "The Global Configuration details have been updated"
  3. Notice that you're still on the same "Global Configuration" page

Click Save

tutuploadsmedia_1273793867830.png

This time we'll try clicking the "Save" button.

tutuploadsmedia_1273793945123.png

This time you still get the "The Global Configuration details have been updated" message but now you've been logged out of the screen.

So what's the difference between Save and Apply?

  • "Save" saves your changes and forces you out of the current screen
  • "Apply" saves your changes but keeps you on the current screen

Joomla Text Wrapping Around Images

This tutorial will show you how to get text to wrap neatly around your images inside Joomla articles.

Place Your Cursor in an Article

tutuploadsmedia_1273756985924.png

I want my image to appear at the top of the article so I'm going to place my cursor before the first text.

Use the Image Button

tutuploadsmedia_1273757040201.png

Scroll to the bottom of the article and click on the Image button

Click on an Image

tutuploadsmedia_1273757330201.png

Click on the image you want to use and its location should appear in the "Image URL" field. Then (and most importantly) chose either "left" or "right" from the "Align" dropdown. Finally, you can can click on "Insert".

Example of Align Right

tutuploadsmedia_1273757521082.png

This is what your image and text will look like if you choose "right" in the "Align" dropdown.

Example of Align Left

tutuploadsmedia_1273757605346.png

This is what your image and text will look like if you choose "left" in the "Align" dropdown.

Add Code to Your Joomla Site Footer

This will show you how to add code to your Joomla site footer. Often websites such as Google Analytics will ask you to place code at the very bottom of the your site. They do this so that if their code doesn't load, your site still will. If the code was at the top of the site and had a problem, your whole site would go down.

Login to Your Joomla Site

tutuploadsmedia_1273587493154.png

Go to example.com/administrator and login to your site.

Go to the Template Manager

tutuploadsmedia_1273587541493.png

Click on "Extensions" and then "Template Manager"

Open Your Default Template

tutuploadsmedia_1273587690869.png

rhuk_milkyway is my default template so I'll click on that name.

Open the Template Files

tutuploadsmedia_1273587749835.png

Click "Edit HTML" in the top-right corner.

Enter Your Code

tutuploadsmedia_1273587819052.png

Scroll all the way to the bottom of the page and post your code right above the final lines: . Then click "Save" in the top-right corner and you'll have finished.

Adding a Joomla Template Variation

This tutorial was written for a student who wanted two copies of this template - one narrow and one wider. More advanced frameworks such as Gantry can do this, and Joomla 1.6 will be able to do it.

However, the easiest way to do this in Joomla 1.5 is to make two copies of your template that you can modify separately. Here's how to do it:

Login to Your Hosting Account

tutuploadsmedia_1273508401924.png

You can login via your hosting company's site or you could go via FTP. Essentially you just need a way to get to your files.

Find Your File Manager

tutuploadsmedia_1273508439999.png

Every hosting company should give you access to your files, althought the access may be in different places with each host. This is an example from the popular CPanel software.

Find Your Templates Folder

tutuploadsmedia_1273508517344.png

We're going to open up the folder that contains our templates.

Copy Your Template

tutuploadsmedia_1273508579840.png

Select the "rhuk_milkyway" folder and click "Copy"

Choose a New Template Folder Name

tutuploadsmedia_1273508737371.png

Choose a new name for the folder. In this case, I'm simply going to call it "rhuk_milkyway_copy" and click "Copy File(s)"

Open Up Your New Template Folder

tutuploadsmedia_1273508825430.png

Open Up the templateDetails.xml File

tutuploadsmedia_1273508849941.png

Check the box next to "templateDetails.xml" and select any of the editing options. templateDetails.xml is the table of contents for our template and contains all of the identifying information that Joomla needs.

Change the template name

tutuploadsmedia_1273509045960.png

Inside the fields, change the name of the template to something that clearly identifies it as a copy.

Access Your Template Manager

tutuploadsmedia_1273509130425.png

Now if you go to Administrator >> Extensions >> Template Manager you should see the two copies of the same template.

Move a Joomla Site from Test Directory to Live

This tutorial will show you how to move a Joomla site from one directory to another using CPanel. One common reason for doing this is to move Joomla from a test folder and make it live. Joomla 1.5 makes this process very easy.

Login into your CPanel

tutuploadsmedia_1273177729964.png

Often you can access your CPanel just by adding /cpanel to your domain name ... example.com/cpanel

Access the File Manager

tutuploadsmedia_1273177795056.png

Although your screen may not look 100% identical to the one above, every version of Cpanel does come with a "File Manger" option somewhere.

Choose to Go to the Webroot

tutuploadsmedia_1273177848646.png

Open Your Test Folder

tutuploadsmedia_1273177958153.png

Select All the Files

tutuploadsmedia_1273177994215.png

Click on Move File

tutuploadsmedia_1273178045406.png

Move to /public_html/

tutuploadsmedia_1273178196171.png

Check Your Site

tutuploadsmedia_1273178304131.png

Visit the front of your site in its new location and verify that everything is working correctly.

Login to Your Joomla Site Administrator

tutuploadsmedia_1273178421982.png

Go to Site >> Global Configuration

tutuploadsmedia_1273178514353.png

Change Path to Log folder

tutuploadsmedia_1273178631118.png

Change that setting to remove your /test/ folder

Change Path to Temp-folder

tutuploadsmedia_1273178784889.png

Change that setting to remove your /test/ folder. Click "Save" in the top-right corner.

Find the Right Width for Your Site

This tutorial will show you how to find the right width for your site.

Find Your Own Screen Width

tutuploadsmedia_1272732057139.png

First, we'll find the current width of your screen so you can have an idea of how large these sizes are. Most of the time it will be in your computer settings:
- For my Mac its Apple icon >> System Preferences >> Displays
- For my PC its Start >> Control Panel >> Display >> Settings
In this case my screen is 1680x1050.

Find Your Visitors Most Common Screen Sizes

tutuploadsmedia_1272732169985.png

Your own screen probably isn't the best width to use. I'd go to Google Analytics and check what the most common screen sizes are for your site visitors. Go to Visitors >> Browser Capabilities >> Screen Resolutions.

Examine the Screen Sizes

tutuploadsmedia_1272732267162.png

Generally the more tech-savvy your visitors, the large the screen. In this case it wouldn't make much sense to have a narrow website width. Ideally our site will be at least close to 1000px. Increasingly widths of around 960px are common.

404 Not Found in Joomla Administrator - JSecure

This is one common solution if you're getting a "404 Not Found" error when visiting your Joomla administrator area. The problem often lies with a good and useful product called JSecure. You normally have to remember a specific URL that was set in the administrator area. For example: mysite.com/administrator?mysecretcode. This stops people from trying to guess your login, but if you forget your secret code ...

Do you see this screen?

tutuploadsmedia_1272638308697.png

If you do, the problem is JSecure. Have you really forgotten your secret code? If so, read on ...

Login to Your Hosting Account

tutuploadsmedia_1272638486132.png

Or you could go via FTP. Essentially you just need a way to get to your files.

Find Your File Manager

tutuploadsmedia_1272638559684.png

Every hosting company should give you access to your files, although the access may be in different places with each host. This is an example from the popular CPanel software.

Browse to /Plugins/System/

tutuploadsmedia_1272638742315.png

You need to access the /plugins/ folder than then the /system/ folder.

Find JSecure.php

tutuploadsmedia_1272638817604.png

Rename the File

tutuploadsmedia_1272638910923.png

Just give jsecure.php a different name and save it. Next time to try to access your site, the 404 error should have gone.

Find and Edit Joomla CSS Problems

This purpose of this tutorial is to show you how to find and fix problems with your Joomla templates. We're going to focus on CSS (or Cascading Style Sheets) because they control very common issues such as fonts, colors and padding.

Download and Install Firefox

tutuploadsmedia_1272633877883.png

No question about it, Firefox is the best tool you can find for fixing problem on your website. Download from https://www.mozilla.com/firefox and install.

Install the Web Developer Plugin

tutuploadsmedia_1272633999346.png

Firefox is useful for the same reason as Joomla ... it has 1000s of amazing addons. The one we're going to use is called "Web Developer". Visit https://addons.mozilla.org/en-US/firefox/addon/60 in your Firefox browser and click "Add to Firefox".

Visit Your Joomla Site

tutuploadsmedia_1272634190531.png

We're going to use the default Joomla for this tutorial.

Diagonse Your Problem

tutuploadsmedia_1272634282384.png

In this example, our welcome message is too small. We'd like to have "Welcome to the Frontpage" in larger text.

Start the Webdeveloper toolbar

tutuploadsmedia_1272634412205.png

Click "CSS" in the toolbar and then click "View Style Information"

Click the item you want to edit

tutuploadsmedia_1272634541732.png

Hover your mouse over any part of the page and a red box will appear around it. Click on that area.

See the CSS Code at the bottom of the page

tutuploadsmedia_1272634659128.png

At the bottom of the page you'll get a lot of information about why that item on your site looks like it does. Here's what's controlling the "Welcome to the Frontpage" line:
1: The file with it's exact location
2: The exact line number inside that file
3: The code at that line number
In this case you can see that the font-size is 1.5em. We'll need to increase that number.

Login to Your Joomla Site

tutuploadsmedia_1272634994062.png

Go to Extensions >> Template Manager inside your site

Click on Your Template Name

tutuploadsmedia_1272635089404.png

Click "Edit CSS"

tutuploadsmedia_1272635142542.png

Open Your Template' CSS File

tutuploadsmedia_1272635315354.png

Browse down to find the template you saw in the previous step called "Find the CSS code at the bottom of the page". Click "Edit" in the top-right corner.

Copy Your Test into an Editor

tutuploadsmedia_1272635529610.png

I'm using Notepad in this example, but any text editor will do. If you have a code editor with line numbers, even better!

Backup, backup, backup, backup, backup, backup!!!

tutuploadsmedia_1272635612434.png

If you're doing this for the first time, you will make mistakes. Backup your file so that you can roll back those mistakes when they happen.

Find Your Code to Change

tutuploadsmedia_1272635729434.png

Search for the code that you find earlier in the tutorial.

Change the Code

tutuploadsmedia_1272635783420.png

Especially when you're getting started, this may involve some trial and error. In this example, I'm going to increase the font-size from 1.5 to 1.7.

Paste Back into Your Joomla Site

tutuploadsmedia_1272635839610.png

Paste the code back into your Template Manager and click "Apply".

Check the Change

tutuploadsmedia_1272636023502.png

Great - in this case the change worked and text is larger. If you the change isn't just what you want, you'll need to go back a few steps to "Change the Code" and try again.

Some Notes

1) This is a process of trial-and-error. Don't expect to get it right first time, ever time.
2) Make one change then check. Make one change then check. If you do that, it's easy to spot a mistake. However, if you make wholesale changes before checking, it will be very difficult to find where you went wrong.
3) If you want to move faster, get an FTP Editor that will allow you to edit this files more quickly and accurately. That however, is for another tutorial :)