Pictures in galleries aren't ordered [#438492]

Hi, I have installed this module, I set the vocabulary Gallery "Orderable" and after save, I got this warning for many times:

user warning: Access denied for user 'someuser'@'%' to database 'somedatabase' query: LOCK TABLES drupal_term_node WRITE in /httpd/html/somesite/www/includes/database.mysqli.inc on line 330.

After this, I tried to order the nodes (pictures) in this taxonomy and it was saved correctly. But in the gallery, there is still the old order (the newest first). Where I did the mistake?

Comments

Comment #1

ferrangil CreditAttribution: ferrangil commented 22 April 2009 at 01:13

Did you changed the Sort Order into the Views? It might be there... the nodes get a new order but you need to tell the view that you want to use that order and no the default.
Just guessing...

Comment #2

pvanderspek CreditAttribution: pvanderspek commented 22 April 2009 at 11:57

As ferrangil also pointed out: if you use views you should use the weight_in_tid as a sort value. By default taxonomy/term/ shows the default ordering as provided by taxonomy. The ordered list of nodes can be accessed via nodeorder/term/ (so by replacing taxonomy with nodeorder).

Comment #3

kyberman

Czech Rep. 🇨🇿

CreditAttribution: kyberman commented 22 April 2009 at 13:09

I'm not using Views, but I used Image module. Do you know where (maybe in the code) I must change the standard values by the weight_in_tid values? Or I have to use Views? What I don't understand is where I can replace taxonomy/term/ with nodeorder/term. Thank you deeply.

Comment #4

pvanderspek CreditAttribution: pvanderspek commented 22 April 2009 at 18:36

Well the URL to a taxonomy-page usually looks like this: http://www.yourdomain.com/taxonomy/term/12 (number varies). To get the ordered version you have to change the URL to this: http://www.yourdomain.com/nodeorder/term/12
By the way, the LOCK TABLES error your getting seems to indicate that the username you're using to access the database isn't allowed to LOCK tables. Maybe you could check this as well?

Comment #5

kyberman

Czech Rep. 🇨🇿

CreditAttribution: kyberman commented 22 April 2009 at 19:28

It's more complicated as it looks. When I use the url /nodeorder/term/12, the order is OK, but the pictures are shown with the author, name of the gallery, etc. They are in the list "picture under picture". But I want to show it as normal gallery. For example the url /galleries/my-first-gallery. But as I see, I will need to edit some code of the gallery module. Maybe, it needs to change source of the gallery from /taxonomy/... to /nodeorder/... Have anybody any idea? Thank you.

Comment #6

marcp CreditAttribution: marcp commented 22 April 2009 at 20:26

Take a look at #117587: Image Gallery with Nodeorder, Next|Prev links, multi taxonomy terms OK! to see if it gives you some inspiration.

Comment #7

vadimk CreditAttribution: vadimk commented 19 March 2010 at 06:07

Try adding this code in nodeorder.module

/**
 * Implementation of hook_menu_alter().
 */
function nodeorder_menu_alter(&$items) {	
  $items['taxonomy/term/%']['page callback'] = 'nodeorder_term_page';
}

Comment #8

marcp CreditAttribution: marcp commented 26 March 2010 at 23:44

Pieter - should we be taking over the display of taxonomy/term/% when the tid is in an orderable vocabulary? Seems like a good idea, but I haven't looked at the code lately.

Comment #9

pvanderspek CreditAttribution: pvanderspek commented 29 March 2010 at 17:45

No, I don't agree. It is already possible to create direct links to the nodeorder-page and it should also be possible to configure the desired behavior via the admin-pages in the latest stable version. Just doing it always prevents users from using ordered and unordered pages in the same website.