writes " Krow posted about the UID creation problem caused by using mysql 3.23.25-beta. He wrote "I am told that there is a way to solve this by calling CREATE TABLE with a table type. I've not tried it myself, or seen the syntax, but a lot of people would be grateful if someone dug up how to do this." That's right.
MYSQL changed the default table type. By specifying the old (deprecated) table type you can get the behavior Slashcode needs. In the slashschema_create.sql file,
CREATE TABLE users ( ... );
CREATE TABLE users ( ... ) TYPE=ISAM;
This is a quick fix, but it works. As
ISAM is deprecated in favor of
MyISAM , I'm sure the proper fix involves screwing around with the myisam config file or something overly complex, or maybe there's a mysql bug waiting to be fixed."