database doesn't initialize

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
MartinRuthenberg
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 15 May 2013, 01:49

database doesn't initialize

Postby MartinRuthenberg » 15 May 2013, 02:04

It's my first attempt to install tt-rss on my virtual Server. Initializing database prompts this:
"Query create index ttrss_counters_cache_feed_id_idx on ttrss_counters_cache(feed_id) failed"

Skipping the initialisation and just saving config.php I only see a blank white page when I open my tt-rss url.

PHP-Version 5.3.15-1
MySQL 5.1.63
Apache

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

Re: database doesn't initialize

Postby fox » 15 May 2013, 16:31

The obvious idea is checking mysql error logs to see why index creation fails.

MartinRuthenberg
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 15 May 2013, 01:49

Re: database doesn't initialize

Postby MartinRuthenberg » 17 May 2013, 22:43

Sorry but this is not an obvious idea. You could as well have told me to look if index creation rights are set for the database user. :wink:

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

Re: database doesn't initialize

Postby sleeper_service » 17 May 2013, 23:07

MartinRuthenberg wrote:Sorry but this is not an obvious idea. You could as well have told me to look if index creation rights are set for the database user. :wink:


sounds pretty obvious to me...

gbcox
Bear Rating Master
Bear Rating Master
Posts: 149
Joined: 25 Apr 2013, 04:52

Re: database doesn't initialize

Postby gbcox » 17 May 2013, 23:57

<Sigh...>
http://tt-rss.org/redmine/projects/tt-r ... ationNotes
2. You will need to acquire database credentials, i.e. login, password, and a database name. If you don't have a database already created, you need to do so before installing. Tiny Tiny RSS can coexist with other applications in a shared database, creating a dedicated one is not necessary.

If you're having problems there are a myriad of HOWTOs that are only a Google search away...


Return to “Support”

Who is online

Users browsing this forum: No registered users and 8 guests