1

Topic: 1.1.5 -> 1.2 update problems...

Encountered some problems when performing this upgrade, the 1.1.5 installation is from the beginning a phpBB 2 conversion wich have been working flawlessly until the upgrade.
The problems start almost immediately with the update-tool reporting an error:

An error was encountered
File: /home/di/public_html/forumtest/11_to_12_update.php
Line: 166

PunBB reported: Unable to alter DB structure.

Database reported: Can't DROP 'search_results_ident_idx'. Check that column/key exists (Errno: 1091)

Tried it two or three times without any change so i edited 11_to_12_update.php so it skipped the part that didnt work only too discover that every change the script tries to make after this fails too with the same error!

Please, someone tell me what im doing to wrong!

Oh, i migt need to say that ive tried installing a clean 1.1.5 pun and upgrading to 1.2 just to see if there was something wrong with permissions and so on but this upgrade performs perfectly.

Some information:
Environment Operating system: Linux
PHP: 4.3.10-2 - Show info
Accelerator: N/A Database MySQL 4.0.23_Debian-1-log

//Micke

Re: 1.1.5 -> 1.2 update problems...

The problem is that the converter drops a few indexes before it moves over the data (to speed it up), but then it fails to recreate the indexes again. I haven't looked into the problem in any detail since the converter is Chacmool's baby. I'm sorry, but the only solution to your problem is to install a clean 1.1.5 and then compare your database with that one and create the missing indexes. Without the indexes, your board will be a lot slower.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

3 (edited by RaWeN 2005-01-18 22:38)

Re: 1.1.5 -> 1.2 update problems...

I see... hope Chacmool takes another look at the converter then.


I fixed my it own way, i ran the script until it failed, cut everything until the posts-table and users edits at the end and ran that bit again, now it works fine again... hopefully smile  Wont put it into live-mode until i know for sure anyway.

Re: 1.1.5 -> 1.2 update problems...

You should still add those indexes though.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

5

Re: 1.1.5 -> 1.2 update problems...

I had exactly the same problem and I took the same solution.
Rickard, maybe you should put a method on how to create indexes

Ludo,

Re: 1.1.5 -> 1.2 update problems...

Yes, that or include code in the upgrade script to deal with this.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

7

Re: 1.1.5 -> 1.2 update problems...

This is why I asked if it might be easier to do a clean install of 1.2, and then convert the old database myself using phpMyAdmin. -- to prevent any problems that might arise caused by the conversion script.

8

Re: 1.1.5 -> 1.2 update problems...

We did the upgrade on the live forum yesterday and i found a pretty strange solution to this "problem", if you rebuild the search index (from the pun-admin) and then run the upgrade script it works perfectly. If someone posts a single message in the forum between the reindex and upgrade it fails as in my first post.

I thougt that i should post it here since other people seems to have the same problem.

Re: 1.1.5 -> 1.2 update problems...

Hmm. I very much doubt the search index would have anything to do with this. At least not with the problem you posted in the top post.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

10

Re: 1.1.5 -> 1.2 update problems...

Nearlsy the same problem here:


An error was encountered
File: /home/www/web421/html/uni/forum/11_to_12_update.php
Line: 127

PunBB reported: Unable to create table forum_perms. Please check MySQL permissions and try again.

Database reported: Table 'forum_perms' already exists (Errno: 1050)

Re: 1.1.5 -> 1.2 update problems...

That looks like you've run the upgrade script and now you're running it again tongue

12 (edited by f10 2005-01-31 11:55)

Re: 1.1.5 -> 1.2 update problems...

You're right Smartys. I run the script a second time, because of errors like this:

An error was encountered
File: /home/www/web421/html/uni/forum2/11_to_12_update.php
Line: 165

PunBB reported: Unable to alter DB structure.

Database reported: Table 'usr_web421_2.search_results' doesn't exist (Errno: 1146)

