Forum
Can't create page (General error: 1366 Incorrect integer value: '' for column 't...
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 debug:
INSERT INTO perch2015_pages(pageTitle,pageNavText,pageParentID,templateID,pageNew,pageCreatorID,pageModified,pageAttributes,pageDepth,pagePath) VALUES('test','test','0','',1,1,'2015-05-04 09:49:36','','1','/test')
Invalid query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'templateID' at row 1
I first created the php-file, then tried to add the page. I got this error. Then I tried to add a page without first creating the file. Same result.
Is this the same as the previous thread or different?
Here I try to add a new page without checking the option "The page will have more pages below it". I have tried to first create the php-file, then add the page in perch, as well as tryng to add a new page in perch without first creating the file in finder.
In both cases, I get this error, and I can see that the "templateID" in the insert is blank.
So, different error message than the previous thread.
I upgraded to 2.8.7 and I still get this error when trying to add a page (the php-file exists).
We've not been able to reproduce this yet, but we'll keep on trying.