On Aug 15, 2005, at 1:17 PM, Dev Purkayastha wrote:
> Wow, and I was at 2.5.2. The 2.5.4 seems like an important upgrade. Is
> there any supereasy means of upgrading, other than just unpacking
> tarball and pointing your web browser to it?
That's probably easiest. There aren't any major config changes
between 2.5.2 and 2.5.4; just unpack the new version, copy your old
database.yml over, and let it run.
Scott
From kyle.cooney at gmail.com Mon Aug 15 20:19:13 2005
From: kyle.cooney at gmail.com (Kyle Cooney)
Date: Mon Aug 15 20:12:58 2005
Subject: [typo] revisiting recent articles sidebar (argh!)
Message-ID: <[EMAIL PROTECTED]>
Hey all -
I'm about to pull my hair out on this subject. I have the sidebar that
Justus was kind enough to share on this list(and I've also tried making the
adjustments Scott recommended). But I keep recieving Application
Error(rails) messages. I checked my production.log file and have come up
with the following error message:
ActiveRecord::StatementInvalid (You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '== 1 ORDER BY created_at DESC LIMIT 5' at line 1: SELECT
* FROM articles WHERE published == 1 ORDER BY created_at DESC LIMIT 5):
For the record, I'm using the recent_controller.rb configured as follows:
class Plugins::Sidebars::RecentController < Sidebars::Plugin
def self.display_name
"Recent Articles"
end
def self.description
"List of recent articles for this blog"
end
def self.default_config
{'count' => 5 }
end
def content
@recent = Article.find(:all, :limit => @sb_config['count'], :conditions =>
["published == 1"], :order => 'created_at DESC')
end
def configure
end
end
and the content.rhtml is configured as follows:
<% unless @recent.blank? -%>
<h5>Recent Articles</h5>
<ul id="recent">
<% for article in @recent -%>
<li><%= article_link article.title, article %> </li>
<% end -%>
</ul>
<% end %>
I've tried various configurations of all of the above. I'm running in
production mode, and I've been restarting ruby as well as lighttpd while
testing each change. Not sure what's going on. I thouhgt it might be related
to way I've built my site with only one article/post on each page, but I'm
not sure how to test that since the even the Azure template is using some of
my customizations.
Thanks for any help. You can probably get a better feel for how my pages are
constructed by going to
www.yesterdaywasdramatic.com<http://www.yesterdaywasdramatic.com>
Kyle
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://rubyforge.org/pipermail/typo-list/attachments/20050815/559b5cba/attachment.htm
From scott at sigkill.org Mon Aug 15 20:25:09 2005
From: scott at sigkill.org (Scott Laird)
Date: Mon Aug 15 20:19:10 2005
Subject: [typo] revisiting recent articles sidebar (argh!)
In-Reply-To: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
On Aug 15, 2005, at 5:19 PM, Kyle Cooney wrote:
> Hey all -
>
> I'm about to pull my hair out on this subject. I have the sidebar
> that Justus was kind enough to share on this list(and I've also
> tried making the adjustments Scott recommended). But I keep
> recieving Application Error(rails) messages. I checked my
> production.log file and have come up with the following error message:
>
> ActiveRecord::StatementInvalid (You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server
> version for the right syntax to use near '== 1 ORDER BY created_at
> DESC LIMIT 5' at line 1: SELECT * FROM articles WHERE published ==
> 1 ORDER BY created_at DESC LIMIT 5):
Try using = not == in SQL.
Scott
