Flutterby™! : new db schema

Next unread comment / Catchup all unread comments User Account Info | Logout | XML/Pilot/etc versions | Long version (with comments) | Weblog archives | Site Map | | Browse Topics

new db schema

2002-02-21 05:27:19+00 by Dan Lyke 9 comments

Flutterby has a new database schema

In anticipation of the new Blogger API and some other features. Email me or leave comments under this entry if anything doesn't work. I think I've tested, but you know how that is.

[ related topics: Flutterby Meta ]

comments in ascending chronological order (reverse):

#Comment made: 2002-02-21 05:52:34+00 by: Dan Lyke

Okay, here's a dummy comment to make sure the new inserts are working.

#Comment made: 2002-02-21 06:45:18+00 by: TheSHAD0W

There were some weird UI side effects under Mozilla 0.9.8... Like pink boxes next to "Most Recent Comments" and "Next Unread Comment"...

#Comment made: 2002-02-21 06:50:24+00 by: TheSHAD0W

Ahh, just fixed. 8v)~

#Comment made: 2002-02-21 06:54:37+00 by: John Anderson

well, my 'next unread comment' link got reset to the beginning of time (or at least february of 2000). other than that, the situation looks nominal.

say, whatever happened to that code release you were talking about a month or so ago?

#Comment made: 2002-02-21 07:19:05+00 by: kroah

All of the links on the right side of the main page that went to "sites you like" and such are now gone.

I was getting used to the cartoon links, now I need to go dig up those bookmarks...

#Comment made: 2002-02-21 07:29:55+00 by: kroah

When clicking on the (*) I got the following error:
Software error:

ERROR:  Function 'text(unknown)' does not exist
 blogentries.id AS blogentry_id,
 blogentries.entered AS entered, 
 blogentries.updated AS updated,
 blogentries.latestcomment AS latestcomment,
 blogentries.text AS text,
 blogentries.texttype AS texttype,
 blogentries.subject AS subject,
 blogentries.author_id AS author_id,
 blogentries.commentcount AS commentcount,
   WHEN blogentries.deleted='Y' THEN
 AS deleted,
 users.name AS name,
   WHEN blogentries.author_id='97' OR 'N'='Y' THEN
 AS editweblogentry,
   WHEN blogentries.deleted='N' AND (blogentries.author_id='97' OR 'N'='Y') THEN
   WHEN blogentries.deleted='Y' AND (blogentries.author_id='97' OR 'N'='Y') THEN
 AS deleteweblogentry,
 'escapehtml' AS escapehtml
FROM users, blogentries WHERE (users.id=blogentries.author_id and (blogentries.id='4613'))

#Comment made: 2002-02-21 14:31:32+00 by: Dan Lyke

Okay, got the single entry code back up to par. I was hoping to take a day or two to get the favorite sites code cleaned up a bit, but I guess I'll cobble that back in and fix it right later.


#Comment made: 2002-02-21 15:10:28+00 by: Dan Lyke

John, this is the first step towards that. I'm a little behind, but this puts all the text blocks in a separate table so that I can build a smarter editor for that, and cleans up a lot of the schema.

#Comment made: 2002-02-22 03:13:20+00 by: Larry Burton

RSS is not updating.