Downgrade 1.10 to 1.9

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
User avatar
UksusoFF
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 29 Aug 2013, 14:07
Location: Russia, Samara
Contact:

Downgrade 1.10 to 1.9

Postby UksusoFF » 24 Sep 2013, 09:07

hi!
any chance downgrade 1.10 to 1.9 without database dump?

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

Re: Downgrade 1.10 to 1.9

Postby sleeper_service » 24 Sep 2013, 17:17

UksusoFF wrote:hi!
any chance downgrade 1.10 to 1.9 without database dump?


this is where the term "backups" comes into play.

vilain
Bear Rating Trainee
Bear Rating Trainee
Posts: 40
Joined: 29 Jun 2013, 08:57

Re: Downgrade 1.10 to 1.9

Postby vilain » 24 Sep 2013, 19:41

When I upgraded from 1.9 to 1.10, the old version of tt-rss was moved to another directory. That's your backup. The trick will be going in by hand and reverting your database to the 122 schema. That requires database skills as it's not automated nor is the downgrade to 1.9.

Looks like it's time to read up on LAMP and MySQL care/maintenance.

User avatar
HunterZ
Bear Rating Disaster
Bear Rating Disaster
Posts: 60
Joined: 21 Mar 2013, 03:30
Location: Seattle

Re: Downgrade 1.10 to 1.9

Postby HunterZ » 25 Sep 2013, 00:36

What's wrong with 1.10? Maybe trying to deal with that would be a more constructive use of time?

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

Re: Downgrade 1.10 to 1.9

Postby sleeper_service » 25 Sep 2013, 01:20

HunterZ wrote:What's wrong with 1.10? Maybe trying to deal with that would be a more constructive use of time?
the numbers! they're too big! we canna take the strain!!!

charlie-tca
Bear Rating Trainee
Bear Rating Trainee
Posts: 32
Joined: 03 May 2013, 23:04
Contact:

Re: Downgrade 1.10 to 1.9

Postby charlie-tca » 25 Sep 2013, 02:15

Personally, I find the two digit numbers hard to deal with. I always drop the last zero, which makes 1.1 less than 1.9. However, I installed it anyway, fresh install, and it seems to work fine here.

User avatar
HunterZ
Bear Rating Disaster
Bear Rating Disaster
Posts: 60
Joined: 21 Mar 2013, 03:30
Location: Seattle

Re: Downgrade 1.10 to 1.9

Postby HunterZ » 25 Sep 2013, 02:23

The upgrade worked fine for me, except that I was a bit confused by the fact that it said that my database would not be upgraded, then turned around and told me that the schema needed to be updated after all.

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

Re: Downgrade 1.10 to 1.9

Postby sleeper_service » 25 Sep 2013, 03:33

it only did that to confuse you, HunterZ

User avatar
HunterZ
Bear Rating Disaster
Bear Rating Disaster
Posts: 60
Joined: 21 Mar 2013, 03:30
Location: Seattle

Re: Downgrade 1.10 to 1.9

Postby HunterZ » 25 Sep 2013, 03:56

sleeper_service wrote:it only did that to confuse you, HunterZ

I know, right?

User avatar
UksusoFF
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 29 Aug 2013, 14:07
Location: Russia, Samara
Contact:

Re: Downgrade 1.10 to 1.9

Postby UksusoFF » 25 Sep 2013, 09:26

sleeper_service wrote:this is where the term "backups" comes into play.

Yep, but it's too late
vilain wrote:When I upgraded from 1.9 to 1.10, the old version of tt-rss was moved to another directory. That's your backup. The trick will be going in by hand and reverting your database to the 122 schema. That requires database skills as it's not automated nor is the downgrade to 1.9.

Looks like it's time to read up on LAMP and MySQL care/maintenance.

Where i can found difference between 121 and 123 scheme?
HunterZ wrote:What's wrong with 1.10? Maybe trying to deal with that would be a more constructive use of time?

