MySQL error when installing

[hp9000]

Hello,

When I run the install.php script, after entering all the fields, I press "Let's go" and get the following:

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

Any ideas?

Thanks!

[Joachim Müller]

maybe your mysql version is not good enough: check your mysql version and compare it with the minimum requirements.
If I'm wrong , turn on debug_mode (if you can't access the coppermine config panel, enable it with phpMyAdmin in cpg11d_config table) and check the output details.

GauGau

[Sniffer]

dear gaugau,

i have the same problem hp900 described
now i have aske the admin of my domain and he answered that he will install mysql 4.x next time (i think that means in 3 months).

now my question:
is it somehow possible to install "Coppermine 1.2" on a mysql-version 3.23.22? (the "minimum requirements" say that i must have 3.23.23 or higher)

thanx a lot!
sniffer

[hp9000]

I checked with the sysadmin, the server is running 3.23.22-beta-log. Geez, not even a final release! And upgrading to 4.x is  low on the priority list. As sniffer said, is there any way to run it on 3.23.x? How about I install it on my own server at home, take an export of the database and import into the 3.x server? Will the rest of the queries be alright or will some of them fail?

Thanks!

[Nibbler]

The list of changes for version 3.23.23 is here:

http://mysql.linuxaid.com.cn/doc/en/News-3.23.23.html

The final change mentions the MATCH() function which I know is used in coppermine's search. You may be able to find a workaround to help you run coppermine on 2.23.22 if you really have no choice.

[moorey]

Probably not. Obviously the error indicates some functions that has not been implemented yet in MySQL. But you're welcome to give it a go and see where it brings you.  :?

[hp9000]

Here's what I did: I modified the script, where it creates the cpg11d_pictures table, and removed the line that says "FULLTEXT KEY `search` (`title`,`caption`,`keywords`,`filename`)". Ran it again and everything worked. I thought the search function wouldn't work, but it does just fine, I'm not sure if it is slower than with the fulltext key thing enabled, or what other drawbacks it may have, but now I have a fully operational site, or so it seems.

Thanks!