forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: jacques_brelle on October 15, 2003, 10:15:18 pm

Title: Installation problem with MySQL
Post by: jacques_brelle on October 15, 2003, 10:15:18 pm
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.
Title: Installation problem with MySQL
Post by: Rodinou on October 15, 2003, 10:16:51 pm
Have you install 1.2 directly or have you before another version of Coppermine ?
Title: Installation problem with MySQL
Post by: Joachim Müller on October 15, 2003, 10:32:36 pm
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]

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


GauGau
Title: Installation problem with MySQL
Post by: RVB on October 21, 2003, 08:31:21 am
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 ??¿¿
Title: Installation problem with MySQL
Post by: jacques_brelle on October 21, 2003, 05:50:54 pm
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.
Title: Installation problem with MySQL
Post by: jacques_brelle on October 21, 2003, 05:53:05 pm
"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.