How do i fix this?Unknown column 'gracefulcountdown' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean externalConn) at MashToolsSharp.mysqlClass.customqry_multi(String qry) in G:\Code\VS2017\MashToolsSharp\mysql.cs:line 331 at UGCC_Sharp.dbinterface.custom_multiquery(String myquery) at UGCC_Sharp.menu.#=q8nLgQYMUtpea1AnpMhhKfw==(String #=qaGAbu1gzEed3tXPILeF3vA==, dbinterface& #=q4gD5ZsVxQU_AA_bA87OWCQ==) at UGCC_Sharp.menu.Page_Load(Object sender, EventArgs e)
Upgrading to 2.0 from 1.95 shows this error
Upgrading to 2.0 from 1.95 shows this error
I just upgraded my UGCC to 2.0. I have the storage set to mysql (it worked fine in 1.95). I can log in fine and use settings, but the main page shows this error:
-
- Site Admin
- Posts: 3617
- Joined: Thu Apr 20, 2006 2:54 pm
- Location: America's Heartland
- Contact:
Re: Upgrading to 2.0 from 1.95 shows this error
That's really odd, that column should have been present for even 1.95. Are you sure you're using the correct database? Did you get any errors during the database upgrade process? Did the column get accidentally deleted?
You can probably use the sql tool in the admin menu, try entering the following and it should add the column back to the DB.
You can probably use the sql tool in the admin menu, try entering the following and it should add the column back to the DB.
Code: Select all
ALTER TABLE servers ADD gracefulcountdown INT DEFAULT 0
Masher
-----------
Please do not PM me unless asked to! We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.
NEW Join our Discord!
-----------
Please do not PM me unless asked to! We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.
NEW Join our Discord!
Re: Upgrading to 2.0 from 1.95 shows this error
I'm not sure what happened, but the problem fixed itself after a few hours.