[Solved]: CPG 1.4.16 - Installation problem

[Abda]

Hi, can anyone help?

I have:
- downloaded cpg1.4.16.zip, upack, uploaded to ftp server
- albums and include dir are set to 777
- MySQL: 5.0.33
- PHP Version 5.1.6
- Apache 2.0
- GD Support    enabled
- GD Version    2.0 or higher

Than I run page install.php on my website.
It is show correctly, fill with informations and than "Let's GO":
- in sql database few tables are created - _albums, _categories, _comments, _config a _sessions
- in ftp directory include is created file - config.inc.php - and informations there are correct
- but install.php page show error message:

The following errors were encountered and need to be corrected first:

mySQL Error: Column 'title' cannot be part of FULLTEXT index on query ' CREATE TABLE atest_pictures ( pid int(11) NOT NULL auto_increment, aid int(11) NOT NULL default '0', filepath varchar(255) NOT NULL default '', filename varchar(255) NOT NULL default '', filesize int(11) NOT NULL default '0', total_filesize int(11) NOT NULL default '0', pwidth smallint(6) NOT NULL default '0', pheight smallint(6) NOT NULL default '0', hits int(10) NOT NULL default '0', mtime datetime NOT NULL default '0000-00-00 00:00:00' , ctime int(11) NOT NULL default '0', owner_id int(11) NOT NULL default '0', owner_name varchar(40) NOT NULL default '', pic_rating int(11) NOT NULL default '0', votes int(11) NOT NULL default '0', title varchar(255) NOT NULL default '', caption text NOT NULL, keywords varchar(255) NOT NULL default '', approved enum('YES','NO') NOT NULL default 'NO', galleryicon int(11) NOT NULL default '0', user1 varchar(255) NOT NULL default '', user2 varchar(255) NOT NULL default '', user3 varchar(255) NOT NULL default '', user4 varchar(255) NOT NULL default '', url_prefix tinyint(4) NOT NULL default '0', pic_raw_ip tinytext, pic_hdr_ip tinytext, lasthit_ip tinytext, PRIMARY KEY (pid), KEY owner_id (owner_id), KEY pic_hits (hits), KEY pic_rate (pic_rating), KEY aid_approved (aid,approved), KEY pic_aid (aid), position INT(11) NOT NULL default '0', FULLTEXT KEY search (title,caption,keywords,filename) ) TYPE=MyISAM COMMENT='Used to store data about individual pics''

So creation of tables ends with error. I tried different directories within FTP....., sql database seems to be correct (i run also few forums there with no problem)

Any tip? Trick?

Thanks

[Nibbler]

http://forum.coppermine-gallery.net/index.php/topic,36746.0.html

[Abda]

thanks

[Abda]

I dont want to make a new thread. Now i have installed the CPG with removed lines from schema.sql  FULLTEXT KEY search (title,caption,keywords,filename) and TYPE=MyISAM COMMENT='Used to store data about individual pics';, because with this lines it always ends with error.

But now, i have problem with login. Dont know if its connected or what i am doing wrong. I didnt found similar problem (maybe different specification) on this forum. Can anyone help?

Installation is ok - finished, tables seems to be ok. But when I enter admin name and pwd, system welcomes me - so it is entered correctly - but when i pres Contiunue - I am not logged. I cant acces admin.php file..........

please give me some tip

And one additional question - is somehow possible to use Userdatabase from PHPBB3 forum? some link to install instruction? thank you

[Joachim Müller]

I dont want to make a new thread.

But you have to: we have a strict "One question per thread" policy that you agreed to respect when signing up. Locking.

And one additional question - is somehow possible to use Userdatabase from PHPBB3 forum? some link to install instruction? thank you

RTFM. You agreed to read the docs before posting as well when signing up. Respect board rules in the future. Search phrase should be "bridging". If you then have open questions, start a new thread on this.