IntegraMOD

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://krillmeed.com/forum/index.php

PHP Version:
MySQL Version:


What was done before the problem appeared?
changed databases


What was done to try to solve the problem?




De.scription and Message

I have been changing servers, after a whole lot of problems, and help from Helter Skelter, the new database seems to have gone in. The problem is, when i change the config file on the new or the old one to point to the new database, i get redirected to the install/install php folder, which of course does not exist. If i switch them back to the old database, both new and old sites work, so i presume this fault is in the database somewere (New one) Any one know how to fix this <img>

your config should look like this..

Code: Select all

 <php>  

Usually, when your redirected to install, it means that it cannot find your config.php, however another user had this trouble due to an added mod. I believe it was the advanced color groups mod. It was solved by re-running the install that came with the color groups mod

in your case you need to change

$table_prefix = 'phpbb_';

to match your current prefix like this

$table_prefix = 'trek_';

My new database is mysql5 which i now can enter, by changing all the mysql4 files in includes, to mysql 5. The forum is very slow, so i think i did it wrong. Is there an explanation to change integramod to work with mysql5?

if your server supports mysqli use that. If not, leave it at mysql4

it could not connect to the database when i used 4.

another couple of problems, hopefully small ones. In the database when i asked it to check it. This is what it comes up with:

Problems with indexes of table `trek_attachments` More than one INDEX key was created for column `attach_id`
Problems with indexes of table `trek_digest` PRIMARY and INDEX keys should not both be set for column `user_id`
Problems with indexes of table `trek_pa_comments` PRIMARY and INDEX keys should not both be set for column `comments_id`


Any ideas, or should i start a new topic on this?

have you added any mods that would affect these tables?

if not, dump the tables, create them with the create table statements from the 141 install/schemas/mysql_schema and use the inserts from your original backup

Will try that, i know i am being a pain

As for the first question, tried it, with both original and backups. 2 still there. This might explain why?

# Table structure for table `phpbb_pa_comments`
#

CREATE TABLE phpbb_pa_comments (
comments_id int(10) NOT NULL auto_increment,
file_id int(10) NOT NULL default '0',
comments_text text NOT NULL,
comments_title text NOT NULL,
comments_time int(50) NOT NULL default '0',
comment_bbcode_uid varchar(10) default NULL,
poster_id mediumint(8) NOT NULL default '0',
PRIMARY KEY (comments_id),
KEY comments_id (comments_id),
FULLTEXT KEY comment_bbcode_uid (comment_bbcode_uid)
) TYPE=MyISAM;


# Table structure for table 'phpbb_attachments'
#
CREATE TABLE phpbb_attachments (
attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_id_1 mediumint(8) NOT NULL,
user_id_2 mediumint(8) NOT NULL,
KEY attach_id_post_id (attach_id, post_id),
KEY attach_id_privmsgs_id (attach_id, privmsgs_id),
KEY post_id (post_id),
KEY privmsgs_id (privmsgs_id)
);

Hope you can help with the word part, the forum is pretty useless without it :?

try dumping
_search_wordlist,
_search_wordmatch and
_words

then run the create table sql for them. then youll need to rebuild search from your forum acp

Code: Select all

 ## Table structure for table `phpbb_search_wordlist`#  CREATE TABLE phpbb_search_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;  # --------------------------------------------------------  ## Table structure for table `phpbb_search_wordmatch`#  CREATE TABLE phpbb_search_wordmatch (   post_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 (post_id),   KEY word_id (word_id)) TYPE=MyISAM;  ## Table structure for table `phpbb_words`#  CREATE TABLE phpbb_words (   word_id mediumint(8) unsigned NOT NULL auto_increment,   word char(100) NOT NULL default '',   replacement char(100) NOT NULL default '',   PRIMARY KEY  (word_id)) TYPE=MyISAM;  

remember to keep good backups of these tables

Did that, when i did it, it came up with "Could not insert new word"

A point here as well, i did make back ups of all these, the problem with the word list, it would not allow me to insert, anything with a ÂÂ ´in it, such as wouldnÂÂ ´t couldnÂÂ ´t and so on