I guess I win the First Failed Upgrade Contest! (Somebody's gotta be the first!)
After overwriting the old files, I went to the login.php page and got the following:
Upgrade detected! running..
Your Version: 1.77 New Version: 1.8
Please wait..
24Can't DROP 'PRIMARY'; check that column/key exists
When I login, I get:
Unknown column 'chtmlid' in 'field list'
I'm able to replicate this error every time I try to upgrade. All of my data is backed up, so I have restored to 1.77 and then (attempted to) upgrade 4 or 5 different times now -- each time getting the "Can't Drop Primary" error.
Originally, I thought it might be tied to the fact that my server recently upgraded to MySQL 4.10 and that it stemmed from previous problems converting ISAM to MyISAM. I then tried to load it up in my local testing environment (different box) to see if I could replicate the errors. While I was unable to get the same error, I got the following:
Upgrade detected! running..
Your Version: 1.77 New Version: 1.8
Please wait..
20Unknown column 'urows' in 'lm_config'
Logging in, again, gives me:
Unknown column 'chtmlid' in 'field list'
Note -- I *AM* able to install 1.8 as a clean install. If I delete all the db tables and then hit login.php, everything is created properly. On one attempt, I did a clean install and then tried dumping my old data in, and with the exception of a few lines that I manually had to manipulate, most of the data was inserted okay (though this probably isn't the smartest thing to do, as I don't know what upgraded features this might inadvertently circumvent). Hopefully you might be able to figure out what might be coughing.