Topic on Project:Support desk

[RESOLVED] Database error: "1054: Unknown column 'rev_sha1' in 'field list' (localhost)"

8
Axuwon (talkcontribs)

I have wiki on my old laptop (MediaWiki:1.17.0 MySQL:5.5.21 PHP:5.3.18 phpMyAdmin: 3.5.3). Now I've decided to move it to my new laptop (MediaWiki:1.20.3 MySQL:5.5.29 PHP:5.4.12 phpMyAdmin:3.5.7). By phpMyAdmin interface i have exported the database on my old laptop and in the same way imported it on my new laptop. After setting the user account and restarting the apache and mysql services, while trying to access my wiki from browser i receive the following error message:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "Revision::fetchFromConds". Database returned error "1054: Unknown column 'rev_sha1' in 'field list' (localhost)".

Am I missing smth? Anyway I do appreciate the real help to solve the issue.

NB. At LocalSettings.php on my old laptop there are was a line $wgDBprefix = "mdw_"; which I copied to LocalSettings.php on new laptop.

Ciencia Al Poder (talkcontribs)
Axuwon (talkcontribs)

Running the update.php do solved the issue!

115.91.55.219 (talkcontribs)

I'm running update.php to update mediawiki 1.15.1 to 1.21.1 on my laptop. I changed MySQL user to root at Localhost.php.

During running the update.php, there is a error 1054: unknown colum 'rev_sha1' in 'field list'(localhost).

The step where error happened was "batch conversion of user_options: A database query syntax error has occurred.

I appreciate it if anybody could help me to solve this issue.

88.130.73.137 (talkcontribs)

Have a look at the threads on this very page. There already were three or four concerning this issue and I think they had a solution.

Ciencia Al Poder (talkcontribs)
168.167.134.101 (talkcontribs)

Thank you...I had the same problem and this helped me.


Thank you,

69.160.2.216 (talkcontribs)

i don't think this work