First off make sure you have uploaded ALL the new files
Second my initial response would be to make sure you ran all the upgrades but since your mysql issues have to do with two separate tables I would tend to think based on the errors you have corrupt tables. Go ahead and run a repair on them and lets see where we stand.
Third do not run any more upgrades as that appears to have gone fine except check your data directory permissions. Your data directories should have been 777 and when the last upgrade ran it would have moved your thumbs into the new thumbs directory but it appears you did not have that happen possible permissions issues?
I checked the permissions on the data directories and they are all 777
I can't even get into my admin area. Very strange. I'm sure I messed SOMETHING up but I have no idea what it is. I followed the instructions on install but no luck. I have done it twice now with the same result. The first time, I completely wiped it and tried again.
I decided to try a fresh install as well, and had no issues whatsoever with that. I have no idea what I'm doing wrong but I would hate to have to rebuild the whole thing. Is there any way I could import all of my data from my old classifieds section to my new one instead of doing the upgrade or is that the only way I can save my current data?
Your issues are simple as I have posted your tables are corrupt or missing
Look here at error on line 622
Content visible to verified customers only.
You should clearly have a iponline table but your query is failing. Do you see why I said earlier to check your iponline and usergroups table.
Also when logged in as admin and you have debugging set to display errors you should see the true error
Well, I seemed to have cleared up the error on line 622 but the two at the top of the page are still coming up. The iponline table was NOT missing but I'm sure there was something wrong with it since when I dropped it, then copied the iponline table from my good copy, that error went away.
Is there a way I can just import the data from the old version to my new working version instead of trying to continue this upgrade? Obviously the upgrade scripts need a little work. It's not modifying the tables like it should.