On Fri, Nov 27, 2020 at 10:15 AM krogac <[email protected]> wrote:
> In logs i have: > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'guacamole_db.guacamole_user_attribute' doesn't exist > Was the schema of your database altered in some way before the upgrade scripts were run? The errors you are seeing are inconsistent with any version of Guacamole's database schemas: * The "guacamole_connection_permission_ibfk_2" foreign key has existed since support for MySQL was introduced. It was removed only as part of 1.0.0. If the "upgrade-pre-1.0.0.sql" script reports that this foreign key does not exist, then the current database schema cannot possibly be the schema from 0.9.14 *or any earlier version*. This suggests that the upgrade has already been performed but ... * ... The "guacamole_user_attribute" table was introduced as part of 1.0.0. If the upgrade were performed, this table would exist. My guess would be that your 0.9.14 database dump was taken after schema changes were made, and that your database schema is now in a state which does not match 0.9.14, does not match 1.0.0, and which no upgrade script can work with. If there is anything you have done to the database that you haven't already listed here, that might explain what's going on, as would any errors that occurred when said things were done. - Mike
