<?xml version="1.0" encoding="UTF-8"?>
<tickets type="array">
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2010-02-09T15:17:14+01:00</created-at>
    <creator-id type="integer">74572</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">354</number>
    <permalink>no-invalidation-of-cache-after-editing-a-theme-file</permalink>
    <priority type="integer">32914</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>&quot;cache themes&quot;</tag>
    <title>No invalidation of cache after editing a theme file</title>
    <updated-at type="datetime">2010-02-09T15:17:17+01:00</updated-at>
    <user-id type="integer">74572</user-id>
    <user-name>Raphaela</user-name>
    <creator-name>Raphaela</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/354</url>
    <original-body>No invalidation of cache after editing a theme file</original-body>
    <latest-body>No invalidation of cache after editing a theme file</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;No invalidation of cache after editing a theme file&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2010-01-21T18:07:40+01:00</created-at>
    <creator-id type="integer">70154</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">353</number>
    <permalink>inline-images-dont-work-in-at-least-gmail-and-yahoo</permalink>
    <priority type="integer">32912</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>&quot;newsletter images&quot;</tag>
    <title>Inline images don't work in at least Gmail and Yahoo </title>
    <updated-at type="datetime">2010-01-21T18:07:41+01:00</updated-at>
    <user-id type="integer">70154</user-id>
    <user-name>Joseph Ridgway</user-name>
    <creator-name>Joseph Ridgway</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/353</url>
    <original-body>Images appear as attachments, not inline images. I've tried many fixes but nothing is working yet. Has anyone had the same issue? Do inline images work for you?</original-body>
    <latest-body>Images appear as attachments, not inline images. I've tried many fixes but nothing is working yet. Has anyone had the same issue? Do inline images work for you?</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;Images appear as attachments, not inline images. I've tried many
fixes but nothing is working yet. Has anyone had the same issue? Do
inline images work for you?&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2010-01-17T01:44:01+01:00</created-at>
    <creator-id type="integer">37212</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">352</number>
    <permalink>adva-cms-with-jboss-torquebox</permalink>
    <priority type="integer">32911</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>jboss jdbc jtds torquebox</tag>
    <title>Adva CMS with JBoss &amp; TorqueBox</title>
    <updated-at type="datetime">2010-01-17T01:44:05+01:00</updated-at>
    <user-id type="integer">37212</user-id>
    <user-name>jsgoecke</user-name>
    <creator-name>jsgoecke</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/352</url>
    <original-body>We are able to run JRuby with Rails/Adva no problem connecting to a database via JTDS. But, when we try to run from within JBoss/TorqueBox we get this error:

http://gist.github.com/279104

It seems that with this initializer loads:

vendor/plugins/adva_activity/init.rb:8

We get this error:

undefined method `include_into' for Rails::Plugin::Activities:Module</original-body>
    <latest-body>We are able to run JRuby with Rails/Adva no problem connecting to a database via JTDS. But, when we try to run from within JBoss/TorqueBox we get this error:

http://gist.github.com/279104

It seems that with this initializer loads:

vendor/plugins/adva_activity/init.rb:8

We get this error:

undefined method `include_into' for Rails::Plugin::Activities:Module</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;We are able to run JRuby with Rails/Adva no problem connecting
to a database via JTDS. But, when we try to run from within
JBoss/TorqueBox we get this error:&lt;/p&gt;
&lt;p&gt;&lt;a href=
&quot;http://gist.github.com/279104&quot;&gt;http://gist.github.com/279104&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;It seems that with this initializer loads:&lt;/p&gt;
&lt;p&gt;vendor/plugins/adva_activity/init.rb:8&lt;/p&gt;
&lt;p&gt;We get this error:&lt;/p&gt;
&lt;p&gt;undefined method &lt;code&gt;include_into' for
Rails::Plugin::Activities:Module&lt;/code&gt;&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2010-01-03T10:39:21+01:00</created-at>
    <creator-id type="integer">14866</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">351</number>
    <permalink>comments-feed-not-working</permalink>
    <priority type="integer">32910</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>atom comments feed</tag>
    <title>comments feed not working</title>
    <updated-at type="datetime">2010-01-03T10:39:24+01:00</updated-at>
    <user-id type="integer">14866</user-id>
    <user-name>Thomas R. Koll</user-name>
    <creator-name>Thomas R. Koll</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/351</url>
    <original-body>/comments.atom for blog section as root doesn't work. e.g. http://blog.photostre.am/comments.atom
What does work is http://blog.photostre.am/blog/comments.atom

I can merely guess, but I think it's wrongly dispatched.</original-body>
    <latest-body>/comments.atom for blog section as root doesn't work. e.g. http://blog.photostre.am/comments.atom
What does work is http://blog.photostre.am/blog/comments.atom

I can merely guess, but I think it's wrongly dispatched.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;/comments.atom for blog section as root doesn't work. e.g.
&lt;a href=
&quot;http://blog.photostre.am/comments.atom&quot;&gt;http://blog.photostre.am/comments.atom&lt;/a&gt;
What does work is &lt;a href=
&quot;http://blog.photostre.am/blog/comments.atom&quot;&gt;http://blog.photostre.am/blog/comments.atom&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;I can merely guess, but I think it's wrongly dispatched.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2010-01-03T01:02:20+01:00</created-at>
    <creator-id type="integer">81232</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">350</number>
    <permalink>no-such-file-to-load-ftools</permalink>
    <priority type="integer">32909</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag nil="true"></tag>
    <title>no such file to load -- ftools</title>
    <updated-at type="datetime">2010-01-03T01:02:21+01:00</updated-at>
    <user-id type="integer">81232</user-id>
    <user-name>Sophrinix</user-name>
    <creator-name>Sophrinix</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/350</url>
    <original-body>using ruby 1.9
when I try to rake adva:install:all

I get the following message:
no such file to load -- ftools

please advise.</original-body>
    <latest-body>using ruby 1.9
when I try to rake adva:install:all

I get the following message:
no such file to load -- ftools

please advise.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;using ruby 1.9&lt;br&gt;
when I try to rake adva:install:all&lt;/p&gt;
&lt;p&gt;I get the following message:&lt;br&gt;
no such file to load -- ftools&lt;/p&gt;
&lt;p&gt;please advise.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-12-25T10:44:21+01:00</created-at>
    <creator-id type="integer">24496</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">349</number>
    <permalink>menus-in-more-ways</permalink>
    <priority type="integer">32908</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>menu nested</tag>
    <title>menus in more ways</title>
    <updated-at type="datetime">2009-12-25T10:44:56+01:00</updated-at>
    <user-id type="integer">24496</user-id>
    <user-name>ramonrails</user-name>
    <creator-name>ramonrails</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/349</url>
    <original-body>I had a need to use the menus in 3 forms

1. flat_menu (same as in adva cms now. all sections in a single UL)
2. top_level_menu (only the grand parents of sections, no children. one UL)
3. nested_menu (entire hierarchy of sections as they are arranged. UL &gt; LI &gt; UL &gt; ...)

