Yay Microsoft!

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
h3
Bear Rating Trainee
Bear Rating Trainee
Posts: 3
Joined: 14 Sep 2005, 13:12

Yay Microsoft!

Postby h3 » 14 Sep 2005, 13:15

I just got this from my del.icio.us/popular feed:

Code: Select all

Warning: pg_query(): Query failed: ERROR: value too long for type character varying(250) in tt-rss-1.0.4/db.php on line 33


The query in question...

Code: Select all

SELECT id,last_read,no_orig_date,title,feed_id,content_hash ,EXTRACT(EPOCH FROM updated) as updated_timestamp FROM ttrss_entries WHERE guid = 'http://www.microsoft.com/presspass/features/2005/sep05/09-13OfficeUI.mspx'INSERT INTO ttrss_entries (title, guid, link, updated, content, content_hash, feed_id, comments, no_orig_date) VALUES ('Q&A: Microsoft Showcases New User Interface for Office ⌠12■ Core Applications: The new UI √ the most dramatic change to the way Office applications work since introduction of the toolbar in 1997 √ will help users become more proficient with Office', 'http://www.microsoft.com/presspass/features/2005/sep05/09-13OfficeUI.mspx', 'http://www.microsoft.com/presspass/features/2005/sep05/09-13OfficeUI.mspx', '2005/09/13 11:04:00', '', 'SHA1:da39a3ee5e6b4b0d3255bfef95601890afd80709', '16', '', false)

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

Postby fox » 14 Sep 2005, 21:30

Holy crap. Allright, I'll probably change title field to TEXT in the next version.

h3
Bear Rating Trainee
Bear Rating Trainee
Posts: 3
Joined: 14 Sep 2005, 13:12

Postby h3 » 14 Sep 2005, 21:38

In the meantime, for others who may run into this, this is what I've done (a little overkill, maybe ;))

Code: Select all

alter table ttrss_entries add column guid2 text;
update ttrss_entries set guid2=guid;
alter table ttrss_entries drop column guid;
alter table ttrss_entries rename guid2 to guid;
alter table ttrss_entries add column link2 text;
update ttrss_entries set link2=link;
alter table ttrss_entries drop column link;
alter table ttrss_entries rename link2 to link;
alter table ttrss_entries add column title2 text;
update ttrss_entries set title2 to title;
update ttrss_entries set title2=title;
alter table ttrss_entries drop column title;
alter table ttrss_entries rename title2 to title;

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

Postby fox » 14 Sep 2005, 21:43

Aaaand fixed in upstream.


Return to “Support”

Who is online

Users browsing this forum: No registered users and 22 guests