Hah! Ok, that is turned on. This is a database provided by a parent department, so I don't have any control over the settings.
I was able to make it eventually work by using the "execute php" part of Devel, and uninstalling the schema, installing the schema, and then using some system call I found online to tell Drupal that I was at the correct patch level.
But I'm glad to learn about this, in case it comes up elsewhere...
Thanks,
Ricky
What if you didn't make any manual changes to your database, but there's still a problem? I get:
> Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key: ALTER TABLE "honeypot_user" ADD `id` INT NOT NULL auto_increment COMMENT 'Unique record ID.', ADD PRIMARY KEY (`id`);
when I try to run the update. I have never manually modified the database table.