wordpress | Learn for Master

WordPress database error Table crashed

September 21, 2016 Author: david

For mysql database you may get the following error:

Fix “WordPress database error Table … is marked as crashed and should be repaired”

WordPress database error Table … is marked as crashed and last repair (automatic?) failed.

We can fix this error using the following commands:

[user@server ~/public_html]$ mysql -u user -p
Enter password:
Welcome to the MySQL monitor.&nbsp; Commands end with ; or \g.
Your MySQL connection id is 1120449
Server version: 5.1.48 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

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

mysql> show databases;
Connection id:&nbsp;&nbsp;&nbsp; 1120477
Current database: database

> use YOUR_DATABASE;

> show tables;

> use YOUR_TABLE_NAME;

mysql> select * from prefix_posts limit 1;


ERROR 145 (HY000): Table './database/prefix_posts' is marked as crashed and should be repaired
mysql> repair table prefix_posts;
+-----------------------+--------+----------+----------+
| Table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; | Op&nbsp;&nbsp;&nbsp;&nbsp; | Msg_type | Msg_text |
+-----------------------+--------+----------+----------+
| database.prefix_posts | repair | status&nbsp;&nbsp; | OK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
+-----------------------+--------+----------+----------+
1 row in set (3.56 sec)

mysql> select * from prefix_posts limit 1;
+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+
| ID | post_author | post_date           | post_date_gmt       | post_content | post_title | post_category | post_excerpt | post_status | comment_status | ping_status | post_password | post_name | to_ping | pinged | post_modified       | post_modified_gmt   | post_content_filtered | post_parent | guid                                                       | menu_order | post_type  | post_mime_type | comment_count |
+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+
| 12 |           8 | 2008-05-20 10:09:49 | 2008-05-20 15:09:49 |              | 308image1  |             0 |              | inherit     | open           | open        |               | 308image1 |         |        | 2008-05-20 10:09:49 | 2008-05-20 15:09:49 |                       |           0 | http://gaarai.com/wp-content/uploads/2008/05/308image1.gif |          0 | attachment | image/gif      |             0 |
+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+
1 row in set (0.00 sec)

mysql> exit
Bye
[user@server ~/public_html]$

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

[user@server ~/public_html]$ mysql -u user -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1120449

Server version: 5.1.48 MySQL Community Server (GPL)

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

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

mysql> show databases;

Connection id:    1120477

Current database: database

> use YOUR_DATABASE;

> show tables;

> use YOUR_TABLE_NAME;

mysql> select * from prefix_posts limit 1;

ERROR 145 (HY000): Table './database/prefix_posts' is marked as crashed and should be repaired

mysql> repair table prefix_posts;

+-----------------------+--------+----------+----------+

+-----------------------+--------+----------+----------+

+-----------------------+--------+----------+----------+

1 row in set (3.56 sec)

mysql> select * from prefix_posts limit 1;

+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+

+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+

| 12 | 8 | 2008-05-20 10:09:49 | 2008-05-20 15:09:49 | | 308image1 | 0 | | inherit | open | open | | 308image1 | | | 2008-05-20 10:09:49 | 2008-05-20 15:09:49 | | 0 | http://gaarai.com/wp-content/uploads/2008/05/308image1.gif | 0 | attachment | image/gif | 0 |

+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+

1 row in set (0.00 sec)

mysql> exit

Bye

[user@server ~/public_html]$

Fix “WordPress database error Table … is marked as crashed and should be repaired”

[Read More...]

Cache with nginx

August 27, 2016 Author: david

No comment yet

Here are some good resources to use cache a website with NGINX.

NGINX is commonly deployed as a reverse proxy or load balancer in an application stack and has a full set of caching features. It can be helpful for:

Speeding up the website by caching full pages, static files (js, images, css etc.).
Serving g-zipped data to browsers for faster delivery.
Rewrite the urls to make them more human readable and easier to remember.
Adding proper ‘expires header’ to static content so that they can be cached by the browsers.

[Read More...]

Good resources learn how to develop WordPress plugin

August 1, 2016 Author: david

No comment yet

Create a Custom WordPress Plugin From Scratch

This tutorial is from: http://code.tutsplus.com/tutorials/create-a-custom-wordpress-plugin-from-scratch–net-2668

1 Files and folders

WordPress stores its plugins in the wp-content/plugins/ folder. This is the place where we’ll be adding our files as well.

we are going to use two files (one for the main plugin file and one for implementing the administration page) therefore we’ll be putting all our files in a specific folder that we’ll name oscommerce_importer.

2. Creating the plugin file

