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,
Comments
Comment #1
nrauni commentedIt's the patch to fix.. it's my first path :)
Comment #2
jeremy commentedThe Ad Bard network has changed, and this module is no longer useful. A new version will be released at a future date.