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

ferrangil’s picture

ferrangil commented

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

pvanderspek’s picture

pvanderspek commented

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).

kyberman’s picture

kyberman
Location Czech Rep. 🇨🇿
commented

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.

pvanderspek’s picture

pvanderspek commented

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?

kyberman’s picture

kyberman
Location Czech Rep. 🇨🇿
commented

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.

marcp’s picture

marcp commented

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

vadimk’s picture

vadimk commented

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';
}
marcp’s picture

marcp commented

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.

pvanderspek’s picture

pvanderspek commented

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.

dieuwe’s picture

dieuwe
Location Auckland, NZ
commented
Issue summary: View changes
Status: Active » Closed (outdated)

Closing as the Drupal 6 branch of this module (and Drupal 6 in general) has been discontinued.