1.6 Database update issue

[toschulz]

I updated my Fog server to Debian Trixie, and one thing led to another, and I ended up moving over to 1.6-working. It looks like part of my database schema is out of sync. I always get datatables error when I pull up details for any host.

I’ve just tried updating the installer files from github and re-run the install script, but I can’t get the error message to go away.

Does anyone have a fix so I don’t get errors about a missing host-login-history-table?
I have a database backup from before the switch to 1.6, so I can revert to 1.5.x if needed

[Tom Elliott]

Is this preventing things from working in the UI?

What version of 1.6 are you running (should tell you exactly at the bottom right of the UI)

[toschulz]

@Tom-Elliott

The Version is: 1.6.0-beta.3075

As far as I can tell, everything seems to be working with the exception of host login history

[Tom Elliott]

@toschulz So I suspect the problem is due to a divergence of db schema between dev-branch/stable + working-1.6

If you can update yoru Mysql directly:

sudo mariadb -u root fog (if no root password of course - if you have a root password add -p

UPDATE schemaVersion SET vVersion=0;

Then refresh your screen, click the install/update, and hopefully the error will go away.

The way the schema is configured is it will attempt (idempotently) to rerun every single SQL query in the schema chain.

This should fix the problem you’re seeing.

I believe there’s a column on the login history piece being requested that may just simply be missing which would cause the issue with datatables.