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 "RecentChange::save". Database returned error "1054: Unknown column 'rc_moved_to_ns' in 'field list' (localhost)".
Hi!
This is a known problem. Currently the best fix available is to add the missing column by hand. This should work using the ALTER TABLE command provided here:
Afterwards you should PURGE the recentchanges table and then run the maintenance script rebuildrecentchanges.php. This should make sure that you do not have corrupt entries in the table.
Hello. I am back now. The problem began when I decided to continue building my website. It worked fine until I uploaded a logo. When I saved localsettings.php a PHP Is Outdated error occurred. I then decided to downgrade from 1.21 to 1.16 which was the most recent one that supports PHP 2.7
I kept the same database and I was able to log in but I encountered the error I copied and pasted in the first post I made yesterday. I could not save any of my edits.
After contacting HostGator again (which is the cause of the PHP issue), they said that there is a code required to use PHP 3 which was then entered into .htaccess
Since PHP 3 seems to be working now, I decided to upgrade (or switch back to) MediaWiki 1.21
The extraction occurred successfully and I encountered the "set up the Wiki" link message.
During the Set Up process, it said "The tables are outdated. Click here to fix them." It almost looked like a command line interface. Sorry, but I can't remember anything else.
But that problem seems to be fixed now. The "Congratulations!" page appeared. I do not see any Database Error messages. And I am able to save my edits.
You can mark this as solved now. I will open up another topic again if the issue occurs.
