Jump to content

Converting SQLite to MySQL error.


Shad0wGeneral

Recommended Posts

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?

image.png.d41c18bc493c7387bc33a48381e301c2.png

Edited by Shad0wGeneral
Link to comment
Share on other sites

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 by conceptr980
Link to comment
Share on other sites

  • 2 months later...

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?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Who's Online   0 Members, 0 Anonymous, 3 Guests (See full list)

    • There are no registered users currently online
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Terms of Use