I keep getting this message in the log whenever I try to go to the adsense clicks section

Table 'bazardsn_drupal.adsense_clicks' doesn't exist query: INSERT INTO adsense_clicks (ip,timestamp) values('12.219.94.121', 1152378785) in /home/bazardsn/public_html/includes/database.mysql.inc on line 120.

Comments

kbahey’s picture

kbahey commented
Status: Active » Closed (fixed)

You must have not copied all the files in the directory, and just the adsense.module.

Try executing this SQL in PHPMyAdmin:

CREATE TABLE adsense_clicks (
aid int(10) NOT NULL auto_increment,
ip varchar(15) default '0',
timestamp int(11) unsigned NOT NULL default '0',
PRIMARY KEY (aid),
KEY (timestamp)
);

That should create the table for you.

alpinejag’s picture

alpinejag commented

Thanks, I thought I copied everything the zip file, guess I missed something. Seems to be working fine now, it's not spitting out anymore errors at least. I let you know if I have any more problems. Thanks for the quick response.

bitsize’s picture

bitsize commented
Priority: Minor » Normal
Status: Closed (fixed) » Active

I installed AdSense [$Revision: 1.34.2.22 $ $Date: 2007/02/12 02:47:02 $] on Drupal 4.7.5 and the ads work great, but the click thru tracking does not work. The DB table is in place and there are no errors, but logging does not record either.

Any suggestions to get the AdSense logs to work?

Timotheos’s picture

Timotheos commented

First things first... did you enable click tracking?

bitsize’s picture

bitsize commented

Wow - that was fast....

Yes, that was the first thing I looked for here:

admin/settings/adsense
Enable Adsense click tracking?
Logs IP and time of Adsense clicks. This can be very useful in tracking which of your pages generate the most clicks, as well as help if click fraud is suspected.

This is in fact checked.

Good suggestion thought. Do you have any others?

kbahey’s picture

kbahey commented

Click tracking does not work with all browsers.

I think it works with MS IE but not Firefox.

bitsize’s picture

bitsize commented

Thanks for that information. I tested in IE7, and FireFox. Logging does not work in either browser.

It does however work in IE6, so I thank you for the information. I would not have thought to look if you had not mentioned it.

Does anyone know if this will be address in the AdSense for Drupal 5 ? I'm thinking of upgrading some day.

Timotheos’s picture

Timotheos commented

Oh I hope you're not clicking on your own ads... you might get banned.

The click tracking works on how the iframe is rendered. In Firefox you have to click right smack on the border to get it to work where as in IE6 it works anywhere in the iframe. I wasn't aware that it didn't work on IE7. So if there's another way to tracks clicks then I'm all ears ;)

kbahey’s picture

kbahey commented
Status: Active » Closed (fixed)

Closing this, since it is an IE7 vs IE6 issue.