Skip to content

Bot purchase fails and throws two exceptions

Build Information

Emulator Version: Last Supernova Build (https://git.krews.org/morningstar/Arcturus-Community/-/jobs/882)

Current Behavior

Currently, when you press "Buy" for any bot, the purchase fails and you get the following exceptions:

15:54:53.055 [HabExec-1-2   ] ERROR c.e.habbo.habbohotel.bots.BotManager - Caught SQL exception
java.sql.SQLSyntaxErrorException: Unknown column 'owner_id' in 'field list'
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
        at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
        at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
        at com.eu.habbo.habbohotel.bots.BotManager.createBot(BotManager.java:70)
        at com.eu.habbo.habbohotel.catalog.CatalogManager.purchaseItem(CatalogManager.java:900)
        at com.eu.habbo.messages.incoming.catalog.PurchaseFromCatalogEvent.handle(PurchaseFromCatalogEvent.java:190)
        at com.eu.habbo.messages.PacketManager.handlePacket(PacketManager.java:207)
        at com.eu.habbo.threading.runnables.ChannelReadHandler.run(ChannelReadHandler.java:21)
        at com.eu.habbo.threading.ThreadPooling.lambda$run$0(ThreadPooling.java:47)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
        at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
        at java.base/java.lang.Thread.run(Thread.java:1583)
15:54:53.094 [HabExec-1-2   ] ERROR c.e.h.h.catalog.CatalogManager       - Exception caught
java.lang.Exception: Failed to create bot of type: generic
        at com.eu.habbo.habbohotel.catalog.CatalogManager.purchaseItem(CatalogManager.java:920)
        at com.eu.habbo.messages.incoming.catalog.PurchaseFromCatalogEvent.handle(PurchaseFromCatalogEvent.java:190)
        at com.eu.habbo.messages.PacketManager.handlePacket(PacketManager.java:207)
        at com.eu.habbo.threading.runnables.ChannelReadHandler.run(ChannelReadHandler.java:21)
        at com.eu.habbo.threading.ThreadPooling.lambda$run$0(ThreadPooling.java:47)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
        at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
        at java.base/java.lang.Thread.run(Thread.java:1583)

Steps to Reproduce

  1. Buy any bot from catalog

Context (Environment)

  • Last Arcturus Build with
  • Base database for Arcturus
  • Last Nitro React Build
Edited by Cristoforo Krews