Gallery extension problem


#1

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.


#2

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: removed_email_address@domain.invalid
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant


Andrea F.

removed_email_address@domain.invalid
http://bigchieflabs.com/blog/
http://think.bigchief.it


#3

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??


#4

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: removed_email_address@domain.invalid
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant


Andrea F.

removed_email_address@domain.invalid
http://bigchieflabs.com/blog/
http://think.bigchief.it


#5

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


#6

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 ??


#7

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…


#8

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


#9

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: removed_email_address@domain.invalid
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant


Andrea F.

removed_email_address@domain.invalid
http://bigchieflabs.com/blog/
http://think.bigchief.it


#10

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


#11

How are you installing it?

On Sun, Mar 22, 2009 at 3:25 PM, Bryce K. removed_email_address@domain.invalid
wrote:

Post: removed_email_address@domain.invalid
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant

  • Shawn Wilton
  • (503) 881-2707

#12

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.


#13

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. removed_email_address@domain.invalid

  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: removed_email_address@domain.invalid


  • Shawn Wilton
  • (503) 881-2707

#14

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 removed_email_address@domain.invalid


#15

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

2009/3/22 Bryce K. removed_email_address@domain.invalid

2009/3/22 Bryce K. removed_email_address@domain.invalid

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. removed_email_address@domain.invalid

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


  • Shawn Wilton
  • (503) 881-2707

#16

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 removed_email_address@domain.invalid

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