Hope you'll pardon my absolute lack of knowledge of SQL and give me a little clue or 2.
I'm retroactively changing the photos layout on a site to Views Gallery, and need to update a couple of image nodes to the Term "gallery".
Could do it manually, I guess, but I'd really love to know this trick.
So I have nid 1,2,3,4, etc. that need to have the gallery tid = '1' (for argument's sake).
Therefore I need to update the 'term_node' table - and INSERT where nid = 1,2,3,4 tid = '1'
I think that makes sense?
Thanks. :)
That was badly phrased at the end. I meant: I think that makes sense, but I can't figure out the syntax.
Any pointers gratefully appreciated.
On 01 Nov 2011, at 5:33 PM, Jeff Brown wrote:
Hope you'll pardon my absolute lack of knowledge of SQL and give me a little clue or 2.
I'm retroactively changing the photos layout on a site to Views Gallery, and need to update a couple of image nodes to the Term "gallery".
Could do it manually, I guess, but I'd really love to know this trick.
So I have nid 1,2,3,4, etc. that need to have the gallery tid = '1' (for argument's sake).
Therefore I need to update the 'term_node' table - and INSERT where nid = 1,2,3,4 tid = '1'
I think that makes sense?
Thanks. :)
[ Drupal support list | http://lists.drupal.org/ ]
If you must do it manually, you are safer doing separate INSERT statements.
But, since you say you are unfamiliar with the Drupal database, I strongly recommend doing it through the Drupal user interface to avoid damaging your database.
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Jeff Brown jeff@wildcoast.com To: support@drupal.org Sent: Tuesday, November 1, 2011 11:33 AM Subject: [support] MySQL noob: Update images to gallery tid
Hope you'll pardon my absolute lack of knowledge of SQL and give me a little clue or 2.
I'm retroactively changing the photos layout on a site to Views Gallery, and need to update a couple of image nodes to the Term "gallery".
Could do it manually, I guess, but I'd really love to know this trick.
So I have nid 1,2,3,4, etc. that need to have the gallery tid = '1' (for argument's sake).
Therefore I need to update the 'term_node' table - and INSERT where nid = 1,2,3,4 tid = '1'
I think that makes sense?
Thanks. :)
[ Drupal support list | http://lists.drupal.org/ ]
Aw, c'mon Nancy, I always backup before doing anything. And I'm only toying around on a 'test' copy on the server, anyway.
I'm a sysadmin and reluctant web designer. Not a programmer or php/ mysql guru. I think I understand separate INSERT statements. But there are so many doors I could unlock with this magic key....
JK. But it would be useful. And none of the basic tutorials seem to cover this.
Besides, you have no idea how slow and flaky (not to mention expensive) my internet connection is. It will take me at least 2 hours to do them individually through Drupal. An hour, probably, if I do each INSERT manually. And 10 minutes if I can batch them.
My ignorance notwithstanding: is there actually a problem with just mass updating the term_node table? I can't see that any other tables relate to that directly?
On 01 Nov 2011, at 7:16 PM, Ms. Nancy Wichmann wrote:
If you must do it manually, you are safer doing separate INSERT statements.
But, since you say you are unfamiliar with the Drupal database, I strongly recommend doing it through the Drupal user interface to avoid damaging your database.
Nancy
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Jeff Brown jeff@wildcoast.com To: support@drupal.org Sent: Tuesday, November 1, 2011 11:33 AM Subject: [support] MySQL noob: Update images to gallery tid
Hope you'll pardon my absolute lack of knowledge of SQL and give me a little clue or 2.
I'm retroactively changing the photos layout on a site to Views Gallery, and need to update a couple of image nodes to the Term "gallery".
Could do it manually, I guess, but I'd really love to know this trick.
So I have nid 1,2,3,4, etc. that need to have the gallery tid = '1' (for argument's sake).
Therefore I need to update the 'term_node' table - and INSERT where nid = 1,2,3,4 tid = '1'
I think that makes sense?
Thanks. :)
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Jeff Brown
Tel:+27-74-101 5170 Fax:+27-86-532 3508 www.wildcoast.co.za
-
Fred Jones -
Jeff Brown -
Ms. Nancy Wichmann