Page 1 of 1

Query Error on Candidates tab

Posted: 20 May 2020, 23:44
by jarch
Installed Opencats 0.9.4-3 with a backup from Opencats 0.9.1a. Everything backed up but I'm receiving a Query error on the candidates tab.

Query Error -- Report to System Administrator ASAP

MySQL Query Failed: Table 'opencats.tag' doesn't exist

SELECT
t1.tag_id,
t1.tag_parent_id,
t2.title AS tag_parent_title,
t1.title AS tag_title
FROM
tag t1
LEFT JOIN
tag t2 ON t2.tag_id = t1.tag_parent_id
WHERE t1.site_id = 1
ORDER BY IFNULL(t1.tag_parent_id, t1.tag_id), t1.tag_id

Re: Query Error on Candidates tab

Posted: 21 May 2020, 18:19
by cptr13
Is this a fresh install of 0.9.4-3 and you imported the backup after?
What's the environment? OS?

Re: Query Error on Candidates tab

Posted: 15 Jul 2020, 17:39
by Tonyrogerlavy
Hi,

I have the same error when I try to Rescan or delete documents.

I run CATS Version 0.9.4 Countach. on PHP 5.6

also it's works well except this issue which mentioned above in addition to two more issues;

1/ Can't change the footer paragraph on the home page and can't change the logo and the website title.

2/ email didn't send to the recruiter however email test config is ok (I choose tried option 2 and 3 but didn't work)

:| :| :| :| :| :| :| :|

I really cries for help :lol: :lol: :lol: :lol: :lol: :lol: :lol:

Re: Query Error on Candidates tab

Posted: 31 Jul 2020, 10:35
by RussH
Hi Tony, regarding your email issue - still a problem? Can you check the logs & error logs when you're sending? Anything showing up in there?

Tempted to suspect that it's sending but being dropped as unauthorised SMTP traffic. Are you using a local smtp gateway - can you see logs for that, too?