V2.2 Database setup error: incorrect integer value in the gdn_permission table

aboufeta

Hi there,
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,Garden.Settings.Manage,Garden.Settings.View,Garden.Messages.Manage,Garden.SignIn.Allow,Garden.Users.Add,Garden.Users.Edit,Garden.Users.Delete,Garden.Users.Approve,Garden.Activity.Delete,Garden.Activity.View,Garden.Profiles.View,Garden.Profiles.Edit,Garden.Curation.Manage,Garden.Moderation.Manage,Garden.PersonalInfo.View,Garden.AdvancedNotifications.Allow,RoleID,JunctionTable,JunctionColumn) 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....
Thanks!!

Zack.

R_J

In case you wonder why there is no "Vanilla 2.2 Help" category: it is not supported here because no one wants to encourage people using non stable versions

If you think you found an error, you should file it on GitHub. That's the correct place for your question.

aboufeta

There is no "Vanilla 2.2 Help" category, in case you wonder why I posted in this 2.1 category.

R_J

In case you wonder why there is no "Vanilla 2.2 Help" category: it is not supported here because no one wants to encourage people using non stable versions

If you think you found an error, you should file it on GitHub. That's the correct place for your question.

hgtonight

Welcome to the community!

Most user's here have no interest in debugging alpha versions of Vanilla. Take you issue to https://github.com/vanilla/vanilla/issues

EDIT - Man, I really need to start refreshing the page on stale browser tabs. @R_J beat me to it by almost an hour!

R_J

I wonder how you ever managed to finish YAGA if it takes you an hour to write 3 sentences

hgtonight

@R_J said:
I wonder how you ever managed to finish YAGA if it takes you an hour to write 3 sentences

I always get off in tangents when looking up something in the codebase for the questions in the forums. "Registration issue? I have been meaning to grok authenticators for a while..."

I just need to open fewer tabs at a time.

aboufeta

I submitted the issue where it belongs, thanks!
As a side note, @hgtonight‌ : multitasking is bad for your health