Text only | Text with Images

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: hp9000 on January 28, 2004, 09:45:19 PM

Title: MySQL error when installing
Post by: hp9000 on January 28, 2004, 09:45:19 PM
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!
Title: MySQL error when installing
Post by: Joachim Müller on January 28, 2004, 10:24:11 PM
maybe your mysql version is not good enough: check your mysql version and compare it with the minimum requirements (http://coppermine.sourceforge.net/faq.php?q=MinimumRequirements#MinimumRequirements).
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
Title: again
Post by: Sniffer on January 29, 2004, 01:16:07 PM
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
Title: MySQL error when installing
Post by: hp9000 on January 29, 2004, 03:56:40 PM
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!
Title: MySQL error when installing
Post by: Nibbler on January 29, 2004, 06:22:00 PM
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.
Title: MySQL error when installing
Post by: moorey on January 30, 2004, 03:45:06 AM
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.  :?
Title: MySQL error when installing
Post by: hp9000 on January 30, 2004, 05:33:13 PM
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!
Text only | Text with Images