Installation problem with MySQL

[jacques_brelle]

Hi,
I've just tried to install the 1.2 release, and I get that on the install page :
• • • ERROR • • •  
The following errors were encountered and need to be corrected first:

mySQL Error: You have an error in your SQL syntax near 'KEY search (title,caption,keywords,filename) ) TYPE=MyISAM' at line 42

Have any idea of what it means and what I'm supposed to do to get through it ?
 :mrgreen:

Thanks anyway.

[Rodinou]

Have you install 1.2 directly or have you before another version of Coppermine ?

[Joachim Müller]

my first guess is your version of mySQL: you'll need at least 3.23.23 or better (4.x recommended).
To find out your version of mySQL, use a tool like phpMyAdmin, ask your webhost or run this in your browser

Code Select Expand


    $result = mysql_query("SELECT VERSION() as version");
    $row = mysql_fetch_row($result);
    print $row[0];
 

GauGau

[RVB]

Same here for me too, and I'm using mySQL 3.23.52 and PHP 4.3.1
It's with a clean install 1.2x too.

Any ideas ??¿¿

[jacques_brelle]

Thank you so much for your posts !
 
Don't know why but it's fine now (there's a kind of magic ?!)...
Forget it !
See ya.

[jacques_brelle]

"Have you install 1.2 directly or have you before another version of Coppermine ?"
Ooops, I forgot...
It was a "clean" install of a 1.2 version.