Yeah, that is a bug in the latest release. I mentioned it to Quack but haven't made an issue on the Github repo, that would probably ensure that he gets to fixing it sooner rather than later.
See above response
`entry` varchar(255) CHARACTER SET utf8mb4 NOT NULL,`schema migrations`Hey guys, just did a small update to Kepler since it was never fully "finished" - only in a workable hotel state pretty much. Here's my changelog below which should make the server more enjoyable to use.
Changelog
- Club gifts added (default is one gift per month).
- Club clothes added (user editor is updated on login and HC purchase).
- Added user shutup/listen in rooms.
- Fixed populated rooms not showing in the navigator.
- Fixed diving score for longer usernames.
- Added same IP check for MUS camera packet handling so random connections cannot imitate a user.
To change the club gift interval edit the following in the in the settings table:
(The server will need to be started at least once with correct db details before these values appear in the database)
club.gift.timeunit (right now it's DAYS, can beYou must be registered to see links, etc)
club.gift.interval (default is 31 of that interval)
So if you change the interval to 7 and keep the timeunit to DAYS, the gift will be once per week instead of month
If you're already using Kepler, run this migrate SQL for v1.16
Code:CREATE TABLE `users_club_gifts` ( `user_id` int(11) NOT NULL, `sprite` varchar(50) NOT NULL, `date_received` bigint(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `users_mutes` ( `user_id` int(11) NOT NULL, `muted_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `users` ADD `club_gift_due` BIGINT(11) NOT NULL DEFAULT '0' AFTER `club_expiration`; UPDATE catalogue_items SET sale_code = (SELECT sprite FROM items_definitions WHERE items_definitions.id = catalogue_items.definition_id) WHERE page_id = 27 AND is_package = 0; ALTER TABLE `settings` CHANGE `value` `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''; UPDATE users SET club_subscribed = 0;
Screenshots
Download
Compiled v1.16 jar is available:You must be registered to see links
Instead of doing these evil hacks, possibly leading to untested behaviour; i'd recommend simply installing the latest stable MariaDB or MySQL release that properly support and implement utf8mb4 all throughout.
If you encounter issues importing Kepler's database/sql file,I am using the latest version of xampp, which supports MariaDB and MySQL. Uncertain whether these are the latest versions, but they are supported. Got many things to work, but HC and its gifts together with badges are some things I can't seem to get to work. You have an answer to all of this? Would be lovely
2019-01-20T11:44:21.678 - [ErrorLogger] - Error when executing MySQL query:
java.sql.SQLSyntaxErrorException: No such column: rating
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
at org.mariadb.jdbc.internal.com.read.dao.ColumnNameMap.getIndex(ColumnNameMap.java:133)
at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.findColumn(SelectResultSet.java:1484)
at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getInt(SelectResultSet.java:1062)
at com.zaxxer.hikari.pool.HikariProxyResultSet.getInt(HikariProxyResultSet.java)
at org.alexdev.kepler.dao.mysql.RoomDao.fill(RoomDao.java:383)
at org.alexdev.kepler.dao.mysql.RoomDao.getRoomsByUserId(RoomDao.java:48)
at org.alexdev.kepler.messages.incoming.navigator.NAVIGATE.handle(NAVIGATE.java:52)
at org.alexdev.kepler.messages.MessageHandler.invoke(MessageHandler.java:445)
at org.alexdev.kepler.messages.MessageHandler.handleRequest(MessageHandler.java:432)
at org.alexdev.kepler.server.netty.connections.ConnectionHandler.channelRead0(ConnectionHandler.java:99)
at org.alexdev.kepler.server.netty.connections.ConnectionHandler.channelRead0(ConnectionHandler.java:20)
at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:310)
at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:284)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)
at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1414)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)
at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:945)
at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:146)
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645)
at io.netty.channel.nio.NioEventLoop.processSelectedKeysPlain(NioEventLoop.java:545)
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:499)
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459)
at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:886)
at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
at java.base/java.lang.Thread.run(Thread.java:834)