Forum

Thread tagged as: Problem

Issue with Upgrade App

Hi,

I'm currently in the process of upgrading a perch installation to V2.

I've followed the installation instructions and I have the following app versions running on the upgraded site:

Installed apps: content (2.8.4), assets (2.8.4), categories (2.8.4), perch_blog (4.6), perch_gallery (2.8.6), perch_twitter (3.5.1), perch_upgrade (1.5)

I am running the Blog import and I'm getting the following error (From Perch debug) with one of the SQL queries the import tool is running:

SELECT * FROM perch2_categories WHERE categorySlug='stock' LIMIT 1
Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'categorySlug' in 'where clause'

I've checked the perch2_categories table and the column it seems to be trying to reference is in fact called catSlug.

Cheers,

Alex

Alex Tebbutt

Alex Tebbutt 0 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Thanks, we'll get that fixed.

Just to add, I also noticed that it's looking for a column called categoryTitle as well which I think is catTitle.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yes, we're on it.