search

thedudeguy / JukeIt

A Bukkit plugin for Minecraft that allows you to "Burn" new music onto Music Discs and play them in the Jukeboxes.
GNU General Public License v3.0
10 stars 10 forks source link

Jukeit 2.2.0 still mysql problems #119

Closed lipe123 closed 11 years ago

lipe123 commented 11 years ago

Hey there I just loaded the new version and on startup I got these: 2012-11-10 14:05:10 [INFO] [JukeIt] Enabling JukeIt v2.2.2 2012-11-10 14:05:11 [INFO] [JukeIt] No Burned Discs to load. 2012-11-10 14:05:14 [SEVERE] *\ WARNING: FreeMarker logging suppressed. 2012-11-10 14:05:14 [SEVERE] 2012-11-10 14:05:14.220:INFO::jetty-7.x.y-SNAPSHOT 2012-11-10 14:05:14 [SEVERE] 2012-11-10 14:05:14.299:WARN::FAILED SelectChannelConnector@0.0.0.0:800: java.net.SocketException: Permission denied 2012-11-10 14:05:14 [SEVERE] 2012-11-10 14:05:14.300:WARN::FAILED cc.thedudeguy.jetty.server.Server@453630d2: java.net.SocketException: Permission denied

Then in game I still get kicked with: http://pastie.org/5357274

Ps. The crafting recipes work again (at least new blank discs and the disc machine that Itested) Maybe some tables are corrupt and need to be dropped and remade?

thedudeguy commented 11 years ago

ok for the mysql error, I would delete the tables from your mysql DB, and let JukeIt regenerate the table with 2.2.2.

as for the permission denied errors, well those are user errors / OS errors. Permission Denied. the user running the minecraft server does not have suffucient access to bind that port. Either the port is already in use, or the port is too low. Many linux servers only let root users bind ports lower than [8000]. try a port higher than 8000.

lipe123 commented 11 years ago

Yea the 800 was a dumb typo I kinda figured that one out in the meantime also XD.

So if i drop all the tables for jukeit i'll lose all the burners and whatnot custom blocks in game again right?

Can i just drop the discs table, what is it called?

thedudeguy commented 11 years ago

perhaps you can get away with just dropping the "jb_rc_data" table, then restarting and letting jukeit regenerate the table. if not, than try dropping all the tables but back up the tables first of course.

lipe123 commented 11 years ago

Ok I fixed the port, its now at 8000 and that works fine.

The table issue still persists. First I just dropped the one table but still had the error, then i droppped both and restarted the server and it still happens.

Even when I choose the default battle Jesus song from the webserver list I get kicked and it does the error:

23:49:18 CONSOLE: [WARNING] Failed to handle packet: javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[Field 'id' doesn't have a default value] 23:49:18 CONSOLE: executing DML bindLog[] error[Field 'id' doesn't have a default value] 23:49:18 CONSOLE: java.sql.SQLException: Field 'id' doesn't have a default value 23:49:18 CONSOLE: Lipe123 has left. 23:49:18CONSOLE: From: Chris Churchwell Sent: Saturday, November 10, 2012 12:36 PM To: thedudeguy/JukeIt Cc: Cecil du Plessis Subject: Re: [JukeIt] Jukeit 2.2.0 still mysql problems (#119)

ok for the mysql error, I would delete the tables from your mysql DB, and let JukeIt regenerate the table with 2.2.2.

as for the permission denied errors, well those are user errors / OS errors. Permission Denied. the user running the minecraft server does not have suffucient access to bind that port. Either the port is already in use, or the port is too low. Many linux servers only let root users bind ports lower than [8000]. try a port higher than 8000.

— Reply to this email directly or view it on GitHub.

thedudeguy commented 11 years ago

Ok, I think I have fixed it now, can you test it out with the dev version for me please? https://github.com/downloads/thedudeguy/JukeIt/jukeit-dev-SNAPSHOT.jar

lipe123 commented 11 years ago

Do I need to drop the tables again? Cause its still doing the exact same thing.

Also why is there no option not to use mysql and just use its own sqlite thing?

So I setup a remote login to the DB for mysqlworkbench and changed the rc table "id" field to be exactly the same as rp_data ( I just enabled auto increment) as seen here: http://postimage.org/gallery/10ro8r6e/

But I still get the "id" has no default value error. I also tried to set a default value of 0 but that did not help either :(

thedudeguy commented 11 years ago

yes, I beleive you will need to drop tables again so it can recreate the tables with an auto increment.

It can use SQLite. It uses bukkit's persistance db, you can set it in the bukkit yml.

lipe123 commented 11 years ago

Eh I just noticed another table called: minecraft.burned_discs.

I dropped it while the server ran and tried to burn something and got the "Table not found" error, so it was never the rc_data or rp_data it was the "burrned_discs" that had no fields defined in it at all.

aaand holy cow its working!

thedudeguy commented 11 years ago

good good. Thanks for reporting