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
-- https://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!
