Closed (fixed)
Project:
Advertisement
Version:
5.x-1.6
Component:
ad module
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
2 Oct 2008 at 12:46 UTC
Updated:
16 Oct 2008 at 13:12 UTC
Installation on PostgreSQL fails because of a SQL error. The trailing comma at the end of the timestamp line should be removed from the query that creates the ad_clicks table in ad.install.
Should look like this:
db_query("CREATE TABLE {ad_clicks} (
cid SERIAL NOT NULL PRIMARY KEY,
aid INT NOT NULL DEFAULT '0',
uid INT NOT NULL DEFAULT '0',
status INT NOT NULL DEFAULT '0',
hostname varchar(128) NOT NULL DEFAULT '',
user_agent varchar(255) NOT NULL DEFAULT '',
adgroup varchar(255) NOT NULL DEFAULT '',
hostid varchar(32) NOT NULL DEFAULT '',
url varchar(255) DEFAULT '',
timestamp INT NOT NULL DEFAULT '0'
);");
Comments
Comment #1
jeremy commentedThanks, fix committed to the development branch.
Comment #2
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.