I did a new installation with version 2.1. It seems that the Harvest function does not work if the Gallery module has not been installed:

Error message:

MySQL ERROR:

Error Number: 1146

Description: Table ‘innonetc_xngc.exp_galleries’ doesn’t exist

Query: SELECT gallery_id, gallery_full_name FROM exp_galleries ORDER BY gallery_full_name ASC

After installing the gallery module (even if not needed), the Harvest function works well.

Misc,

This is a known issue, and was an oversight on our part.
It will be corrected shortly though.

Thank you for bringing this to our attention though!

This has been corrected in the latest version of Tag
http://www.solspace.com/software/detail/tag/

I’m using Tag 2.6.0 (build 20081119) on ExpressionEngine 1.6.6 (build 20081114) and still receive this error when clicking on Recount Stats:

MySQL ERROR:

Error Number: 1146

Description: Table ‘tablename.exp_gallery_entries’ doesn’t exist

Query: DELETE te FROM exp_tag_entries AS te LEFT JOIN exp_gallery_entries AS ge ON te.entry_id = ge.entry_id WHERE te.type = ‘gallery’ AND ge.entry_id IS NULL

The Photo Gallery module is not installed when I get this message, but if I temporarily install the Photo Gallery module (and re-run Recount Stats) the error goes away — this leads me to believe that there is a bug that shows this message if the Photo Gallery database table doesn’t exist.

Ryan,

Make sure you upgrade to the latest build

http://www.solspace.com/forums/viewthread/661/#8464

Pie Man - 27 November 2008 10:51 AM

Make sure you upgrade to the latest build ;)

Nice work — it’s incredible what a one-day difference in builds can do! Problem solved, thanks!