Title: uapv_thy's Replies | WordPress.org --- # uapv_thy [ ](https://wordpress.org/support/users/uapv_thy/) * [Profile](https://wordpress.org/support/users/uapv_thy/) * [Topics Started](https://wordpress.org/support/users/uapv_thy/topics/) * [Replies Created](https://wordpress.org/support/users/uapv_thy/replies/) * [Reviews Written](https://wordpress.org/support/users/uapv_thy/reviews/) * [Topics Replied To](https://wordpress.org/support/users/uapv_thy/replied-to/) * [Engagements](https://wordpress.org/support/users/uapv_thy/engagements/) * [Favorites](https://wordpress.org/support/users/uapv_thy/favorites/) Search replies: ## Forum Replies Created Viewing 4 replies - 1 through 4 (of 4 total) * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: [Database error when enabling mutlisite](https://wordpress.org/support/topic/database-error-when-enabling-mutlisite/) * [uapv_thy](https://wordpress.org/support/users/uapv_thy/) * (@uapv_thy) * [15 years, 5 months ago](https://wordpress.org/support/topic/database-error-when-enabling-mutlisite/page/2/#post-1915635) * Ok, I make some experimentations… First I try what you suggested : put blog_id =1 to my main site (in the WP_blog table). It’s continue to go fine (I can post on my blogs and so on) but I still not have a complete list of my blogs in the super admin menu. * So, I saw that my main site (blog) have a site_id = 2 (in the WP_blog table) and all the other have a site_id=1… hummm I change the “site_id” with 2 for all and they appear in the menu ! yes! * To make it as clean as possible, I finally change all site_id to 1 in the WP_blog table and the id of my main site to 1 in the WP_site table. In this way I can had new blog without any intervention in the WP_blog table. * Thx to your help * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: [Database error when enabling mutlisite](https://wordpress.org/support/topic/database-error-when-enabling-mutlisite/) * [uapv_thy](https://wordpress.org/support/users/uapv_thy/) * (@uapv_thy) * [15 years, 5 months ago](https://wordpress.org/support/topic/database-error-when-enabling-mutlisite/page/2/#post-1915621) * In my case , in the WP_site table I have only one line with my main site. with the id=2 in the WP_blog table I have 3 lines my main site have id=2 path=/blogs/ the first sub-directory blog have 12 path=/blogs/labeltice/ and the second 22 path=/blogs/licpro/ (because of an auto-increment of 10 with my mysql server) * Perhaps link with this problem, I have not the list of all my blolgs in the super admin menu, Only my main site appears. * (NB my main site was install in a subdirectory not on the root directory) * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: [Database error when enabling mutlisite](https://wordpress.org/support/topic/database-error-when-enabling-mutlisite/) * [uapv_thy](https://wordpress.org/support/users/uapv_thy/) * (@uapv_thy) * [15 years, 5 months ago](https://wordpress.org/support/topic/database-error-when-enabling-mutlisite/#post-1915563) * It is a little confuse for me, without these 9 tables (WP_2 …) I had the error:“ Error establishing a database connection” * After created them manually, my main site was reachable without error. * If I post on my main site, this post is store in the WP_2_post table. * About that and with the explication following I thing that my WP_2_ tables has to be view like WP_1_ tables in a normal configuration * The increment in my mysql database is due to ours sql plateform which have some mysql servers (less that 10) running in paralell. each of them having a different first value and a increment of 10. If one server is down one of the 8 other can do the job and we can re-synchronize all the database without problem because they all use different values for insert order . I am by default on the server 2 (it’s why my first table was WP_2_ and the next WP_12_ I hope it’s clear, because for more explanation I have to ask more to my sys op and I’m not sure to understand all his words… 😉 * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: [Database error when enabling mutlisite](https://wordpress.org/support/topic/database-error-when-enabling-mutlisite/) * [uapv_thy](https://wordpress.org/support/users/uapv_thy/) * (@uapv_thy) * [15 years, 5 months ago](https://wordpress.org/support/topic/database-error-when-enabling-mutlisite/#post-1915547) * Hello, I have the same problem, after my install of network. A “repair” of the database when I want to connect in /wp-admin/ say me that it can’t find tables wp_2_comments, wp_2_… (9 tables are missing). * I duplicate theses tables with the good names and it work now (more or less, because i forgot to change a WP_ value in the table WP_2_option about list of role, this is ok now but I still have a problem with list of my site in the super admin menu, but I am going to post this problem in a new threat) * So with my 9 new tables hand made, I can connect my main site. I can create a new site in the superadmin menu, and it create the 9 tables needs for this site( WP_12_ … 12 because my sql increment is 10 by 10) * The problem was this 9 tables missing after network installation. * bests regards Viewing 4 replies - 1 through 4 (of 4 total)