uapv_thy

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

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)

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… ??

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