Hi,

Im currently trying to upgrade our gooseberry wiki to the latest version. After much reading i discovered that in order to upgrade i 1st have to move our current gooseberry wiki to a fresh install of gooseberry which I have done and is working fine. Next the fresh install has to be upgraded to 1.8 then 1.9 and then to the latest. To upgrade from the fresh gooseberry install to 1.8 i followed this guide. Everything went smooth until the end. The install detected that the database was a gooseberry database and did the necessary conversion. As per the messages the installer displays I'm suppose to start dekihost with /etc/init.d/dekihost start but when I enter in that command console spits out this :

root@ubuntu:/var/www/deki-hayes/config# /etc/init.d/dekihost start
Stopping MindTouch Deki API
Starting MindTouch Deki API: mono /var/www/deki-hayes/bin/mindtouch.host.exe apikey tmz7NYHKXBJJHKxcNgGrNToOWrxq5UFU script /etc/dekiwiki/mindtouch.deki.startup.xml path-prefix @api http-port 8081 ip localhost notty connect-limit -5
nohup: redirecting stderr to stdout
root@ubuntu:/var/www/deki-hayes/config#

And when I try open the 1.8 dekiwiki in my browser i get this:

Site settings could not be loaded

Your site settings could not be loaded. This is most likely the result of misconfiguration of your API (or your API's location).

HTTP Response Status Code: 500

The API says: wiki 'default' has failed to initialize or did not start up properly: Initialization exception: System.InvalidOperationException: Unable to retrieve stored procedure metadata. Either grant SELECTprivilege to mysql.proc for this user or use "use procedure bodies=false" with your connection string. ---> System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values. at MySql.Data.MySqlClient.MySqlDataReader.GetFieldVal ue (Int32 index, Boolean checkNull) [0x00000] at MySql.Data.MySqlClient.MySqlDataReader.GetString (Int32 i) [0x00000] at MySql.Data.MySqlClient.ISSchemaProvider.GetParamet ersFromShowCreate (System.Data.DataTable parametersTable, System.String[] restrictions, System.Data.DataTable routines) [0x00000] --- End of inner exception stack trace --- at MySql.Data.MySqlClient.ISSchemaProvider.GetParamet ersFromShowCreate (System.Data.DataTable parametersTable, System.String[] restrictions, System.Data.DataTable routines) [0x00000] at MySql.Data.MySqlClient.ISSchemaProvider.GetProcedu reParameters (System.String[] restrictions, System.Data.DataTable routines) [0x00000] at MySql.Data.MySqlClient.ProcedureCache.GetProcData (MySql.Data.MySqlClient.MySqlConnection connection, System.String spName) [0x00000] at MySql.Data.MySqlClient.ProcedureCache.AddNew (MySql.Data.MySqlClient.MySqlConnection connection, System.String spName) [0x00000] at MySql.Data.MySqlClient.ProcedureCache.GetProcedure (MySql.Data.MySqlClient.MySqlConnection conn, System.String spName) [0x00000] at MySql.Data.MySqlClient.StoredProcedure.GetParamete rs (System.String procName) [0x00000] at MySql.Data.MySqlClient.StoredProcedure.Resolve () [0x00000] at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior) [0x00000] at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataR eader (CommandBehavior behavior) [0x00000] at System.Data.Common.DbCommand.ExecuteReader () [0x00000] at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader () [0x00000] at MindTouch.Data.DataCommand.Execute (System.Action`1 handler) [0x00000]

I'm not sure what this all means. The security/Api-key matches that in LocalSettings.php and the XML.
Can anyone help me out please?
Thanks!

Well no one wanted to help so I figured it out myself.
Thanks anyway.

You may still share your solution for others who might encounter the same. I'm sure they'd appreciate.

Hi,

Even though my wiki was not working after moving from gooseberry to Hayes, I still backed up my database and attachments and moved to Itasca. Moving to Itasca also did not work. I received similar errors to the ones i received when I moved to Hayes. I still ran the update script and then backed up and moved over to Cooke. Running the update script in Cooke fixed my DB and everything worked fine under Cooke. I guess migrating to each version of Dekiwiki and running each update script converted my database to the correct format.

Hi,

I also experienced the above error message after fat fingering mysql admin and deleting my wiki user . Here is how I fixed it manually:

In Mysql administrator add a 'localhost' host entry for your wiki database user. Make sure that this user has SELECT and EXECUTE privileges on the wiki database catalog.

Also, make sure that your main host entry for your wiki user has the SELECT privilege on the 'mysql' catalog.