This site works best with JavaScript enabled. Please enable JavaScript to get the best experience from this site.
What steps will reproduce the problem?1.Downloaded plugin2.Changed config added some new classes3./admin class [name] [class]4.Gives the extra hearts5.After restart or relog hearts gone
What is the expected output? What do you see instead?I expected the person to keep their class but instead they keep going back to the default class
What version of the LegendQuest, Bukkit and Skill Defaults are you using?Legend Quest v1.9.7, Spigot 1.8.7 Build#40 and No Skill Defaults
Do you have error logs of what happened? (Bukkit and /plugins/LegendQuest/legendquest.log)
[07:25:06] [Craft Scheduler Thread - 48/ERROR]: [LegendQuest] Error writing lq_pc to database.[07:25:06] [Craft Scheduler Thread - 48/WARN]: java.sql.SQLException: [SQLITE_BUSY] The database file is locked (database is locked)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.DB.newSQLException(DB.java:383)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.DB.newSQLException(DB.java:387)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.DB.execute(DB.java:339)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.Stmt.exec(Stmt.java:65)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.Stmt.execute(Stmt.java:114)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at lib.PatPeter.SQLibrary.Database.query(Database.java:242)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at me.sablednah.legendquest.db.DataSync.writeData(DataSync.java:747)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at me.sablednah.legendquest.db.DataSync.access$0(DataSync.java:710)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at me.sablednah.legendquest.db.DataSync$dbProcessCache.run(DataSync.java:48)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at java.lang.Thread.run(Thread.java:745)[07:25:06] [Craft Scheduler Thread - 48/ERROR]: [LegendQuest] Error writing lq_datastore sets to database.[07:25:06] [Craft Scheduler Thread - 48/WARN]: java.sql.SQLException: cannot commit transaction - SQL statements in progress[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.DB.throwex(DB.java:370)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.DB.ensureAutoCommit(DB.java:435)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.DB.execute(DB.java:332)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.Stmt.exec(Stmt.java:65)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.sqlite.Stmt.execute(Stmt.java:114)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at lib.PatPeter.SQLibrary.Database.query(Database.java:242)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at me.sablednah.legendquest.db.DataSync.saveDataStore(DataSync.java:994)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at me.sablednah.legendquest.db.DataSync.writeData(DataSync.java:823)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at me.sablednah.legendquest.db.DataSync.access$0(DataSync.java:710)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at me.sablednah.legendquest.db.DataSync$dbProcessCache.run(DataSync.java:48)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[07:25:06] [Craft Scheduler Thread - 48/WARN]: at java.lang.Thread.run(Thread.java:745)
Please provide any additional information below.
Config File- Link Removed: https://www.mediafire.com/?1jhzlekdzk9rodk
Well that pretty much sums it up - the database file is locked for some reason.
Firstly delete LegendQuest.db-journal
Then what server are you running on? Linux, Windows? Check your permissions and make sure the LQ folder and the .db are writable.
We are running server using Shockbyte hosting website. I deleted the LegendQuest.db-journal sadly it didnt help. We cant control the permissions.
@simon8198: Go
Ok, try shutting down - deleting the db entirely (you'll lose all LQ player info :/ but not inventories etc.) and then restarting.
The alternative is, Is there any way you could switch to MySQL - do Shockbyte offer support for it?
I changed it to MySQL which has fixed the problem. Thanks for telling me
To post a comment, please login or register a new account.