pookguy88, those instructions are basically the same to a “T” for any upgrading you’re going to do.. I followed them when upgrading from 1.5.2 to 2.0 and didn’t have any problems.. <knock on wood> Cause now I gotta re-upgrade mine lol..it’s always scary to do lol..
Upgrading should follow the same procedure as always.
Backup your entire site, including your database.
Delete all wp files EXCEPT config.php and the wp-content folder
Upload the new files, then, to be safe, run wp-admin/upgrade.php
I just upgraded from 2.0 to 2.0.1. Selected the default theme. When I go to any category archive, like https://www.tanster.com/?cat=4, I see the error message:
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND comment_approved = '1'' at line 1]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = AND comment_approved = '1';
By reset permalinks, do you mean going to Options > Permalinks, and clicking “Update Permalink Structure”? I tried that and it didn’t change anything. (I use the default permalink setting.)
I tried upgrading 2.0 to 2.1. Deleted all files except the htaccess file, and config file and of course the content folder.
Uploaded all new files. Ran the upgrade it said to do. Then no posts showed on the site. Nothing in the categories even though it showed articles were posted. The admin shows the articles. Just not the visible part of the site.