Page 1 of 1

Install Issue - MySQL Failed

Posted: 21 Nov 2008, 03:08
by mmwestsussex
Hi All,

Probably asking a really stupid question, but I am attempting an install at 2am! I keep getting stuck at 2nd stage on install on server.

I've changed permissions on server, think I have all directories set up correctly etc. Yet after it succesfully tests connections to database the install provides me with following error message:

Query Error -- Please Report This Bug!

MySQL Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-cats' at line 1

SHOW TABLES FROM web175-cats

Anybody give me a clue as to the issue? I can't find which file is causing the error or see why there would be an error being caused.

Assistance greatly appreciated

thanks... Matt

Re: Install Issue - MySQL Failed

Posted: 24 Nov 2008, 16:50
by RussH
Hiya - where are you trying to install - shared host, own server? LAMP/WAMP? Do you have access to phpmyAdmin?

What version of opencats/cats?
I've found that trying to install the test/demo data always fails - but if you do a plan vanilla install it's successful

Re: Install Issue - MySQL Failed

Posted: 27 May 2009, 19:44
by dbsfin
Hi Russ

Same problem here - we get this error on install

MySQL Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-catsmain' at line 1

Please advise

Regards
Ian

Re: Install Issue - MySQL Failed

Posted: 28 May 2009, 09:56
by RussH
Hi Ian,

as per the other post - can you send through some details - OS/version of the software/etc... and whether (as per my earlier reply to the other poster) if you're trying to install the demo data?

Re: Install Issue - MySQL Failed

Posted: 01 Jun 2009, 11:18
by dbsfin
Hi Russ

We are using the downloaded version form this site, version 0.9.1a

It fails when you get to the point of loading the data

OS. Linux
Perl
5.008005
MySQL
5.0.77
ASP
4.0.2L
PHP
5.2.9
PHP5
5.2.9

Regards
Ian

Re: Install Issue - MySQL Failed

Posted: 01 Jun 2009, 14:11
by RussH
Hi Ian,

just to check I did reinstall the 0.9.1a version in a vmware Ubuntu session without error - but I can't reproduce this. Can you ensure you're using the options to install the basic version - i.e. not choosing to install sample data, and not installing US zipcode lookups - all of which can be done after the fact.

Re: Install Issue - MySQL Failed

Posted: 05 Jun 2009, 17:40
by dbsfin
Hi Russ

I run a shared server environment, and installed and ran the install wizard, so how do I install this and select not to install the data as it simply runs the wizard

Regards
Ian

Re: Install Issue - MySQL Failed

Posted: 25 Nov 2009, 03:51
by Pablo
I have the same problem, please advice. See attachment.

Re: Install Issue - MySQL Failed

Posted: 25 Nov 2009, 14:02
by Pablo
Please I need help on this!

Can someone give head ups ?

TIA

Re: Install Issue - MySQL Failed

Posted: 25 Nov 2009, 14:59
by RussH
Okay,

I can't reproduce this. Can you try reinstalling with defaults and choosing english the language option? Just to try and track down the issue.