Problem with MYSQL 5 Problem with MYSQL 5
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Problem with MYSQL 5

Started by franky.f, February 28, 2007, 07:51:44 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

franky.f

Hi I´m install script and I have problem with mysql 5:
I´m instal with mysql 4 it´s ok and I haven´t sql 4 but sql 5

"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 cpg1410_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''

franky.f

I´m do with topic http://forum.coppermine-gallery.net/index.php?topic=36746.msg172861#msg172861

and I have add problem with upload all files and present files

franky.f

Quote from: franky.f on February 28, 2007, 08:15:55 AM
I´m do with topic http://forum.coppermine-gallery.net/index.php?topic=36746.msg172861#msg172861

and I have add problem with upload all files and present files
Error Report
The following uploads encountered errors: 
File Uploads: 
File Name/URL Error Message
1. example.jpg Forbidden file extension


Joachim Müller

We have a strict "one question per thread" policy. Your uploading issues mustn't be discussed in this thread. Start a new thread on the proper sub-board for your upload issue after having read the upload troubleshooting section of the docs.
Reply to this very thread here wether your initial support request here has been solved (and if yes, how you solved it).

franky.f


Joachim Müller

English only! Closing, locking.