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: 1281
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: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply