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

jeremy’s picture

Status: Needs review » Fixed

Thanks, fix committed to the development branch.

Anonymous’s picture

Status: Fixed » Closed (fixed)

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