bende install.php dosyası çalışmamaktadır bende sql tablosunu phpmyadmine dump(yanlışsa kusura bakmayın kopyala-yapıştır) yöntemiyle yerleştirmeyi düşünüyorum...
bana en acilinden sql tablosunu gönderebilirmisiniz???
CREATE TABLE . `KB_ARTICLES_TABLE` (
article_id mediumint(8) unsigned NOT NULL auto_increment,
article_category_id mediumint(8) unsigned NOT NULL default "0",
article_title varchar(255) binary NOT NULL default "",
article_description varchar(255) binary NOT NULL default "",
article_date varchar(255) binary NOT NULL default "",
article_author_id mediumint(8) NOT NULL,
username VARCHAR(255),
bbcode_uid varchar(10) binary 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)
) TYPE=MyISAM;
INSERT INTO `KB_ARTICLES_TABLE` VALUES (
1, 1, "Test Article", "This is a test article for your KB", "1057708235", 2, "", "93074f48a9", "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, 0, 0,0,0);
CREATE TABLE `KB_CATEGORIES_TABLE`(
category_id mediumint(8) unsigned NOT NULL auto_increment,
category_name VARCHAR(255) binary NOT NULL,
category_details VARCHAR(255) binary NOT NULL,
number_articles mediumint(8) unsigned NOT NULL,
parent mediumint(8) unsigned,
cat_order mediumint(8) unsigned NOT NULL,
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),
auth_post_groups varchar(255),
auth_rate_groups varchar(255),
auth_comment_groups varchar(255),
auth_edit_groups varchar(255),
auth_delete_groups varchar(255),
auth_approval_groups varchar(255),
auth_approval_edit_groups varchar(255),
auth_moderator_groups varchar(255),
comments_forum_id tinyint(3) NOT NULL DEFAULT "-1",
KEY category_id (category_id)
) TYPE=MyISAM;
INSERT INTO `KB_CATEGORIES_TABLE`VALUES (1, "Test Category 1", "This is a test category", "0", "0", "10", "0", "0", "0", "0", "0", "2", "0", "0", "", "", "", "", "", "", "", "", "", "0" );
CREATE TABLE .`KB_CONFIG_TABLE`(
config_name VARCHAR(255) NOT NULL default "",
config_value varchar(255) NOT NULL default "",
PRIMARY KEY (config_name)
) TYPE=MyISAM;
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("allow_new", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("notify", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("admin_id", "2");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) values("show_pretext","0");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) values("pt_header","Article Submission Instructions");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) values("pt_body","Please check your references and include as much information as you can.");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("use_comments", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("del_topic", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("use_ratings", "0");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("comments_show", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("bump_post", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("stats_list", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("header_banner", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("votes_check_userid", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("votes_check_ip", "1");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("art_pagination", "5");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("comments_pagination", "5");
INSERT INTO `KB_CONFIG_TABLE` (config_name, config_value) VALUES ("news_sort", "Alphabetic");
INSERT INTO `KB_CONFIG_TABLE` VALUES ("news_sort_par", "ASC");
INSERT INTO `KB_CONFIG_TABLE` VALUES ("wysiwyg", "0");
INSERT INTO `KB_CONFIG_TABLE` VALUES ("wysiwyg_path", "modules/");
INSERT INTO `KB_CONFIG_TABLE` VALUES ("allow_html", "1");
INSERT INTO `KB_CONFIG_TABLE` VALUES ("allow_bbcode", "1");
INSERT INTO `KB_CONFIG_TABLE` VALUES ("allow_smilies", "1");
INSERT INTO `KB_CONFIG_TABLE` VALUES ("formatting_fixup", "0");
INSERT INTO `KB_CONFIG_TABLE` VALUES ("allowed_html_tags", "b,i,u,a");
CREATE TABLE `KB_TYPES_TABLE` (
id mediumint(8) unsigned NOT NULL auto_increment,
type varchar(255) binary DEFAULT "" NOT NULL,
KEY id (id)
) TYPE=MyISAM;
INSERT INTO `KB_TYPES_TABLE` VALUES (1, "Test Type 1")
CREATE TABLE `KB_VOTES_TABLE` (
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;
CREATE TABLE `KB_SEARCH_TABLE` (
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)
) TYPE=MyISAM;
CREATE TABLE `KB_WORD_TABLE ` (
word_text varchar(50) binary 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)
) TYPE=MyISAM;
CREATE TABLE `KB_MATCH_TABLE` (
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)
) TYPE=MyISAM;
CREATE TABLE `KB_CUSTOM_TABLE` (
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;
CREATE TABLE `KB_CUSTOM_DATA_TABLE` (
customdata_file int(50) NOT NULL default "0",
customdata_custom int(50) NOT NULL default "0",
data text NOT NULL
) TYPE=MyISAM;
SQL sorgusu:
INSERT INTO `KB_TYPES_TABLE`
VALUES ( 1, "Test Type 1" )
CREATE TABLE `KB_VOTES_TABLE` (
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
MySQL çıktısı:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `KB_VOTES_TABLE` (
votes_
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) binary NOT NULL default "",
article_description varchar(255) binary NOT NULL default "",
article_date varchar(255) binary NOT NULL default "",
article_author_id mediumint(8) NOT NULL,
username VARCHAR(255),
bbcode_uid varchar(10) binary 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)
) TYPE=MyISAM;
INSERT INTO phpbb_kb_articles VALUES ("1", "1", "Test Article", "This is a test article for your KB", "1057708235", 2, "", "93074f48a9", "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", "0", "0", "0", "0");
CREATE TABLE phpbb_kb_categories (
category_id mediumint(8) unsigned NOT NULL auto_increment,
category_name VARCHAR(255) binary NOT NULL,
category_details VARCHAR(255) binary NOT NULL,
number_articles mediumint(8) unsigned NOT NULL,
parent mediumint(8) unsigned,
cat_order mediumint(8) unsigned NOT NULL,
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),
auth_post_groups varchar(255),
auth_rate_groups varchar(255),
auth_comment_groups varchar(255),
auth_edit_groups varchar(255),
auth_delete_groups varchar(255),
auth_approval_groups varchar(255),
auth_approval_edit_groups varchar(255),
auth_moderator_groups varchar(255),
comments_forum_id tinyint(3) NOT NULL DEFAULT "-1",
KEY category_id (category_id)
) TYPE=MyISAM;
INSERT INTO phpbb_kb_categories VALUES ("1", "Test Category 1", "This is a test category", "0", "0", "10", "0", "0", "0", "0", "0", "2", "0", "0", "", "", "", "", "", "", "", "", "", "0" );
CREATE TABLE phpbb_kb_config (
config_name VARCHAR(255) NOT NULL default "",
config_value varchar(255) NOT NULL default "",
PRIMARY KEY (config_name)
) TYPE=MyISAM;
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("allow_new", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("notify", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("admin_id", "2");
INSERT INTO phpbb_kb_config(config_name, config_value) values("show_pretext", "0");
INSERT INTO phpbb_kb_config(config_name, config_value) values("pt_header","Article Submission Instructions");
INSERT INTO phpbb_kb_config(config_name, config_value) values("pt_body","Please check your references and include as much information as you can.");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("use_comments", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("del_topic", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("use_ratings", "0");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("comments_show", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("bump_post", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("stats_list", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("header_banner", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("votes_check_userid", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("votes_check_ip", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("art_pagination", "5");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("comments_pagination", "5");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("news_sort", "Alphabetic");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("news_sort_par", "ASC");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("wysiwyg", "0");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("wysiwyg_path", "modules/");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("allow_html", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("allow_bbcode", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("allow_smilies", "1");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("formatting_fixup", "0");
INSERT INTO phpbb_kb_config(config_name, config_value) VALUES ("allowed_html_tags", "b,i,u,a");
CREATE TABLE phpbb_kb_types (id mediumint(8) unsigned NOT NULL auto_increment, type varchar(255) binary DEFAULT "" NOT NULL, KEY id (id)) TYPE=MyISAM;
INSERT INTO phpbb_kb_types VALUES ("1", "Test Type 1");
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;
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)
) TYPE=MyISAM;
CREATE TABLE phpbb_kb_wordlist (
word_text varchar(50) binary 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)
) TYPE=MyISAM;
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)
) TYPE=MyISAM;
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;
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
) TYPE=MyISAM;
Bu forumu görüntüleyenler: Kayıtlı kullanıcı yok ve 0 misafir