search

DevotedMC / NameLayer

A Citadel reinforcement group manager. Allows the creation of groups in Minecraft. Built for Spigot 1.14.4
https://build.devotedmc.com/job/Namelayer-master/
BSD 3-Clause "New" or "Revised" License
3 stars 8 forks source link

MySQL Database Errors #30

Closed 3ssej closed 6 years ago

3ssej commented 6 years ago

Hello. You may remember me - I sort of wasted your time because I got my builds from the wrong place - but I can assure you I've gotten them from the right place now. Anyways, I'm trying to use NameLayer again but I am having trouble getting it to load the first time. Here is my log file: https://pastebin.com/KzStAbcL What can I do to solve this? Thanks again for your help and dedication!

ProgrammerDan commented 6 years ago

Check with your DBMS hosting provider -- it seems the user you configured doesn't have permission to modify the database structure?

3ssej commented 6 years ago

Opened a ticket. They had me try a couple of things but now they are looking into it further. Thanks for your help thus far! I'll let you know if it doesn't work after they try fixing it.

ProgrammerDan commented 6 years ago

Sounds good. If they aren't able to get you running, I can probably provide you with a schema layout they could install for you. Let me know.

3ssej commented 6 years ago

They said that the user has full permission to the database, so I'm not sure what else is wrong. Let me try it real quick with another plugin and I'll see if I get the same error.

ProgrammerDan commented 6 years ago

it might just be the ALTER command itself (perhaps a v. incompatibility) -- what version of MySQL are you using?

3ssej commented 6 years ago

Yeah, CoreProtect seems to work okay with the database. I am asking what version they are using.

3ssej commented 6 years ago

They just keep saying that it isn't relevant. I'm going to try to use a database hosted elsewhere accessible externally and see if that works.

3ssej commented 6 years ago

Alright, well I tried using another database, and while I did get further in the migration, it failed at Migration 7. Console: https://pastebin.com/D622HVuw Looks like another permissions issue though. Thanks again for all of your help.

EDIT: The MySQL version that this database is using is "5.0.12-dev" according to the phpmyadmin page. The host's database (which I was finally able to connect to with phpmyadmin) is the same.

3ssej commented 6 years ago

I tried a third database and it migrated successfully. Please feel free to close this :D

ProgrammerDan commented 6 years ago

Glad you had success, sorry for late reply.