Well the fix for the MySQL error is simple enough just add "to_i" to the count variable that is passed on line 19 of the archives controller.  It still doesn't render correctly though:



On 7/8/06, H. Wade Minter <[EMAIL PROTECTED]> wrote:
I
On Jul 8, 2006, at 11:10 PM, Steve Longdo wrote:

> I did a fresh checkout of r1088 and ran 'rake migrate' to update.
> I believe that is a migration from 42 to 46.  This ran without
> error.  When I attempt to view the site I get a message stating:
> Controller stack got out of kilter!
>
> I saw this in the log:
> Processing ArchivesController#index (for 127.0.0.1 at 2006-07-08
> 22:01:11)
>   Blog Load ( 0.002360)   SELECT * FROM blogs ORDER BY id LIMIT 1
>   Trigger Load ( 0.000713)   SELECT * FROM triggers WHERE (due_at
> <= '2006-07-08 22:01:11')
>   Content Load (0.000000)   Mysql::Error: 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 ''12'' at line 1: select
> count(*) as count, extract(year from published_at)||' '||lpad
> (extract(month from published_at),2,'0') as date from contents
> where type='Article' and published = 1 and published_at <
> '2006-07-08 22:01:11' group by date order by date desc limit '12'
>
> Anybody seen this before?  Is the Archives Sidebar broken?

I noticed that as well when I upgraded, but haven't had the time to
track it down.  But yeah, I saw the exact same thing.

--Wade

_______________________________________________
Typo-list mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/typo-list

_______________________________________________
Typo-list mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/typo-list

Reply via email to