Search found 14 matches

by bmar
13 Sep 2013, 09:57
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28242

Re: Proper way to migrate from MySQL to PostgreSQL

I am not at home these days and I am writing from a smartphone. Migration tool has no knowledge of table columns, just tables. Provided fox hasn't added a new table, you're fine. It has to be run on an empty (but created!) pgsql schema. When you got "user table does not exist", you run it...
by bmar
12 Sep 2013, 15:29
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28242

Re: Proper way to migrate from MySQL to PostgreSQL

I found that the problem is in column "theme_id", scheme has changed and the migration script is not. 2013-09-12 15:20:26 MSK LOG: execute <unnamed>: SET extra_float_digits = 3 2013-09-12 15:20:26 MSK ERROR: column "theme_id" of relation "ttrss_users" does not exist at ...
by bmar
12 Sep 2013, 09:16
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28242

Re: Proper way to migrate from MySQL to PostgreSQL

that's when initializing db from web-interface, sorry. when I initialize it from command-line: ~/tt-rss-mysql2pgsql-master/dist# java -jar tt-rss-mysql2pgsql.jar INSERT INTO ttrss_users(id, login, pwd_hash, last_login, access_level, theme_id, email, full_name, email_digest, last_digest_sent, salt, c...
by bmar
12 Sep 2013, 08:21
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28242

Re: Proper way to migrate from MySQL to PostgreSQL

Ok, I made some small changes and pushed everything to github: https://github.com/hrk/tt-rss-mysql2pgsql Download the contents of the dist directory (if you're not familiar with github, just download everything as a zip, unzip and open the dist directory). Edit config.properties to your liking and ...
by bmar
13 May 2013, 16:08
Forum: Themes and plugins
Topic: pinterest, owncloud, pocket, tweet, etc social plugins
Replies: 68
Views: 68254

Re: pinterest, owncloud, pocket, tweet, etc social plugins

thanks, it's right... sorry for a dumb post :)
by bmar
13 May 2013, 15:47
Forum: Themes and plugins
Topic: pinterest, owncloud, pocket, tweet, etc social plugins
Replies: 68
Views: 68254

Re: pinterest, owncloud, pocket, tweet, etc social plugins

after upgrading tt-rss to 1.7.9 and updating googleplus plugin from git got a: "May 13 15:40:38 xxx php-cgi: [tt-rss] E_WARNING (2) (lib/phpqrcode/phpqrcode.php:946) Cannot modify header information - headers already sent by (output started at /usr/share/tt-rss/www/plugins/googleplus/init.php:5...
by bmar
03 Apr 2013, 11:37
Forum: Themes and plugins
Topic: pinterest, owncloud, pocket, tweet, etc social plugins
Replies: 68
Views: 68254

Re: pinterest, owncloud, pocket, tweet, etc social plugins

I've modified googleplus plugin to make posts to vk.com. Does anybody need it? :)
by bmar
02 Apr 2013, 11:44
Forum: Support
Topic: How to migrate from MySQL to Postgres?
Replies: 16
Views: 8533

Re: How to migrate from MySQL to Postgres?

From that point you are right. :)
by bmar
02 Apr 2013, 08:55
Forum: Feature requests
Topic: Export and import all feeds for all users
Replies: 3
Views: 1516

Re: Export and import all feeds for all users

Something like extending functionality of export\import plugin for admin user? Could you give some recommendations?
by bmar
02 Apr 2013, 08:27
Forum: Feature requests
Topic: Export and import all feeds for all users
Replies: 3
Views: 1516

Export and import all feeds for all users

Could be export and import all feeds for all users be made? I've already asked a question about it in support. It would be very useful for migrating databases or for backup.
by bmar
01 Apr 2013, 16:17
Forum: Support
Topic: How to migrate from MySQL to Postgres?
Replies: 16
Views: 8533

Re: How to migrate from MySQL to Postgres?

Can I request feature for admin user to export data for all users? or it will never be made? :)
by bmar
01 Apr 2013, 16:11
Forum: Support
Topic: How to migrate from MySQL to Postgres?
Replies: 16
Views: 8533

Re: How to migrate from MySQL to Postgres?

I have more than one user, so everyone of them must export before and import after migration?
by bmar
01 Apr 2013, 15:27
Forum: Support
Topic: How to migrate from MySQL to Postgres?
Replies: 16
Views: 8533

Re: How to migrate from MySQL to Postgres?

will it work for current version of tt-rss?
by bmar
28 Mar 2013, 10:11
Forum: Knowledge Base
Topic: What is the difference between Admin, Super User and User
Replies: 3
Views: 2830

Re: What is the difference between Admin, Super User and Use

But then why do super user exist? For future use only?

Go to advanced search