- This topic has 1 reply, 2 voices, and was last updated 13 years, 9 months ago by
.
Viewing 2 posts - 1 through 2 (of 2 total)
-
Posts
-
Minor bug, doesn’t create the proper table:
Script: eMemberInstaller.php
Offending code:
$sql = “CREATE TABLE IF NOT EXISTS ” .$members_meta_table. ” (
umeta_id bigint(20) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
user_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
meta_key varchar(255) DEFAULT NULL,
meta_value longtext,
PRIMARY KEY (umeta_id),
KEY user_id (user_id)
) ;”;
Result: DUPLICATE PRIMARY KEY DECLARED, TABLE is not created, causing problems later.
Suggested fix: remove ONE of the “PRIMARY KEY” specifications from the table creation, and it works just fine.
Thanks,
Dan Linstedt
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.