brotmaschine

Hello,

i had the problem too. I solved it that way:

1. take a look in your WP Database
2. search the entry of your Subblog, show like this: “wp3_3_ngg*” (part “wp3_” is your WPInstall, “3_” is the number of your SubBlog)
3. my “wp3_2_ngg*” where ready for NextGenGallery, The Installation for “wp3_3_ngg*” had no Table right now.
4. I export the 3 table on “wp3_2_ngg*”
5. I replaced “wp3_2_ngg* with “wp3_3ngg*”
6. now in Backend the upgrade for NGG is correct

@alexrabe: where were some more integration in Database?

here is my exportcode:

-- phpMyAdmin SQL Dump
-- version 3.3.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 03. August 2010 um 12:14
-- Server Version: 5.0.45
-- PHP-Version: 5.2.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: <code>Datenbank</code>
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle <code>wp3_3_ngg_album</code>
--

CREATE TABLE IF NOT EXISTS <code>wp3_3_ngg_album</code> (
  <code>id</code> bigint(20) NOT NULL auto_increment,
  <code>name</code> varchar(255) NOT NULL,
  <code>previewpic</code> bigint(20) NOT NULL default '0',
  <code>albumdesc</code> mediumtext,
  <code>sortorder</code> longtext NOT NULL,
  <code>pageid</code> bigint(20) NOT NULL default '0',
  PRIMARY KEY  (<code>id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle <code>wp3_3_ngg_album</code>
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle <code>wp3_3_ngg_gallery</code>
--

CREATE TABLE IF NOT EXISTS <code>wp3_3_ngg_gallery</code> (
  <code>gid</code> bigint(20) NOT NULL auto_increment,
  <code>name</code> varchar(255) NOT NULL,
  <code>path</code> mediumtext,
  <code>title</code> mediumtext,
  <code>galdesc</code> mediumtext,
  <code>pageid</code> bigint(20) NOT NULL default '0',
  <code>previewpic</code> bigint(20) NOT NULL default '0',
  <code>author</code> bigint(20) NOT NULL default '0',
  PRIMARY KEY  (<code>gid</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle <code>wp3_3_ngg_gallery</code>
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle <code>wp3_3_ngg_pictures</code>
--

CREATE TABLE IF NOT EXISTS <code>wp3_3_ngg_pictures</code> (
  <code>pid</code> bigint(20) NOT NULL auto_increment,
  <code>post_id</code> bigint(20) NOT NULL default '0',
  <code>galleryid</code> bigint(20) NOT NULL default '0',
  <code>filename</code> varchar(255) NOT NULL,
  <code>description</code> mediumtext,
  <code>alttext</code> mediumtext,
  <code>imagedate</code> datetime NOT NULL default '0000-00-00 00:00:00',
  <code>exclude</code> tinyint(4) default '0',
  <code>sortorder</code> bigint(20) NOT NULL default '0',
  <code>meta_data</code> longtext,
  PRIMARY KEY  (<code>pid</code>),
  KEY <code>post_id</code> (<code>post_id</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle <code>wp3_3_ngg_pictures</code>
--

EDIT: PS: thx alexraabe for this great PlugIn!!!
PPS: dont know why it show, but delete the entry “code” in SQL before making the integration!