Page 1 of 1

'cats_dev.tag' doesn't exist

Posted: 05 May 2017, 00:59
by bajjee
Hi,

Brand new installation. Ubuntu 16.04 server, used installation script - $ wget https://raw.githubusercontent.com/openc ... Install.sh and installed demo database.

Able to login successfully, all tabs are working successfully except Candidates tab, when I click Candidates tab, I get the following error.

MySQL Query Failed: Table 'cats_dev.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 = 201
ORDER BY IFNULL(t1.tag_parent_id, t1.tag_id), t1.tag_id

Appreciate your help.

Bajjee

Re: 'cats_dev.tag' doesn't exist

Posted: 05 May 2017, 01:08
by cptr13
ok, first of all...thanks for using the script! It usually works. I'll have to look at it and see what's changed. It may take me a few days to reply.

Re: 'cats_dev.tag' doesn't exist

Posted: 07 May 2017, 17:32
by bajjee
Did you have a chance to find the issue, or can you give me a workaround to fix it. Thanks for your time.

Re: 'cats_dev.tag' doesn't exist

Posted: 20 Jun 2017, 12:12
by RussH
I believe this issue occurs if you install the sample data.. rather than the clean install. The sample data doesn't include the tag table. You can either manually add this in or just re-run the install script and ask for a clean install.