[SOLVED] Error Database Connection Upload Wordpress Wesbite Live

While uploading website from local to live, gives lots of headache and trouble to everyone. Here is the tip, how you can get through and make your website live. 

First Step:

Import a MySQL Database using phpMyAdmin

Before uploading a database from computer to host, you must create new database in server. Click MySQL Database and create a new database.

As shown in above image, create new database and click create button. After that, upload the database that you have backed up in sql format.

1. Open phpMyAdmin by selecting phpMyAdmin icon
2. Select the database in the left menu that you will be working with
3. Click Import in the top menu
4. Under File to Import, click Browse and select the backup file you previously created (it will be either a .sql .zip or .tar.gz file).
5. Click Go at the bottom right

When the database has been imported successfully, you should see a message at the top of the page similar to: Import has been successfully finished, ## queries executed.

Then you will see the tables same as you have developed. Before proceeding further, make small changes in the value of option table. 

Change the value  localhost/yoursite to -> www.yoursite.com

After that upload your WordPress site to host with the help of FileZilla.

See the image that you help to get some information:

Upload your complete WordPress Site, now you will get the actual error because of which you will not be able to run website. 

Now you have to make certain changes in the files that you have uploaded. See the wp-config and wp-config-sample files. Edit the files, replace the database details with that of actual with that of server.

/** MySQL database username */
define('DB_USER', '_______');

/** MySQL database password */
define('DB_PASSWORD', ' ______');

/** MySQL hostname */
define('DB_HOST', 'localhost');


Do not replace the host, in 99% case localhost works.

Now your WordPress site is ready to go,but there is one more thing that you must change (i.e. links)

And finally, one more thing

Login to your Dashboard (www.yoursite.com/wp-admin.php)
Go to : Settings -> General

There change site address (URL) from localhost to the same as WordPress Address (i.e. http://www.yoursite.com)

Save it.


Here you go, your WordPress site that you have developed locally, now runs LIVE.

[SOLVED] Fatal error: Maximum execution time of 30 seconds exceeded

"Fatal error: Maximum execution time of 30 seconds exceeded"

This is the most common problem encountered, this can be overcome by changing certain codes.
For this follow the instruction provided below, hope it will help to solve your problem. 

With regards to the problem, it is with the server configuration PHP configuration. You need to change your max_execution_time PHP variable to a greater value that it is, you can try 90 seconds. If you are on shared host, you can try adding the below given line to your .htcaccess file and check if its works or not:

php_value max_execution_time 90

If not, add below php code to your MAIN ROOT index.php file in the head:

ini_set('max_execution_time', 90);

Also you can follow the steps below:

Browse to C:\wamp\bin\apache\apache2.2.22\bin\php.ini

Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

After that restart wamp server to take effect.

[SOLVED] please correct the errors on this form" adsense error

Many blogger face this problem due to their adsense widgets while setting up their blog. It occurs when we try to add new adsense link using the blogger widgets available. As show in the figure:

There are two simple methods for adding adsense units. First one suggest to add adsense widgets , this is practice by beginners and the second method suggest us to obtain the adsense code from adsense login page and place it to the favorable position in our blog. 

Revenue Improvements

In-order to improve our daily revenue from adsense, we can place the ad unit to the appropriate position in our blog. Adsense link units provides essential support for increasing the adsense revenue. 

Because of this error, bloggers are unable to insert the adsense links units.

So follow the steps given below, that can help you to get rid from the adsense error:

1. Login into adsense and blogger account.

2. After that make sure only two adsense widgets are present in your blog. Since, Google allows only     three adsense units per page. 

3. Then go to your adsense home page.

4. Click the "My ads" tab.

5. Click the "New ad unit" option. 

6. Create any appropriate ad unit as you wish, save it and copy the java script code.

7. Now open your blogger dashboard and click the "layout".

8. Select "add a gadget" option from the blog layout.

9. Now choose the HTML/ JavaScript gadget. 

10. Now paste the java script code into the new gadget content (as obtained from step 6)
      and save it.

11. After that you can notice the appearance of blank white space on the gadget. 

12. Wait for around 15 to 20 minutes.

13. Finally, you can notice the newly added widget displays the adsense unit.