SimpleClans

SimpleClans

467k Downloads

You have an error in your SQL syntax, New "fee_enabled" isn't upgrading exsiting databases

TomLewis opened this issue ยท 4 comments

commented

Hello, I just updated SimpleClans and its failed to add the new fee_enabled column, I can manually create these, but the upgrade process is broken at present.

Also, if I were to manually create these, would I need to restart the server?
What are the colums that I need to create and on what table? it looks like both on sc_clans, 2 colums fee_enabled and fee_value, Im not entirely sure what the data type double(64,2) is though, is it the same as a float? and tinyint I assume will either be 0/1 for a boolean if its enabled or not?

[10:39:20] [Server thread/INFO]: [SimpleClans] MySQL Connection successful
[10:39:20] [Server thread/ERROR]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''fee_enabled' tinyint(1) default '0'' at line 1
[10:39:20] [Server thread/ERROR]: Query: ALTER TABLE sc_clans ADD COLUMN 'fee_enabled' tinyint(1) default '0';
[10:39:20] [Server thread/ERROR]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''fee_value' double(64,2)' at line 1
[10:39:20] [Server thread/ERROR]: Query: ALTER TABLE sc_clans ADD COLUMN 'fee_value' double(64,2);

Then under that a bit later is this massive spam:
https://gist.githubusercontent.com/FrozenBeard/e9f9bcf14868309c439d06e06ddcd083/raw/8e3896caaf7356192b0d8d5f9672b21b5537023f/gistfile1.txt

commented

Apparently I used ' instead of `.

commented

This has fully broken the entire plugin from working.

commented

Use the previous version until I fix it.

commented

Thanks @RoinujNosde on the speed of your replys!