I downloaded and enabled the email download module and received the following error:

user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: CREATE TABLE email_download_download ( eid INT(10) UNSIGNED, did INT(10) UNSIGNED AUTO_INCREMENT, updated_at DATETIME NOT NULL, count INT(10) UNSIGNED NOT NULL, PRIMARY KEY (eid, did), FOREIGN KEY (eid) REFERENCES email_download_email(eid) ON DELETE CASCADE); in C:\drupal-5.7\includes\database.mysql.inc on line 172.

And when going to Admin/Administer Downloads I get:

user warning: Table 'pcs.email_download_download' doesn't exist query: SELECT * FROM email_download_email e JOIN email_download_download d ON e.eid=d.eid in C:\drupal-5.7\includes\database.mysql.inc on line 172.

using Drupal 5.7

Comments

hadsie’s picture

hadsie commented
Status: Active » Fixed

This should be fixed in the latest D5 release (should be on d.o soon). Unfortunately I couldn't get the update function to properly work so you'll need to uninstall and re-install the tables.

Status: Fixed » Closed (fixed)

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