I moved two wikis from separate servers onto a single server running the latest release (8.05) with a multi-tenant configuration. They were both 1.9.0c before the move.

I ran the update-db.php script against both DBs. I understand there's a bug in the script which keeps it from working with the multi-tenant config of LocalSettings.php. So I configured LocalSettings.php as a single setup against each DB one at a time, running the update script against them that way.

The wikis mostly work... with a couple exceptions (which are probably related). Both my wikis have the exact same symptoms.

When I click Save after editing a page, I get the "Looks like something is broken" message. The 500 error being thrown is...

Request URI:
http://localhost:8081/deki/pages/31/...20080509231909

Server response:
Array
(
[exception] => Array
(
[message] => Unknown column 'rc_transaction_id' in 'field list'
[source] => MySql.Data
[stacktrace] => Array
(
[frame] => Array
(
[0] => MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000]
[1] => MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000]
[2] => MySql.Data.MySqlClient.MySqlDataReader.GetResultSe t () [0x00000]
[3] => MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]
)

)

[type] => MySql.Data.MySqlClient.MySqlException
)

)

Also, the part of the page which displays "page last edited x minutes ago by" username... the username is showing as "User:".

If I simply navigate away from the editor and visit the page, I can see that my edit was actually successful. The page was edited.

Also, the edit is not recorded in Recent Changes.

Also, on restricted pages (semi-public - can be read but only one user should be able to edit it) I am able to edit the page this way as a user that is not in the Grant List. So, whatever this issue is, it also allows restricted pages to be edited.

Bummer. Kinda seems like the db update script didn't kill some table it was supposed to? But the script did say it ran successfully against both DBs. Everything else seems to work fine. I can even add new attachments without any errors. Just can't edit a page without that error about that Unknown Column.

I seek help

I've resolved this issue.

This happened because I moved/renamed my database in a manner which didn't jive with the update-db.php script.
I created a blank database with the createdb.sh script from 8.05, then imported my 1.9.0b data, then performed the update-db.sh script from 8.05. This is the wrong way to do it.
The right way to do this is to create a blank database from a 1.9.0x installation of createdb.sh, then import 1.9.0x data, then perform the update-db.sh from 8.05.

Seems simple when I say it that way !

Similar issue experienced here:

can you write the detailed setps (I will really apreciate if you write the commands too) to do this that you mention:

"The right way to do this is to create a blank database from a 1.9.0x installation of createdb.sh, then import 1.9.0x data, then perform the update-db.sh from 8.05."

I'm new in this but I wanna fix it because I have that problem with my recent changes and with the permisions.