SQL not working

[blacksythe]

Describe the bug
May or May not be a bug (with this being fairly new)

SQL tables not created and mod seems to revert to json

Additional info seems to be overwritten by ftbutils which may be part of the problem but tested with most of utils disabled (not removed) however this remained unresolved
(Unfortunately included in many mod packs)

To Reproduce
Steps to reproduce the behavior:
database {
# Database Host
S:dbHost=mc.zdcraft.net:3306

# The Name Of The Database
S:dbName=ConstitutionDB

# Database Password
S:dbPassword=*******

# Alternative Database Path
S:dbPath=localhost

# Database Type, Supported Options: MySQL, SQLite, SQL
S:dbType=MySQL

# Database Username
S:dbUsername=ConstitutionDB

}

Expected behavior
Tables created on creating groups and adding perms

Desktop (please complete the following information):

• CENTOS 7, MARIADB, Apache
• Browser [e.g. chrome, safari]
• 1.09

Additional context*
logs.zip

[Andrew2070]

Hello.
First off, thank you for taking the time to submit this bug report.
While I have fully implemented my SQL/MySQL/SQLite systems, they haven't been activated.
Essentially the Mod does not call on the DB to load/save at all, even though the systems exist.
I'm still trying to understand how to store data more efficiently, and altering the systems with that in mind.

To put simply, the DB features are dormant for the time being, at least for another week.
If you'd like to see the DB structure before it's released, take a look here:
https://github.com/Andrew2070/Constitution/blob/master/src/main/java/constitution/datasource/schematics/ConstitutionSchematic.java

AFAIK, there shouldn't be any incompatibilities with FTBUtilities.

[blacksythe]

Thanks for getting back.

A forge permissions/ban manager mod with sql functionality is exactly what I have been looking for.

[Andrew2070]

Precisely what i'm trying to do here.
It's kind of a circular issue, some of the 100+ essential style commands I'm working on depend on a DB, while the DB depends on such commands for testing the save/load mechanisms.

I'm trying to implement 10-15 commands a day to get that done.

Unfortunately I can't serialize whole objects into the DB, which means I have to extract the data and encode it into the DB, then decode it back into the Object seamlessly.

SQL crashes aren't exactly informative either, so finessing the DB system requires a lot of trial/error. Something I haven't exactly found the time for as yet, but hopefully will finish within a week.