Ten Edges

WordPress, Joomla, Drupal are drawing closer to each other in terms of functionality

• Ease of setup: WP
• Content Editors: WP
• Site Administration: WP
• Accessibility and SEO: Joomla
• Structural Flexibility: Drupal
• User Roles and Workflow: Joomla
• Community/Web 2.0 Functionality: WP, Drupal

WordPress is a basic blogging tool. It provides a user interface where you can work in an easy and intuitive manner. It handles the logistics involved in making your composition presentable and publicly available, allowing you to focus on what you want to write.

Pingbacks happen when authors of other blogs cite an article from another site in their own articles.

Here is a typical email:

From: “WordPress.com” <donotreply@wordpress.com>
Date: August 31, 2011 2:49:04 PM PDT
To: ggarchar@zapmap.com
Subject: [Ten Edges] Please moderate: “WP.org”

A new pingback on the post “WP.org” is waiting for your approval

http://tenedges.com/wp-org/

Website : Lesson Plan &laquo; Ten Edges (IP: 69.170.134.202 , 69.170.134.202)
URL    : http://tenedges.com/2011/08/31/lesson-plan/
Pingback excerpt:
[...] WordPress Can Do For You WordPress Basics Using The WordPress Hosted Service [...]

Approve it: http://tenedges.wordpress.com/wp-admin/comment.php?action=approve&c=23
Trash it: http://tenedges.wordpress.com/wp-admin/comment.php?action=trash&c=23
Spam it: http://tenedges.wordpress.com/wp-admin/comment.php?action=spam&c=23
Currently 2 comments are waiting for approval. Please visit the moderation panel:

http://tenedges.wordpress.com/wp-admin/edit-comments.php?comment_status=moderated

Static Content, not associated with a date/time like posts.

http://en.support.wordpress.com/pages/

http://en.support.wordpress.com/pages/front-page/

Topics

• Appearance
• Comments
• Configuration
• FAQ
• General
• Languages
• Links
• Media
• Social Tools
• Subscriptions
• Tools
• TOS & Copyright
• Traffic
• Upgrades
• Users
• Widgets & Sidebars
• Writing & Editing

They are labeled as Field, but referred to as columns

mysql> show columns from wp_users from wordpress;
+---------------------+---------------------+------+-----+---------------------+----------------+
| Field               | Type                | Null | Key | Default             | Extra          |
+---------------------+---------------------+------+-----+---------------------+----------------+
| ID                  | bigint(20) unsigned | NO   | PRI | NULL                | auto_increment |
| user_login          | varchar(60)         | NO   | MUL |                     |                |
| user_pass           | varchar(64)         | NO   |     |                     |                |
| user_nicename       | varchar(50)         | NO   | MUL |                     |                |
| user_email          | varchar(100)        | NO   |     |                     |                |
| user_url            | varchar(100)        | NO   |     |                     |                |
| user_registered     | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| user_activation_key | varchar(60)         | NO   |     |                     |                |
| user_status         | int(11)             | NO   |     | 0                   |                |
| display_name        | varchar(250)        | NO   |     |                     |                |
+---------------------+---------------------+------+-----+---------------------+----------------+
10 rows in set (0.01 sec)

