Forum

Thread tagged as: Error

Can't create page (Unknown column 'create_folder')

Perch: 2.8.6, PHP: 5.5.20, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $, with PDO
Server OS: Darwin, apache2handler
Installed apps: content (2.8.6), assets (2.8.6), categories (2.8.6)
App runtimes: <?php $apps_list = array( 'content', 'categories', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /Users/disvgron/github/di-website/cms/perch
PERCH_CORE: /Users/disvgron/github/di-website/cms/perch/core
PERCH_RESFILEPATH: /Users/disvgron/github/di-website/cms/perch/resources
Image manipulation: GD
PHP limits: Max upload 2M, Max POST 8M, Memory: 128M, Total max file upload: 2M
Resource folder writeable: Yes
HTTP_HOST: dino.dev
DOCUMENT_ROOT: /Users/disvgron/github/di-website/cms
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php

From the log:

INSERT INTO perch2015_pages(pageTitle,pageNavText,pageParentID,templateID,create_folder,pageNew,pageCreatorID,pageModified,pageAttributes,pageDepth,pagePath) VALUES('Products','Products','0','','1',1,1,'2015-05-04 09:27:59','','1','/products/index.php')
Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'create_folder' in 'field list'

Screenshot

Svein Are Gronsund

Svein Are Gronsund 0 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you tell us what you we're doing?

Here I try to add a new page AND checking the option "The page will have more pages below it". I want to have sub-pages to the "products"-page.

I have tried different values in the "file name"-field. Lastly I tried: "products/index.php" (the directory + file had been created), but I still get this error. And to me it looks like something is very wrong: The insert specified "create_folder" that doesn't exist in the DDL.

(BTW: I'm "sag" on Slack)

Drew McLellan

Drew McLellan 2638 points
Perch Support

Was this an update from an older version?

No, a fresh install.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, thanks, I think we've tracked it down.