You have already seen the Joomla! front page in the chapter one. I will describe it differently in this chapter. Watch the blocks in the picture 2.2. Generally, we can group the blocks as you can see in the picture 2.3.

Picture 2.3 The blocks default structure in Joomla!
The structure that is shown in the picture 2.3 is the structure that you get in the time of Joomla! installation. Of course, it will change while you are adding or changing the modules. After learning this book, you will have the ability of reorganizing anything in the Joomla! page. In the next sub chapters, we will discuss each block in the default structure.
Next, we will install Joomla! In this tutorial, we will use Joomla! 1.5.3.
Beneath are the steps in instalating the Joomla! 1.5.3:
1. Download Joomla! 1.5.3 from the Joomla! official site. There are various choises of compression. The writer use Joomla_1.5.3-Stable-Full_Package.tar.gz.

Picture 1.17 Joomla! compression file
2. Next, extract the file by clicking right of it then choose Extract to joomla_1.5.3-Stable-Full_Package\ as you can see in the picture 1.18. But with one condition, you use Winrar.
Read the rest of this entry »
Before doing the Joomla! installation, you have to prepare the database that will be used during the installation. Here are the steps:
1. Open your browser. Then type http://localhost/phpmyadmin address. You will get the appearance as in the picture 1.14.

Picture 1.14 Login form before enter the database manager
2. Fill user name and password as you already set in the time of the AppServer installation. Then click the OK button.
3. In the phpMyAdmin front page, enter the database name that you want for Joomla! For example, joomla. Look at the picture 1.15.

Picture 1.15 Make new database named joomla
4. Click the Create button to execute the making of the new database so called joomla.
If you get the appearance as in the picture 1.16 means that the new database is succeeded in made and get ready to use to receive the data from Joomla! Next, we will install the Joomla!

Picture 1.16 New database named joomla has been created
In this training session, we will use AppServer. You can download the AppServer package at www.appservenetwork.com. You can use 2.5.x. version. In this version, you will get PHP 5. If you download 2.4 versions, you will get PHP 4. I suggest you in using 2.5.x.
Beneath are the steps of AppServer installation:
1. Click twice the AppServer setup.

Picture 1.1 AppServer setup file

Picture 1.2 Wellcome page
2. You will get the welcome page as you can see in the picture 1.2. Click the Next button to continue. You will get the agreement page as you can see in the picture 1.3.
Read the rest of this entry »
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD).
You can also (and should, if possible) use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 12.5.2.3, “CHECK TABLE Syntax”, and Section 12.5.2.6, “REPAIR TABLE Syntax”.
Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these:
· tbl_name.frm is locked against change
· Can’t find file tbl_name.MYI (Errcode: nnn)
· Unexpected end of file
· Record file is crashed
· Got error nnn from table handler
Read the rest of this entry »