Question
some tables not getting created in wordpress setup tutorial
- Posted December 22, 2013
I’m following along with the WordPress multi-site tutorial here https://www.digitalocean.com/community/articles/how-to-set-up-multiple-wordpress-sites-using-multisite which also references a few other tutorials on DO.
I went through the tutorial twice (i.e. setup two servers) and got the same problem, namely some of my tables are not setup. You can see the error here
http://162.243.211.128/wp-admin/maint/repair.php?repair=1
or I’ll copy it here
The wp_users table is okay.
The wp_usermeta table is okay.
The wp_1_posts table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_posts’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_posts table. Error: Table ‘wordpress.wp_1_posts’ doesn’t exist
The wp_1_comments table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_comments’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_comments table. Error: Table ‘wordpress.wp_1_comments’ doesn’t exist
The wp_1_links table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_links’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_links table. Error: Table ‘wordpress.wp_1_links’ doesn’t exist
The wp_1_options table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_options’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_options table. Error: Table ‘wordpress.wp_1_options’ doesn’t exist
The wp_1_postmeta table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_postmeta’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_postmeta table. Error: Table ‘wordpress.wp_1_postmeta’ doesn’t exist
The wp_1_terms table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_terms’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_terms table. Error: Table ‘wordpress.wp_1_terms’ doesn’t exist
The wp_1_term_taxonomy table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_term_taxonomy’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_term_taxonomy table. Error: Table ‘wordpress.wp_1_term_taxonomy’ doesn’t exist
The wp_1_term_relationships table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_term_relationships’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_term_relationships table. Error: Table ‘wordpress.wp_1_term_relationships’ doesn’t exist
The wp_1_commentmeta table is not okay. It is reporting the following error: Table ‘wordpress.wp_1_commentmeta’ doesn’t exist. WordPress will attempt to repair this table… Failed to repair the wp_1_commentmeta table. Error: Table ‘wordpress.wp_1_commentmeta’ doesn’t exist
The wp_blogs table is okay.
The wp_signups table is okay.
The wp_site table is okay.
The wp_sitemeta table is okay.
The wp_registration_log table is okay.
The wp_blog_versions table is okay.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
ok, thanks, it worked this time. The problem was that I thought these two lines were the same, so I only added one of them <br> <br>define(‘WP_ALLOW_MULTISITE’, true); <br>define(‘MULTISITE’, true); <br> <br> <br>
That’s odd. I just followed the following articles in the same order that they are listed in and it works just fine (screenshot: <a href=“https://kmlnsr.me/Screenshot from 2013-12-23 11%3A12%3A23.png”>https://kmlnsr.me/Screenshot from 2013-12-23 11%3A12%3A23.png</a>): <br> <br><a href=“https://www.digitalocean.com/community/articles/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu”>https://www.digitalocean.com/community/articles/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu</a> <br><a href=“https://www.digitalocean.com/community/articles/how-to-install-WordPress-on-ubuntu-12-04”>https://www.digitalocean.com/community/articles/how-to-install-WordPress-on-ubuntu-12-04</a> <br><a href=“https://www.digitalocean.com/community/articles/how-to-set-up-multiple-wordpress-sites-using-multisite”>https://www.digitalocean.com/community/articles/how-to-set-up-multiple-wordpress-sites-using-multisite</a> <br> <br>I added a second site but still do not see any of these <code>wp_1_*</code> tables. Did you follow the articles as is or did you change anything?