Database schema update inifinite loop

If you run tt-rss on an officially unsupported platform (shared hosting, Windows, etc.) post here
markos
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 22 Oct 2015, 23:05

Database schema update inifinite loop

Postby markos » 22 Oct 2015, 23:21

Hi,

Today I have updated my server to Ubuntu 14.04.3 with upgrade to Postgres 9.3. Since Ubuntu now came with tt-rss which left my previous installation broken, I have tried to upgrade to the latest git version without success. After running update.php script successfully my schema_version in database is 129 as is the highest version in schema/versions/pgsql subdirectory.

Yet if I tried to log in as normal user I keep getting an error: "Your access level is insufficient to run this script." I assume that's because it tries to update db as I end up on /tt-rss/public.php?op=dbupdate.

If I login as admin user so that my access level is 10, then I am redirected to the same url only this time it tells me that "Tiny Tiny RSS database is up to date." Clicking on button just redirects me back to this screen after a short, failed attempt to open apps main screen (/tt-rss/index.php). Fails at about 30%.

I am sure I am missing something simple, but since I have spent hours on it already and am apparently unable to find solution online, I am hoping somebody had this problem already and can point me in right direction.

Thanks.

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Database schema update inifinite loop

Postby sleeper_service » 23 Oct 2015, 03:32

you really should either
a) post this in the ubuntu forums, asking how to make their bastardized version work, or
b) install regular ttrss from git.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Database schema update inifinite loop

Postby fox » 23 Oct 2015, 08:49

dump the database, uninstall packaged tt-rss completely (purge the package), clone the git version, load the database dump back, setup git tt-rss to use it, that's it

never try to mix packaged software and stuff you yourself downloaded in the future

markos
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 22 Oct 2015, 23:05

Re: Database schema update inifinite loop

Postby markos » 23 Oct 2015, 17:29

Thanks.


Return to “Unsupported platforms”

Who is online

Users browsing this forum: No registered users and 1 guest