Incorrect table definition
| Project: | Email Download |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
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
#1
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.
#2
Automatically closed -- issue fixed for 2 weeks with no activity.