membership_userrecords doesn't exist bug on AppGini 5.73 and 5.74
Posted: 2019-02-21 18:45
On some versions of MySQL when using Unicode encoding, you might see the above error. We plan to make a fix for it in the next release. For now, please run this SQL command on your database using phpMyAdmin, MySQL command line or any other convenient MySQL management utility:
Please accept my deep apologies for any inconvenience caused by this issue.
Code: Select all
CREATE TABLE IF NOT EXISTS `membership_userrecords` (
`recID` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`tableName` VARCHAR(100),
`pkValue` VARCHAR(255),
`memberID` VARCHAR(100),
`dateAdded` BIGINT UNSIGNED,
`dateUpdated` BIGINT UNSIGNED,
`groupID` INT UNSIGNED,
PRIMARY KEY (`recID`),
UNIQUE INDEX `tableName_pkValue` (`tableName`, `pkValue`(150)),
INDEX `pkValue` (`pkValue`),
INDEX `tableName` (`tableName`),
INDEX `memberID` (`memberID`),
INDEX `groupID` (`groupID`)
)