Creating a MySQL database for WordPress

Creating a MySQL database with cPanel, which is included in all of hosting plans(may differ with different hosting providers), can be easily accomplished.

Create a MySQL database on your hosting account, you need to log in control Panel. This can be done by either using the Go to cPanel button in the Customer Area My Accounts section or by entering one of the following URLs in your web browser:

http://yourdomainname.com/cpanel

 

create database with cpanel

Creating MySQL Database with cpanel

In order to connect a new database you need to enter the desired name of the database in the New Database field and click on the Submit button as shown below:

where to enter details to create wordpress database

enter your details to create wordpress database

Hint enter keyword into Table Prefix e.g. wp_horseriding to avoid spam emails. Spammers search the internet for newly installed wp_ databases. And make note of Username and password.

Wordpress Training Teaching full install

WordPress Login Screen

A confirmation screen will be displayed, informing that the database has been successfully created.

Next Run the install

WordPress Login Screen

Publish button changed to Submit For Review

How to Fix wordpress Publish button in  from Submit For Review

One of the latest problems i have the (pain) pleasure to come across to during a local business wordpress themes design. It really started off as a bit of a nightmare, when i of realised I could no longer add new pages to my WordPress site or even save the customiser settings for our theme either, faced this problem when working on a custom wordpress roofing theme but found the answer after 6ish hours.

The problem was, there was no “Publish” button. The ‘Publish’ button had be replaced by a “Submit For Review” button. Plus when saving the custom preview seemed to work, but after reloading the page were back to the old settings.

I hope my wordpress tips will help you fix your WordPress website fast and get your website working for you, and not you working for your website.

  1. Changing themes can cause this problem. I recommend you switch back to a default theme (i.e. twenty eleven, twenty twelve etc.) and test if the problem still occurs.
  2. Plugins can also cause this problem. To verify if this is the problem, I recommend deactivating or moving your plugins to a directory outside of the folder and see if the problem still happens.

Login to your phpMyAdmin, repairing the database tables. This can solve the problem.
Fix Publish button changed to Submit For ReviewThe WordPress “Publish” button is a “Submit For Review” button problem can also be caused my not having a ‘Primary Key’ and ‘Auto Increment’ in the wp-post table in your database
You can hire me to do this for you. Basically login to your phpMyAdmin and go to the table wp-post. You will see the following error, suggesting that there is no ‘Primary Key’ nor ‘Auto Increment’.

How to Fix Publish button changed to Submit For Review

Go to ‘Structure’ and on the ‘ID’ row, click on ‘Primary Key’ to make this this primary row. Once the ‘ID’ row is the ‘Primary Key’ you can then edit the ‘ID’ row and set it to Auto Increment.

 

Pinguis Web dealing with WordPress Errors and custom WordPress Website Designers

WordPress Update Services

WordPress Update Services are tools which are used to let other people know you’ve updated your blog.

WordPress automatically updates popular Update Services when you have updated your blog by sending pings each time you create or update a post.

Listed below are Ping Services WordPress uses:

http://rpc.pingomatic.com
http://rpc.twingly.com
http://api.feedster.com/ping
http://api.moreover.com/RPC2
http://api.moreover.com/ping
http://www.blogdigger.com/RPC2
http://www.blogshares.com/rpc.php
http://www.blogsnow.com/ping
http://www.blogstreet.com/xrbin/xmlrpc.cgi
http://bulkfeeds.net/rpc
http://www.newsisfree.com/xmlrpctest.php
http://ping.blo.gs/
http://ping.feedburner.com
http://ping.syndic8.com/xmlrpc.php
http://ping.weblogalot.com/rpc.php
http://rpc.blogrolling.com/pinger/
http://rpc.technorati.com/rpc/ping
http://rpc.weblogs.com/RPC2
http://www.feedsubmitter.com
http://blo.gs/ping.php
http://www.pingerati.net
http://www.pingmyblog.com
http://geourl.org/ping
http://ipings.com
http://www.weblogalot.com/ping

Update service URL’s are listed under “Update Services” under Settings-> Writing Settings

WordPress Address None www. or with www.

WordPress Address www. or none www.

How to get www. before your domain name on your WordPress Website.

WordPress Address none www. or with wwwUltimately, it doesn’t really matter which one you choose. The success of your website will not be determined by a www or non-www URL. The important thing is that whichever one you choose be accurate and consistent.

If visitors type to www.pinguisweb.com or chose to type pinguisweb.com they will still find the Number 1 “Website Design Kerry” website.

In fact when you visit www.pinguisweb.com, the www will not be displayed in the browser’s address bar.

Its assumed when you are searching the world wide web that www. is there.

As long as the domain name is identical there will be no problem with WordPress. Its written into the .htaccess file WordPress has Rewrite Rules to correct this.

To change to either on the left hand black bar go to settings and general. Basically its a matter of choice.

Just be consistent throughout.

Of course, WordPress changes everything when you go installing it in a sub domain and linking it back to you main domain.

WordPress Media Settings

WordPress Media Settings

Media Settings are controlled by the various settings related to images and other media that are used in writing posts and pages.

Wordpress Media Settings Ireland

The image sizes listed determine the maximum dimensions in pixels to use when inserting an image into the body of a post.

  • Thumbnail size – Specify the Width and Height of your Thumbnail
    Crop thumbnail to exact dimensions (normally thumbnails are proportional)
  • Medium size – Specify the the Max Width and Max Height
  • Large size –  Specify the the Max Width and Max Height

