KB Issues!

[fords8]

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: [url]http://[/url]

PHP Version:
MySQL Version:


What was done before the problem appeared?
I think this started after a upgrade to Integramod 141 from Integramod 140.


What was done to try to solve the problem?
Tryed to do DB Maintenance and a few other things.



De.scription and Message

1ST issue:
KB Articles are not being posted to the forum I have them pointed to in the KB Configuration in the admin panel.

2ND issue:
Under KB Configuration in the admin panel where it says *Comments settings* I am trying to set Allow comments to yes and when I hot submit and go back, it does not change to yes. No remains checked off.

3RD issue:
Under KB Configuration in the admin panel where it says *Ratings settings* I am trying to set Allow ratings to yes and when I hot submit and go back, it does not change to yes. No remains checked off.

Thanks!

[Dioncecht]

A similar thing happened to me. Check your database and make sure you have fields for the options that aren't changing. I think you'll find that once you get the database corrected, all of your issues, including the first one will go away.

[fords8]

Could you explain abit more.

[Teelk]

Hmmm... this is the second time the KB install queries failed... very strange.

Compare the following SQL to your database. Use phpmyadmin, usually from cpanel to view your database. Ensure the following tables exist, and then browse each table to ensure that each of the fields exists within. If a table doesn't exist, run copy and paste the code for it from the below code into the sql query section of phpmyadmin.

Code: Select all

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_de.scription varchar(255) binary NOT NULL default '',   article_date varchar(255) binary NOT NULL default '',   article_author_id mediumint(8) unsigned NOT NULL default '0',   username varchar(255) default NULL,   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;  CREATE TABLE phpbb_kb_categories (   category_id mediumint(8) unsigned NOT NULL auto_increment,   category_name varchar(255) binary NOT NULL default '',   category_details varchar(255) binary 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),   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;  CREATE TABLE phpbb_kb_config (   config_name varchar(255) NOT NULL default '',   config_value varchar(255) default NULL,   PRIMARY KEY  (config_name) ) 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_types (   id mediumint(8) unsigned NOT NULL auto_increment,   type varchar(255) binary NOT NULL default '',   KEY id (id) ) TYPE=MyISAM;  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_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_de.scription 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;

The following sql code is the contents of the kb config table. Go through it and see if all of these exist within that table. I'm guessing they don't as you can't save some configuration information. If it doesn't exist you can run the query associated with it and it will insert it for you.

Code: Select all

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");

Note that the table prefix phpbb_ is the default prefix, if you chose something else during installation then replace phpbb_ with your table prefix.

[fords8]

I need to do a upgrade from Cpanel to Vdeck, so I am going to reinstall the whole thing. Thanks for the help.