Errors upon Upgrading from 2.0.6 to 2.5.2

Nope, straight from Perch 2.0.6. I should add the site seems to be working fine. No missing content that I can see. Just wanted to check what these errors were and if they're going to cause me problems.

OK so I am seeing some some interesting characters in my content. For example ' is displaying as ’.

Something to do with the MarkItUp! Editor?

OK now things have started to break!

I installed the Twitter app and imported some tweets. That all seemed to work. Then I edited my index.php file to add the tweets to the homepage and uploaded this. When I returned to perch the original errors posted above appeared again, and when I clicked 'continue' I could see that a number of pages had lost their navigation structure (appearing alongside pages they should have been subpages of). When I clicked into Page Details I got the following error:

The page attribute template (templates/pages/attributes/default.html) could not be found.

I can add that folder from the perch 2.5.2 zip I downloaded, but the navigation structure is still broken as described above.

Any thoughts?

Andrew

I should also add that the Twitter settings and Tweets I imported have also disappeared.

I've manually fixed the navigation structure and restored the missing twitter data, but I'm still concerned about those errors and if they'll cause me problems in the future.

Also still seeing the issue with special characters displaying incorrectly.

Any help you could provide would be greatly appreciated.

No, that'll teach me to skip versions! Thanks, that's fixed the special character issue. Do you think I need to do anything else about those errors above?

Looks like it's having trouble finding the perch2_resources table. When I log into phpmyadmin I can see that table but it's empty.

Sorry, yes I've done that already. The errors I'm referring to are in the first post. I got them when I upgraded from 2.0.6 to 2.5.2. I've posted them again below.

Software Update The following error occurred: ALTER TABLE perch2_resources ADD resourceCreated DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00' AFTER resourceType SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER resourceCreated SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceAWOL TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceUpdated SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD INDEX idx_awol (resourceAWOL) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceTitle CHAR(255) NULL DEFAULT NULL AFTER resourceAWOL SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceFileSize INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTitle SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceFileSize SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceWidth SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceCrop TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceHeight SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceDensity FLOAT NOT NULL DEFAULT '1' AFTER resourceCrop SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceTargetWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceDensity SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceTargetHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTargetWidth SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceMimeType CHAR(64) NULL DEFAULT NULL AFTER resourceTargetHeight SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD FULLTEXT INDEX idx_search (resourceTitle) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD resourceInLibrary TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceMimeType SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist The following error occurred: ALTER TABLE perch2_resources ADD INDEX idx_library (resourceInLibrary) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bartonch_stage.perch2_resources' doesn't exist

Yep, it's definitely there!

I was able to delete it ok. How do I get Perch to recreate it?

Thanks Drew, that worked.