... now I have to restore my old database. How I can install version 1.2 without this errors?

Re: 1.1.5 -> 1.2 update problems...

Could you export the table structure of your forum database and paste it here?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

14 (edited by f10 2005-01-31 19:23)

Re: 1.1.5 -> 1.2 update problems...

Server localhost

# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Erstellungszeit: 31. Januar 2005 um 20:18
# Server Version: 4.0.20
# PHP-Version: 4.3.10
# 
# Datenbank: `usr_web421_2`
# 
CREATE DATABASE `usr_web421_2`;
USE usr_web421_2;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `bans`
#

CREATE TABLE `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `ip` varchar(255) default NULL,
  `email` varchar(50) default NULL,
  `message` varchar(255) default NULL,
  `expire` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `categories`
#

CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat_name` varchar(80) NOT NULL default 'New Category',
  `disp_position` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `censoring`
#

CREATE TABLE `censoring` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `search_for` varchar(60) NOT NULL default '',
  `replace_with` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `config`
#

CREATE TABLE `config` (
  `conf_name` varchar(255) NOT NULL default '',
  `conf_value` text,
  PRIMARY KEY  (`conf_name`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `forums`
#

CREATE TABLE `forums` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `forum_name` varchar(80) NOT NULL default 'New forum',
  `forum_desc` text,
  `moderators` text,
  `num_topics` mediumint(8) unsigned NOT NULL default '0',
  `num_posts` mediumint(8) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned default NULL,
  `last_post_id` int(10) unsigned default NULL,
  `last_poster` varchar(200) default NULL,
  `closed` tinyint(1) NOT NULL default '0',
  `admmod_only` tinyint(1) NOT NULL default '0',
  `disp_position` int(10) NOT NULL default '0',
  `cat_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=26 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `online`
#

CREATE TABLE `online` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `logged` int(10) unsigned NOT NULL default '0'
) TYPE=HEAP;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `posts`
#

CREATE TABLE `posts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `poster_id` int(10) unsigned NOT NULL default '1',
  `poster_ip` varchar(15) default NULL,
  `poster_email` varchar(50) default NULL,
  `message` text NOT NULL,
  `smilies` tinyint(1) NOT NULL default '1',
  `posted` int(10) unsigned NOT NULL default '0',
  `edited` int(10) unsigned default NULL,
  `edited_by` varchar(200) default NULL,
  `topic_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2982 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `protect_users`
#

CREATE TABLE `protect_users` (
  `id` char(20) default NULL,
  `passwd` char(34) default NULL
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `ranks`
#

CREATE TABLE `ranks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `rank` varchar(50) NOT NULL default '',
  `min_posts` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `reports`
#

CREATE TABLE `reports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `post_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0',
  `forum_id` int(10) unsigned NOT NULL default '0',
  `reported_by` int(10) unsigned NOT NULL default '0',
  `created` int(10) unsigned NOT NULL default '0',
  `message` text NOT NULL,
  `zapped` int(10) unsigned default NULL,
  `zapped_by` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `search_matches`
#

CREATE TABLE `search_matches` (
  `post_id` int(10) unsigned NOT NULL default '0',
  `word_id` int(10) unsigned NOT NULL default '0',
  `subject_match` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `search_words`
#

CREATE TABLE `search_words` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `word` varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (`word`),
  KEY `search_words_id_idx` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12567 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `subscriptions`
#

CREATE TABLE `subscriptions` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `tblstats`
#

CREATE TABLE `tblstats` (
  `st_id` int(11) NOT NULL auto_increment,
  `st_ip` varchar(17) NOT NULL default '0',
  `st_ua` varchar(128) NOT NULL default '0',
  `st_ref` varchar(164) NOT NULL default '0',
  `st_page` varchar(128) NOT NULL default '0',
  `st_time` int(14) NOT NULL default '0',
  `st_unique` int(1) NOT NULL default '0',
  `st_ref_dom` varchar(50) NOT NULL default '',
  `st_key` varchar(64) NOT NULL default '',
  `st_tag` varchar(12) NOT NULL default '',
  PRIMARY KEY  (`st_id`)
) TYPE=MyISAM AUTO_INCREMENT=34516 ;

# --------------------------------------------------------


#
# Tabellenstruktur für Tabelle `topics`
#

CREATE TABLE `topics` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `posted` int(10) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned NOT NULL default '0',
  `last_post_id` int(10) unsigned NOT NULL default '0',
  `last_poster` varchar(200) default NULL,
  `num_views` mediumint(8) unsigned NOT NULL default '0',
  `num_replies` mediumint(8) unsigned NOT NULL default '0',
  `closed` tinyint(1) NOT NULL default '0',
  `sticky` tinyint(1) NOT NULL default '0',
  `moved_to` int(10) unsigned default NULL,
  `forum_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=203 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `users`
#

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `title` varchar(50) default NULL,
  `realname` varchar(40) default NULL,
  `url` varchar(100) default NULL,
  `icq` varchar(12) default NULL,
  `msn` varchar(50) default NULL,
  `aim` varchar(20) default NULL,
  `yahoo` varchar(20) default NULL,
  `location` varchar(30) default NULL,
  `use_avatar` tinyint(1) NOT NULL default '0',
  `signature` text,
  `disp_topics` tinyint(3) unsigned default NULL,
  `disp_posts` tinyint(3) unsigned default NULL,
  `email_setting` tinyint(1) NOT NULL default '1',
  `save_pass` tinyint(1) NOT NULL default '1',
  `notify_with_post` tinyint(1) NOT NULL default '0',
  `smilies` tinyint(1) NOT NULL default '1',
  `show_img` tinyint(1) NOT NULL default '1',
  `show_avatars` tinyint(1) NOT NULL default '1',
  `show_sig` tinyint(1) NOT NULL default '1',
  `link_to_new_win` tinyint(1) NOT NULL default '1',
  `timezone` tinyint(2) NOT NULL default '0',
  `style` varchar(25) NOT NULL default 'Oxygen',
  `num_posts` int(10) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '-1',
  `last_post` int(10) unsigned default NULL,
  `registered` int(10) unsigned NOT NULL default '0',
  `last_visit` int(10) unsigned NOT NULL default '0',
  `last_action` int(10) unsigned NOT NULL default '0',
  `admin_note` varchar(30) default NULL,
  `activate_string` varchar(50) default NULL,
  `activate_key` varchar(8) default NULL,
  `language` varchar(10) default NULL,
  `access` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=128 ;

# --------------------------------------------------------

http://www.bigl.ch/files/struktur.pdf

Re: 1.1.5 -> 1.2 update problems...

Very odd. If the above is your 1.1.5 database, you're missing the search_results table. Tables don't just vanish. You must have done something else to the database. I can see that there are other non-PunBB tables in the same database. What are those?

Edit: Forget about what I said about the permissions table. PunBB hasn't had a table called permissions since 1.0 smile

"Programming is like sex: one mistake and you have to support it for the rest of your life."

16

Re: 1.1.5 -> 1.2 update problems...

there was an error during restoring my database. Here is the fully restored structure (including search_results and permissions, version 1.1.4):

Datenbank usr_web421_2 auf localhost

# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Erstellungszeit: 31. Januar 2005 um 21:56
# Server Version: 4.0.20
# PHP-Version: 4.3.10
# 
# Datenbank: `usr_web421_2`
# 

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `Logger`
#

CREATE TABLE `Logger` (
  `id` int(11) NOT NULL default '0',
  `remote_addrs` varchar(20) default NULL,
  `remote_host` varchar(200) default NULL,
  `user_agent` varchar(200) default NULL,
  `regtime` datetime default NULL,
  `viewed` int(11) NOT NULL default '0'
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `PPA_COMMENT`
#

CREATE TABLE `PPA_COMMENT` (
  `pid` varchar(10) NOT NULL default '',
  `msg_id` mediumint(10) NOT NULL auto_increment,
  `userhost` varchar(200) NOT NULL default '',
  `msg_subject` varchar(200) NOT NULL default '',
  `msg_body` text NOT NULL,
  `msg_date` datetime default NULL,
  PRIMARY KEY  (`msg_id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `PPA_PICTURES`
#

CREATE TABLE `PPA_PICTURES` (
  `pid` mediumint(10) NOT NULL auto_increment,
  `aid` varchar(10) NOT NULL default '',
  `filepath` varchar(200) NOT NULL default '',
  `filename` varchar(200) NOT NULL default '',
  `filesize` int(25) NOT NULL default '0',
  `pwidth` varchar(5) NOT NULL default '',
  `pheight` varchar(5) NOT NULL default '',
  `hits` mediumint(10) NOT NULL default '0',
  `vote_rates` float(5,2) NOT NULL default '0.00',
  `vote_times` mediumint(10) NOT NULL default '0',
  `pic_desc` text NOT NULL,
  PRIMARY KEY  (`pid`)
) TYPE=MyISAM AUTO_INCREMENT=44 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `PPA_TABLE`
#

CREATE TABLE `PPA_TABLE` (
  `aid` mediumint(10) NOT NULL auto_increment,
  `description` text NOT NULL,
  `uploads` enum('YES','NO') NOT NULL default 'YES',
  `date` datetime default NULL,
  `big_desc` text NOT NULL,
  PRIMARY KEY  (`aid`),
  KEY `aid` (`aid`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `Rate`
#

CREATE TABLE `Rate` (
  `Item` text,
  `Rating` int(11) default NULL,
  `Votes` int(11) default NULL,
  `Num_Votes` int(11) default NULL,
  `IP` text,
  `id` int(11) NOT NULL auto_increment,
  `viewed` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `bans`
#

CREATE TABLE `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `ip` varchar(255) default NULL,
  `email` varchar(50) default NULL,
  `message` varchar(255) default NULL,
  `expire` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `calendar_mssgs`
#

CREATE TABLE `calendar_mssgs` (
  `id` mediumint(5) unsigned NOT NULL auto_increment,
  `uid` tinyint(3) unsigned NOT NULL default '0',
  `m` tinyint(2) NOT NULL default '0',
  `d` tinyint(2) NOT NULL default '0',
  `y` smallint(4) NOT NULL default '0',
  `start_time` time NOT NULL default '00:00:00',
  `end_time` time NOT NULL default '00:00:00',
  `title` varchar(50) NOT NULL default '',
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `calendar_users`
#

CREATE TABLE `calendar_users` (
  `uid` smallint(6) NOT NULL auto_increment,
  `username` char(15) NOT NULL default '',
  `password` char(32) NOT NULL default '',
  `fname` char(20) NOT NULL default '',
  `lname` char(30) NOT NULL default '0',
  `userlevel` tinyint(2) NOT NULL default '0',
  `email` char(40) default NULL,
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `categories`
#

CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat_name` varchar(80) NOT NULL default 'New Category',
  `disp_position` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `censoring`
#

CREATE TABLE `censoring` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `search_for` varchar(60) NOT NULL default '',
  `replace_with` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `cms5_stats_browser`
#

CREATE TABLE `cms5_stats_browser` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `browser` text,
  `count` int(11) default NULL,
  `image` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=22 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `cms5_stats_colors`
#

CREATE TABLE `cms5_stats_colors` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `colors` text,
  `count` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `cms5_stats_visits`
#

CREATE TABLE `cms5_stats_visits` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `datum` text,
  `count` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=245 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `config`
#

CREATE TABLE `config` (
  `conf_name` varchar(255) NOT NULL default '',
  `conf_value` text,
  PRIMARY KEY  (`conf_name`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `downloads_auth`
#

CREATE TABLE `downloads_auth` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(80) NOT NULL default '',
  `password` varchar(80) NOT NULL default '',
  `master` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `downloads_categories`
#

CREATE TABLE `downloads_categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `downloads_config`
#

CREATE TABLE `downloads_config` (
  `config_name` varchar(20) NOT NULL default '',
  `config_value` text NOT NULL,
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `downloads_files`
#

CREATE TABLE `downloads_files` (
  `id` int(11) NOT NULL auto_increment,
  `date` text NOT NULL,
  `name` mediumtext NOT NULL,
  `count` int(11) NOT NULL default '0',
  `votes` int(11) NOT NULL default '0',
  `rating` varchar(5) NOT NULL default '0',
  `location` mediumtext NOT NULL,
  `size` varchar(100) NOT NULL default '',
  `category` int(11) NOT NULL default '0',
  `description_brief` longtext NOT NULL,
  `description_full` longtext NOT NULL,
  `custom_1_l` varchar(20) NOT NULL default '',
  `custom_1_v` varchar(40) NOT NULL default '',
  `custom_2_l` varchar(20) NOT NULL default '',
  `custom_2_v` varchar(40) NOT NULL default '',
  `image` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `forum_perms`
#

CREATE TABLE `forum_perms` (
  `group_id` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '0',
  `read_forum` tinyint(1) NOT NULL default '1',
  `post_replies` tinyint(1) NOT NULL default '1',
  `post_topics` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`,`forum_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `forums`
#

CREATE TABLE `forums` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `forum_name` varchar(80) NOT NULL default 'New forum',
  `forum_desc` text,
  `moderators` text,
  `num_topics` mediumint(8) unsigned NOT NULL default '0',
  `num_posts` mediumint(8) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned default NULL,
  `last_post_id` int(10) unsigned default NULL,
  `last_poster` varchar(200) default NULL,
  `closed` tinyint(1) NOT NULL default '0',
  `admmod_only` tinyint(1) NOT NULL default '0',
  `disp_position` int(10) NOT NULL default '0',
  `cat_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=26 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `online`
#

CREATE TABLE `online` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `logged` int(10) unsigned NOT NULL default '0'
) TYPE=HEAP;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `posts`
#

CREATE TABLE `posts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `poster_id` int(10) unsigned NOT NULL default '1',
  `poster_ip` varchar(15) default NULL,
  `poster_email` varchar(50) default NULL,
  `message` text NOT NULL,
  `smilies` tinyint(1) NOT NULL default '1',
  `posted` int(10) unsigned NOT NULL default '0',
  `edited` int(10) unsigned default NULL,
  `edited_by` varchar(200) default NULL,
  `topic_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2987 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `protect_users`
#

CREATE TABLE `protect_users` (
  `id` char(20) default NULL,
  `passwd` char(34) default NULL
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `ranks`
#

CREATE TABLE `ranks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `rank` varchar(50) NOT NULL default '',
  `min_posts` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `reports`
#

CREATE TABLE `reports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `post_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0',
  `forum_id` int(10) unsigned NOT NULL default '0',
  `reported_by` int(10) unsigned NOT NULL default '0',
  `created` int(10) unsigned NOT NULL default '0',
  `message` text NOT NULL,
  `zapped` int(10) unsigned default NULL,
  `zapped_by` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `search_cache`
#

CREATE TABLE `search_cache` (
  `id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `search_data` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `search_matches`
#

CREATE TABLE `search_matches` (
  `post_id` int(10) unsigned NOT NULL default '0',
  `word_id` int(10) unsigned NOT NULL default '0',
  `subject_match` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `search_results`
#

CREATE TABLE `search_results` (
  `id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `search_data` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `search_results_ident_idx` (`ident`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `search_words`
#

CREATE TABLE `search_words` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `word` varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (`word`),
  KEY `search_words_id_idx` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12576 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `subscriptions`
#

CREATE TABLE `subscriptions` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `topic_id` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `tblstats`
#

CREATE TABLE `tblstats` (
  `st_id` int(11) NOT NULL auto_increment,
  `st_ip` varchar(17) NOT NULL default '0',
  `st_ua` varchar(128) NOT NULL default '0',
  `st_ref` varchar(164) NOT NULL default '0',
  `st_page` varchar(128) NOT NULL default '0',
  `st_time` int(14) NOT NULL default '0',
  `st_unique` int(1) NOT NULL default '0',
  `st_ref_dom` varchar(50) NOT NULL default '',
  `st_key` varchar(64) NOT NULL default '',
  `st_tag` varchar(12) NOT NULL default '',
  PRIMARY KEY  (`st_id`)
) TYPE=MyISAM AUTO_INCREMENT=34535 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `top_ip`
#

CREATE TABLE `top_ip` (
  `ip` varchar(15) NOT NULL default '',
  `time` varchar(15) NOT NULL default ''
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `top_popup`
#

CREATE TABLE `top_popup` (
  `day` varchar(15) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `width` varchar(4) NOT NULL default '',
  `height` varchar(4) NOT NULL default '',
  `menubar` char(3) NOT NULL default '',
  `locationbar` char(3) NOT NULL default '',
  `status` char(3) NOT NULL default '',
  `resizable` char(3) NOT NULL default '',
  `scrollbars` char(3) NOT NULL default '',
  `toolbar` char(3) NOT NULL default '',
  `statistik` int(5) NOT NULL default '0',
  `ansicht` char(1) NOT NULL default '',
  `sperre` varchar(10) NOT NULL default '',
  `links` varchar(5) NOT NULL default '',
  `oben` varchar(5) NOT NULL default '',
  `tag` varchar(15) NOT NULL default '',
  `anfang` varchar(5) NOT NULL default '',
  `ende` varchar(5) NOT NULL default ''
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `topics`
#

CREATE TABLE `topics` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `poster` varchar(200) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `posted` int(10) unsigned NOT NULL default '0',
  `last_post` int(10) unsigned NOT NULL default '0',
  `last_post_id` int(10) unsigned NOT NULL default '0',
  `last_poster` varchar(200) default NULL,
  `num_views` mediumint(8) unsigned NOT NULL default '0',
  `num_replies` mediumint(8) unsigned NOT NULL default '0',
  `closed` tinyint(1) NOT NULL default '0',
  `sticky` tinyint(1) NOT NULL default '0',
  `moved_to` int(10) unsigned default NULL,
  `forum_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=203 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `users`
#

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `title` varchar(50) default NULL,
  `realname` varchar(40) default NULL,
  `url` varchar(100) default NULL,
  `icq` varchar(12) default NULL,
  `msn` varchar(50) default NULL,
  `aim` varchar(20) default NULL,
  `yahoo` varchar(20) default NULL,
  `location` varchar(30) default NULL,
  `use_avatar` tinyint(1) NOT NULL default '0',
  `signature` text,
  `disp_topics` tinyint(3) unsigned default NULL,
  `disp_posts` tinyint(3) unsigned default NULL,
  `email_setting` tinyint(1) NOT NULL default '1',
  `save_pass` tinyint(1) NOT NULL default '1',
  `notify_with_post` tinyint(1) NOT NULL default '0',
  `smilies` tinyint(1) NOT NULL default '1',
  `show_img` tinyint(1) NOT NULL default '1',
  `show_avatars` tinyint(1) NOT NULL default '1',
  `show_sig` tinyint(1) NOT NULL default '1',
  `link_to_new_win` tinyint(1) NOT NULL default '1',
  `timezone` tinyint(2) NOT NULL default '0',
  `style` varchar(25) NOT NULL default 'Oxygen',
  `num_posts` int(10) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '-1',
  `last_post` int(10) unsigned default NULL,
  `registered` int(10) unsigned NOT NULL default '0',
  `last_visit` int(10) unsigned NOT NULL default '0',
  `last_action` int(10) unsigned NOT NULL default '0',
  `admin_note` varchar(30) default NULL,
  `activate_string` varchar(50) default NULL,
  `activate_key` varchar(8) default NULL,
  `language` varchar(10) default NULL,
  `access` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=128 ;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `zz_messages`
#

CREATE TABLE `zz_messages` (
  `ID` int(5) NOT NULL default '0',
  `time` datetime default NULL,
  `user` varchar(18) NOT NULL default '',
  `msgtext` text NOT NULL,
  `target` text NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `ID_2` (`ID`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `zz_user`
#

CREATE TABLE `zz_user` (
  `ID` varchar(200) NOT NULL default '',
  `logintime` datetime default NULL,
  `user` varchar(18) NOT NULL default '',
  `IP` varchar(150) NOT NULL default '',
  `status` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `ID_2` (`ID`)
) TYPE=MyISAM;

Logger and cms5 are counters, PPA is a Picture-Gallery, zz a chat and downloads is a download-Manager. Do I forgot anything?

After upgrading to 1.2 (using 11_to_12_update.php) my Database was completly unusable. I got the same error as RaWeN...

Re: 1.1.5 -> 1.2 update problems...

That is not a clean 1.1.4 dump. It contains tables from 1.2 as well. I suggest you revert to the database you had before you ran the 1.2 update script. Also, a tip for the future is to use a table prefix when you install PunBB in the same database a lots of other applications.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

18

Re: 1.1.5 -> 1.2 update problems...

Does version 1.2.1 solve the upgrade-problem?

Re: 1.1.5 -> 1.2 update problems...

f10 wrote:

Does version 1.2.1 solve the upgrade-problem?

If by that you mean "does it repair the damage done by the old migration tool?" the answer is no. Now that the migration tool has been updated, I didn't feel it was worth spending hours and hours on. If you mean your particular upgrade problem, the answer is also no, but that's because it's not a problem with the upgrade script. Your database is missing a table. There's nothing the upgrade script can do about that. Add the table manually and see if that helps.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

20

Re: 1.1.5 -> 1.2 update problems...

it's strange that several persons have exactly the same problem. I think Rod has the same problem with indexes missing. I got exactly the same problem. My 1.2 works without indexes so it's slower.
A method to create missing indexes would be appreciated.

Ludo,

Re: 1.1.5 -> 1.2 update problems...

It's not strange. The problem was that the previous version of Chacmool's converter didn't properly add the indexes back after the conversion was complete. I will look into creating a script that tries to remedy the situation.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

22

Re: 1.1.5 -> 1.2 update problems...

Thanks Rickard. In the meantime, I fully restored the old 1.1.4 database including all tables and PunBB is working as good as before... But I don't have the time, to do a restore of the database again, when the same error will occure during the installation of 1.2.1.

If it's no problem to upgrade with Chacmool's new 1.2.1 converter, I will give a try. Anybody tried yet?

23

Re: 1.1.5 -> 1.2 update problems...

Database reported: Can't DROP 'search_results_ident_idx'. Check that column/key exists (Errno: 1091)

that happend with me when i renamed my tables from punbb_en_xxx to punbb_xxx
when i return to the original names (restore db) uprade done successful.

If your people come crazy, you will not need to your mind any more.

24

Re: 1.1.5 -> 1.2 update problems...

Rickard wrote:

I will look into creating a script that tries to remedy the situation.

Thanks

25

Re: 1.1.5 -> 1.2 update problems...

I currently have 1.1.5 as well, am I going to run any problems going to 1.2.1 ? Is there a guide inside the .tar.gz on how to do this cleanly without errors?