1 Reply by f10

(71 replies, posted in News)

If someone make a bad entry at registration (for e.g. too short password), he has to wait one hour to reenter the right data? He only sees an unclickable button nad has no idea that's for preventing of denial-of-service-attack...

Go to forum: News

2 Topic by f10

(0 replies, posted in PunBB 1.2 troubleshooting)

How can I use graphics (like in version 1.1.4) instead of the CSS-post status indicators (in version 1.2.2)?

Thanks...

Go to forum: PunBB 1.2 troubleshooting

3 Reply by f10

(39 replies, posted in PunBB 1.2 troubleshooting)

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?

Go to forum: PunBB 1.2 troubleshooting

4 Reply by f10

(39 replies, posted in PunBB 1.2 troubleshooting)

Does version 1.2.1 solve the upgrade-problem?

Go to forum: PunBB 1.2 troubleshooting

5 Reply by f10

(39 replies, posted in PunBB 1.2 troubleshooting)

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...

Go to forum: PunBB 1.2 troubleshooting

6 Reply by f10

(39 replies, posted in PunBB 1.2 troubleshooting)

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

Go to forum: PunBB 1.2 troubleshooting

7 Reply by f10

(39 replies, posted in PunBB 1.2 troubleshooting)

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?

Go to forum: PunBB 1.2 troubleshooting

8 Reply by f10

(39 replies, posted in PunBB 1.2 troubleshooting)

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)

Go to forum: PunBB 1.2 troubleshooting