Now we create our main plugin file. We’ll name it as itoscommerce_importer.php.

[Read More...]

How to create plugins for wordpress

July 30, 2016 Author: david

No comment yet

Here are two good examples to show how to add buttons to wordpress editor by build wordpress plugins.

WordPress has two different editors: TinyMCE editor(i.e., visual editor) and Text editor(i.e., HTML editor).

WordPress also lets us create custom buttons to both of the visual and text(or HTML) editor. To add a button for Text editor we need to use Quicktags API and to add buttons to the TinyMCE editor we have to use JavaScript APIs provided by the TinyMCE library. Here are two articles that will help you to learn these APIs.

Add Buttons to WordPress Text Editor

Here is an example code snippet which adds a button to the WordPress code editor and wraps the selected text using [code][/code] tags.

[Read More...]

remove alternativ background lines for wp-syntax

July 16, 2016 Author: david

No comment yet

wp-syntax is a power tool to highlight your code, but the alternative background lines can make your code unreadable on some screens.

To remove the alternative background lines feature, we can just overwrite the css by adding the two lines in your theme’s style.css.

You can change the background color to whatever you like.

.wp_syntax pre { background:#FCFCFC !important; }
.wp_syntax td.code { background-image:none; background-color:none; }

1 2	.wp_syntax pre { background:#FCFCFC !important; } .wp_syntax td.code { background-image:none; background-color:none; }

[Read More...]

How to use memcached in WordPress

July 9, 2016 Author: david

No comment yet

What is Memcached?

Memcached is an in-memory key-value store for small chunks of arbitrary data (strings, objects) from results of database calls, API calls, or page rendering.

Memcached is simple yet powerful. Its simple design promotes quick deployment, ease of development, and solves many problems facing large data caches. Its API is available for most popular languages.

You can get more information of memecached from this link: https://github.com/memcached/memcached/wiki

Why do you use Memcached?

By using memcached (properly), you limit the number of queries to the database (because they’ll read the results from memcached instead).

[Read More...]

Top CDN services to speed up your website

July 7, 2016 Author: david

No comment yet

If you build a website using popular CMS tools such as wordpress, you may wonder how to speed up your website. CDN is one the methods you need to adopt to make your site faster and more reliable. This post will describe what CDN is, how it can speed up your website, and recommend the top CDN providers you can choose.

What is CDN

Content Delivery Network (CDN) is a group of servers placed across the global in order to deliver static contents such as html file, images much faster. According to BuiltWith, out of top 10k websites,

[Read More...]

How to solve page not found error when using permalinks for wordpress

June 19, 2016 Author: david

No comment yet

I got the page not found error when I use the pretty permalinks of wordpress.

Here is how I solved the problem after several round searches using search engines.

make sure you have the write permission of /var/www/html/ folder
sudo a2enmod rewrite
edit the file /etc/apache2/apache2.conf (here we have an example of /var/www/html):

<Directory /var/www/html>
        Options Indexes FollowSymLinks
        AllowOverride None
        Require all granted
</Directory>

1

2

3

4

5

6

Options Indexes FollowSymLinks

AllowOverride None

Require all granted

</Directory>

and change it to;

<Directory /var/www/html>
        Options Indexes FollowSymLinks
        AllowOverride All
        Require all granted
</Directory>

1

2

3

4

5

6

Options Indexes FollowSymLinks

AllowOverride All

Require all granted

</Directory>

then,

sudo service apache2 restart

1 2	sudo service apache2 restart

Most people can solve the page not found error after step 3, but I got internal server error.

check the log:

cat /var/log/apache2/error.log,

[Read More...]

WordPress database error Table crashed

Cache with nginx

Good resources learn how to develop WordPress plugin

How to create plugins for wordpress

remove alternativ background lines for wp-syntax

How to use memcached in WordPress

Top CDN services to speed up your website

How to solve page not found error when using permalinks for wordpress

Get $35 Toward a New Fire TV 4K Device

Shop Amazon Gift Cards. Any Occasion. No Expiration

Best books to master algorithms

Best books to master machine learning

Recommended books to master big data

Search

Category List

Featured Categories

Rss Feeds

Categories

Subscribe

Contact US

Popular Posts

learn4master.com 2016 Accelerated by keyCDN

Get $35 Toward a New Fire TV 4K Device

Shop Amazon Gift Cards. Any Occasion. No Expiration

Best books to master algorithms

Best books to master machine learning

Recommended books to master big data

Search

Category List

Featured Categories

Tags

Categories

Subscribe

Categories

Contact US

Tags

Popular Posts

learn4master.com 2016 Accelerated by keyCDN