OpenCATS 0.9.4-3

Free, Open-Source Applicant Tracking System including job-board. Entirely customisable!

Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
By mmwestsussex
#552
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
User avatar
By RussH
#568
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
By dbsfin
#767
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
User avatar
By RussH
#768
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?
By dbsfin
#779
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
User avatar
By RussH
#780
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.
By dbsfin
#787
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
By Pablo
#875
I have the same problem, please advice. See attachment.
Attachments
opencats_bug.png
MySQL bug opencats
opencats_bug.png (65.51 KiB) Viewed 3223 times
User avatar
By RussH
#877
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.

From where you are trying to looking? You can buy[…]

Email Integration

where I should upload this file :? :? :? :? :?[…]

Email Setting!!!-Solved

OpenCats dev are never been clear in thier answers[…]

Job Order Export

Hi RussH, any chance of getting a reply about thi[…]

Unable to edit Candidates

I have have freshly installed openCATS have set my[…]

How to install OpenCats on hostinger?

I have PHP 5.6 and I uploaded the OpenCats folder […]

how to "delete" a user

Thanks for the reply The thread op asked about de[…]

Yes it is possible. But you have to dug into the s[…]

It need to be exceptionally truthful to export the[…]