mysql> show columns from wp_posts from wordpress;
+-----------------------+---------------------+------+-----+---------------------+----------------+
| Field                 | Type                | Null | Key | Default             | Extra          |
+-----------------------+---------------------+------+-----+---------------------+----------------+
| ID                    | bigint(20) unsigned | NO   | PRI | NULL                | auto_increment |
| post_author           | bigint(20) unsigned | NO   | MUL | 0                   |                |
| post_date             | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| post_date_gmt         | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| post_content          | longtext            | NO   |     | NULL                |                |
| post_title            | text                | NO   |     | NULL                |                |
| post_excerpt          | text                | NO   |     | NULL                |                |
| post_status           | varchar(20)         | NO   |     | publish             |                |
| comment_status        | varchar(20)         | NO   |     | open                |                |
| ping_status           | varchar(20)         | NO   |     | open                |                |
| post_password         | varchar(20)         | NO   |     |                     |                |
| post_name             | varchar(200)        | NO   | MUL |                     |                |
| to_ping               | text                | NO   |     | NULL                |                |
| pinged                | text                | NO   |     | NULL                |                |
| post_modified         | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| post_modified_gmt     | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| post_content_filtered | text                | NO   |     | NULL                |                |
| post_parent           | bigint(20) unsigned | NO   | MUL | 0                   |                |
| guid                  | varchar(255)        | NO   |     |                     |                |
| menu_order            | int(11)             | NO   |     | 0                   |                |
| post_type             | varchar(20)         | NO   | MUL | post                |                |
| post_mime_type        | varchar(100)        | NO   |     |                     |                |
| comment_count         | bigint(20)          | NO   |     | 0                   |                |
+-----------------------+---------------------+------+-----+---------------------+----------------+
23 rows in set (0.01 sec)

Gary-Garchars-Computer:~ GG5$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 102
Server version: 5.5.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show tables from wordpress
    -> ;
+-----------------------+
| Tables_in_wordpress   |
+-----------------------+
| wp_commentmeta        |
| wp_comments           |
| wp_links              |
| wp_options            |
| wp_postmeta           |
| wp_posts              |
| wp_term_relationships |
| wp_term_taxonomy      |
| wp_terms              |
| wp_usermeta           |
| wp_users              |
+-----------------------+
11 rows in set (0.01 sec)

mysql> show columns from wp_users from wordpress;
+---------------------+---------------------+------+-----+---------------------+----------------+
| Field               | Type                | Null | Key | Default             | Extra          |
+---------------------+---------------------+------+-----+---------------------+----------------+
| ID                  | bigint(20) unsigned | NO   | PRI | NULL                | auto_increment |
| user_login          | varchar(60)         | NO   | MUL |                     |                |
| user_pass           | varchar(64)         | NO   |     |                     |                |
| user_nicename       | varchar(50)         | NO   | MUL |                     |                |
| user_email          | varchar(100)        | NO   |     |                     |                |
| user_url            | varchar(100)        | NO   |     |                     |                |
| user_registered     | datetime            | NO   |     | 0000-00-00 00:00:00 |                |
| user_activation_key | varchar(60)         | NO   |     |                     |                |
| user_status         | int(11)             | NO   |     | 0                   |                |
| display_name        | varchar(250)        | NO   |     |                     |                |
+---------------------+---------------------+------+-----+---------------------+----------------+
10 rows in set (0.00 sec)

mysql>

Writing “wordpress” as the database in the config file won’t get you anywhere.

Although the quick installation will set up your database tables and fields, it expects you to have already created the database in MySQL first!

Here is what it looks like in Mac OSX:

Startup MySQL first:

Then, get into the terminal and make the empty database:
 
Gary-Garchars-Computer:~ GG5$ mysql -u root -p
Enter password:


mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)


mysql> create database wordpress;
mysql> show databases;


+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
| wordpress |
+--------------------+
3 rows in set (0.01 sec)

http://wordpress.com/#!/my-blogs/

• augmental.com
• chessmap.wordpress.com
• fmp10.wordpress.com
• graywater.wordpress.com
• lincolnct.com
• learnpostscript.wordpress.com
• mmxxii.wordpress.com
• macenable.wordpress.com
• phpxphp.wordpress.com
• scriptsteps.wordpress.com
• tenedges.com
• war2.wordpress.com

Typical Daily Activity

Something about "men at work" gets the viewers!

New Cell Tower

Actually, this spike was the result of an email I sent to the Willow Glen eList in response to a Lost Dog posting:

It seems that an arrow pointing to a link in an email increases click-through, or perhaps it’s just because there are so many animal lovers in cyberspace:

http://lincolnct.com <- photo of the lost dog