I got quota warning email sent to my email. Exceed 80% of quota already but since I never add any new file and database grow also not significant I decide to find out if cpanel system  add something that I don’t know.

Error log is responsible for this problem.

# ls -l | grep log
-rw-r–r– 1 externa2 externa2 346169667 May 1 15:57 error_log
-rw-r–r– 1 externa2 externa2 274 Dec 14 06:29 wp-blog-header.php
-rw-r–r– 1 externa2 externa2 27695 Dec 14 06:29 wp-login.php

As you see I have around 346 MB size of error log file.

Empty this file and I have spare room 🙂

#echo ‘ ‘ > error_log

P.S : in case of you want to know what kind of error that might cause your log file got bigger in size you can use tail -f command.

# tail -f error_log

voila ….

[01-May-2012 23:08:04] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY `meta_count` DESC LIMIT 5’ at line 1 for query SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = ORDER BY `meta_count` DESC LIMIT 5; made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array, call_user_func_array, relevanssi_query, relevanssi_do_query, relevanssi_do_excerpt, apply_filters, call_user_func_array, pk_stt2_admin_content_filter, stt_terms_list, pk_stt2_db_get_search_terms
[01-May-2012 23:08:04] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY `meta_count` DESC LIMIT 5’ at line 1 for query SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = ORDER BY `meta_count` DESC LIMIT 5; made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array, call_user_func_array, relevanssi_query, relevanssi_do_query, relevanssi_do_excerpt, apply_filters, call_user_func_array, pk_stt2_admin_content_filter, stt_terms_list, pk_stt2_db_get_search_terms

Wow, this plugin need to deactivate as I don’t use it intensively.

P.P.S :

Those command is command line that you can use as long your web host support ssh access. For a list of web host that offer ssh access you can access resources section.

Beside trying Amazon affiliate I also try Clickbank program. Almost a one and half year I try ClickBank with article marketing approach. One sale followed by another sale until my website got ‘Panda touch’ 🙂 .

No sale for month and continue to hit ClickBank Dormant account policy.

As you see from the picture I got $31 ‘discount’  due to no sale happen 🙁

My account also stay in CDR status too. Clickbank will not release my first check if I don’t met 5 sales and different credit card requirement.

I need help to overcome ClickBank CDR status and CB Goliath come to rescue.

I install CB Goliath and got result in week 2 after activate and setting.

I set a few keywords on CB Goliath including sell cheap ebook too . Not bad for me since I can get rid from dormant status and chance for release my CDR status very soon.

That is my technique to overcome ClickBank CDR by increase sale with help from CB Goliath.

Create Squidoo lens is not easy today. I’ve spend a few hours to craft and put many aspect to the lens and still get the message :

“low quality content”

Solution for this problem :

1. Edit all content. Rewrite if possible and try to publish.

2. Delete the lens. Try to create new lens with longer title and put the content slowly. After you add a text module then you can hit “publish” button and continue adding other module when you see published message.

3. Move the content. I prefer to move ‘unpublish’ content to other platform and  make it live. This way I can add more assets and link properti that I can use in the future.

Some platform I use when I get stuck at squidoo ‘low quality content’ and still can not get it published are :

• Hubpages ; I use it for alternative when squidoo fall to publish my content.
• Zujava ; new platform that allow you to publish ‘leaf’ (name for pages on zujava)

Example of Zujava leaf in action : How to install  Moodle

I use Ampps for almost 2 month and I like it. This software has ability like wampserver that provide 2 php version and I can switch it anytime I like and full access to many famous open source application.

Ampps also follow latest technology, thay release new version when new version of its component got upgrade.

In this post I’ll share how to upgrade ampps step by step. Lets get start!

Check current version component :

Target

Get proper version for update (make sure you follow the path) and click download.

save to my document or anything you want.

Double click to start install update

Click Next followed by Install button.

Follow all process.

Before restart web server I want to check its PHP version.

Click launch ampps after upgrade complete and restart apache web server for sure.

Checking again php version with phpinfo() version and I see new PHP version exist.

Yes, I have new PHP version 🙂

Blogspot service is great. Everything is handle with care using Google service. I also try blogspot custom domain for one of my domain to share the load of my shared hosting. So far so good until I check statistic for that domain. A page is not exist and when I try to see it I see the same.

Yes, page not found is there and I must do something.

I must set missing host section on blogspot to point specific url where I can redirect the traffic to main domain.

