Hi there

i picked up the following error upgrading to NG3.

user warning: Table '****_***.node_gallery_relationships' doesn't exist query: SELECT rid, gallery_type, image_type, imagefield_name, settings from node_gallery_relationships in /home/****/public_html/sites/all/modules/node_gallery/node_gallery.inc on line 116.

I went through the usual procedure as outlined in upgrading modules. All related modules are up to date. When calling the update.php script it fails with an error message related to Lightbox2-directory has been removed with upgrade to NG3.

Anybody experienced the same?

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

fluxrider’s picture

You might have deactivated the module when we all got that security alert. If you did turn it off you lose the relationships in the default when you first set it up. Just add the relationship back and all should be good.

Anonymous’s picture

Hi there

Thank you for your support. The module is still active. If I revert back to NG2 the relationship appears to be intact. It is only when upgrading that it breaks. I am also unable to create a new relationship with upgrade.

Your help would be much appreciated.

fluxrider’s picture

Hi Porker. My steps were this - Resaved the default ng2 relationship and took note of the settings. Took note of all the imagecache settings ( i had custom ng sizes in there as well as the defaults ) The upgrade to ng3 removes the default sizes from imagecache and puts in new ones and creates the content types.
In NG2 the relationship was a two part thingy where you had to establish the relationship and save before you could get to the settings. In ng3 you can change the settings without going through the relationship.
When you go to admin/settings/node_gallery What do you see ?
If nothing then add the relationship.

scroogie’s picture

Hi porker,

the error is indeed the database upgrade. Without it, there will be a database table missing, and the module won't work. Can you please post the error message you get from the database upgrade?

Anonymous’s picture

hi Scroogie/ thank you Fluxrider

Since my last post, I realised when running update.php the error message was related to the Lightbox2 integration submodule in NG2, which is defunct in NG3. I had not removed this directory from the Node Gallery module before upgrading. Once removed the update worked. Issues here, many URL aliases were scrapped, styling went up the swanny and the node gallery views needed reworking to bring the site back to where I had it before.

Previously I wrapped DIV tags into the Node gallery theme templates, but I am having to work around this as I can't locate the right templates to modify or the template is empty.

Site is just about back again.

Thanks for your support.

porcupine73’s picture

I encountered this error when upgrading from NG 2.x to 3. I did initially have that same rogue lightbox2 directory/submodule in place, so I removed it. I also upgraded filefield at the same time.

All the nodes and relationships for my photos were in place, but it would not display any photos. It took me a solid 12 hours to fix that. It looks like until I edited and saved each node gallery relationship, it would not create the new table for the filefield for that content type.

Then, looking back at my database from prior to the upgrade, I noticed that the nodge_galleries table had been conveniently dropped, but without transitioning the rows into the filefield and other node gallery tables. Even putting the node_galleries table back in and trying to rerun the updates would not get the gid, nid, vid, fid values into the tables.

Finally I had to take my node_galleries data into Excel, and craft three queries for each row to insert gid, nid, vid, fid into the tables that it looked like needed those values. Then after doing those inserts and clearing my caches again it finally worked, phew, that made me nervous that I had lost all my images. But she is rolling like a big wheel now thanks!

Then I noticed for anonymous users, the images were still not appearing. So I noticed the newly create filefields did not have view permission for anonymous users. After adding that then it was good.

neilo_’s picture

Hi Guys,

I'm having the same error message when I run update.php.

My database update error reads:

The following queries were executed
node_gallery module
Update #6300

Failed: Node Gallery Lightbox2 module directory was found, and it has been removed with the release of Node Gallery version 3.

My admin user error reads:

user warning: Table 'drupal6.node_gallery_relationships' doesn't exist query: SELECT rid, gallery_type, image_type, imagefield_name, settings from node_gallery_relationships in /var/www/vhosts/xxxxxx.com/httpdocs/sites/all/modules/node_gallery/node_gallery.inc on line 116.

Can any help here how to fix this error step by step?

Thanks.

zengenuity’s picture

Status: Active » Closed (won't fix)

Issue queue cleanup. No more changes to 6.x.