Installing for the first time on a Drupal 4.7.2 site i get the following warning:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 25 query: ad_install CREATE TABLE ads ( aid INT(10) UNSIGNED NOT NULL UNIQUE DEFAULT '0', uid INT(10) UNSIGNED NOT NULL DEFAULT '0', gid INT(10) UNSIGNED NOT NULL DEFAULT '0', adstatus VARCHAR(255) NOT NULL DEFAULT '', adtype VARCHAR(255) NOT NULL DEFAULT '', redirect VARCHAR(255) NOT NULL DEFAULT '', autoactivate INT UNSIGNED NOT NULL DEFAULT '0', autoactivated INT UNSIGNED NOT NULL DEFAULT '0', autoexpire INT UNSIGNED NOT NULL DEFAULT '0', autoexpired INT UNSIGNED NOT NULL DEFAULT '0', activated INT UNSIGNED NOT NULL DEFAULT '0', maxviews INT UNSIGNED NOT NULL DEFAULT '0', maxclicks INT UNSIGNED NOT NULL DEFAULT '0', in /home/public_html/test/includes/database.mysql.inc on line 120.

Tables 'ads' completely fails to create. Setting as critical, as is a problem with installation.

Comments

marcoBauli’s picture

marcoBauli commented
Status: Active » Needs review

there's an unclosed bracket:

please replace line 43 KEY (autoexpire)");
with

KEY (autoexpire))");

feedback coming soon ;)

jeremy’s picture

jeremy commented
Status: Needs review » Fixed

Fix already in development branches, just awaiting the rolling of a new release.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)