Converting SQLite to MySQL error.

[Shad0wGeneral]

Hey all I appear to be stuck with this rather annoying error now I thought it was due to TCAdmin being out of date so I threw an update (2.0.179.0) at it but all its done is reverse the which one is out of date.... Anyone got a fix for this?

Edited June 12, 2022 by Shad0wGeneral

[conceptr980]

This topic is been discussed before. Rollback TCADMIN to version 2.0.178.0 then convert sqlite to mysql then update to 2.0.179.0

 

As in your case your trying to convert 2.0.178.0 sql tables in 2.0179.0 version

 

Manual Update Steps:

https://help.tcadmin.com/Updating

 

Ex. Commands in your case if its windows rolleback :

1- Rollback version: "C:\Program Files\TCAdmin2\Monitor\TCAdminUpdateTool.exe" 2.0.178.0

2- Start TCADMIN and convert SQLite to MySQL

3- Update tcadmin back to 2.0.179.0 (Manual or via Panel)

 

I hope that helps

Edited June 12, 2022 by conceptr980

[Eased]

Having the same issue trying to use the Convert SQLite Database to MySQL tool. Error message: "The mysql script is from a different version. SQLite Version: 179 MySQL Version: 178". I am running on version 2.0.179.0.

Rolling back to 2.0.178.0 does not resolve the issue because the SQLite database version is not rolled back/downgraded from the manual upgrade commands. So the same error message is given even though TCAdmin is running on 178.

The other thread is also unhelpful because we are in the reverse situation, where the SQLite version is higher than the MySQL version, so no rollback is theoretically possible.

Any other suggestions?

[Eased]

This issue was fixed by support providing a MySQL.sql file for C:\Program Files\TCAdmin2\Database so it overwrites the MySQL.sql.