When enabling this module, i got the error
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes: CREATE TABLE {link_click_count} (
`id` INT unsigned NOT NULL auto_increment,
`url` VARCHAR(1000) NOT NULL,
`nid` INT NOT NULL,
`uid` INT NOT NULL,
`date` INT NOT NULL,
PRIMARY KEY (`id`),
INDEX `nid_url` (`nid`, `url`),
INDEX `date` (`date`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Table to store every click detail.'; Array
(
)
in db_create_table() (regel 2720 van /obfuscated/includes/database/database.inc).
Of course, a quick and dirty solution would be to modify the database schema not to set an index on url, but that would just slow things down.
A more elegant solution would seem to be a separate table for storing URL data.
By the way, it appears that URL's can be up to 2000 characters long, so it seems like a good idea not to limit an url string to 1000 characters.
Fixed
1.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.