More stuff to notice
1. Only published ones get listed. Drafts are ignored.
2. droppy js added to :default, :common (http://github.com/jaz303/droppy, MIT License)</original-body>
    <latest-body>I had a need to use the menus in 3 forms

1. flat_menu (same as in adva cms now. all sections in a single UL)
2. top_level_menu (only the grand parents of sections, no children. one UL)
3. nested_menu (entire hierarchy of sections as they are arranged. UL &gt; LI &gt; UL &gt; ...)

More stuff to notice
1. Only published ones get listed. Drafts are ignored.
2. droppy js added to :default, :common (http://github.com/jaz303/droppy, MIT License)</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;I had a need to use the menus in 3 forms&lt;/p&gt;
&lt;ol&gt;
&lt;li&gt;flat_menu (same as in adva cms now. all sections in a single
UL)&lt;br&gt;&lt;/li&gt;
&lt;li&gt;top_level_menu (only the grand parents of sections, no
children. one UL)&lt;br&gt;&lt;/li&gt;
&lt;li&gt;nested_menu (entire hierarchy of sections as they are arranged.
UL &amp;gt; LI &amp;gt; UL &amp;gt; ...)&lt;/li&gt;
&lt;/ol&gt;
&lt;p&gt;More stuff to notice&lt;br&gt;
1. Only published ones get listed. Drafts are ignored.&lt;br&gt;
2. droppy js added to :default, :common (&lt;a href=
&quot;http://github.com/jaz303/droppy&quot;&gt;http://github.com/jaz303/droppy&lt;/a&gt;,
MIT License)&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-12-24T16:38:10+01:00</created-at>
    <creator-id type="integer">24496</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">348</number>
    <permalink>local-and-production-host-swapping</permalink>
    <priority type="integer">32907</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>capistrano deployment hosted multisite production shared-data</tag>
    <title>local and production host swapping</title>
    <updated-at type="datetime">2009-12-24T16:38:11+01:00</updated-at>
    <user-id type="integer">24496</user-id>
    <user-name>ramonrails</user-name>
    <creator-name>ramonrails</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/348</url>
    <original-body>While I am using adva_cms for hosting some of my client sites, I wanted to share this code with the community if anyone gets a benefit from this.

What was required? (What did I do)

I had to swap between local and production host url everytime I was deploying using capistrano.
So I made some changes to include an &quot;alias&quot; text field for each site.

What I did not do. (Bad for me and project)
Testing. I just updated a few test scripts to fetch data appropriately but never went through the detailed testing to make sure things are ok. (maybe a little less time available from projects for adva_cms)

Benefits of this
1. Now I can keep the local url in host (my_local_test_site.local) and production url in alias (production_site1.com, production_site2.com, ...). Saves me some effort of switching the host url before deploy. Of course the binary sqlite3 file also does not need update in git.
2. I can also point 2 different domains to the same data set in adva_cms. (I am not sure if that is bad practice, but my client needed it.)

Drawbacks:
Let me know. I will be happy to fix those to the extent possible.

Source available at http://www.github.com/ramonrails/adva_cms
All feedback is welcome.</original-body>
    <latest-body>While I am using adva_cms for hosting some of my client sites, I wanted to share this code with the community if anyone gets a benefit from this.

What was required? (What did I do)

I had to swap between local and production host url everytime I was deploying using capistrano.
So I made some changes to include an &quot;alias&quot; text field for each site.

What I did not do. (Bad for me and project)
Testing. I just updated a few test scripts to fetch data appropriately but never went through the detailed testing to make sure things are ok. (maybe a little less time available from projects for adva_cms)

Benefits of this
1. Now I can keep the local url in host (my_local_test_site.local) and production url in alias (production_site1.com, production_site2.com, ...). Saves me some effort of switching the host url before deploy. Of course the binary sqlite3 file also does not need update in git.
2. I can also point 2 different domains to the same data set in adva_cms. (I am not sure if that is bad practice, but my client needed it.)

Drawbacks:
Let me know. I will be happy to fix those to the extent possible.

Source available at http://www.github.com/ramonrails/adva_cms
All feedback is welcome.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;While I am using adva_cms for hosting some of my client sites, I
wanted to share this code with the community if anyone gets a
benefit from this.&lt;/p&gt;
&lt;p&gt;What was required? (What did I do)&lt;/p&gt;
&lt;p&gt;I had to swap between local and production host url everytime I
was deploying using capistrano.&lt;br&gt;
So I made some changes to include an &quot;alias&quot; text field for each
site.&lt;/p&gt;
&lt;p&gt;What I did not do. (Bad for me and project)&lt;br&gt;
Testing. I just updated a few test scripts to fetch data
appropriately but never went through the detailed testing to make
sure things are ok. (maybe a little less time available from
projects for adva_cms)&lt;/p&gt;
&lt;p&gt;Benefits of this&lt;br&gt;
1. Now I can keep the local url in host (my_local_test_site.local)
and production url in alias (production_site1.com,
production_site2.com, ...). Saves me some effort of switching the
host url before deploy. Of course the binary sqlite3 file also does
not need update in git.&lt;br&gt;
2. I can also point 2 different domains to the same data set in
adva_cms. (I am not sure if that is bad practice, but my client
needed it.)&lt;/p&gt;
&lt;p&gt;Drawbacks:&lt;br&gt;
Let me know. I will be happy to fix those to the extent
possible.&lt;/p&gt;
&lt;p&gt;Source available at &lt;a href=
&quot;http://www.github.com/ramonrails/adva_cms&quot;&gt;http://www.github.com/ramonrails/adva_cms&lt;/a&gt;&lt;br&gt;
All feedback is welcome.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-12-23T13:58:51+01:00</created-at>
    <creator-id type="integer">74572</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">347</number>
    <permalink>export-feature-migration-for-contents-not-just-for-themes</permalink>
    <priority type="integer">32906</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>@wishlist</tag>
    <title>export feature / migration for contents - not just for themes</title>
    <updated-at type="datetime">2009-12-23T13:58:52+01:00</updated-at>
    <user-id type="integer">74572</user-id>
    <user-name>Raphaela</user-name>
    <creator-name>Raphaela</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/347</url>
    <original-body>export feature / migration for contents - not just for themes</original-body>
    <latest-body>export feature / migration for contents - not just for themes</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;export feature / migration for contents - not just for
themes&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-12-10T14:05:41+01:00</created-at>
    <creator-id type="integer">74572</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">346</number>
    <permalink>tags-for-wikipages</permalink>
    <priority type="integer">32905</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>@wishlist</tag>
    <title>Tags for wikipages</title>
    <updated-at type="datetime">2009-12-10T14:05:44+01:00</updated-at>
    <user-id type="integer">74572</user-id>
    <user-name>Raphaela</user-name>
    <creator-name>Raphaela</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/346</url>
    <original-body>It would be nice, to immediately land on the wikipage when clicking on a tag, that has been used only once so far, instead of jumping to the list of wikipages tagged with that tagged.</original-body>
    <latest-body>It would be nice, to immediately land on the wikipage when clicking on a tag, that has been used only once so far, instead of jumping to the list of wikipages tagged with that tagged.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;It would be nice, to immediately land on the wikipage when
clicking on a tag, that has been used only once so far, instead of
jumping to the list of wikipages tagged with that tagged.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-12-10T14:02:52+01:00</created-at>
    <creator-id type="integer">74572</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">345</number>
    <permalink>breadcrumb-navigation-for-adva-wiki</permalink>
    <priority type="integer">32904</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>@wishlist</tag>
    <title>Breadcrumb navigation for adva-wiki</title>
    <updated-at type="datetime">2009-12-10T14:02:54+01:00</updated-at>
    <user-id type="integer">74572</user-id>
    <user-name>Raphaela</user-name>
    <creator-name>Raphaela</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/345</url>
    <original-body>At the moment, navigation between wikipages is painful. A breadcrumb navigation would help.</original-body>
    <latest-body>At the moment, navigation between wikipages is painful. A breadcrumb navigation would help.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;At the moment, navigation between wikipages is painful. A
breadcrumb navigation would help.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-11-30T17:45:49+01:00</created-at>
    <creator-id type="integer">78096</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">344</number>
    <permalink>encoding-problem-ruby-19</permalink>
    <priority type="integer">32903</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>enconding ruby19</tag>
    <title>encoding problem ruby 1.9</title>
    <updated-at type="datetime">2009-11-30T17:45:50+01:00</updated-at>
    <user-id type="integer">78096</user-id>
    <user-name>samuel tonini</user-name>
    <creator-name>samuel tonini</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/344</url>
    <original-body>Hi,

while i tried to install the adva:install:core i got this rake aborted issue http://pastie.org/720400

i fixed it with dirty # coding: utf-8 adding at the top of the file

ps: I'm using ruby 1.9

cheers

sam</original-body>
    <latest-body>Hi,

while i tried to install the adva:install:core i got this rake aborted issue http://pastie.org/720400

i fixed it with dirty # coding: utf-8 adding at the top of the file

ps: I'm using ruby 1.9

cheers

sam</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;while i tried to install the adva:install:core i got this rake
aborted issue &lt;a href=
&quot;http://pastie.org/720400&quot;&gt;http://pastie.org/720400&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;i fixed it with dirty # coding: utf-8 adding at the top of the
file&lt;/p&gt;
&lt;p&gt;ps: I'm using ruby 1.9&lt;/p&gt;
&lt;p&gt;cheers&lt;/p&gt;
&lt;p&gt;sam&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-11-30T17:18:42+01:00</created-at>
    <creator-id type="integer">78096</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">343</number>
    <permalink>no-such-file-to-load-sha1</permalink>
    <priority type="integer">32902</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>new</state>
    <tag>authentication</tag>
    <title>no such file to load -- sha1</title>
    <updated-at type="datetime">2009-11-30T17:18:44+01:00</updated-at>
    <user-id type="integer">78096</user-id>
    <user-name>samuel tonini</user-name>
    <creator-name>samuel tonini</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/343</url>
    <original-body>rake aborted while i tried to do the &quot;adva:install:core -R vendor/adva/engines/adva_cms/lib/tasks&quot; step.

fixed it with change required 'sha1' to 'digest/sha1' in &quot;adva_user/vendor/plugins/authentication/lib/authentication/hash_helper.rb&quot;

cheers

sam</original-body>
    <latest-body>rake aborted while i tried to do the &quot;adva:install:core -R vendor/adva/engines/adva_cms/lib/tasks&quot; step.

fixed it with change required 'sha1' to 'digest/sha1' in &quot;adva_user/vendor/plugins/authentication/lib/authentication/hash_helper.rb&quot;

cheers

sam</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;rake aborted while i tried to do the &quot;adva:install:core -R
vendor/adva/engines/adva_cms/lib/tasks&quot; step.&lt;/p&gt;
&lt;p&gt;fixed it with change required 'sha1' to 'digest/sha1' in
&quot;adva_user/vendor/plugins/authentication/lib/authentication/hash_helper.rb&quot;&lt;/p&gt;
&lt;p&gt;cheers&lt;/p&gt;
&lt;p&gt;sam&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">1</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-08-31T13:34:05+02:00</created-at>
    <creator-id type="integer">23609</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">328</number>
    <permalink>migration-failing-on-postgresql</permalink>
    <priority type="integer">32883</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag nil="true"></tag>
    <title>Migration failing on PostgreSQL</title>
    <updated-at type="datetime">2009-11-23T17:25:51+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Chris Barnett</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/328</url>
    <original-body>engines/adva_cms/db/migrate/20090709111934_add_email_notification_to_site.rb has:

@@@ ruby
add_column :sites, :email_notification, :boolean, :default =&gt; 0
@@@

Which fails under PostgreSQL:

@@@
==  AddEmailNotificationToSite: migrating =====================================
-- add_column(:sites, :email_notification, :boolean, {:default=&gt;0})
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR:  column &quot;email_notification&quot; is of type boolean but default expression is of type integer
HINT:  You will need to rewrite or cast the expression.
: ALTER TABLE &quot;sites&quot; ALTER COLUMN &quot;email_notification&quot; SET DEFAULT 0
@@@

The attached patch replaces :default =&gt; 0 with :default =&gt; false</original-body>
    <latest-body>engines/adva_cms/db/migrate/20090709111934_add_email_notification_to_site.rb has:

@@@ ruby
add_column :sites, :email_notification, :boolean, :default =&gt; 0
@@@

Which fails under PostgreSQL:

@@@
==  AddEmailNotificationToSite: migrating =====================================
-- add_column(:sites, :email_notification, :boolean, {:default=&gt;0})
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR:  column &quot;email_notification&quot; is of type boolean but default expression is of type integer
HINT:  You will need to rewrite or cast the expression.
: ALTER TABLE &quot;sites&quot; ALTER COLUMN &quot;email_notification&quot; SET DEFAULT 0
@@@

The attached patch replaces :default =&gt; 0 with :default =&gt; false</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;
engines/adva_cms/db/migrate/20090709111934_add_email_notification_to_site.rb
has:&lt;/p&gt;
&lt;pre&gt;
&lt;code class=
&quot;ruby&quot;&gt;add_column :sites, :email_notification, :boolean, :default =&amp;gt; 0&lt;/code&gt;
&lt;/pre&gt;
&lt;p&gt;Which fails under PostgreSQL:&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt;==  AddEmailNotificationToSite: migrating =====================================
-- add_column(:sites, :email_notification, :boolean, {:default=&amp;gt;0})
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR:  column &quot;email_notification&quot; is of type boolean but default expression is of type integer
HINT:  You will need to rewrite or cast the expression.
: ALTER TABLE &quot;sites&quot; ALTER COLUMN &quot;email_notification&quot; SET DEFAULT 0&lt;/code&gt;
&lt;/pre&gt;
&lt;p&gt;The attached patch replaces :default =&amp;gt; 0 with :default =&amp;gt;
false&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-11-18T08:57:42+01:00</created-at>
    <creator-id type="integer">26158</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">341</number>
    <permalink>when-deleting-a-section-the-user-is-not-returned-to-section-list</permalink>
    <priority type="integer">32900</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag nil="true"></tag>
    <title>When deleting a section, the user is not returned to section list</title>
    <updated-at type="datetime">2009-11-23T17:14:08+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Torsten Becker</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/341</url>
    <original-body>The user deletes a section in the section list. adva-cms shows the new section screen, but it would be better to show the section list.</original-body>
    <latest-body>The user deletes a section in the section list. adva-cms shows the new section screen, but it would be better to show the section list.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;The user deletes a section in the section list. adva-cms shows
the new section screen, but it would be better to show the section
list.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">25735</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-02-02T13:18:06+01:00</created-at>
    <creator-id type="integer">25735</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">219</number>
    <permalink>authorized_tag-not-working-for-forum-posts</permalink>
    <priority type="integer">3</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag>permissions rbac</tag>
    <title>authorized_tag not working for forum posts</title>
    <updated-at type="datetime">2009-11-23T17:13:56+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Marko Sepp&#228;</creator-name>
    <assigned-user-name>Marko Sepp&#228;</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/219</url>
    <original-body>Error was detected when running an integration test with admin login and trying to edit a post in a topic. Admin user was redirected to login instead of edit for of a post. This error comes from wrong authorizations through authorized_tag. Following is the input of what authorized tag gives for visible-for.

&lt;code&gt;
&lt;span class=&quot;visible-for user-191 comment-350-author comment-350-moderator comment-350-admin superuser&quot;&gt;
        &lt;a href=&quot;/topics/195/posts/350/edit?return_to=%2Ftopics%2Fa-topic&quot; id=&quot;edit_post_350&quot;&gt;Edit&lt;/a&gt;
&lt;/span&gt;
&lt;/code&gt;

instead it should be like this

&lt;code&gt;
&lt;span class=&quot;visible-for user-191 comment-350-author section-350-moderator site-350-admin superuser&quot;&gt;
        &lt;a href=&quot;/topics/195/posts/350/edit?return_to=%2Ftopics%2Fa-topic&quot; id=&quot;edit_post_350&quot;&gt;Edit&lt;/a&gt;
&lt;/span&gt;
&lt;/code&gt;</original-body>
    <latest-body>Error was detected when running an integration test with admin login and trying to edit a post in a topic. Admin user was redirected to login instead of edit for of a post. This error comes from wrong authorizations through authorized_tag. Following is the input of what authorized tag gives for visible-for.

&lt;code&gt;
&lt;span class=&quot;visible-for user-191 comment-350-author comment-350-moderator comment-350-admin superuser&quot;&gt;
        &lt;a href=&quot;/topics/195/posts/350/edit?return_to=%2Ftopics%2Fa-topic&quot; id=&quot;edit_post_350&quot;&gt;Edit&lt;/a&gt;
&lt;/span&gt;
&lt;/code&gt;

instead it should be like this

&lt;code&gt;
&lt;span class=&quot;visible-for user-191 comment-350-author section-350-moderator site-350-admin superuser&quot;&gt;
        &lt;a href=&quot;/topics/195/posts/350/edit?return_to=%2Ftopics%2Fa-topic&quot; id=&quot;edit_post_350&quot;&gt;Edit&lt;/a&gt;
&lt;/span&gt;
&lt;/code&gt;</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;Error was detected when running an integration test with admin
login and trying to edit a post in a topic. Admin user was
redirected to login instead of edit for of a post. This error comes
from wrong authorizations through authorized_tag. Following is the
input of what authorized tag gives for visible-for.&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt;    Edit
&lt;/code&gt;
&lt;/pre&gt;
&lt;p&gt;instead it should be like this&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt;    Edit
&lt;/code&gt;
&lt;/pre&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-10-01T13:52:14+02:00</created-at>
    <creator-id type="integer">66888</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">336</number>
    <permalink>forgotten-theme-export-link</permalink>
    <priority type="integer">32895</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>open</state>
    <tag>fea</tag>
    <title>Forgotten theme export link</title>
    <updated-at type="datetime">2009-11-23T11:55:30+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Akzhan</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/336</url>
    <original-body>While themes were moved to adva_themes engine, export link was missed from page design.

I recommend to retrieve it using
- vendor/adva/engines/adva_themes/app/views/admin/themes/_theme.html.erb

@@@ html
&lt;ul id=&quot;theme_list&quot;&gt;
	&lt;li class=&quot;theme&lt;%= ' current' if theme.active? %&gt;&quot;&gt;
	  &lt;h4 title=&quot;&lt;%= theme.theme_id %&gt;&quot;&gt;&lt;%= theme.name %&gt;&lt;/h4&gt;
	  &lt;p&gt;
			&lt;%= &quot;v#{theme.version}&quot; if theme.version.present? %&gt;
	    &lt;%= t(:'adva.common.by_author', :author =&gt; theme.author_link) %&gt;
	  &lt;/p&gt;
		&lt;%= link_to theme_image_tag(theme.theme_id, theme.preview.base_url, :title =&gt; theme.theme_id), index_path([theme, :'theme/file']) if theme.preview %&gt;

		&lt;ul class=&quot;options&quot;&gt;
	    &lt;% if theme.active? %&gt;
				&lt;li&gt;&lt;%= link_to_deactivate_theme(theme) %&gt;&lt;/li&gt;
	    &lt;% else %&gt;
				&lt;li&gt;&lt;%= link_to_activate_theme(theme) %&gt;&lt;/li&gt;
	    &lt;% end %&gt;
	    &lt;li&gt;&lt;%= link_to t(:'adva.themes.links.edit'), edit_admin_theme_path(@site, theme) %&gt;&lt;/li&gt;
	    &lt;li&gt;&lt;%= link_to t(:'adva.themes.links.export'), export_admin_theme_path(@site, theme.id) %&gt;&lt;/li&gt;
	    &lt;li&gt;&lt;%= link_to t(:'adva.themes.links.delete'), admin_theme_path(@site, theme), { :confirm =&gt; t(:'adva.themes.confirm_uninstall'), :method =&gt; :delete }  %&gt;&lt;/li&gt;
	  &lt;/ul&gt;
	&lt;/li&gt;
&lt;/ul&gt;
@@@

@@@ yaml
en:
  adva:
    themes:
      links:
        export:  'Download as zip'
@@@</original-body>
    <latest-body>While themes were moved to adva_themes engine, export link was missed from page design.

I recommend to retrieve it using
- vendor/adva/engines/adva_themes/app/views/admin/themes/_theme.html.erb

@@@ html
&lt;ul id=&quot;theme_list&quot;&gt;
	&lt;li class=&quot;theme&lt;%= ' current' if theme.active? %&gt;&quot;&gt;
	  &lt;h4 title=&quot;&lt;%= theme.theme_id %&gt;&quot;&gt;&lt;%= theme.name %&gt;&lt;/h4&gt;
	  &lt;p&gt;
			&lt;%= &quot;v#{theme.version}&quot; if theme.version.present? %&gt;
	    &lt;%= t(:'adva.common.by_author', :author =&gt; theme.author_link) %&gt;
	  &lt;/p&gt;
		&lt;%= link_to theme_image_tag(theme.theme_id, theme.preview.base_url, :title =&gt; theme.theme_id), index_path([theme, :'theme/file']) if theme.preview %&gt;

		&lt;ul class=&quot;options&quot;&gt;
	    &lt;% if theme.active? %&gt;
				&lt;li&gt;&lt;%= link_to_deactivate_theme(theme) %&gt;&lt;/li&gt;
	    &lt;% else %&gt;
				&lt;li&gt;&lt;%= link_to_activate_theme(theme) %&gt;&lt;/li&gt;
	    &lt;% end %&gt;
	    &lt;li&gt;&lt;%= link_to t(:'adva.themes.links.edit'), edit_admin_theme_path(@site, theme) %&gt;&lt;/li&gt;
	    &lt;li&gt;&lt;%= link_to t(:'adva.themes.links.export'), export_admin_theme_path(@site, theme.id) %&gt;&lt;/li&gt;
	    &lt;li&gt;&lt;%= link_to t(:'adva.themes.links.delete'), admin_theme_path(@site, theme), { :confirm =&gt; t(:'adva.themes.confirm_uninstall'), :method =&gt; :delete }  %&gt;&lt;/li&gt;
	  &lt;/ul&gt;
	&lt;/li&gt;
&lt;/ul&gt;
@@@

@@@ yaml
en:
  adva:
    themes:
      links:
        export:  'Download as zip'
@@@</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;While themes were moved to adva_themes engine, export link was
missed from page design.&lt;/p&gt;
&lt;p&gt;I recommend to retrieve it using&lt;br&gt;
-
vendor/adva/engines/adva_themes/app/views/admin/themes/_theme.html.erb&lt;/p&gt;
&lt;pre&gt;
&lt;code class=&quot;html&quot;&gt;&amp;lt;ul id=&quot;theme_list&quot;&amp;gt;
    &amp;lt;li class=&quot;theme&amp;lt;%= ' current' if theme.active? %&amp;gt;&quot;&amp;gt;
      &amp;lt;h4 title=&quot;&amp;lt;%= theme.theme_id %&amp;gt;&quot;&amp;gt;&amp;lt;%= theme.name %&amp;gt;&amp;lt;/h4&amp;gt;
      &amp;lt;p&amp;gt;
            &amp;lt;%= &quot;v#{theme.version}&quot; if theme.version.present? %&amp;gt;
        &amp;lt;%= t(:'adva.common.by_author', :author =&amp;gt; theme.author_link) %&amp;gt;
      &amp;lt;/p&amp;gt;
        &amp;lt;%= link_to theme_image_tag(theme.theme_id, theme.preview.base_url, :title =&amp;gt; theme.theme_id), index_path([theme, :'theme/file']) if theme.preview %&amp;gt;

        &amp;lt;ul class=&quot;options&quot;&amp;gt;
        &amp;lt;% if theme.active? %&amp;gt;
                &amp;lt;li&amp;gt;&amp;lt;%= link_to_deactivate_theme(theme) %&amp;gt;&amp;lt;/li&amp;gt;
        &amp;lt;% else %&amp;gt;
                &amp;lt;li&amp;gt;&amp;lt;%= link_to_activate_theme(theme) %&amp;gt;&amp;lt;/li&amp;gt;
        &amp;lt;% end %&amp;gt;
        &amp;lt;li&amp;gt;&amp;lt;%= link_to t(:'adva.themes.links.edit'), edit_admin_theme_path(@site, theme) %&amp;gt;&amp;lt;/li&amp;gt;
        &amp;lt;li&amp;gt;&amp;lt;%= link_to t(:'adva.themes.links.export'), export_admin_theme_path(@site, theme.id) %&amp;gt;&amp;lt;/li&amp;gt;
        &amp;lt;li&amp;gt;&amp;lt;%= link_to t(:'adva.themes.links.delete'), admin_theme_path(@site, theme), { :confirm =&amp;gt; t(:'adva.themes.confirm_uninstall'), :method =&amp;gt; :delete }  %&amp;gt;&amp;lt;/li&amp;gt;
      &amp;lt;/ul&amp;gt;
    &amp;lt;/li&amp;gt;
&amp;lt;/ul&amp;gt;&lt;/code&gt;
&lt;/pre&gt;
&lt;pre&gt;
&lt;code class=&quot;yaml&quot;&gt;en:
  adva:
    themes:
      links:
        export:  'Download as zip'&lt;/code&gt;
&lt;/pre&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-10-01T10:40:03+02:00</created-at>
    <creator-id type="integer">66888</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">335</number>
    <permalink>customization-of-tag-links</permalink>
    <priority type="integer">32894</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>open</state>
    <tag>content customization tags theming</tag>
    <title>Customization of tag links</title>
    <updated-at type="datetime">2009-11-23T11:38:31+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Akzhan</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/335</url>
    <original-body>We need customization of links to tags (to easy adopt themes for AdvaCMS).

So here is our proposal to update 
- app/helpers/content_helper.rb

  def link_to_tag(*args)
    options = args.extract_options!
    tag = args.pop
    section = args.pop
    route_name = :&quot;#{section.class.name.downcase}_tag_path&quot;
    text = args.pop || tag.name
    link_to(text, send(route_name, :section_id =&gt; section.id, :tags =&gt; tag), options)
  end

And second proposal is tag cloud cell (typical for social networks):

- app/cells/tag_cloud_cell.rb
class TagCloudCell &lt; BaseCell
  has_state :index
  helper    :content

  def index
    symbolize_options!
    set_site
    set_section

    nil
  end
end

- app/cells/tag_cloud/index.html.erb
&lt;% if @section and @section.tag_counts.present? %&gt;
&lt;h2&gt;Tags:&lt;/h2&gt;
&lt;div class=&quot;tags&quot;&gt;
  &lt;% @section.tag_counts.each do |tag|
    weight = tag.count / 10
    weight = 5 if weight &gt; 5
    weight = 1 if weight &lt; 1
  %&gt;
    &lt;%= link_to_tag @section, tag, :class =&gt; &quot;s#{weight}&quot; %&gt;
  &lt;% end %&gt;
&lt;/div&gt;
&lt;% end %&gt;</original-body>
    <latest-body>We need customization of links to tags (to easy adopt themes for AdvaCMS).

So here is our proposal to update 
- app/helpers/content_helper.rb

  def link_to_tag(*args)
    options = args.extract_options!
    tag = args.pop
    section = args.pop
    route_name = :&quot;#{section.class.name.downcase}_tag_path&quot;
    text = args.pop || tag.name
    link_to(text, send(route_name, :section_id =&gt; section.id, :tags =&gt; tag), options)
  end

And second proposal is tag cloud cell (typical for social networks):

- app/cells/tag_cloud_cell.rb
class TagCloudCell &lt; BaseCell
  has_state :index
  helper    :content

  def index
    symbolize_options!
    set_site
    set_section

    nil
  end
end

- app/cells/tag_cloud/index.html.erb
&lt;% if @section and @section.tag_counts.present? %&gt;
&lt;h2&gt;Tags:&lt;/h2&gt;
&lt;div class=&quot;tags&quot;&gt;
  &lt;% @section.tag_counts.each do |tag|
    weight = tag.count / 10
    weight = 5 if weight &gt; 5
    weight = 1 if weight &lt; 1
  %&gt;
    &lt;%= link_to_tag @section, tag, :class =&gt; &quot;s#{weight}&quot; %&gt;
  &lt;% end %&gt;
&lt;/div&gt;
&lt;% end %&gt;</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;We need customization of links to tags (to easy adopt themes for
AdvaCMS).&lt;/p&gt;
&lt;p&gt;So here is our proposal to update&lt;br&gt;
- app/helpers/content_helper.rb&lt;/p&gt;
&lt;p&gt;def link_to_tag(*args)&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt;options = args.extract_options!
tag = args.pop
section = args.pop
route_name = :&quot;#{section.class.name.downcase}_tag_path&quot;
text = args.pop || tag.name
link_to(text, send(route_name, :section_id =&amp;gt; section.id, :tags =&amp;gt; tag), options)&lt;/code&gt;
&lt;/pre&gt;
&lt;p&gt;end&lt;/p&gt;
&lt;p&gt;And second proposal is tag cloud cell (typical for social
networks):&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;app/cells/tag_cloud_cell.rb class TagCloudCell &amp;lt;
BaseCell&lt;br&gt;
has_state :index helper :content&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;def index&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt;symbolize_options!
set_site
set_section

nil&lt;/code&gt;
&lt;/pre&gt;
&lt;p&gt;end end&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;app/cells/tag_cloud/index.html.erb &amp;lt;% if @section and
@section.tag_counts.present? %&amp;gt;&lt;br&gt;
&lt;h2&gt;Tags:&lt;/h2&gt;
&lt;br&gt;
&lt;div class=&quot;tags&quot;&gt;&lt;br&gt;
&amp;lt;% @section.tag_counts.each do |tag| weight = tag.count / 10
weight = 5 if weight &amp;gt; 5 weight = 1 if weight &amp;lt; 1 %&amp;gt;
&amp;lt;%= link_to_tag @section, tag, :class =&amp;gt; &quot;s#{weight}&quot; %&amp;gt;
&amp;lt;% end %&amp;gt;&lt;/div&gt;
&lt;br&gt;
&amp;lt;% end %&amp;gt;&lt;/li&gt;
&lt;/ul&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-09-18T17:16:31+02:00</created-at>
    <creator-id type="integer">70154</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">333</number>
    <permalink>has_filter-categorized-with-postgresql</permalink>
    <priority type="integer">32892</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>open</state>
    <tag>filtering postgresql</tag>
    <title>has_filter :categorized with PostgreSQL</title>
    <updated-at type="datetime">2009-11-23T11:36:49+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Joseph Ridgway</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/333</url>
    <original-body>Filtering articles (or albums etc) by category doesn't work with PostgreSQL installed. PostgreSQL doesn't allow &quot;#{table_name}.id&quot; in the group by clause like MySQL does. Rather, each column must be listed. I've tried fixing this but didn't get far. If I understood the method better I might get further. Any help?

This can be found in vendor/adva/engines/adva_cms/vendor/plugins/has_filter/lib/has_filter/active_record/act_macro.rb. 

Error below:

PGError: ERROR:  column &quot;contents.site_id&quot; must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT contents.*, COUNT(*) AS count FROM &quot;contents&quot;   INNER...
               ^
: SELECT contents.*, COUNT(*) AS count FROM &quot;contents&quot;   INNER JOIN &quot;categorizations&quot; ON &quot;categorizations&quot;.categorizable_id = &quot;contents&quot;.id AND &quot;categorizations&quot;.categorizable_type = E'Content' INNER JOIN &quot;categories&quot; ON &quot;categories&quot;.id = &quot;categorizations&quot;.category_id  WHERE (((categories.id IN(E'4')) AND (&quot;contents&quot;.section_id = 1)) AND (&quot;contents&quot;.section_id = 1)) AND ( (&quot;contents&quot;.&quot;type&quot; = 'Article' ) )  GROUP BY contents.id HAVING count(*) &gt;= 1 ORDER BY contents.position, contents.id DESC, contents.published_at DESC LIMIT 25 OFFSET 0</original-body>
    <latest-body>Filtering articles (or albums etc) by category doesn't work with PostgreSQL installed. PostgreSQL doesn't allow &quot;#{table_name}.id&quot; in the group by clause like MySQL does. Rather, each column must be listed. I've tried fixing this but didn't get far. If I understood the method better I might get further. Any help?

This can be found in vendor/adva/engines/adva_cms/vendor/plugins/has_filter/lib/has_filter/active_record/act_macro.rb. 

Error below:

PGError: ERROR:  column &quot;contents.site_id&quot; must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT contents.*, COUNT(*) AS count FROM &quot;contents&quot;   INNER...
               ^
: SELECT contents.*, COUNT(*) AS count FROM &quot;contents&quot;   INNER JOIN &quot;categorizations&quot; ON &quot;categorizations&quot;.categorizable_id = &quot;contents&quot;.id AND &quot;categorizations&quot;.categorizable_type = E'Content' INNER JOIN &quot;categories&quot; ON &quot;categories&quot;.id = &quot;categorizations&quot;.category_id  WHERE (((categories.id IN(E'4')) AND (&quot;contents&quot;.section_id = 1)) AND (&quot;contents&quot;.section_id = 1)) AND ( (&quot;contents&quot;.&quot;type&quot; = 'Article' ) )  GROUP BY contents.id HAVING count(*) &gt;= 1 ORDER BY contents.position, contents.id DESC, contents.published_at DESC LIMIT 25 OFFSET 0</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;Filtering articles (or albums etc) by category doesn't work with
PostgreSQL installed. PostgreSQL doesn't allow &quot;#{table_name}.id&quot;
in the group by clause like MySQL does. Rather, each column must be
listed. I've tried fixing this but didn't get far. If I understood
the method better I might get further. Any help?&lt;/p&gt;
&lt;p&gt;This can be found in
vendor/adva/engines/adva_cms/vendor/plugins/has_filter/lib/has_filter/active_record/act_macro.rb.&lt;/p&gt;
&lt;p&gt;Error below:&lt;/p&gt;
&lt;p&gt;PGError: ERROR: column &quot;contents.site_id&quot; must appear in the
GROUP BY clause or be used in an aggregate function&lt;br&gt;
LINE 1: SELECT contents.&lt;em&gt;, COUNT(&lt;/em&gt;) AS count FROM &quot;contents&quot;
INNER...&lt;br&gt;&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt;           ^&lt;/code&gt;
&lt;/pre&gt;
&lt;p&gt;: SELECT contents.&lt;em&gt;, COUNT(&lt;/em&gt;) AS count FROM &quot;contents&quot;
INNER JOIN &quot;categorizations&quot; ON &quot;categorizations&quot;.categorizable_id
= &quot;contents&quot;.id AND &quot;categorizations&quot;.categorizable_type =
E'Content' INNER JOIN &quot;categories&quot; ON &quot;categories&quot;.id =
&quot;categorizations&quot;.category_id WHERE (((categories.id IN(E'4')) AND
(&quot;contents&quot;.section_id = 1)) AND (&quot;contents&quot;.section_id = 1)) AND (
(&quot;contents&quot;.&quot;type&quot; = 'Article' ) ) GROUP BY contents.id HAVING
count(*) &amp;gt;= 1 ORDER BY contents.position, contents.id DESC,
contents.published_at DESC LIMIT 25 OFFSET 0&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-09-09T15:28:41+02:00</created-at>
    <creator-id type="integer">54464</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">331</number>
    <permalink>fix-for-cell-dialog-resize-on-edit</permalink>
    <priority type="integer">32887</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>open</state>
    <tag>bugfix cells fckeditor</tag>
    <title>Fix for cell dialog resize on edit</title>
    <updated-at type="datetime">2009-11-23T11:24:37+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Micah Geisel</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/331</url>
    <original-body>diff --git a/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html b/plugins/adva_fckeditor/public/javascripts/adva_fcke
index e202bfb..aacc153 100644
--- a/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html
+++ b/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html
@@ -183,8 +183,7 @@
     }
     
     // resize the dialog
-    // TODO: doesn't work since the dialog doesn't expose this method ...
-    // dialog.RefreshSize();
+    dialog.SetAutoSize(true);
   };
   
   // register event handlers</original-body>
    <latest-body>diff --git a/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html b/plugins/adva_fckeditor/public/javascripts/adva_fcke