Uploading Files

Default settings used for during the media upload process when writing a post.

  • Organize my uploads into month- and year-based folders – Check this box if you wish to organize your uploads into folders based on the year and the month of the upload. WordPress will automatically create the folders, such as wp-content/uploads/2010, these folders are well organised and easy to browse, if you need.

Save Changes Button

Click the Save Changes button to ensure your changes are saved(committed) to your database. Your settings have been saved.
Remember that some plugins require additional image sizes and will create them based on their specifications. One of the main reasons for WordPress site being bloated or taking up to much room.

WordPress Discussion Settings

How to setup WordPress Discussion Settings or Comments.

Default article settings WordPress will send out a pings to a site or article you have linked to in your post automatically.

Trackbacks allows you to communicate to another blog or blog owner using your WordPress

Pingbacks are sent automatically when you link to someone’s site or they link to you.


Other comment settings

I dont allow comments on my websites as a rule.

My settings are: Comment author must fill out name and email.

Users must be registered and logged in to comment.

set to 0 days

Email me whenever

A comment is held for moderation

Before a comment appears

Comment must be manually approved.

Comment author must have a previously approved comment

 

I hate spam so hold a comment in the queue if it contains or more links. (A common characteristic of comment spam is a large number of hyperlinks.)

Below are avatar settings

Avatar Display
Avatar Display

Maximum Rating
Maximum Rating




Default Avatar
Default Avatar

For users without a custom avatar of their own, you can either display a generic logo or a generated one based on their email address.

WordPress Reading Settings

WordPress Reading Settings Control your frontpage Settings

Front Page Display Setting choose what content appears on your website’s front page. Choose to have your latest blog posts or a static page. Created in the Pages tab (black bar left hand sidebar) of your site.

Your front page is set to display your latest blog posts by default, this can change it to a static front page. Using a static front page is handy if you want to use your front page as a landing page.

Reading Settings in WordPress

Blog pages show at most – Controls the number of Posts to display on your blog page. If frontpage display is set to display Your Latest Posts this value is controlled here also.

Syndication feeds show the most recent – These feeds show the most recent items and lets you set how many blog posts will be sent out at via RSS feed (mine is located at http://pinguisweb.com/feed/). Add /feed/ to your wordpress domain name to get your feed address.

For each article in a feed, show – choose whether to show all post content or the first 55 words, you can select Full text or Summary. Full text means that the entire contents of a post are included in the feed. Summary means that only the first 55 words are included in the feed, along with the option to continue reading the rest of the post. Best change to Summary because of pagespeed and bandwidth factors.

Search Engine Visibility – If you want to setup your website before indexig check the Discourage search engines from indexing this site box to ask search engines not to index this site. When the option is checked, this changes robots.txt to send back noindex(Disallow) commands to search engines.

Writing Settings WordPress

How to change the Writing Settings WordPress

Default Writing Settings WordPress Ireland

WordPress has a lot of Default Setting already set to help you get started quickly. Reading Settings is no different but can be tweeked to get the results that push you up from amateur status.

It not going to change the world but may improve your blog rating that bit.

 

Writing Settings in WordPress

Convert emoticons like and to graphics on display – i would tick YES
WordPress should correct invalidly nested XHTML automatically – i would tick YES

Default Post Category for this one i would select a popular search term related to my business. These categories are set in All Posts and Category. Enter your category information there and come back and select it from the list.

Default Post Format I always leave it to standard the choices are Standard, Aside, Chat, Gallery, Link, Image, Quote, Status, Video or Audio. Again depends on you type of blog or customers.

WordPress General Settings

How to set your General Website Settings in WordPress

One of the first pages to visit in the WordPress back-end is your Settings Screen. Down the left hand side bar under settings, you can set control of the most basic configuration settings for your site, your site’s title and location, who can register an account at your site, and how dates and times are used and displayed.

Wordpress General Settings

Below is an example of the setting used in Ireland. We will explain…

Changing Website Title and Tagline are pretty simple.

Changing the Email Address associated with the Administrator is next input box.

Timezone should be set to Dublin as Cork is not there and Kerry has none(Yet).

Date Format is a personal choice but i recommend Date/Month/Year as its standard in Ireland..

Time Format again is a personal choice i would keep it at default Hour/Minute/ in 12-hour clock.

Select Week Starts On Day and the Default WordPress Site Language

Hit Save Changes…

 

Change Your WordPress Timezone

Learn How To Change Your WordPress Default Timezone

If you are scheduling, selling online, message publication, and many calendar features with WordPress may not work until you have set the default timezone set.

When signing in to your new website, you will see a warning bar telling you to check your timezone in WordPress. Do not ignore or Dismiss this.

WordPress settings, help text says ‘Choose a city in the same timezone as you”.

 

To change your WordPress TimezoneGo to your WordPress dashboard on the left hand sidebar. Click on the Settings, then click General.

Changing Timezone SettingsSelect a city nearest you. There is not too many Cities in Kerry, Dublin is our option here.

On the Settings > General page, find the section labeled Timezone. Select a city in the same timezone as you.  Go to Europe and scroll down until Dublin is listed.


Save your changes.

Be sure to click the Save Changes button at the bottom of the Settings > General screen.