Ticket #237 (assigned defect)

Opened 1 year ago

Last modified 1 year ago

Database upgrades not working

Reported by: gwagenknecht Assigned to: donncha (accepted)
Priority: normal Milestone: WPMU 2.0
Component: component1 Version: 2.0
Severity: normal Keywords:
Cc:

Description

I tried r867 today and it looks like database upgrades are not working. The site admin page didn't report any error. However, if I call the upgrade script for an individual blog directly, I see an error related to "alter table wp_blogs add key domain". The key already exists.

I'm not sure but the wp_blogs table should not be upgraded when each individual blog is upgraded, shouldn't it?

Change History

01/24/07 15:23:20 changed by gwagenknecht

Note, my database was from somewhere around r530. I don't know anymore.

02/23/07 16:44:49 changed by donncha

  • owner changed from somebody to donncha.
  • status changed from new to assigned.

What happens if you comment out the global blogs like wp_blogs, wp_users, wp_site, wp_sitemeta, wp_usermeta, wp_sitecategories ... in wp-admin/upgrade-schema.php?

Unfortunately those tables might be upgraded from time to time but the db_delta should take care of that. If it doesn't we need to think up an alternate method of doing upgrades of global tables.

02/24/07 06:52:27 changed by lunabyte

What about a separation of Admin db version, i.e. the global tables, and the user db version?

Then 2 if statements to upgrade schema, so that the global stuff is only run once?

It doesn't need to be a separate tracking #, unless deemed necessary, but if the db version was stored as a site and global option, then might it be easier to distinguish if it was up to date or not?

03/02/07 19:36:33 changed by drmike

  • version changed from 1.0 to 2.0.
  • milestone set to WPMU 2.0.

I wonder if they ever figured this out.