Gallery extension problem

I use Gallery extension 0.2 on radiant 0.6.1 (gem). Uploading and
viewing pictures are OK, but only in CMS. I have problems with
displaying my gallery. I have only one gallery with uploadad images.
Problems is in this part of code:

      <r:gallery:if_index>
      <ul>
        <r:galleries:each>
        <li><r:link /></li>
        </r:galleries:each>
      </ul>
     </r:gallery:if_index>

On the page i got error:

PGError: ERROR: argument of WHERE must be type boolean, not type integer
: SELECT * FROM galleries WHERE (1).

I don’t know why… I ask for help.

I can’t work now, but I’ll try asap with radiant 0.6.1…
If you want try the latest version (0.3.2)

http://darcs.bigchieflabs.com/radiant/extensions/gallery/

…and let me know if it works…thank you!!

Il giorno 10/mag/07, alle ore 22:47, Artur B. ha scritto:

      </ul>


Posted via http://www.ruby-forum.com/.


Radiant mailing list
Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant


Andrea F.

[email protected]
http://bigchieflabs.com/blog/
http://think.bigchief.it

Andrea F. wrote:

I can’t work now, but I’ll try asap with radiant 0.6.1…
If you want try the latest version (0.3.2)

http://darcs.bigchieflabs.com/radiant/extensions/gallery/

…and let me know if it works…thank you!!

OK. How can I remove the existing gallery??

The best way is to drop galleries and gallery_items table and the
public/galleries folder…then you can re-install the extension…let
me know…tnx again :wink:

Il giorno 11/mag/07, alle ore 13:30, Artur B. ha scritto:


Posted via http://www.ruby-forum.com/.


Radiant mailing list
Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant


Andrea F.

[email protected]
http://bigchieflabs.com/blog/
http://think.bigchief.it

