install php error

[krillmeed]

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>

[Helter]

your config should look like this..

Line number On/Off | Expand/Contract | 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_';

[krillmeed]

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?

[Helter]

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

[krillmeed]

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?

[Helter]

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

[krillmeed]

Will try that, i know i am being a pain

[krillmeed]

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 :?

[Helter]

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

Line number On/Off | Expand/Contract | 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

[krillmeed]

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

[krillmeed]

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