I'm not really getting this, but is there no upgrade from nodeorder 6 to 7. When I install version 7 there is no updates on running the update script on the database?

term_node table no longer exists in Drupal 7 which instead use taxonomy_index. So how do I get my existing node ordering into taxonomy_index table. Is this a manual job?

my error is: DOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'weight' in 'field list': SELECT weight, nid FROM {taxonomy_index} WHERE nid IN(:nids_0); Array ( [:nids_0] => 1509 ) in nodeorder_node_load() (line 767 of /sites/all/modules/nodeorder/nodeorder.module)

CommentFileSizeAuthor
#2 nodeorder-upgrade_path-1831172-2.patch3.32 KBgrahamC
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

bib_boy’s picture

bib_boy CreditAttribution: bib_boy commented
Category: support » bug
grahamC’s picture

grahamC
Location Oxford, UK
CreditAttribution: grahamC commented
FileSize
nodeorder-upgrade_path-1831172-2.patch3.32 KB

I ran into this too. Attached is a patch which works for me.

Bear in mind that taxonomy's updates will have completely hosed nodeorder's data on an already upgraded site, so this needs to be in place during the initial site upgrade.

(The site I'm dealing with has a ridiculously small number of nodes, so I've probably cut corners by not making it into a proper batch process or anything.)

halloffame’s picture

halloffame CreditAttribution: halloffame commented

Patch itself worked but got this

Unable to preserve existing orderings. Update nodeorder at the same time as taxonomy module to allow this!

Too late to go back.

grahamC’s picture

grahamC
Location Oxford, UK
CreditAttribution: grahamC commented

@halloffame: Well, one could probably adapt it to export the weights from a D6 database and import them the same way...

That said, I still consider the nodeorder module unusably broken on D7 at the moment because of #1780576: Saving nodes resets nodeorder