Drupal 7.0 has been officially available. The most exciting release and one of the best open source content management systems with more flexibility options and more usability improvements. Almost 1% of all the websites in the world are powered by Drupal.

“About 1,000 people contributed to Drupal 7. It is a legendary piece of work, by the community, for the community. On Friday, we celebrate the release with 248 parties in 88 countries. Make sure to buy these people a drink.” Said Dries Buytaert, Drupal Founder.

Thousands of add-on modules and designs let you build any site you can imagine, you can create new content types using the Drupal Core, you can add custom texts, images, and file-fields to the content and users as well. There is no doubt that Drupal has gained a good reputation during the years. Today, it is being used in by government agencies, universities, non-profits organizations, and individuals.

When installing Drupal, some built-in modules for services like OpenID, forums and contact forms, can be enabled and disabled.

The problem is mainly from the database and while the installation, some fields were not created. So what you should do to fix this is to upload the /install/ directory again and run yourwebsite.com/install/upgrade.php It will ask you whether you want to upgrade the database and the language file; once the upgrade is successful, the function will work perfectly.

Pligg team has announced that they are working to solve the issue as soon as possible. I will update this post when the problem is fixed.

UPDATE: Pligg 1.1.3 has been updated and the fix is included.

I have pointed in my last article that Google Page Rank (PR) update is gonna take place soon, approximately at the end of 2010, webmasters would definitely want to check their Page Rank which is obviously one of the most important factors that affect the SERP (Search engine results page).

Popuri.us

I have discovered this website recently and I believe is one of the best. The website responds very fast. Also, you can get other information about your domain such as Alexa Rank, Compete Rank, Quantcast Rank, Google BackLinks, Yahoo BackLinks, Live Search BackLinks, Technorati Links, and del.icio.us Bookmarks.

Dig PageRank

One of the easiest tools to use. It checks the PR within multiple datacenters and returns the pagerank immediately.

PR Checker

A very popular tool for checking the pagerank. However, you need to insert the Captcha!

Bulk PageRank Checker

With Bulk PageRank Checker you can check multiple domains at the same time! Although it is a bit slow, you will get accurate and whole design is just simple.

Xinureturns

This tool checks other several services such as the rankings, social media bookmarks statistics, and the backlinks from a number of search engines.

Check Pagerank

Similar to “Pr Checker”. You have to insert the Captcha.

WebToolHub – Pagerank Checker

You choose the datacenter IP and you are ready to go.

Recently, I wanted to upload a 10GB SQL file to MySQL using PhpMyAdmin. unfortunately, it didn’t work properly. the fields were created in the database but with no records. It seemed to be a memory and PHP configuration issue. After that i made some searches. And eventually, figured out that there is a script called BigDump is made for this purpose.

To restore the very large backup of your mySQL database (or a part of it) into the new or the same mySQL database. You can’t access the server shell and you can’t import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web server. -ozerov.de/bigdump.php

alright, so now all what you gotta do is to follow these steps:

• Download the script (10 KB ZIP archive).
• open BigDump.php with any text editor. Edit your MySQL connection information.

$db_server   = '';
$db_name     = '';
$db_username = '';
$db_password = '';

• Upload the script (bigdump.php) to your server.
• Upload the SQL (.sql) file to your server.
• Go to http://www.mywebsite.com/bigdump.php and from there you can start the process.

• Click on Start Import and you are done! Congrats.

For more information and detailed steps, you can visit BigDump homepage.

Informing search engines that your site content has been updated is an important task. Google downloads your site-map automatically every few days, or even few hours If you are running a big website. However, Webmasters like to ping Search Engines automatically after every update on the website. Here are few links for several search engines that you may want to ping.

1. Google

http://www.google.com/webmasters/tools/ping?sitemap=http://site.com/sitemap.xml

2. Yahoo

http://search.yahooapis.com/SiteExplorerService/V1/updateNotification?appid=YahooDemo&url=http://site.com/sitemap.xml

3. Bing

http://www.bing.com/webmaster/ping.aspx?siteMap=http://site.com/sitemap.xml

4. Ask

http://submissions.ask.com/ping?sitemap=http://site.com/sitemap.xml

If you are using WordPress, All-In-One-Seo does this every time you publish a new post. I have made a function if you don’t want to make the ping request manually.

File Name: pinger.php

<?php

function pingSE($url){
@file_get_contents("http://www.google.com/webmasters/tools/ping?sitemap=" . $url);
@file_get_contents("http://search.yahooapis.com/SiteExplorerService/V1/updateNotification?appid=YahooDemo&amp;url=" . $url);
@file_get_contents("http://www.bing.com/webmaster/ping.aspx?siteMap=" . $url);
@file_get_contents("http://submissions.ask.com/ping?sitemap=" . $url);
}

// using the function..

pingSE("http://site.com/sitemap.xml");

?>