I'm using shared hosting. It's not supported officially, it's right?
After update i'm have much more load of CPU, i don't know why :(
Look at this it's daily report from hosting:

Code: Select all

+------------+--------------------+----------------------+--------------------+
| Date       | Total Load         | Not Critical Load    | Critical Load      |
+------------+--------------------+----------------------+--------------------+
| 2013-09-24 |               17.68|                   357|                  14|
| 2013-09-23 |               17.88|                   370|                  10|
| 2013-09-22 |                6.83|                    71|                   1|
| 2013-09-21 |                3.94|                     6|                   0|
| 2013-09-20 |                4.87|                     5|                   0|
| 2013-09-19 |                4.23|                     5|                   0|
| 2013-09-18 |                4.31|                     3|                   0|
| 2013-09-17 |                4.47|                     0|                   0|
| 2013-09-16 |                4.37|                     0|                   0|
| 2013-09-15 |                4.70|                     1|                   0|
| 2013-09-14 |                3.91|                     0|                   0|
| 2013-09-13 |                4.75|                     1|                   0|
| 2013-09-12 |                4.01|                     1|                   0|
| 2013-09-11 |                4.44|                     5|                   0|
+------------+--------------------+----------------------+--------------------+

lotrfan
Bear Rating Disaster
Bear Rating Disaster
Posts: 73
Joined: 18 Mar 2013, 04:42

Re: Downgrade 1.10 to 1.9

Postby lotrfan » 25 Sep 2013, 10:55

Code: Select all

$ git diff 1.9..1.10 schema/ttrss_schema_mysql.sql
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 8ba57e1..aae0abf 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -84,7 +84,7 @@ create table ttrss_counters_cache (
        value integer not null default 0,
        updated datetime not null,
        foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
-);
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 
 create index ttrss_counters_cache_feed_id_idx on ttrss_counters_cache(feed_id);
 create index ttrss_counters_cache_owner_uid_idx on ttrss_counters_cache(owner_uid);
@@ -96,7 +96,7 @@ create table ttrss_cat_counters_cache (
        value integer not null default 0,
        updated datetime not null,
        foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
-);
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 
 create index ttrss_cat_counters_cache_owner_uid_idx on ttrss_cat_counters_cache(owner_uid);
 
@@ -163,6 +163,7 @@ create table ttrss_entries (id integer not null primary key auto_increment,
        date_updated datetime not null,
        num_comments integer not null default 0,
        plugin_data longtext,
+       lang varchar(2),
        comments varchar(250) not null default '',
        author varchar(250) not null default '') ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 
@@ -301,7 +302,7 @@ create table ttrss_tags (id integer primary key auto_increment,
 
 create table ttrss_version (schema_version int not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 
-insert into ttrss_version values (121);
+insert into ttrss_version values (123);
 
 create table ttrss_enclosures (id integer primary key auto_increment,
        content_url text not null,
@@ -434,7 +435,7 @@ create table ttrss_feedbrowser_cache (
        feed_url text not null,
        site_url text not null,
        title text not null,
-       subscribers integer not null) DEFAULT CHARSET=UTF8;
+       subscribers integer not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 
 create table ttrss_labels2 (id integer not null primary key auto_increment,
        owner_uid integer not null,


Pretty much the only "major" change was switching some of the tables to use InnoDB (instead of MyISAM). (most are already using InnoDB)

hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: Downgrade 1.10 to 1.9

Postby hrk » 25 Sep 2013, 11:03

lotrfan already replied (the other change is the addition of the lang column in ttrss_entries) but just for your own information, you can find all the update scripts here: https://github.com/gothfox/Tiny-Tiny-RSS/tree/master/schema/versions/mysql

User avatar
UksusoFF
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 29 Aug 2013, 14:07
Location: Russia, Samara
Contact:

Re: Downgrade 1.10 to 1.9

Postby UksusoFF » 25 Sep 2013, 11:06

thx, i will try this

roshambo
Bear Rating Trainee
Bear Rating Trainee
Posts: 35
Joined: 19 Jun 2013, 20:03

Re: Downgrade 1.10 to 1.9

Postby roshambo » 04 Oct 2013, 00:24

UksusoFF: were you able to downgrade?

I'm having all sorts of issues in chrome and firefox loading a core for minutes (occasionally crashing tab) about every 20-30 articles and memory usage jumps 100-200 MB during that time. It began around upgrading to 1.10 previously it would take 300-400 articles before it became an issue. The latest build hasn't helped the situation.

User avatar
HunterZ
Bear Rating Disaster
Bear Rating Disaster
Posts: 60
Joined: 21 Mar 2013, 03:30
Location: Seattle

Re: Downgrade 1.10 to 1.9

Postby HunterZ » 04 Oct 2013, 00:28

Those with performance issues in 1.10 may want to check out this thread: viewtopic.php?p=15299#p15299


Return to “Support”

Who is online

Users browsing this forum: No registered users and 15 guests