Hey guys please help me when i run install.php on my localhost i put the
Name:admin
Pass:admin
Email:***********
localhost
database name
login:root
pass:root
then when i submit i recived the errors below:
mySQL Error: You have an error in your SQL syntax near 'KEY search (title,caption,keywords,filename) ) TYPE=MyISAM' at line 46 on query ' CREATE TABLE cpg145_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'
What version of mysql are you using? Check the minimum requirements.
I had a similar error and reuploaded the .sql files in the sql folder; after telling my ftp upload program (FireFTP) to treat these files (.sql) as ASCII type files. I had to add the sql extension to an existing list of file type extensions in my ftp program (FireFTP).
Worked for me! ;D
Quote from: atta on July 07, 2006, 06:50:20 PM
Hey guys please help me when i run install.php on my localhost i put the
Name:admin
Pass:*****
Email:***********
localhost
database name
login:root
pass:****
Those are silly usernames and passwords, you should never use them, even on a testbed. You shouldn't post them neither - if you succeed to install and those settings come in to place, you might find yourself hacked in not time.