Upgraded to 1.12, not working now

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
GusBricker
Bear Rating Trainee
Bear Rating Trainee
Posts: 6
Joined: 20 Apr 2014, 12:42

Upgraded to 1.12, not working now

Postby GusBricker » 20 Apr 2014, 12:52

I upgraded to 1.12, I cant remember what version from (pretty sure was <= 1.08).

Now my feeds aren't working, i keep getting "Communication With Server Error". The error log is full of this:
E_USER_ERROR (256) classes/db/mysqli.php:33 Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) ...

I did the update via the command line on my server using update.php. I'm running on a Dreamhost Private Server, any tips?

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

Re: Upgraded to 1.12, not working now

Postby hrk » 21 Apr 2014, 01:26

Posting the full error will allow kind-hearted people to help you.

The most I can do right now is ask: did you update the database schema?

GusBricker
Bear Rating Trainee
Bear Rating Trainee
Posts: 6
Joined: 20 Apr 2014, 12:42

Re: Upgraded to 1.12, not working now

Postby GusBricker » 21 Apr 2014, 01:58

Ah good point. Where is the error log located usually?
I did update database schema.

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

Re: Upgraded to 1.12, not working now

Postby hrk » 21 Apr 2014, 02:17

I guess the same place you got the error message you partially pasted here... isn't it?

GusBricker
Bear Rating Trainee
Bear Rating Trainee
Posts: 6
Joined: 20 Apr 2014, 12:42

Re: Upgraded to 1.12, not working now

Postby GusBricker » 21 Apr 2014, 15:53

hrk wrote:I guess the same place you got the error message you partially pasted here... isn't it?

Ah my bad, i misinterpreted what you meant. I read it as paste the entire error log. Whereas you just want to see the full error.

Here it is:

Code: Select all

E_USER_ERROR (256)   classes/db/mysqli.php:33   Query INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, no_orig_date, date_updated, date_entered, comments, num_comments, plugin_data, lang, author) VALUES ('The Earliest Flying Cars, Jetpacks, and Other Insane Retrofuture Inventions', 'SHA1:b908c34a74929f0baaf4c7eabc6e94827485132c', 'http://motherboard.vice.com/read/the-earliest-flying-cars-jetpacks-and-other-insane-retrofuture-inventions', '2014/04/18 17:05:00', 'A flying platform created in 1955 by the US Navy.&nbsp;Image:&nbsp;British Path&eacute;The history of the future is fascinating, especially when with pressing play on a YouTube video can transport you back in time nearly a century to watch it happen.This week, the esteemed&nbsp;British&nbsp;Path&eacute;&nbsp;put its entire archive of historical film clips and newsreels&nbsp;online, a treasure trove of 85,000 clips amounting to 3,500 hours of footage from 1896 to 1976. Mixed in with some classic gems&mdash;interviews with survivors of the Titanic, newsreels from Hiroshima, Marilyn Monroe&#39;s death, and so on&mdash;is a delightful&nbsp;collection&nbsp;of videos that show early inventors creating the technological wonders that shape modern society,&nbsp;and the ones today&#39;s futurists are still trying to crack.In the humans-have-been-trying-to-do-this-forever realm, there are clips of early attempts at flying cars, flying bicycles, hovercraft, and jetpacks (sensing a theme here?), from the late 40s to early 60s&mdash;post-World War II boom time.This 1949 flying car, filmed in Italy, is fueled by a propeller and still manages to get airborne at 200 miles per hour.&nbsp;Fast-forward six years and jump across the pond and the US Navy has revealed its &quot;Flying Platform,&quot; aka a very old-school hoverboard, which is described as &quot;the closest thing yet to a magic carpet.&quot; Two small engines drive two propellers rotating in opposite directions underneath the platform, which the pilot controls by shifting his body weight to tilt the platform.&quot;Sadly, development ceased because the US Army judged them to be impractical as combat vehicles as they were small, limited in speed and only barely flew out of the ground cushion effect,&quot; explains the video description.The Navy&#39;s contraption managed to hover a few feet above the ground, which is considerably more than what this 1960 hover scooter managed. Powered by a motor, it looks like a riding lawnmower and only manages to get a couple inches off the ground.The 1960s version of a flying bike is wonderfully ridiculous as well. Called a &quot;manpowered plane,&quot; the pilot/cyclist had to pedal enough to lift a metal aircraft with an 80-foot wingspan off the ground. It must have been exhausting, but it worked.In 1966 in the UK, an early jetpack is caught on film, ambitiously described as the latest idea for lunar travel. The video shows it racing a race car around a track, because this is the shit people did in the 60s.One of my favorites is the &quot;Flying Drainpipe,&quot; where the driver sits on top of a drainpipe and is launched into the air. It was the first vertical takeoff machine in France, built in 1957. The rocket-like machine is&nbsp;described in the video as &quot;little more than a jet engine in a tube.&quot;&nbsp;The newsreel announcer said it&#39;s &quot;pointing the way to the aircraft of the future&quot;: high-speed jets that only need a few square yards of concrete to take off and land.There&#39;s also the 1920s Walkman for ladies (the antenna is an umbrella and you change the tuning on a gadget in a garter),&nbsp;the first mobile phone in Britain, and a montage of the world&#39;s first helicopters.Of course some inventions never took off, like the completely insane &quot;Dynasphere&quot; from the 1930s, which is basically a huge tire with a steering wheel in it. The circular car was intended to navigate ice and mud because it couldn&#39;t crash, because it&#39;s a circle. The British&nbsp;Path&eacute;&nbsp;called it at the time, a &quot;remarkable innovation in spherical locomotion, which, it is claimed, will one day revolutionize modern transport.&quot; It didn&#39;t.The&nbsp;entire archive&nbsp;is worth bookmarking and spending a distracted Friday afternoon browsing through.&nbsp;Word of advice: Avoid the&nbsp;&quot;10 Tragedies Caught on Film&quot;&nbsp;montage video. It&#39;s the worst thing ever.&nbsp;\n', 'SHA1:9d9b612c2b2ce84f1372ba8ff93805fea1cbf9a7', false, NOW(), '2014-04-20 08:45', '', '0', '', '', '[email protected] (Meghan Neal)') failed: Unknown column 'lang' in 'field list'


