Archive for October, 2012

How to fix links not working error after moving server files in WordPress

If the home page showed up just fine, but posts and inside pages all went right to File Not Found 404 pages. Then do the following steps

Step 1
 
Login as administrator and goto Dashboard.
 
Step 2
 
Go to Dashboard > Settings > Permalinks and simply clicked “Save Changes".
 
No need to change anything. Just click the save changes button then wordpress remove the errors automatically .
Reload your wordpress site and check the links. 
 

Read more »

Hide the guest account on ubuntu 12.10 from the logon screen

 

Here’s a quick way to hide the guest account from the logon screen. 

To get started, press Ctrl + Alt + T on your keyboard to open the terminal. When it opens, run the commands below to hide the guest account from the logon screen.
 
sudo sh -c 'echo "allow-guest=false" >> /etc/lightdm/lightdm.conf'
 
Restart your computer and the guest account should be gone.
 

Hide gust account in ubuntu 12.10


Read more »

How to use GROUP BY and ORDER BY together in SQL

Step 1

First you need to create one table named employee with 9 fields.

CREATE TABLE employee (
 
    id int unsigned not null auto_increment primary key,
    firstname varchar(20),
    lastname varchar(20),
    title varchar(30),
    age int,
    yearofservice int,
    salary int,
    perks int,
    email varchar(60)
); 
 
Step 2
 
Insert some dummy values into the employee table
 
INSERT INTO employee (firstname, lastName, title, age, yearofservice, 
salary, perks, email) values ("James", "John", 
"Programmer", 31, 3, 120000, 25000, "jj@gmail.com");
 
INSERT INTO employee (firstname, lastName, title, age, yearofservice, 
salary, perks, email) values ("Joe", "Mathew", 
"Teacher", 42, 4, 186000, 32000, "jm@gmail.com");
 
INSERT INTO employee (firstname, lastName, title, age, yearofservice, 
salary, perks, email) values ("Jobin", "Thomas", 
"Programmer", 28, 1, 236000, 36800, "jt@gmail.com");

Read more »