Ad Groups Not Showing

On the admin/content/ad page, there is a "Groups" link, leading to admin/content/ad/groups, where you can Create a Group.

HTH
Terry

The vocabulary used by the ad module is specified in the variable table as 'ad_group_vid'. To manually see which vocabulary is being used, you could execute the following directly in MySQL:

  mysql> SELECT * FROM variable WHERE name = 'ad_group_vid';

(It will return the serialized variable, something like "i:4;")

You could then go to "Administer >> Content management >> Categories" and verify that there is an "Ad groups" category of type "Advertisement" with the correct vocabulary ID. However, if this was a problem a complete uninstall and reinstall should have cleaned this up for you.

Edit the "Ad groups" vocabulary and verify that "Types: ad group" is checked. It should be both checked and grayed out.

No further updates, I'm guessing you've solved your issue. Closing.

I had a variant of the previously posted problem. The ad groups weren't showing up. After endless experimentation of installing older and newer versions and deleting the Ad groups taxonomy and re-creating it, I managed to get it showing up again when creating and adding an ad. However, a problem remains.

I have 2 ad group categories: featured and secondary. The block "All active secondary group ads" works fine and shows the ad marked secondary. The block "ad group: secondary" does not.

Also, the previously posted instructions say "Edit the "Ad groups" vocabulary and verify that "Types: ad group" is checked. It should be both checked and grayed out."

My "Ad groups" vocabulary is set to Type "Advertisement" and is not grayed out.

It sounds like your ad module installation is broken. It also sounds like you've done quite a bit of tweaking, which is probably how this happened. My suggestion is to completely uninstall all ad modules, and then reinstall them. (Go to admin > modules, disable all modules, then go to the uninstall and actually uninstall them all, too).

This will of course drop all of your ad tables. More importantly, it will flush all the various configurations, one or more of which has evidently gotten messed up. Then, when you re-install, things will likely work.

I have what looks like the same issue. It seems to have shown up after an upgrade to 5.3 of drupal.

I've check the vocab table and everything seems to be hooked up correctly. I've got stuff listed under Ad > Groups, I just don't have anything under "Ad Groups" when I create/edit an ad.

I've done a uninstall and reinstall of the ad modules, but the issue is the same.

So right now I can edit old ads in the same groups, but can not create new ads because I can't put them into groups as there is no admin interface exposed for that.

And debug or help would be appreciated.

I got this running again in a test environment by doing a manual uninstall (drop tables, deleted node). The uninstall for the modules were giving the white screen of death. So far this seems to correct it, but it is a real pain to go back and create all the ads.

I have not done the work to correct this on our live site, so if anyone needs information to see what is going wrong I can still dump information.

Just me talking to myself...

My issue was 'vocabulary_node_types' table had some how removed the "ad" type from the database. I could not see this from the drupal admin interface and I have no idea why that time was removed, but after adding the row everything is now perfect.

Thanks for posting the resolution to your problem rinvelt. I will add a sanity check for this into the code, so the ad module can tell people when their installation is broken in this way, and perhaps auto-fix it.

Assigning to myself as there's a bug here that needs to be fixed before the next release.

Hi, I have a similar problem.

I installed the ad module and it was working great. It was one of the first modules I installed in my site. I had 3 ad groups and 3 banners working. one for each group. But then I started to add some content, installed some other modules and I didn't realize something was wrong with the ad module till I didn't see my ads anymore.

Does anyone knows of any known issues with any of this modules:

Content Access
CCK
- Youtube CCK
- View Field
- Image

Categories
Image
Imagecache
My Site
Custom Pagers
Date API
Panels
Thickbox
Webform
Jquery Interface Library
Jquery Update
Views
- Views Bonus
Fivestar
Voting API

I guess one of those modules is causing the problem. but if not it might be this.

I was using the category module and then I did this: Administer > Categories > Settings > Install taxonomy wrapper and enable the option Maintain category data in taxonomy tables. After I did this somehow the link to Taxonomy in Administer dissapeared.

I remove the ad module manually, i'm droping the tables, but when I reinstall the module, I get this:

* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 10 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 8 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 9 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 17 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 14 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 10 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 8 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 9 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 17 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'panguadalu_portal.ads' doesn't exist query: SELECT * FROM ads WHERE aid = 14 in /home/panguadalu/domains/panguadalupe.org.mx/public_html/includes/database.mysql.inc on line 172.

I need some help with this. What did I go wrong?

Thanks..

I solved the error when reinstalling the module by copy the ad tables from a new and empty drupal site.

But when I go to create new groups I get this:

Created new ad group Banner1.

But I also get No groups have been created.

As noted in the documentation, the ad module requires the core taxonomy module. It will not work with the category module, not even with the compatibility layer enabled.

Thanks for the reply. I can tell you that it's possible to have the ad module and the categories module working on the same site, but not together, I know this because I have a site with categories and ads. Give me some time and I will post here how to do it, the problem is caused by the categories module.

The original issue was caused by reinstalling the ad module, causing the vocabulary vid to change. However, the ad module was caching the old vid in the variables table. I've added simple logic to detect this error and auto-fix.

Fix committed to development tree.