Print Page - Installation problem with MySQL

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.

coppermine-gallery.com/forum

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