'twittercapture.tcat_controller_tasklist' doesn't exist'

[noamTzi]

Hi there, I get this error when TCAT is trying to update the tables. I'm not sure why this happened at all, therefore, I'm not sure what information. Any help would be appreciated! Thanks

Error message: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'twittercapture.tcat_controller_tasklist' doesn't exist' in /var/www/dmi-tcat/capture/stream/controller.php:44 Stack trace: '#'0 /var/www/dmi-tcat/capture/stream/controller.php(44): PDO->query('select task, in...') '#'1 {main} thrown in /var/www/dmi-tcat/capture/stream/controller.php on line 44

• It runs on an Ubuntu 15.10 server, & PHP version 5.6.11
• I suspect that's somehow related to the OS old version.

Additional context There's this thread: https://github.com/digitalmethodsinitiative/dmi-tcat/issues/169 And it might be helpful, but it was closed 4 years ago so maybe things were changed from then?

[noamTzi]

Hi again, so due to my recovery plan that's not working as expected, I'd probably need to restore the tcat server. Where are the query bins are located? Could I recover them if I get the files from the old server and put them in the same location?

[ErikBorra]

Hi @noamTzi ,

Note that TCAT runs on PHP 7 and that the installation script needs Ubuntu 18.x or higher. The best way forward is to have a clean install of TCAT on a machine with those specifications. Thereafter you may use the export/import scripts.

Best,

Erik

[noamTzi]

I'm on it. Thank you! As for the query bins - how do I save them?

[ErikBorra]

Follow the export/import instructions.

[noamTzi]

Hi Erik, I'm sorry I haven't replied, I tried many things, and none worked. In the end, I installed tcat with a docker and the app shows, but still doesn't work properly. I see here that you mentioned the minimum version of ubuntu to be used with tcat is 18, so I have 20.04. The docker holds the app and it seems to work but the tweets aren't being captured.

I read this about using docker and this about the crontab, I'm having exactly the same problems. I would try the suggestion in the last issue I mentioned and keep you guys updated.

Thank you for the follow up!

[noamTzi]

Hi again, I tried building an image with the fixed Dockerfile you mentioned, but I get this error. It occurs when I use:

docker image build -t tcat:1.0 .

on step 9 when DMI-TCAT tries to install:

E: Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/o/openssl/openssl_1.1.1-1ubuntu2.1~18.04.6_amd64.deb  404
Not Found [IP: 91.189.88.142 80]
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

I used this installation guide hoping to make a clean image.

May you guys help me figure what am I doing wrong?

[niczem]

The install script runs properly during the docker install as you can see in this run: https://github.com/niczem/dmi-tcat/runs/1614040379?check_suite_focus=true

... maybe you are not rebuilding the whole docker image but using prebuild once frome the cache which have cached values for apt? You can check this by emptying your docker cache.