opencats.org

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 ?

sorry was the candidate tab not working

I am not clear on this.

Is there still a problem? Or has it been fixed.

What version of OpenCATS?

How did you do the restore?

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.

Did you follow the documentation and use composer?

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.