index e202bfb..aacc153 100644
--- a/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html
+++ b/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html
@@ -183,8 +183,7 @@
     }
     
     // resize the dialog
-    // TODO: doesn't work since the dialog doesn't expose this method ...
-    // dialog.RefreshSize();
+    dialog.SetAutoSize(true);
   };
   
   // register event handlers</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;diff --git
a/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html
b/plugins/adva_fckeditor/public/javascripts/adva_fcke&lt;br&gt;
index e202bfb..aacc153 100644&lt;br&gt;
---
a/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html
+++
b/plugins/adva_fckeditor/public/javascripts/adva_fckeditor/fckeditor_plugins/cells/cell.html
@@ -183,8 +183,7 @@&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt; }

 // resize the dialog&lt;/code&gt;
&lt;/pre&gt;
&lt;ul&gt;
&lt;li&gt;// TODO: doesn't work since the dialog doesn't expose this
method ...&lt;/li&gt;
&lt;li&gt;// dialog.RefreshSize();&lt;/li&gt;
&lt;li&gt;dialog.SetAutoSize(true); };&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;// register event handlers&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-11-04T10:23:03+01:00</created-at>
    <creator-id type="integer">75194</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">339</number>
    <permalink>down-migration-fails</permalink>
    <priority type="integer">32898</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>open</state>
    <tag>migration</tag>
    <title>down migration fails</title>
    <updated-at type="datetime">2009-11-23T11:21:20+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Johannes Strampe</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/339</url>
    <original-body>We tried to down migrate with all adva-engines installed.
