Was setting up a new site on my development platform within Drupal 5.x, and experimenting with different configurations. For a short time, the OG module was installed, as was the Avatar Selection module. Realized OG was not going to work well on this particular site, so it was removed. In doing the final clean up of things prior to deployment, I had noticed a table called 'avatar_selection_og' in the database and removed it during housekeeping. Now, on entering the 'Manage Avatars' section of Avatar Selection, I get the following warning:

user warning: Table '(database name).avatar_selection_og' doesn't exist query: SELECT avso.ogid, count(*) AS count FROM avatar_selection avs LEFT JOIN avatar_selection_og avso ON avs.aid = avso.aid GROUP BY avso.ogid in (path for install)/includes/database.mysql.inc on line 174.

Reporting this as a bug, as I would have thought this should have been deleted when OG was uninstalled, or when I ran an update on the database itself. Would also like to know how I can get rid of this warning!

Comments

stella’s picture

stella commented
Category: bug » support
Status: Active » Fixed

You need to add the table back in. The table should only be removed when the avatar selection module is removed and not before.

As a rule, it's a bad idea to modify the database directly.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.