Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Installation problem with MySQL  (Read 4979 times)

0 Members and 1 Guest are viewing this topic.

jacques_brelle

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Installation problem with MySQL
« 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.
Logged

Rodinou

  • Contributor
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 346
  • Tournicoti, Tournicota
    • http://www.sortons.net
Installation problem with MySQL
« Reply #1 on: October 15, 2003, 10:16:51 pm »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Installation problem with MySQL
« Reply #2 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
Logged

RVB

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Installation problem with MySQL
« Reply #3 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 ??¿¿
Logged

jacques_brelle

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Installation problem with MySQL
« Reply #4 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.
Logged

jacques_brelle

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Installation problem with MySQL
« Reply #5 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.027 seconds with 18 queries.