I have shared hosting account on bluehost and want to use it for pointing missing host to blogspot.

Lets get start!

1. Login to bluehost cpanel and click “addon domains”

2. Verify ownership for this domain. Upload file is the easiest but I already set it for blogspot custom domain so I must use other option. I prefer to use  EPP code for domain ownership verification.

3. Login to godaddy and choose ‘send by email’ for authorization code.

4. After domain verification is correctly set I can create a subdomain.

5. Subdomain redirection.

Set redirection for this subdomain to main domain and click save.

6. Login to blogspot and enter sub domain created on step 5.

click save.

great, at this moment I have working system that redirect any ‘not found’ traffic to main page of my domain. As you see from the picture, I’ve convert 41 useless traffic to main page using this way.

Your setting is vary, depend on your domain policy but I hope you got the point.

A client contact me to change his nameserver back to godaddy hosting since he   already paid for the hosting but not realized about that until he login to his account.

I have set his hosting to use hawkhost but as his wish is my command 🙂 I just do that.

How to change nameserver back to godaddy is simple :

1. Login to godaddy and choose the domain.

2. Change to ‘I want to forward my domains’

3. Change back to ‘I have specific nameservers for my domains’

Click save and wait for while.

You also able to send ticket to godaddy and let them do it for you 🙂

I like to use cron as best friend to do a job that periodically need to perform.  In my opinion cpanel hosting provide easy to understand and reliable cron service too. I’ve try a few free cron service out there but I still confident with service provided by cpanel.

To access cron from cpanel you can click “cron jobs” by scroll down on your cpanel.

Cpanel cron provide ‘template’ where you can do simple task. You can run a task every minute, every 5 minutes and so on.

If you want specific time you can arrange it by enter the value inside provided box as you can see from this picture.

Click “Add new cron job” to let system know about it.

What if you don’t have cpanel based cron? You can use service from “Corntab“.

You can enter set the time and corntab will automatically create the result that you can paste to your crontab editor.

Caution :

Use your cron  facility wisely as you need to perform this job in regular. Don’t use short interval too often. Use it as necessary.

Another  wordpress malware case solved. I just want to answer this question as I believe not everyone care about it.

What characteristics does a good web hosting  must have?

Well, I strongly believe on Good support (24×7 would be great, if not possible choose web host that provide live chat as you always welcome to ask).

Another technical point is “able to keep up with technology”. I will never choose web hosting company that use old technology. Always upgrade whenever possible.

For example I found this on recent cpanel case based web hosting :

Wow, PHP 5.2.11 is very..very..very outdated man.

See this for my recommended web hosting

PHP 5.2.17 is the latest version for PHP 5.2 path.

Want to see another software?

compare with this one.

phpMyadmin is one of well known application that online marketer, blogger and more profession use. By using old version you also open yourself for attack or another hacking attempt.

I’ve check my current web hosting. They use old software. What should I do?

Simple, change your web hosting and move the files by yourself or hire someone to do that for you (you can contact me to discuss your requirement or see my current service offer). You can focus on your business and make profit.

Stay health!

Hahaha, my title just little too much 🙂 . Yes, being busy with adding useful content for my fresh store builder website. Adding more article from my own research, compile it into article and some checklist for new user.

After follow all checklist preparation that FSB provide I let it go for 1 day until I realize I don’t enable it for the world.

Here little steps taken to do that :

1. Login to your FSB admin page

2. Pay attention to Tools section

Click Tools -> Change Parameters

Click Store Settings

Change Site Live parameter from 0 to 1

Click “Save All” button.

Once you do that you have working fresh store builder page ready to serve the world.

One task that I used to do during transfer wordpress from one host to another host is export database and import database.

Due to difference of control panel that each web hosting provide sometime I don’t found phpmyadmin installed and I need solution for that job.

I’m lucky that google provide everything 🙂 . A few project beside phpMyadmin provide me excellent tools to accomplish my job in time. Here’s a few project that do similar work as phpMyAdmin.

1. Admirer, small size. Under 400k
2. phpMiniAdmin for MySQL, very small size with limited capability but enough for me. Under 10k. My fav.
3. SQl Buddy, close competitor to phpMyadmin (imho).
4. TinyMy, 7 k but I don’t try it yet.
5. Chive project, I use it for learn advanced feature of MySQL server like Routines, Trigger and Views.