{"action":"closed","issue":{"url":"https://api.github.com/repos/PEXPlugins/PermissionsEx/issues/1691","labels_url":"https://api.github.com/repos/PEXPlugins/PermissionsEx/issues/1691/labels{/name}","comments_url":"https://api.github.com/repos/PEXPlugins/PermissionsEx/issues/1691/comments","events_url":"https://api.github.com/repos/PEXPlugins/PermissionsEx/issues/1691/events","html_url":"https://github.com/PEXPlugins/PermissionsEx/issues/1691","id":47530650,"number":1691,"title":"PEX mysql error","user":{"login":"vitaxa","id":1349255,"avatar_url":"https://avatars.githubusercontent.com/u/1349255?v=3","gravatar_id":"","url":"https://api.github.com/users/vitaxa","html_url":"https://github.com/vitaxa","followers_url":"https://api.github.com/users/vitaxa/followers","following_url":"https://api.github.com/users/vitaxa/following{/other_user}","gists_url":"https://api.github.com/users/vitaxa/gists{/gist_id}","starred_url":"https://api.github.com/users/vitaxa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vitaxa/subscriptions","organizations_url":"https://api.github.com/users/vitaxa/orgs","repos_url":"https://api.github.com/users/vitaxa/repos","events_url":"https://api.github.com/users/vitaxa/events{/privacy}","received_events_url":"https://api.github.com/users/vitaxa/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2014-11-02T09:34:01Z","updated_at":"2015-01-05T05:23:46Z","closed_at":"2015-01-05T05:23:45Z","body":"Hi, i have problem with mysql config pex. \r\npermissions:\r\n  basedir: plugins/PermissionsEx\r\n  backend: sql\r\n  backends:\r\n    sql:\r\n      uri: mysql://77.37.140.106/minecraft3\r\n      user: hgfdh\r\n      password: ************\r\n      type: sql\r\n  superperms: {}\r\n  debug: false\r\n  allowOps: false\r\n  user-add-groups-last: false\r\n  log-players: false\r\n  createUserRecords: false\r\n  informplayers:\r\n    changes: false\r\nmultiserver:\r\n  use-netevents: true\r\nupdater: true\r\nalwaysUpdate: false\r\n\r\nWhen i start server PEX shows error: ru.tehkode.permissions.exceptions.PermissionBackendException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'prefix' in 'field list'.\r\n\r\nI tried to update mysq to 5.6 version. And tried to delete all pevious tables(permissions, permissions_entity, permissions_inheritance) from database.\r\n\r\nServer version cauldron-1.7.10-1.1231.04.209"}}