phpBB Türkiye

Knowledge Base Mod kurdum ama, ne zaman sqlleri calıştırmaya kalksam sqlsi çalışmıyor..install_kb_tables.php dosyasına girdiğimde sql yüklemek yerine, hata veriyor..

Hata Kodu

Kod: Tümünü seç

Warning: mysql_connect(): Access denied for user: 'www-data@civilian.epidio.net' (Using password: NO) in /home/turkapaylasim/public_html/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/turkapaylasim/public_html/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/turkapaylasim/public_html/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Knowledge Base 2.0.2'nin sqlsini bi de phpMyAdminden çalıştırayım dicem ama sqlsini de tam olarak vermemiş. Bilen varsa lütfen yazsın..

Tablo yapılarında bir sorun var, otomatik sql çalıştırıcısı çalışmıyor. Aynı sorunu ben de yaşamıştım, sonra sql dosyalarından tabloları ayıklayarak eklemiştim veritabanına.

Bu modun tam sqlsini bilsem, phpMyAdmin'den halledicem ama adamlar install.txt'de vermemişler ki..

bununla ilgili başlık vardı ama bulamadım o yüzden veriorum

daha önce bi arkadaş yayınlamıştı

sqlar şu şekilde

Kod: Tümünü seç

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;

Umarım, çalışır.. Teşekkürler

Merhaba,

SQL güncellemelerinden önce, kullandığını veritabanı şifresinin size gereken izni sağlamadığı açıkça görülüyor. Şifre de kullanmıyormuşsunuz. Size alan sağlayan firma ile irtibata geçmenizi ya da bilgilerinizi doğru girmenizi öneririm.

Kolay gelsin.

Aslında bu sitede pek çok db update yapmıştım.. İlk defa oldu..

Neyse, bir dahakinde konuşurum.. Zaten Sqlleri artık sorgulatabildim..

Herkese teşekkürler..

Couldnt Query Custom field

DEBUG MODE

SQL Error : 1146 Table 'mrock_rock.phpbb_kb_custom' doesn't exist

SELECT * FROM phpbb_kb_custom ORDER BY field_order ASC

Line : 50
File : functions_kb_field.php