256 Install

That's good to know, as I just schedueld my site for some potential down time when I do this. :D I'm not using wp-shopping cart, or firestats though. More like wp-e-commerce (oh wait, I went another way with this) and short stats.

I'm wondering how you got around the "next record" issue i had. Never solved it but we've never seen an issue with it not transfering over.

Hi minusme,

You can send it to andrew@idtstudios.com.

Edit: I also need to know your name to properly give you credit.

Thanks,
Andrew

As a heads up, any plugin that is poorly coded and uses $table_prefix instead of $wpdb->prefix will cause some issues.

At least on 1.2.5 it is for me.

(Or plugins that don't have a prefix at all and just have a hardcoded table name.)

Actually, I was referring to a few plugins I have, not yours. Although... ;)

Anyway, $wpdb->prefix for use in a plugin will be wp_x_.

$table_prefix is (supposedly) being deprecated, but with 1.2.5 the error I was getting with those plugins was similar to: table database.name.wp_tablename doesn't exist.

I wouldn't rely on that though. For any of my custom stuff with new tables, I'm going through sunrise.php because at that point $wpdb->prefix is still the original table prefix.

That would probably work.

As for why the other doesn't exist, maybe it just hasn't been thought of yet.

I'll post it on trac and see what Donncha says about it.

Thanks for posting it to Trac. Donncha must be taking the day off because I haven't noticed him stirring about.

Thanks,
Andrew

Stupid question time: Do we need to change anything within the multidb plugin or with the original multidb code?

@minusme,

Even I am trying to use 256 databases.

In the install.txt it is given that we need to move/copy the tables of first blog to the db specified in C (if we go for 16 databases). Can you let me to which database you moved the contents of the first blog. Thanks!

Luke, can you share what you use in sunrise to get the correct db and prefix? I'm finding that I have to manually correct multiple occurances in most plugins, and it's a killer...

thanks mike!!! I actually had forgotten to add the tables there, OUCH!!

I would still be interested in how others are using sunrise for multiple db...

Yes. The reasoning behind it is the system takes the $blog_id, md5s it into a hash and then takes the first few characters to determine which database to use. If you;re just doing 16 databases, it just takes the first character. If you're going 256 databases (ie 16 x 16), it takes the first 2 characters. If you're doing 4096 databases (ie 16 x 16 x 16) it's the first three characters. And so on.