• Home
  • Categories
  • Recent
  • Popular
  • Pricing
  • Contact us
  • Docs
  • Login
FusionAuth
  • Home
  • Categories
  • Recent
  • Popular
  • Pricing
  • Contact us
  • Docs
  • Login

SQLException when upgrading

Scheduled Pinned Locked Moved
Q&A
exception upgrade
0
2
1.3k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D
    dan
    last edited by 14 Sept 2021, 17:03

    I'm upgrading from 1.29 to 1.30 and I see a bunch of SQL exceptions:

    ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'k.ip_access_control_lists_id' in 'field list'
            at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
    

    Using Mysql if it matters.

    --
    FusionAuth - Auth for devs, built by devs.
    https://fusionauth.io

    1 Reply Last reply Reply Quote 0
    • D
      dan
      last edited by 14 Sept 2021, 17:05

      That looks like you haven't applied the migrations needed. Per the release notes, that upgrade will require database migrations: https://fusionauth.io/docs/v1/tech/release-notes/

      As a reminder, you can have fusionauth do the database migrations, but only if you are in development mode (check fusionauth.properties). If you are in production mode, you'll have to apply the migrations yourself, as outlined here: https://fusionauth.io/docs/v1/tech/installation-guide/upgrade/#database

      --
      FusionAuth - Auth for devs, built by devs.
      https://fusionauth.io

      1 Reply Last reply Reply Quote 0
      1 out of 2
      • First post
        1/2
        Last post