Hallo zusammen
Hat jemand eine Idee - was hier noch fehlt?
Installation:
Performing database updates
CREATE TABLE IF NOT EXISTS `fr_boards` ( `board_id` smallint(5) NOT NULL auto_increment, `cat_id` tinyint(4) NOT NULL default '0', `child_level` tinyint(4) NOT NULL default '0', `parent_id` smallint(5) NOT NULL default '0', `board_order` smallint(5) NOT NULL default '0', `last_msg_id` int(10) NOT NULL default '0', `updated_msg_id` int(10) NOT NULL default '0', `name` tinytext NOT NULL, `description` text NOT NULL, `topics` mediumint(
NOT NULL default '0', `posts` mediumint(
NOT NULL default '0', PRIMARY KEY (`board_id`) ) TYPE=MyISAM Already Done
CREATE TABLE IF NOT EXISTS `fr_categories` ( `cat_id` tinyint(4) NOT NULL auto_increment, `cat_order` tinyint(4) NOT NULL default '0', `name` tinytext NOT NULL, PRIMARY KEY (`cat_id`) ) TYPE=MyISAM Already Done
CREATE TABLE IF NOT EXISTS `fr_message_icons` ( `icon_id` smallint(5) NOT NULL auto_increment, `title` varchar(80) NOT NULL default '', `filename` varchar(80) NOT NULL default '', `icon_order` smallint(5) NOT NULL default '0', PRIMARY KEY (`icon_id`) ) TYPE=MyISAM AUTO_INCREMENT=14 Already Done
INSERT INTO `fr_message_icons` (`icon_id`, `title`, `filename`, `icon_order`) VALUES (1, 'Post', 'icon1', 0), (2, 'Smile', 'icon2', 1), (3, 'Big smile', 'icon3', 2), (4, 'Angry', 'icon4', 3), (5, 'Cool', 'icon5', 4), (6, 'Sad', 'icon6', 5), (7, 'Wink', 'icon7', 6), (8, 'Comment', 'icon8', 7), (9, 'Magnify', 'icon9',
, (10, 'Icon', 'icon10', 9), (11, 'Lamp', 'icon11', 10), (12, 'Bug', 'icon12', 11), (13, 'Wheel', 'icon13', 12) Already Done
CREATE TABLE IF NOT EXISTS `fr_messages` ( `msg_id` int(10) NOT NULL auto_increment, `topic_id` mediumint(
NOT NULL default '0', `board_id` smallint(5) NOT NULL default '0', `poster_time` int(10) NOT NULL default '0', `poster_id` mediumint(
NOT NULL default '0', `modified_id` int(10) NOT NULL default '0', `subject` tinytext NOT NULL, `poster_name` tinytext NOT NULL, `poster_email` tinytext NOT NULL, `poster_ip` tinytext NOT NULL, `smileys_enabled` tinyint(4) NOT NULL default '1', `modified_time` int(10) NOT NULL default '0', `modified_name` tinytext NOT NULL, `body` text NOT NULL, `icon` varchar(16) NOT NULL default '1', PRIMARY KEY (`msg_id`) ) TYPE=MyISAM Already Done
CREATE TABLE IF NOT EXISTS `fr_topics` ( `topic_id` mediumint(
NOT NULL auto_increment, `is_sticky` tinyint(4) NOT NULL default '0', `board_id` smallint(5) NOT NULL default '0', `first_msg_id` int(10) NOT NULL default '0', `last_msg_id` int(10) NOT NULL default '0', `started_member_id` int(
NOT NULL default '0', `updated_member_id` int(
NOT NULL default '0', `poll_id` mediumint(
NOT NULL default '0', `replies` int(10) NOT NULL default '0', `views` int(10) NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', PRIMARY KEY (`topic_id`) ) TYPE=MyISAM Already Done
INSERT INTO `config` (name, value) VALUES ('fr_version', '2.0 Beta') OK
INSERT INTO `config` (name, value) VALUES ('fr_title', 'Coppermine Simple Forum') OK
INSERT INTO `config` (name, value) VALUES ('fr_guest_browse', 1) OK
INSERT INTO `config` (name, value) VALUES ('fr_guest_post', 1) OK
INSERT INTO `config` (name, value) VALUES ('fr_hot_topic_msg', 20) OK
INSERT INTO `config` (name, value) VALUES ('fr_topic_per_page', 20) OK
INSERT INTO `config` (name, value) VALUES ('fr_msg_max_size', 512) OK
INSERT INTO `config` (name, value) VALUES ('fr_msg_per_page', 15) OK
INSERT INTO `config` (name, value) VALUES ('fr_max_word_length', 30) OK
INSERT INTO `config` (name, value) VALUES ('fr_gap_time', 30) OK
INSERT INTO `config` (name, value) VALUES ('fr_avatar_size', 100) OK
INSERT INTO `config` (name, value) VALUES ('fr_signature_max_size', 512) OK
ALTER TABLE `users` ADD `fr_avatar` varchar(255) NOT NULL DEFAULT '' OK
ALTER TABLE `users` ADD `fr_signature` text NOT NULL DEFAULT '' OK
Performing database updates
UPDATE `config` SET value='2.1/Beta/9' where name='fr_version' OK
CREATE TABLE IF NOT EXISTS `fr_notify` ( `user_id` int(10) NOT NULL default '0', `topic_id` mediumint(
NOT NULL default '0', `board_id` smallint(5) NOT NULL default '0', `send` tinyint(1) NOT NULL default '0' ) TYPE=MyISAM Already Done
INSERT INTO `config` (name, value) VALUES ('fr_time_online_checking', 5) OK
CREATE TABLE IF NOT EXISTS `fr_badwords` ( `word_id` int(10) NOT NULL auto_increment, `word` varchar(45) NOT NULL default '', `replace` varchar(45) NOT NULL default '', PRIMARY KEY (`word_id`) ) TYPE=MyISAM Already Done
INSERT INTO `config` (name, value) VALUES ('fr_msg_icons', 1) OK
ALTER TABLE `fr_messages` ALTER `icon` SET DEFAULT '1' Already Done
>> Wenn ich Forum aufrufe:
Array (
- => Error Number: 1146 [1] => Table 'stettlernet_bettstett_mysql8697e198ddc66ba90d602a04b69d6aec.fr_messages' doesn't exist [2] => SELECT COUNT(*) as count FROM fr_messages WHERE poster_id = 1 )
Besten Dank für die Hilfe
Gruss - Stettler Martin