Now i have “undefined tag `gallery’” message on the top of my site…

It was 0.3.2 released :). I removed the tables and folder and everything
looks fine without one thing. On my site (even if I use “Vies Site”
button) i received an error:

PGError: ERROR: relation “galleries” does not exist : SELECT a.attname,
format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM
pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND
a.attnum = d.adnum WHERE a.attrelid = ‘galleries’::regclass AND a.attnum

0 AND NOT a.attisdropped ORDER BY a.attnum

It appeared on the top of my site. Any suggestions ??

My conclusion about this topic is:

I have Radiant 0.6.1 and had installed 0.3.2 gallery extension and
gallery didn’t work, so I remove the extension in that way: dropped
tables: galleries and gallery_items and then removed the gallery folder
from /vendor/extensions folder. I logged into Radiant CMS and saw that
there is no gallery extensions. The website also had any bugs. So tried
the old one version of gallery extension 0.2.0. So i copied the gallery
folder into /vendor/extensions and made
“rake radiant:extensions:gallery:install”. I logged into Radiant and saw
that in Extensions tab is “Gallery extension”. So i went to “Galleries”
and received error:
Application error (Apache)

Change this error message for exceptions thrown outside of an action
(like in Dispatcher setups or broken Ruby code) in public/500.html

IN production log i got error:

ActiveRecord::StatementInvalid (PGError: ERROR: relation “galleries”
does not exist
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = ‘galleries’::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
):

So i assume that there is no tables in database “galleries” and
“galleries_item”. But i did the “rake”. What is wrong?? What should i do
?? It’s important for me…

Yeah! I made the tables: galleries and galleries_items with appopriate
fields … and works :).

Il giorno 11/mag/07, alle ore 23:33, Artur B. ha scritto:

Yeah! I made the tables: galleries and galleries_items with appopriate
fields … and works :).

Good! I can’t understand why they don’t exist after this command:

rake radiant:extensions:gallery:install

did you use it?


Posted via http://www.ruby-forum.com/.


Radiant mailing list
Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant


Andrea F.

[email protected]
http://bigchieflabs.com/blog/
http://think.bigchief.it

Yes i did it… But there wasn’t created…

How are you installing it?

On Sun, Mar 22, 2009 at 3:25 PM, Bryce K. [email protected]
wrote:

Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant

  • Shawn Wilton
  • (503) 881-2707

Here is what I’m doing.

First up I get the attachement_fu plugin.

git clone
git://github.com/technoweenie/attachment_fu.gitvendor/plugins/attachment_fu

Next I get the gallery plugin and install.

  1. git clone
    git://github.com/pilu/radiant-gallery.gitvendor/extensions/gallery
  2. rake radiant:extensions:gallery:install

(output of the rake command)

bryce@12-pack:~/apps/mymadlab$ rake radiant:extensions:gallery:install
(in /home/bryce/apps/mymadlab)
mkdir -p /home/bryce/apps/mymadlab/config/extensions/gallery
Copying /public/images/extensions/gallery/lightbox/loading.gif…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/loading.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/loading.gif
Copying /public/images/extensions/gallery/lightbox/donate-button.gif…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/donate-button.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/donate-button.gif
Copying /public/images/extensions/gallery/lightbox/closelabel.gif…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/closelabel.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/closelabel.gif
Copying /public/images/extensions/gallery/lightbox/bullet.gif…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/bullet.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/bullet.gif
Copying /public/images/extensions/gallery/lightbox/close.gif…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/close.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/close.gif
Copying /public/images/extensions/gallery/lightbox/thumb-1.jpg…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/thumb-1.jpg
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/thumb-1.jpg
Copying /public/images/extensions/gallery/lightbox/download-icon.gif…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/download-icon.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/download-icon.gif
Copying /public/images/extensions/gallery/lightbox/prevlabel.gif…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/prevlabel.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/prevlabel.gif
Copying /public/images/extensions/gallery/lightbox/nextlabel.gif…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/nextlabel.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/nextlabel.gif
Copying /public/images/extensions/gallery/lightbox/image-1.jpg…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/image-1.jpg
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/image-1.jpg
Copying /public/images/extensions/gallery/admin/edit.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/edit.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/edit.png
Copying /public/images/extensions/gallery/admin/show.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/show.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/show.png
Copying /public/images/extensions/gallery/admin/gallery.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/gallery.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/gallery.png
Copying /public/images/extensions/gallery/admin/new-gallery.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/new-gallery.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/new-gallery.png
Copying /public/images/extensions/gallery/admin/edit-image.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/edit-image.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/edit-image.png
Copying /public/images/extensions/gallery/admin/destroy.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/destroy.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/destroy.png
Copying /public/images/extensions/gallery/admin/reorder-children.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/reorder-children.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/reorder-children.png
Copying /public/images/extensions/gallery/admin/file.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/file.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/file.png
Copying /public/images/extensions/gallery/admin/reorder.png…
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/reorder.png
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin/reorder.png
Copying /public/stylesheets/extensions/gallery/lightbox.css…
mkdir -p /home/bryce/apps/mymadlab/public/stylesheets/extensions/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/stylesheets/extensions/gallery/lightbox.css
/home/bryce/apps/mymadlab/public/stylesheets/extensions/gallery/lightbox.css
Copying
/public/stylesheets/extensions/gallery/admin/images/pictures_zoom_big.png…
mkdir -p
/home/bryce/apps/mymadlab/public/stylesheets/extensions/gallery/admin/images
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/stylesheets/extensions/gallery/admin/images/pictures_zoom_big.png
/home/bryce/apps/mymadlab/public/stylesheets/extensions/gallery/admin/images/pictures_zoom_big.png
Copying
/public/stylesheets/extensions/gallery/admin/images/pictures_zoom_small.png…
mkdir -p
/home/bryce/apps/mymadlab/public/stylesheets/extensions/gallery/admin/images
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/stylesheets/extensions/gallery/admin/images/pictures_zoom_small.png
/home/bryce/apps/mymadlab/public/stylesheets/extensions/gallery/admin/images/pictures_zoom_small.png
Copying /public/stylesheets/extensions/gallery/admin/gallery.css…
mkdir -p
/home/bryce/apps/mymadlab/public/stylesheets/extensions/gallery/admin
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/stylesheets/extensions/gallery/admin/gallery.css
/home/bryce/apps/mymadlab/public/stylesheets/extensions/gallery/admin/gallery.css
Copying /public/javascripts/extensions/gallery/slider.js…
mkdir -p /home/bryce/apps/mymadlab/public/javascripts/extensions/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/slider.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/slider.js
Copying /public/javascripts/extensions/gallery/lite_sortable.js…
mkdir -p /home/bryce/apps/mymadlab/public/javascripts/extensions/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/lite_sortable.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/lite_sortable.js
Copying /public/javascripts/extensions/gallery/builder.js…
mkdir -p /home/bryce/apps/mymadlab/public/javascripts/extensions/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/builder.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/builder.js
Copying /public/javascripts/extensions/gallery/lightbox.js…
mkdir -p /home/bryce/apps/mymadlab/public/javascripts/extensions/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/lightbox.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/lightbox.js
Copying /public/javascripts/extensions/gallery/gallery/zoom_slider.js…
mkdir -p
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/gallery/zoom_slider.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery/zoom_slider.js
Copying /public/javascripts/extensions/gallery/gallery/panel.js…
mkdir -p
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/gallery/panel.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery/panel.js
Copying /public/javascripts/extensions/gallery/gallery/edit_form.js…
mkdir -p
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/gallery/edit_form.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery/edit_form.js
Copying /public/javascripts/extensions/gallery/gallery/utils.js…
mkdir -p
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/gallery/utils.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery/utils.js
Copying /public/javascripts/extensions/gallery/gallery/tree.js…
mkdir -p
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery
cp
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/javascripts/extensions/gallery/gallery/tree.js
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery/tree.js
Select which layout to create (leave blank to skip):

  1. Simple
  2. Simple carbon with lightbox
  3. Simple with lightbox
  4. Simple carbon
    [1-4] values separated by commas: 1,2,3,4
    Importing layout ‘Simple’…OK
    Importing layout ‘Simple carbon with lightbox’…OK
    Importing layout ‘Simple with lightbox’…OK
    Importing layout ‘Simple carbon’…OK
    Gallery extension has been installed.
  5. Create a new page with ‘Gallery’ as page type.
  6. Select a gallery layout for your page.
  7. Start creating your galleries.

And thats pretty much it.

And after doing that and restarting the server you still don’t see the
gallery layout in the admin panel?

2009/3/22 Bryce K. [email protected]

  1. rake radiant:extensions:gallery:install

/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/donate-button.gif
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/close.gif
Copying /public/images/extensions/gallery/lightbox/download-icon.gif…
cp

mkdir -p /home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
Copying /public/images/extensions/gallery/admin/gallery.png…
/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/new-gallery.png
mkdir -p /home/bryce/apps/mymadlab/public/images/extensions/gallery/admin

Copying
Copying
Copying /public/stylesheets/extensions/gallery/admin/gallery.css…

mkdir -p /home/bryce/apps/mymadlab/public/javascripts/extensions/gallery
Copying /public/javascripts/extensions/gallery/gallery/zoom_slider.js…
cp

mkdir -p
4. Simple carbon
And thats pretty much it.
whenever

Post: [email protected]


  • Shawn Wilton
  • (503) 881-2707

Actually I have a much bigger problem than that. I can not access
anything
underneath my public folder. If I remove the gallery extension it all
starts working again.

2009/3/22 Shaolo [email protected]

I’ve had to remove and then reinstall several extension because one
would
not install properly.

2009/3/22 Bryce K. [email protected]

2009/3/22 Bryce K. [email protected]

github.com/pilu/radiant-gallery.gitvendor/extensions/gallery
cp
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
mkdir -p
Copying /public/images/extensions/gallery/lightbox/bullet.gif…
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/bullet.gif

/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/prevlabel.gif

cp
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
mkdir -p
Copying

/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/stylesheets/extensions/gallery/admin/images/pictures_zoom_small.png

cp
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery
mkdir -p
Copying /public/javascripts/extensions/gallery/gallery/tree.js…
/home/bryce/apps/mymadlab/public/javascripts/extensions/gallery/gallery/tree.js
Gallery extension has been installed.

On Sun, Mar 22, 2009 at 3:25 PM, Bryce K. [email protected]

Any ideas as to why this is happening would be great.


  • Shawn Wilton
  • (503) 881-2707

Check your log files. They will usually tell you what you are missing.
I have noticed that if an extension fails to run properly, it usually
takes
down the entire system.

log/production.log or log/development.log depending on which system you
are
trying to run.

2009/3/22 Shaolo [email protected]

First up I get the attachement_fu plugin.

cp
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox
mkdir -p
Copying /public/images/extensions/gallery/lightbox/thumb-1.jpg…
/home/bryce/apps/mymadlab/public/images/extensions/gallery/lightbox/thumb-1.jpg

/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/lightbox/nextlabel.gif

/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/images/extensions/gallery/admin/gallery.png

/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin

mkdir -p
/home/bryce/apps/mymadlab/public/images/extensions/gallery/admin
mkdir -p
Copying

/home/bryce/apps/mymadlab/vendor/extensions/gallery/public/stylesheets/extensions/gallery/admin/images/pictures_zoom_small.png

cp

Copying /public/javascripts/extensions/gallery/gallery/edit_form.js…

[1-4] values separated by commas: 1,2,3,4

whenever

Radiant mailing list

  • Shawn Wilton
  • (503) 881-2707

  • Shawn Wilton
  • (503) 881-2707