2002-02-21 06:27:19+01 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 06:52:34+01 by: Dan Lyke
Okay, here's a dummy comment to make sure the new inserts are working.
#Comment made: 2002-02-21 07:45:18+01 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 07:50:24+01 by: TheSHAD0W
Ahh, just fixed. 8v)~
#Comment made: 2002-02-21 07:54:37+01 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 08:19:05+01 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 08:29:55+01 by: kroah
When clicking on the (*) I got the following error:
Software error:
ERROR: Function 'text(unknown)' does not exist
SELECT
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,
CASE
WHEN blogentries.deleted='Y' THEN
'Deleted'
ELSE
''
END
AS deleted,
users.name AS name,
CASE
WHEN blogentries.author_id='97' OR 'N'='Y' THEN
'[edit]'
ELSE
''
END
AS editweblogentry,
CASE
WHEN blogentries.deleted='N' AND (blogentries.author_id='97' OR 'N'='Y') THEN
'[delete]'
WHEN blogentries.deleted='Y' AND (blogentries.author_id='97' OR 'N'='Y') THEN
'[undelete]'
ELSE
''
END
AS deleteweblogentry,
'escapehtml' AS escapehtml
FROM users, blogentries WHERE (users.id=blogentries.author_id and (blogentries.id='4613'))
ORDER BY entered DESC
#Comment made: 2002-02-21 15:31:32+01 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.
Thanks!
#Comment made: 2002-02-21 16:10:28+01 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 04:13:20+01 by: Larry Burton
RSS is not updating.