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.
#2797
Hi i managed to restored data from older version of cats into latest copy on ubuntu 16.04 however encounter this problem

when click on tab , the following error appears

Query Error -- Report to System Administrator ASAP


MySQL Query Failed: Table 'opencats1.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

can anyone assist ?
#2800
Hi i have an earlier copy of cats running on ubuntu 14.04 but my server crash. Recently i re installed a new copy cats 0.9.3-3 on ubuntu 16.04; and chose the option of restoring backup copy. All functions are working except the candidate tab, when click the error message above pops up.
#2802
Let me elaborate.

The reason you're getting this error is because composer is now required to install additional dependencies. Follow these instructions and it should get resolved.



From your first OpenCATS system, create the backup file.

Install the new OpenCATS system.

If you have a NEW copy of ubuntu 16.04 installed (no LAMP installation yet), you can use the install script and follow the instructions here: http://opencats-documentation.readthedo ... Linux.html
The Video tutorial is here: https://www.youtube.com/watch?v=9bu67GG0R_k

If you already have LAMP installed, you can follow the documentation here:
http://opencats-documentation.readthedo ... 16.04.html
and video tutorial here: https://www.youtube.com/watch?v=D2mCeoyksdc&t=956s

Make sure you restore with your .bak file when it gets to the "new install" or "restore" screen.

If you have any questions, or issues let me know.

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me