[Plugin: NextGEN Gallery] wp_ngg_tags and wp_ngg_pic2tags missing/moved after upgrade
-
Hi all,
Hope someone can point me in the right direction here searching hasn’t located anything and bare with me as I’m not a db guru by any means
Just upgraded NextGen to 1.02. Installed files Ok and was able to run the db upgrade successfully (based on wp-admin saying so).
I had a search feature which looked at the wp_ngg_pic2tags and wp_nggtags tables (as well as the other tables) but both tables are missing following upgrade.
I assume they have been integrated somewhere else as the tags are showing with I look at the pics in “Manage Gallery” and they also show under the tags link.
I have a backup if I need to reload the tables.
Can anyone advise?
Cheers,
Aengus
P.S. this was my query (allow for slight change caused by posting)
$nngquery = “
SELECT pid,description,alttext
FROM wp_ngg_pictures
WHERE MATCH (description, filename, alttext) AGAINST (‘*$keywords*’ IN BOOLEAN MODE)
AND exclude = ‘0’
UNION
SELECT pid,description,alttext
FROM wp_ngg_pictures, wp_ngg_tags, wp_ngg_pic2tags
WHERE pid = picid and tagid = id and
MATCH (name) AGAINST (‘*$keywords*’ IN BOOLEAN MODE)
AND exclude = ‘0’
- The topic ‘[Plugin: NextGEN Gallery] wp_ngg_tags and wp_ngg_pic2tags missing/moved after upgrade’ is closed to new replies.