Error when trying to create a new page

Permalink 1 user found helpful
I upgraded 5.7.3.1 to 5.7.4.2 and when I try and create a new page I get this error:
An exception occurred while executing 'SELECT t0.cPath AS cPath1, t0.ppID AS ppID2, t0.cID AS cID3, t0.ppIsCanonical AS ppIsCanonical4, t0.ppGeneratedFromURLSlugs AS ppGeneratedFromURLSlugs5 FROM PagePaths t0 WHERE t0.cID = ? AND t0.ppIsCanonical = ? LIMIT 1' with params ["350", 1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.ppGeneratedFromURLSlugs' in 'field list'


Any ideas?

Edit: Looks like the draft is being created, maybe the urls are messed up?
Edit 2: Now I'm getting a ton of database errors, I can't swap page types or create new pages without this error popping up. I'm starting to regret upgrading my clients 5.6 website to 5.7 but it's too late to turn back now.

hdocwra
 
hdocwra replied on at Permalink Best Answer Reply
hdocwra
Okay this is actually quite easy to fix.

If you go into phpmyadmin or similar go to 'PagePaths' and add the column ppGeneratedFromURLSlugs with tinyint length 1 set to a default of 0.

All fixed!
olatunji replied on at Permalink Reply
tried solution, but error 1054 was returned.
olatunji replied on at Permalink Reply
I also get this error. Could someone please write out the code as it would have to be done on the PagePath.php page.
MrKDilkington replied on at Permalink Reply
MrKDilkington
Hi olatunji

Have you tried updating to the most current version of concrete5? Version 5.7.3.1 was released on Jan 9, 2015 and many changes have been made since then.