• Resolved Steve Blasdale

    (@elrond532000)


    My wordpress network system has been running for several months. Recently I upgraded to 3.2.1 and all seemed to function well. Today I tried to add a new site to the system, this has failed though with no error messages.

    It appears an entry was made to the table wp_blogs, which looks similar to the other entries, excepting the domain name and blog_id.

    No other tables were created for the new site.

    When I try and access the site dashboard from the network site admin I see the subdomain is missing from the url, and I access the root sites dashboard.

    I have disabled all network enable plugins, and the problem still occurs with sites I try and create. (Yes I have come across problems where plugins stop site creation)

    I have compared my .htaccess and wp-config between this 3.2.1 system, and a still fully functioning 3.1 system I still run, and they look the same.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    No other tables were created for the new site.

    Check your database permissions and space. You may be out of space.

    I have disabled all network enable plugins,

    Disable ALL your plugins. not just some. ALL.

    Also, db table creation failing is either plugin interference, or something changed on the db server side. like db user permissions.

    Thread Starter Steve Blasdale

    (@elrond532000)

    All plugins were disabled. There is adequest space.

    I have placed a die statement in the make_db_current_silent() function to display $wp_queries. The create tables are not suffixed with the blog_id. In my working 3.1 system they are.

    3.2
    CREATE TABLE wp_terms ( term_id bigint(20) unsigned NOT NULL auto_increment, name varchar(200) …….

    3.1
    CREATE TABLE wp_27_terms ( term_id bigint(20) unsigned NOT NULL auto_increment, name varchar( ………

    So its failing because tables are already there, how is the blog_id inserted into the table name.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    mu-plugins too?

    What theme are you running?

    Thread Starter Steve Blasdale

    (@elrond532000)

    Yes mu-plugins was disabled. I use child themes based on twenty10. Changes are to css and to the footer. Same changes are in place on the working system.

    I don’t see that to be the problem, it seems to me that the change blog is not setting up the table names, and the schema.php is generating the wrong SQL.

    Where is wpdb defined.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    Your wp-config.php

    Thing is, the wp_ part is your prefix, as you well know. The 27_ part comes from your wp_blogs table, where you see the ID number on the line? That’s the number you get.

    Since that didn’t change from 3.1 to 3.2, we’re trying to look at external sources for the wacky.

    Thread Starter Steve Blasdale

    (@elrond532000)

    This was a plugin problem.

    I Network disabled all plugins, thinking that would be enough. What I did not do was disable the plugins associated with the main site.

    There was one plugin which loaded wp-admin/includes/upgrade.php before the blog id had been set. Hence the wrong table names was used for the create. The code to load wp-admin/includes/upgrade.php was at the beginning of the plugin and executed unconditionally.

    Disabling this plugin would probably have worked. Instead I removed the code from the plugin. The plugin is badly written, and the developer seems not to have upgraded it in several years. In any case its a hacked plugin.

    The reason my other multsite works is that despite having the same plugins, this plugin is not enabled in the main site. It is enabled in the other sites in the network.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Can not create new subdomain sites in a working syste,’ is closed to new replies.