Thanks

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

Re: Upgraded to 1.12, not working now

Postby sleeper_service » 21 Apr 2014, 17:44

GusBricker wrote:
hrk wrote: failed: Unknown column 'lang' in 'field list'[/code]

Thanks


and here you lied and told us you'd updated your schema... yet the error message indicates you didn't.

puzzling

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

Re: Upgraded to 1.12, not working now

Postby fox » 21 Apr 2014, 17:59

there was this I think one time when upgrading went wrong for some reason and one of the schema files was not applied. op, you can find the .sql file where lang is being created and run the relevant parts. this should fix it.

unless you didn't update the schema of course, then just do so.

GusBricker
Bear Rating Trainee
Bear Rating Trainee
Posts: 6
Joined: 20 Apr 2014, 12:42

Re: Upgraded to 1.12, not working now

Postby GusBricker » 22 Apr 2014, 01:37

sleeper_service wrote:
GusBricker wrote:
hrk wrote: failed: Unknown column 'lang' in 'field list'[/code]

Thanks


and here you lied and told us you'd updated your schema... yet the error message indicates you didn't.

puzzling


First I'm ignoring your clear attitude problem. Second, I did update my schema, I remember after I ran update.php, I logged in, and it said its updating the schema from 1.08, then to 1.09, 1.10, etc.. Is there a full proof way to ensure that it actually did it? Or is it okay to apply the schema update again?

You will have to cut me some slack, as I don't do a whole lot of work with SQL.

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

Re: Upgraded to 1.12, not working now

Postby hrk » 22 Apr 2014, 16:18

Code: Select all

SELECT schema_version FROM ttrss_version


This will tell you your current schema version. The latest should be 124 (or higher).

The lang column was added in the 122 schema version (you can find it in the schema/mysql/122.sql file in your tt-rss directory).

Code: Select all

alter table ttrss_entries add column lang varchar(2);


You shouldn't need anything else, if you already have the latest schema.

GusBricker
Bear Rating Trainee
Bear Rating Trainee
Posts: 6
Joined: 20 Apr 2014, 12:42

Re: Upgraded to 1.12, not working now

Postby GusBricker » 23 Apr 2014, 01:15

hrk wrote:

Code: Select all

SELECT schema_version FROM ttrss_version


This will tell you your current schema version. The latest should be 124 (or higher).

The lang column was added in the 122 schema version (you can find it in the schema/mysql/122.sql file in your tt-rss directory).

Code: Select all

alter table ttrss_entries add column lang varchar(2);


You shouldn't need anything else, if you already have the latest schema.


Ok i checked my schema version, it reported back as 124. So i dont need to change anything correct?

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

Re: Upgraded to 1.12, not working now

Postby sleeper_service » 23 Apr 2014, 01:57

depends, do you have a lang column? if not, then yes if so, then no, but, then, you shouldn't be getting the error you posted.

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

Re: Upgraded to 1.12, not working now

Postby hrk » 23 Apr 2014, 02:19

Since you're getting an error claiming that you lack the "lang" column, you'll need to run the SQL I wrote above.

Keep in mind that it is strange that, while upgrading from <1.8 to 1.12 you missed the "122" update (which should be the one in 1.10). If you can't lose your current database and start from scratch, then I recommend you export your current schema and compare it with the latest one. Every difference you find, search for it in the versioned schemas and apply it to your database. Long, boring, potentially dangerous, but that's the only way to be sure you're running a right schema without creating it from scratch.

If I were you, I'd just add the "lang" column and hope it works. :)

GusBricker
Bear Rating Trainee
Bear Rating Trainee
Posts: 6
Joined: 20 Apr 2014, 12:42

Re: Upgraded to 1.12, not working now

Postby GusBricker » 23 Apr 2014, 02:59

hrk wrote:Since you're getting an error claiming that you lack the "lang" column, you'll need to run the SQL I wrote above.

Keep in mind that it is strange that, while upgrading from <1.8 to 1.12 you missed the "122" update (which should be the one in 1.10). If you can't lose your current database and start from scratch, then I recommend you export your current schema and compare it with the latest one. Every difference you find, search for it in the versioned schemas and apply it to your database. Long, boring, potentially dangerous, but that's the only way to be sure you're running a right schema without creating it from scratch.

If I were you, I'd just add the "lang" column and hope it works. :)


Ah hrk, your a legend :)
Adding the lang column appears the have fixed it. I really need to move off Dreamhost Private Server's, they are so dam slow!


Return to “Support”

Who is online

Users browsing this forum: No registered users and 11 guests