IntegraMOD

install php error

2007-11-27T11:35:41-07:00

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

Statistics: Posted Author: krillmeed — Tue Nov 27, 2007 11:35 am

install php error

2007-11-27T10:58:44-07:00

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

Statistics: Posted Author: krillmeed — Tue Nov 27, 2007 10:58 am

Re: install php error

2007-11-27T10:30:28-07:00

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

Statistics: Posted Author: Helter — Tue Nov 27, 2007 10:30 am

Re: install php error

2007-11-27T10:11:19-07:00

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

Statistics: Posted Author: krillmeed — Tue Nov 27, 2007 10:11 am

Re: install php error

2007-11-27T09:37:52-07:00

Will try that, i know i am being a pain

Statistics: Posted Author: krillmeed — Tue Nov 27, 2007 9:37 am

Re: install php error

2007-11-27T09:19:38-07:00

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

Statistics: Posted Author: Helter — Tue Nov 27, 2007 9:19 am

install php error

2007-11-27T07:26:09-07:00

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?

Statistics: Posted Author: krillmeed — Tue Nov 27, 2007 7:26 am

Re: install php error

2007-11-26T23:49:20-07:00

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

Statistics: Posted Author: Helter — Mon Nov 26, 2007 11:49 pm

install php error

2007-11-26T23:19:33-07:00

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?

Statistics: Posted Author: krillmeed — Mon Nov 26, 2007 11:19 pm

Re: install php error

2007-11-26T20:08:05-07:00

your config should look like this..

Line number On/Off | Expand/Contract | Select all

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_';

Statistics: Posted Author: Helter — Mon Nov 26, 2007 8:08 pm

install php error

2007-11-26T09:56:05-07:00

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

Statistics: Posted Author: krillmeed — Mon Nov 26, 2007 9:56 am