V2.2 Database setup error: incorrect integer value in the gdn_permission table
I'm trying to install the latest version of Vanilla, the master branch from the git repo.
I'm doing this because I'd like to use the API application which requires a v2.2 version.
I can't get to make the setup work, because of the following database error:
incorrect integer value in the gdn_permission table
Incorrect integer value: 'Garden.Moderation.Manage
' for column 'Garden.Curation.Manage' at row 1|Gdn_Database|Query|insert GDN_Permission (Garden.Email.View
) values (:GardenEmailView, :GardenSettingsManage, :GardenSettingsView, :GardenMessagesManage, :GardenSignInAllow, :GardenUsersAdd, :GardenUsersEdit, :GardenUsersDelete, :GardenUsersApprove, :GardenActivityDelete, :GardenActivityView, :GardenProfilesView, :GardenProfilesEdit, :GardenCurationManage, :GardenModerationManage, :GardenPersonalInfoView, :GardenAdvancedNotificationsAllow, :RoleID, :JunctionTable, :JunctionColumn)_
So that you know, I can install and setp a v2.1.6 version of Vanilla without problem.
So far, based on more or less similar help messages I've found on the net, I have :
- checked mysql strict mode on the server,
- created the vanilla schema without '_' in the name
- created the vanilla schema from mysql workbench, and from php myadmin (each time from the wizard and by sql query)
- checked the users rights (root and vanilla user)
And, I'm aware that the branch is not stable.
The message rather indicates a "data" problem, and I'm stuck at this point.
If any of you have any idea where I could go from here, I would really appreciate....