Error happens in
migration: CreateCategoryTranslations
unknown method: drop_translation_table

The actual method is called drop_translation_table! in translated.rb of the globalize plugin and can be used instead.

After fixing this, there are still errors preventing the down migration.</original-body>
    <latest-body>We tried to down migrate with all adva-engines installed.
Error happens in
migration: CreateCategoryTranslations
unknown method: drop_translation_table

The actual method is called drop_translation_table! in translated.rb of the globalize plugin and can be used instead.

After fixing this, there are still errors preventing the down migration.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;We tried to down migrate with all adva-engines installed.&lt;br&gt;
Error happens in&lt;br&gt;
migration: CreateCategoryTranslations&lt;br&gt;
unknown method: drop_translation_table&lt;/p&gt;
&lt;p&gt;The actual method is called drop_translation_table! in
translated.rb of the globalize plugin and can be used instead.&lt;/p&gt;
&lt;p&gt;After fixing this, there are still errors preventing the down
migration.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-11-18T14:46:23+01:00</created-at>
    <creator-id type="integer">74572</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">342</number>
    <permalink>create-section</permalink>
    <priority type="integer">32901</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>open</state>
    <tag>create section</tag>
    <title>Create Section</title>
    <updated-at type="datetime">2009-11-23T11:13:09+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Raphaela</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/342</url>
    <original-body>adva-cms does not allow to create multiple sections with the same title.</original-body>
    <latest-body>adva-cms does not allow to create multiple sections with the same title.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;adva-cms does not allow to create multiple sections with the
same title.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-08-05T06:22:06+02:00</created-at>
    <creator-id type="integer">54464</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">326</number>
    <permalink>undefined-method-admin_gem_plugin_path</permalink>
    <priority type="integer">32879</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>hold</state>
    <tag nil="true"></tag>
    <title>undefined method `admin_gem_plugin_path`</title>
    <updated-at type="datetime">2009-11-23T11:10:23+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Micah Geisel</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/326</url>
    <original-body>visiting /admin/sites/1/plugins yields this error. im guessing that rails 2.3.3 created a new related class of Plugin called GemPlugin, causing your resource_url helpers to call a path that doesnt exist. ive already hacked around the issue, so just an fyi.</original-body>
    <latest-body>visiting /admin/sites/1/plugins yields this error. im guessing that rails 2.3.3 created a new related class of Plugin called GemPlugin, causing your resource_url helpers to call a path that doesnt exist. ive already hacked around the issue, so just an fyi.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;visiting /admin/sites/1/plugins yields this error. im guessing
that rails 2.3.3 created a new related class of Plugin called
GemPlugin, causing your resource_url helpers to call a path that
doesnt exist. ive already hacked around the issue, so just an
fyi.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">false</closed>
    <created-at type="datetime">2009-06-25T08:53:40+02:00</created-at>
    <creator-id type="integer">32675</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">321</number>
    <permalink>ruby-191-branch-pushed-up</permalink>
    <priority type="integer">32874</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>open</state>
    <tag nil="true"></tag>
    <title>ruby 1.9.1 branch pushed up</title>
    <updated-at type="datetime">2009-11-23T11:01:12+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Priit Tamboom</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/321</url>
    <original-body>I pushed ruby 1.9.1 branch (http://github.com/svenfuchs/adva_cms/tree/ruby191), so everyone who is playing with adva on ruby 1.9.1 please use it until ruby191 branch is ready to merge with master.</original-body>
    <latest-body>I pushed ruby 1.9.1 branch (http://github.com/svenfuchs/adva_cms/tree/ruby191), so everyone who is playing with adva on ruby 1.9.1 please use it until ruby191 branch is ready to merge with master.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;I pushed ruby 1.9.1 branch (&lt;a href=&quot;http://github.com/svenfuchs/adva_cms/tree/ruby191)&quot;&gt;http://github.com/svenfuchs/adva...&lt;/a&gt;,
so everyone who is playing with adva on ruby 1.9.1 please use it
until ruby191 branch is ready to merge with master.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">25735</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-05-08T21:53:06+02:00</created-at>
    <creator-id type="integer">26158</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">304</number>
    <permalink>install-problem</permalink>
    <priority type="integer">32857</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag nil="true"></tag>
    <title>Install problem</title>
    <updated-at type="datetime">2009-11-23T10:56:10+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Torsten Becker</creator-name>
    <assigned-user-name>Marko Sepp&#228;</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/304</url>
    <original-body>no such file to load -- ruby_pants when running rake adva:install:all</original-body>
    <latest-body>no such file to load -- ruby_pants when running rake adva:install:all</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;no such file to load -- ruby_pants when running rake
adva:install:all&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">25735</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2008-10-09T15:43:37+02:00</created-at>
    <creator-id type="integer">7400</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">100</number>
    <permalink>research-js-test-frameworks-and-propose-options</permalink>
    <priority type="integer">4</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag nil="true"></tag>
    <title>Research JS test frameworks and propose options</title>
    <updated-at type="datetime">2009-11-23T10:12:23+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Sven Fuchs</creator-name>
    <assigned-user-name>Marko Sepp&#228;</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/100</url>
    <original-body></original-body>
    <latest-body></latest-body>
    <original-body-html></original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-03-10T21:50:46+01:00</created-at>
    <creator-id type="integer">7400</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">248</number>
    <permalink>rework-rbac-backend</permalink>
    <priority type="integer">32824</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag nil="true"></tag>
    <title>rework RBAC backend</title>
    <updated-at type="datetime">2009-11-23T09:44:56+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Sven Fuchs</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/248</url>
    <original-body></original-body>
    <latest-body></latest-body>
    <original-body-html></original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-03-31T11:32:28+02:00</created-at>
    <creator-id type="integer">25735</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">277</number>
    <permalink>revisit-rbac</permalink>
    <priority type="integer">2</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag>rbac</tag>
    <title>Revisit RBAC</title>
    <updated-at type="datetime">2009-11-23T09:43:30+01:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Marko Sepp&#228;</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/277</url>
    <original-body>Revisit RBAC</original-body>
    <latest-body>Revisit RBAC</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;Revisit RBAC&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-11-02T15:21:45+01:00</created-at>
    <creator-id type="integer">18096</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">338</number>
    <permalink>fix-admin-access-for-single-site-mode</permalink>
    <priority type="integer">32897</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag nil="true"></tag>
    <title>Fix admin access for single site mode</title>
    <updated-at type="datetime">2009-11-03T11:34:58+01:00</updated-at>
    <user-id type="integer">74572</user-id>
    <user-name>Raphaela</user-name>
    <creator-name>Clemens Kofler</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/338</url>
    <original-body>When accessing the admin area in single site mode with the host not matching the stored site's host, one gets an error. In contrast, in the public area we always just use the first site in single site mode - this should be adapted for the admin area as well.

Relevant code bits (all in the adva_cms engine):
- app/controllers/base_controller.rb: before_filter set_site (using Site.find_by_host!)
- app/models/site.rb: .find_by_host! method
- app/controllers/admin/sites_controller.rb: before_filter protect_single_site_mode (incorrectly using find_or_initialize_by_host which doesn't make sense at all)

IMO the best thing would be to use the same behavior for the admin SitesController as seen in BaseController.

Please do also add a test that fails with the current implementation to make sure we don't run into that again.</original-body>
    <latest-body>When accessing the admin area in single site mode with the host not matching the stored site's host, one gets an error. In contrast, in the public area we always just use the first site in single site mode - this should be adapted for the admin area as well.

Relevant code bits (all in the adva_cms engine):
- app/controllers/base_controller.rb: before_filter set_site (using Site.find_by_host!)
- app/models/site.rb: .find_by_host! method
- app/controllers/admin/sites_controller.rb: before_filter protect_single_site_mode (incorrectly using find_or_initialize_by_host which doesn't make sense at all)

IMO the best thing would be to use the same behavior for the admin SitesController as seen in BaseController.

Please do also add a test that fails with the current implementation to make sure we don't run into that again.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;When accessing the admin area in single site mode with the host
not matching the stored site's host, one gets an error. In
contrast, in the public area we always just use the first site in
single site mode - this should be adapted for the admin area as
well.&lt;/p&gt;
&lt;p&gt;Relevant code bits (all in the adva_cms engine):&lt;br&gt;
- app/controllers/base_controller.rb: before_filter set_site (using
Site.find_by_host!) - app/models/site.rb: .find_by_host! method -
app/controllers/admin/sites_controller.rb: before_filter
protect_single_site_mode (incorrectly using
find_or_initialize_by_host which doesn't make sense at all)&lt;/p&gt;
&lt;p&gt;IMO the best thing would be to use the same behavior for the
admin SitesController as seen in BaseController.&lt;/p&gt;
&lt;p&gt;Please do also add a test that fails with the current
implementation to make sure we don't run into that again.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">18096</assigned-user-id>
    <attachments-count type="integer">0</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-10-27T15:25:25+01:00</created-at>
    <creator-id type="integer">74572</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">337</number>
    <permalink>breadcrumb-navigation-incomplete-for-newsletters</permalink>
    <priority type="integer">1</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag>breadcrumb menu newsletter</tag>
    <title>breadcrumb navigation incomplete for newsletters</title>
    <updated-at type="datetime">2009-10-30T10:13:11+01:00</updated-at>
    <user-id type="integer">18096</user-id>
    <user-name>Clemens Kofler</user-name>
    <creator-name>Raphaela</creator-name>
    <assigned-user-name>Clemens Kofler</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/337</url>
    <original-body>When navigating to an existing newsletter, say 'My Newsletter' the breadcrumb shows as follows:

My Site 1 -&gt; Newsletters -&gt; Issues

with 'My Newsletter' missing between 'Newsletters' and 'Issues'</original-body>
    <latest-body>When navigating to an existing newsletter, say 'My Newsletter' the breadcrumb shows as follows:

My Site 1 -&gt; Newsletters -&gt; Issues

with 'My Newsletter' missing between 'Newsletters' and 'Issues'</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;When navigating to an existing newsletter, say 'My Newsletter'
the breadcrumb shows as follows:&lt;/p&gt;
&lt;p&gt;My Site 1 -&amp;gt; Newsletters -&amp;gt; Issues&lt;/p&gt;
&lt;p&gt;with 'My Newsletter' missing between 'Newsletters' and
'Issues'&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
  <ticket>
    <assigned-user-id type="integer">7400</assigned-user-id>
    <attachments-count type="integer">1</attachments-count>
    <closed type="boolean">true</closed>
    <created-at type="datetime">2009-09-25T18:45:56+02:00</created-at>
    <creator-id type="integer">70154</creator-id>
    <milestone-due-on type="datetime" nil="true"></milestone-due-on>
    <milestone-id type="integer" nil="true"></milestone-id>
    <number type="integer">334</number>
    <permalink>optimistic-locks-dont-work</permalink>
    <priority type="integer">32893</priority>
    <project-id type="integer">13992</project-id>
    <raw-data type="binary" nil="true" encoding="base64"></raw-data>
    <state>resolved</state>
    <tag nil="true"></tag>
    <title>Optimistic locks don't work</title>
    <updated-at type="datetime">2009-09-29T11:08:06+02:00</updated-at>
    <user-id type="integer">25735</user-id>
    <user-name>Marko Sepp&#228;</user-name>
    <creator-name>Joseph Ridgway</creator-name>
    <assigned-user-name>Sven Fuchs</assigned-user-name>
    <url>http://artweb-design.lighthouseapp.com/projects/13992/tickets/334</url>
    <original-body>Note I'm using PostgreSQL. Line 155 in engines/adva_cms/app/controllers/admin/articles_controller.rb evaluates to true when it shouldn't:

    if @article.updated_at &amp;&amp; (Time.zone.parse(updated_at) != @article.updated_at) 

It looks like @article.updated_at includes microseconds. My solution is to convert both to strings before evaluating:

    if @article.updated_at &amp;&amp; (Time.zone.parse(updated_at).to_s != @article.updated_at.to_s) 

This works but might not be the best solution.</original-body>
    <latest-body>Note I'm using PostgreSQL. Line 155 in engines/adva_cms/app/controllers/admin/articles_controller.rb evaluates to true when it shouldn't:

    if @article.updated_at &amp;&amp; (Time.zone.parse(updated_at) != @article.updated_at) 

It looks like @article.updated_at includes microseconds. My solution is to convert both to strings before evaluating:

    if @article.updated_at &amp;&amp; (Time.zone.parse(updated_at).to_s != @article.updated_at.to_s) 

This works but might not be the best solution.</latest-body>
    <original-body-html>&lt;div&gt;&lt;p&gt;Note I'm using PostgreSQL. Line 155 in
engines/adva_cms/app/controllers/admin/articles_controller.rb
evaluates to true when it shouldn't:&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt;if @article.updated_at &amp;amp;&amp;amp; (Time.zone.parse(updated_at) != @article.updated_at)&lt;/code&gt;
&lt;/pre&gt;
&lt;p&gt;It looks like @article.updated_at includes microseconds. My
solution is to convert both to strings before evaluating:&lt;/p&gt;
&lt;pre&gt;
&lt;code&gt;if @article.updated_at &amp;amp;&amp;amp; (Time.zone.parse(updated_at).to_s != @article.updated_at.to_s)&lt;/code&gt;
&lt;/pre&gt;
&lt;p&gt;This works but might not be the best solution.&lt;/p&gt;&lt;/div&gt;</original-body-html>
  </ticket>
</tickets>
