Search found 715 matches

by RussH
12 Nov 2018, 11:52
Forum: Cries for Help!
Topic: Timing out
Replies: 3
Views: 34

Re: Timing out

Hey, sorry about this, it really doesn't sound like an application issue, more a server one. Are you running on windows? I've heard that sometimes you need to give explicit windows firewall permission to allow the MySQL port to work (port 3306). Maybe you can disable the windows firewall temporarily...
by RussH
31 Oct 2018, 15:43
Forum: Cries for Help!
Topic: MySQL Query Failed
Replies: 5
Views: 93

Re: MySQL Query Failed

Hi,

I fixed the test data so that it's compliant with strict mode and also added in some missing features introduced since the test data was created (candidate tags).

it's a single file, https://github.com/opencats/OpenCATS/pull/400 it's added to the development branch right now.
by RussH
30 Oct 2018, 16:55
Forum: Cries for Help!
Topic: testdomain.com appears in Auto Generated Messages [SOLVED]
Replies: 2
Views: 42

Re: testdomain.com appears in Auto Generated Messages [SOLVED]

Hi,

I assume that testdomain.com is picked up from settings/administration/site name

The footer 'Powered by CATS' can be amended in OpenCATS/lib/Mailer.php lines 209/210 (HTML) and line 222 (Plain text)
by RussH
29 Oct 2018, 15:27
Forum: Cries for Help!
Topic: MySQL Query Failed: Lost connection to MySQL server during query
Replies: 6
Views: 59

Re: MySQL Query Failed: Lost connection to MySQL server during query

maybe you have a session timeout someplace if you have this on GoDaddy. I doubt they'd let you configure that. I used to have some slow queries on an old MySQL, but after a MySQL upgrade it disappeared.
by RussH
27 Oct 2018, 00:10
Forum: Cries for Help!
Topic: MySQL Query Failed
Replies: 5
Views: 93

Re: MySQL Query Failed

Since the app was created, 'No Zero Date' is part of 'strict mode' in the default install for >= MySQL 5.7

You can ignore this by reconfiguring the setup https://www.linode.com/community/questi ... trict-mode
by RussH
26 Oct 2018, 23:56
Forum: Cries for Help!
Topic: MySQL Query Failed: Lost connection to MySQL server during query
Replies: 6
Views: 59

Re: MySQL Query Failed: Lost connection to MySQL server during query

well.. you've probably got a slow query? Do you host this yourself, or on a VPS etc? Make sure you're not running an old version of MySQL! Configure MySQL to log slow queries to the slow query log and see what's happening. Look at the MySQL Tuner Perl script to see if you need to optimise your MySQL...
by RussH
23 Oct 2018, 16:52
Forum: Cries for Help!
Topic: Custom "Not in Consideration" Status [SOLVED]
Replies: 3
Views: 83

Re: Custom "Not in Consideration" Status [SOLVED]

Okay, looks like I just amended the 'candidate_joborder_status' table with some additional entries.
by RussH
23 Oct 2018, 15:27
Forum: Cries for Help!
Topic: Phone format
Replies: 3
Views: 629

Re: Phone format

Hi, without learning PCRE, I plugged different nos in and this doesn't reformat the phone number. I'm also in the UK. I'll need to revisit at some point and do it properly, but if you want an ugly hack, here's the section I changed; class StringUtility { const matchPHSeparator = '[\s\/.-]*'; /* PCRE...
by RussH
23 Oct 2018, 15:04
Forum: Cries for Help!
Topic: Custom "Not in Consideration" Status [SOLVED]
Replies: 3
Views: 83

Re: Custom "Not in Consideration" Status [SOLVED]

Hi James, very easy to do - even I've done this and added in custom statuses. I'll see if I can unpick what I did / amended which files.