Getting an error in Perch when trying to add a new page that is a link only.

laurenceh · Mar 7th 2019

Hi,

I’m using Perch 3.1.4 and it was a fresh install.

When trying to add a new page that is a link only, I’m getting the error: "Sorry, that page could not be created."

Here’s the debug report from the "Add a new page" Admin page:

Code

Debug Message - Perch 3.1.4
[1] SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='db910d09fa7d10ab0ffa2c01e169f2cc' LIMIT 1
UPDATE perch3_users SET userHash='f393e4220d7898960d2367ab35f6ee13' WHERE userID='1'
[29] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[8] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[1] SELECT *, (LENGTH(templatePath) - LENGTH(REPLACE (templatePath, "/", ""))) AS depth FROM perch3_page_templates ORDER BY depth, templatePath ASC
[1] SELECT * FROM perch3_pages WHERE pageID='0' LIMIT 1
INSERT INTO perch3_pages(pageTitle,pageNavText,pageParentID,templateID,pageNew,pageCreatorID,pageModified,pageAttributes,pagePath,pageNavOnly) VALUES('Apps for Kids','Apps for Kids','0','',1,'1','2019-03-07 18:36:57','','https://google.com','1')
Invalid query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'templateID' at row 1
Setting alert: Sorry, that page could not be created. (alert)
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[3] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1] SELECT itemTitle FROM perch3_menu_items WHERE itemType='app' AND itemValue='content' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /core/apps/content/modes/page.add.post.php
[17] SELECT p.*, (SELECT COUNT(*) FROM perch3_pages WHERE pageParentID=p.pageID) AS subpages FROM perch3_pages p ORDER BY pageTreePosition ASC
[1] SELECT *, (LENGTH(templatePath) - LENGTH(REPLACE (templatePath, "/", ""))) AS depth FROM perch3_page_templates ORDER BY depth, templatePath ASC
Queries: 14
Memory: 2.6846

Display More

And here’s my general diagnostics report:

PHP

Perch: 3.1.4, PHP: 7.2.6, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $, with PDO
Server OS: Linux, apache2handler
Installed apps: content (3.1.4), assets (3.1.4), categories (3.1.4), perch_blog (5.6.1), perch_forms (1.12)
App runtimes: <?php $apps_list = [ 'perch_blog', 'perch_forms' ];
PERCH_LOGINPATH: /console
PERCH_PATH: /var/www/html/console
PERCH_CORE: /var/www/html/console/core
PERCH_RESFILEPATH: /var/www/html/console/resources
Image manipulation: GD
PHP limits: Max upload 2M, Max POST 8M, Memory: 128M, Total max file upload: 2M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
HTTP_HOST: localhost
DOCUMENT_ROOT: /var/www/html
REQUEST_URI: /console/core/settings/diagnostics/
SCRIPT_NAME: /console/core/settings/diagnostics/index.php

Display More

Any help much appreciated.

Thanks,

Laurence

drewm · Mar 8th 2019

If you enable debug and try again, what gets output at the bottom of the page at the point you get the error?

laurenceh · Mar 8th 2019

Code

Debug Message - Perch 3.1.4
[1] SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='0c928c476320d51dbe4819bd9c4244f7' LIMIT 1
UPDATE perch3_users SET userHash='a0cd68021497226901d67b459dd526c3' WHERE userID='1'
[29] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[8] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[1] SELECT *, (LENGTH(templatePath) - LENGTH(REPLACE (templatePath, "/", ""))) AS depth FROM perch3_page_templates ORDER BY depth, templatePath ASC
[1] SELECT * FROM perch3_pages WHERE pageID='0' LIMIT 1
INSERT INTO perch3_pages(pageTitle,pageNavText,pageParentID,templateID,pageNew,pageCreatorID,pageModified,pageAttributes,pagePath,pageNavOnly) VALUES('Apps for Kids','Apps for Kids','0','',1,'1','2019-03-08 12:14:08','','http://wonderworldapps.com/apps/','1')
Invalid query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'templateID' at row 1
Setting alert: Sorry, that page could not be created. (alert)
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[3] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1] SELECT itemTitle FROM perch3_menu_items WHERE itemType='app' AND itemValue='content' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2] SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /core/apps/content/modes/page.add.post.php
[17] SELECT p.*, (SELECT COUNT(*) FROM perch3_pages WHERE pageParentID=p.pageID) AS subpages FROM perch3_pages p ORDER BY pageTreePosition ASC
[1] SELECT *, (LENGTH(templatePath) - LENGTH(REPLACE (templatePath, "/", ""))) AS depth FROM perch3_page_templates ORDER BY depth, templatePath ASC
Queries: 14
Memory: 2.685

Display More

drewm · Mar 8th 2019

That looks like it could be a bug - do you know what version of MySQL you're on?

laurenceh · Mar 9th 2019

I’m on MySQL 5.7.

laurenceh · Mar 12th 2019

Hi Drew,

If I were to manually insert my page into the perch3_pages table with a templateID of 0, would that work for me in the meantime?

Or is that overly simplistic and I should leave well alone?

Thanks.

drewm · Mar 13th 2019

That would probably work, actually.

drewm Mar 7th 2019