xvoid писал(а):Вобщем проблема описывалась уже, но я невнятно её описал
Сори, рыскаю ненахожу, можно ссылку на топик с решением ?xvoid писал(а):я тогда много у вас перелопатил
Вот решение этой проблемы:В админке так же есть пункт "Types man ", там "Создать новый тип:", вписываю что угодно, хоть на разных языках, хоть цифрами, ничего несоздает а меня перекидывает в "Предварительный просмотр форума"
Столкнулся с той же проблемой, потом сделал рукамиNCom писал(а): не дадите мне список SQL которые нужно создать? попробовать руками
Код: Выделить всё
DROP TABLE IF EXISTS `phpbb_kb_articles`;
CREATE TABLE `phpbb_kb_articles` (
`article_id` mediumint(8) unsigned NOT NULL auto_increment,
`article_category_id` mediumint(8) unsigned NOT NULL default '0',
`article_title` varchar(255) NOT NULL default '',
`article_description` varchar(255) NOT NULL default '',
`article_date` varchar(255) NOT NULL default '',
`article_author_id` mediumint(8) NOT NULL default '0',
`username` varchar(255) default NULL,
`bbcode_uid` varchar(10) NOT NULL default '',
`article_body` text NOT NULL,
`article_type` mediumint(8) unsigned NOT NULL default '0',
`approved` tinyint(1) unsigned NOT NULL default '0',
`topic_id` mediumint(8) unsigned NOT NULL default '0',
`views` bigint(8) NOT NULL default '0',
`article_rating` double(6,4) NOT NULL default '0.0000',
`article_totalvotes` int(255) NOT NULL default '0',
KEY `article_id` (`article_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `phpbb_kb_articles`
--
INSERT INTO `phpbb_kb_articles` VALUES (1, 1, 0x546573742041727469636c65, 0x54686973206973206120746573742061727469636c6520666f7220796f7572204b42, 0x31303537373038323335, 2, '', 0x39333037346634386139, 'This is a test article for your Knowledge Base. This MOD is based on code written by wGEric < eric@egcnetwork.com > (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo < jonohlsson@hotmail.com > (Jon Ohlsson) - http://www.mx-system.com/ \r\n\r\nBe sure you add categories and article types in the ACP and also change the Configuration to your liking.\r\n\r\nHave fun and enjoy your new Knowledge Base! :D', 1, 1, 257, 22, 0.0000, 0);
DROP TABLE IF EXISTS `phpbb_kb_categories`;
CREATE TABLE `phpbb_kb_categories` (
`category_id` mediumint(8) unsigned NOT NULL auto_increment,
`category_name` varchar(255) NOT NULL default '',
`category_details` varchar(255) NOT NULL default '',
`number_articles` mediumint(8) unsigned NOT NULL default '0',
`parent` mediumint(8) unsigned default NULL,
`cat_order` mediumint(8) unsigned NOT NULL default '0',
`auth_view` tinyint(3) NOT NULL default '0',
`auth_post` tinyint(3) NOT NULL default '0',
`auth_rate` tinyint(3) NOT NULL default '0',
`auth_comment` tinyint(3) NOT NULL default '0',
`auth_edit` tinyint(3) NOT NULL default '0',
`auth_delete` tinyint(3) NOT NULL default '2',
`auth_approval` tinyint(3) NOT NULL default '0',
`auth_approval_edit` tinyint(3) NOT NULL default '0',
`auth_view_groups` varchar(255) default NULL,
`auth_post_groups` varchar(255) default NULL,
`auth_rate_groups` varchar(255) default NULL,
`auth_comment_groups` varchar(255) default NULL,
`auth_edit_groups` varchar(255) default NULL,
`auth_delete_groups` varchar(255) default NULL,
`auth_approval_groups` varchar(255) default NULL,
`auth_approval_edit_groups` varchar(255) default NULL,
`auth_moderator_groups` varchar(255) default NULL,
`comments_forum_id` tinyint(3) NOT NULL default '-1',
KEY `category_id` (`category_id`)
) ENGINE=MyISAM;
--
-- Дамп данных таблицы `phpbb_kb_categories`
--
INSERT INTO `phpbb_kb_categories` VALUES (1, 0x546573742043617465676f72792031, 0x54686973206973206120746573742063617465676f7279, 2, 0, 10, 0, 0, 0, 0, 0, 2, 0, 0, '', '', '', '', '', '', '', '', '', 35);
DROP TABLE IF EXISTS `phpbb_kb_config`;
CREATE TABLE `phpbb_kb_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) ENGINE=MyISAM;
--
-- Дамп данных таблицы `phpbb_kb_config`
--
INSERT INTO `phpbb_kb_config` VALUES ('allow_new', '1');
INSERT INTO `phpbb_kb_config` VALUES ('notify', '1');
INSERT INTO `phpbb_kb_config` VALUES ('admin_id', '2');
INSERT INTO `phpbb_kb_config` VALUES ('show_pretext', '0');
INSERT INTO `phpbb_kb_config` VALUES ('pt_header', 'Article Submission Instructions');
INSERT INTO `phpbb_kb_config` VALUES ('pt_body', 'Please check your references and include as much information as you can.');
INSERT INTO `phpbb_kb_config` VALUES ('use_comments', '1');
INSERT INTO `phpbb_kb_config` VALUES ('del_topic', '1');
INSERT INTO `phpbb_kb_config` VALUES ('use_ratings', '0');
INSERT INTO `phpbb_kb_config` VALUES ('comments_show', '1');
INSERT INTO `phpbb_kb_config` VALUES ('bump_post', '1');
INSERT INTO `phpbb_kb_config` VALUES ('stats_list', '1');
INSERT INTO `phpbb_kb_config` VALUES ('header_banner', '1');
INSERT INTO `phpbb_kb_config` VALUES ('votes_check_userid', '1');
INSERT INTO `phpbb_kb_config` VALUES ('votes_check_ip', '1');
INSERT INTO `phpbb_kb_config` VALUES ('art_pagination', '5');
INSERT INTO `phpbb_kb_config` VALUES ('comments_pagination', '5');
INSERT INTO `phpbb_kb_config` VALUES ('news_sort', 'Alphabetic');
INSERT INTO `phpbb_kb_config` VALUES ('news_sort_par', 'ASC');
INSERT INTO `phpbb_kb_config` VALUES ('wysiwyg', '0');
INSERT INTO `phpbb_kb_config` VALUES ('wysiwyg_path', 'modules/');
INSERT INTO `phpbb_kb_config` VALUES ('allow_html', '1');
INSERT INTO `phpbb_kb_config` VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_kb_config` VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_kb_config` VALUES ('formatting_fixup', '0');
INSERT INTO `phpbb_kb_config` VALUES ('allowed_html_tags', 'b,i,u,a');
DROP TABLE IF EXISTS `phpbb_kb_custom`;
CREATE TABLE `phpbb_kb_custom` (
`custom_id` int(50) NOT NULL auto_increment,
`custom_name` text NOT NULL,
`custom_description` text NOT NULL,
`data` text NOT NULL,
`field_order` int(20) NOT NULL default '0',
`field_type` tinyint(2) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
PRIMARY KEY (`custom_id`)
) ENGINE=MyISAM ;
DROP TABLE IF EXISTS `phpbb_kb_customdata`;
CREATE TABLE `phpbb_kb_customdata` (
`customdata_file` int(50) NOT NULL default '0',
`customdata_custom` int(50) NOT NULL default '0',
`data` text NOT NULL
) ENGINE=MyISAM;
DROP TABLE IF EXISTS `phpbb_kb_results`;
CREATE TABLE `phpbb_kb_results` (
`search_id` int(11) unsigned NOT NULL default '0',
`session_id` varchar(32) NOT NULL default '',
`search_array` text NOT NULL,
PRIMARY KEY (`search_id`),
KEY `session_id` (`session_id`)
) ENGINE=MyISAM;
DROP TABLE IF EXISTS `phpbb_kb_types`;
CREATE TABLE `phpbb_kb_types` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`type` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM;
--
-- Дамп данных таблицы `phpbb_kb_types`
--
INSERT INTO `phpbb_kb_types` VALUES (1, 0x547970652031);
DROP TABLE IF EXISTS `phpbb_kb_votes`;
CREATE TABLE `phpbb_kb_votes` (
`votes_ip` varchar(50) NOT NULL default '0',
`votes_userid` int(50) NOT NULL default '0',
`votes_file` int(50) NOT NULL default '0'
) ENGINE=MyISAM;
DROP TABLE IF EXISTS `phpbb_kb_wordlist`;
CREATE TABLE `phpbb_kb_wordlist` (
`word_text` varchar(50) NOT NULL default '',
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word_common` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`word_text`),
KEY `word_id` (`word_id`)
) ENGINE=MyISAM;
DROP TABLE IF EXISTS `phpbb_kb_wordmatch`;
CREATE TABLE `phpbb_kb_wordmatch` (
`article_id` mediumint(8) unsigned NOT NULL default '0',
`word_id` mediumint(8) unsigned NOT NULL default '0',
`title_match` tinyint(1) NOT NULL default '0',
KEY `post_id` (`article_id`),
KEY `word_id` (`word_id`)
) ENGINE=MyISAM;
Код: Выделить всё
#
#---------[OPEN]----------------------------------------------
#
kb_cat_admin_body.tpl and kb_type_body.tpl
#
#---------[FIND]-----------------------------------------------
#
<form action="{S_ACTION}" method="GET">
#
#----------[REPLACE WITH]-----------------------------------
#
<form action="{S_ACTION}" method="POST">
#
#----------[SAVE ALL]-----------------------------------------
#
Код: Выделить всё
Running query :: ALTER TABLE phpbb_kb_articles ADD article_rating double(6,4) NOT NULL default "0.0000" ; -> ERROR - QUERY FAILED ----> Table 'modelldepo.phpbb_kb_articles' doesn't exist
Running query :: ALTER TABLE phpbb_kb_articles ADD article_totalvotes int(255) NOT NULL default "0" ; -> ERROR - QUERY FAILED ----> Table 'modelldepo.phpbb_kb_articles' doesn't exist
Running query :: INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_rating", "0") ; -> ERROR - QUERY FAILED ----> Duplicate entry 'allow_rating' for key 1
Running query :: INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_anonymos_rating", "0") ; -> ERROR - QUERY FAILED ----> Duplicate entry 'allow_anonymos_rating' for key 1
Running query :: INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("comments_show", "1") ; -> ERROR - QUERY FAILED ----> Duplicate entry 'comments_show' for key 1
Running query :: INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("mod_group", "0") ; -> ERROR - QUERY FAILED ----> Duplicate entry 'mod_group' for key 1
Running query :: INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("bump_post", "1") ; -> ERROR - QUERY FAILED ----> Duplicate entry 'bump_post' for key 1
Running query :: INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("stats_list", "1") ; -> ERROR - QUERY FAILED ----> Duplicate entry 'stats_list' for key 1
Running query :: INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("header_banner", "1") ; -> ERROR - QUERY FAILED ----> Duplicate entry 'header_banner' for key 1
Running query :: CREATE TABLE phpbb_kb_votes ( votes_ip varchar(50) NOT NULL default "0", votes_userid int(50) NOT NULL default "0", votes_file int(50) NOT NULL default "0" ) TYPE=MyISAM -> ERROR - QUERY FAILED ----> Table 'phpbb_kb_votes' already exists
Running query :: CREATE TABLE phpbb_kb_custom ( custom_id int(50) NOT NULL auto_increment, custom_name text NOT NULL, custom_description text NOT NULL, data text NOT NULL, field_order int(20) NOT NULL default "0", field_type tinyint(2) NOT NULL default "0", regex varchar(255) NOT NULL default "", PRIMARY KEY (custom_id) ) TYPE=MyISAM; -> ERROR - QUERY FAILED ----> Table 'phpbb_kb_custom' already exists
Running query :: ALTER TABLE phpbb_kb_articles MODIFY article_author_id mediumint(8) NOT NULL ; -> ERROR - QUERY FAILED ----> Table 'modelldepo.phpbb_kb_articles' doesn't exist
Код: Выделить всё
error getting quick stats
DEBUG MODE
SQL Error : 1146 Table 'modelldepo.phpbb_kb_articles' doesn't exist
SELECT article_id FROM phpbb_kb_articles WHERE article_type = 1
Line : 74
File : functions_kb.php
Код: Выделить всё
Could not obtain article data
DEBUG MODE
SQL Error : 1146 Table 'modelldepo.phpbb_kb_articles' doesn't exist
SELECT t.*, u.user_id, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile FROM phpbb_kb_articles t, phpbb_users u WHERE u.user_id = t.article_author_id AND t.approved = 2 ORDER BY t.article_id
Line : 251
File : functions_kb.php
Руками.Whity писал(а):Как это исправить?
Код: Выделить всё
Table 'modelldepo.phpbb_kb_articles' doesn't exist
Код: Выделить всё
Table 'phpbb_kb_custom' already exists