membership_userrecords doesn't exist bug on AppGini 5.73 and 5.74

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
User avatar
a.gneady
Site Admin
Posts: 977
Joined: 2012-09-27 14:46
Contact:

membership_userrecords doesn't exist bug on AppGini 5.73 and 5.74

Post by a.gneady » 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:

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`)
)
Please accept my deep apologies for any inconvenience caused by this issue.
:idea: Learn all the tips and tricks of customizing AppGini apps through our online course.

:arrow: Summary Reports plugin enables you to build powerful reports and charts inside your AppGini application through a few simple steps. See the big picture and discover trends in your data that empower you to take the right decisions confidently.

:arrow: Search Page Maker enables you to build user-friendly yet powerful search pages for your AppGini application by simply dragging and dropping the fields you want to include in search.

Post Reply