Guys,

I'm using the Drupal 6.10, Ab version 6.x-2.0-beta4 2009-Mar-27

When I click on a banner link it open a new window and access the page normally.
but when i go back to my website and access a next page i got the error message below

user warning: Unknown column 'extra' in 'field list' query: INSERT INTO ad_clicks (aid, uid, status, hostname, user_agent, adgroup, extra, hostid, url, timestamp) VALUES (66, 1, 0, '200.103.134.213', 'Mozilla/5.0 (X11; U; Linux x86_64; pt-BR; rv:1.9.0.7) Gecko/2009030423 Ubuntu/8.10 (intrepid) Firefox/3.0.7', '0', '', '', 'http://bauma.com.br/bauma/', 1238386775) in /var/www/vhosts/teste.com.br/httpdocs/teste/sites/all/modules/ad/ad.module on line 248.

I tried use the version 6.x-2.x-dev but i have the same problem..

UPDATE:

creating this issue i investigated a little and i found the problem..

the column extra isn't mapped in ad_schema, i found the update function into module

/**
 * Introduce "extra" field for ad statistics and clicks, optionally allowing
 * add-on modules to provide additional granularity.
 */
function ad_update_6004() {

and then i need to access the update.php script and selected the 6004.

The following queries were executed
ad module
Update #6004

    * ALTER TABLE {ad_statistics} ADD `extra` VARCHAR(255) NOT NULL DEFAULT '', ADD INDEX extra (extra)
    * ALTER TABLE {ad_clicks} ADD `extra` VARCHAR(255) NOT NULL DEFAULT '', ADD INDEX extra (extra)

Update #6005

    * No queries

now it worked fine.

I think that the db_schema must be updated..

Thanks for all,

CommentFileSizeAuthor
#1 update_ad_schema.txt1.36 KBnrauni

Comments

nrauni’s picture

StatusFileSize
new1.36 KB

It's the patch to fix.. it's my first path :)

jeremy’s picture

Status: Active » Fixed

The Ad Bard network has changed, and this module is no longer useful. A new version will be released at a future date.

Status: Fixed » Closed (fixed)

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