Hi all,

On my site I'm using version 5.x-1.3-2 of the ad module, and it seems that one of my image ad got stuck (I can't unpublish it). Everytime I go to the edit page for the ad I get a page not found error. All my other ads are working properly. My question is how would I go about deleting the particular ad manually from the database?

Cheers,
sno

Comments

jeremy’s picture

jeremy commented
Status: Active » Postponed (maintainer needs more info)

How did you get into tihs state? It is an unfortunate condition, and the only way I can imagine you got there is by deleting a node directly in the database without going through Drupal's API's. The best way to solve this problem would be to add the node back in the node table, and then to delete it through a standard Drupal administrative interface, as this will call all the appropriate delete hooks.

Alternatively, you could attempt to clean things up manually by looking in all the ad* tables and deleting any rows with an aid equal to the nid in question. However, I repeat that this is not recommended and if done wrong could cause you more problems. Take a database backup before your try this.

jeremy’s picture

jeremy commented
Status: Postponed (maintainer needs more info) » Fixed

No further updates after a month, I'll assume you've tracked this down. Re-open and provide feedback to my questions if you need further assistance.

Anonymous’s picture

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

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