dump and restore problem

[geert d.]

Hi,

I wanted to copy my Tracks from one machine to another.  Both are linux machines.

I installed Tracks following the WIKI instructions to install it on ubuntu 20.10 under apache2.  Both installs use mysql

Install works fine.  Then I dumped the tracks database (mysql dump) from my old machine and restored it in my new install.  Final result, I can login with my old username and password but then immediately get the "We're sorry but something went wrong" page.  If I then put "/projects" behind the url, I get all my projects listed.  I can edit the projects, but as soon as I click on a project to see its associated tasks, I get the "something went wrong" page again.

This also happens when I click on the Home tab, Starred tab and the Tickler tab... My notes and recurring tasks are visible without problems, statistics also.....

Any clue on what is going on here ?

Thanks

[Jyri-Petteri Paloposki]

Are you seeing something in your server error log? There should be a
more descriptive error there, the ”We're sorry but something went wrong”
is a boilerplate error thrown in almost all scenarios.

Best regards,
--
Jyri-Petteri ”ZeiP” Paloposki
Tracks principal maintainer

[Daniel Calcoen]

Dear geert d.

Do  you have an alternative to connect to the database ?

like DBeaver

https://readthedocs.web.cern.ch/display/PARTK/DBeaver+direct+into+tables+Import+Export+Reindex

is to check the content of the tables

can happen that you didn't have enough privileges to export all.

you could also look here how to GRANT PROCESS privilege

https://github.com/TracksApp/tracks/wiki/MySQL-tips

Regards

Daniel

[geert d.]

Hi,

thanks ZeiP. 

First I had a permission problem which left the production.log file empty.  Once fixed, I saw the issue was caused by another permission problem,

Now it is working ok

geert