Forum

Thread tagged as: Problem, Error

Can't create link only page

Hello,

trying to add a new page with "Page already exists, or is a link only" option, results in error "Sorry, that page could not be created."

On Perch 2.7.5 and debug shows the following:

Invalid query: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'templateID' at row 1"

Thanks

Andrés Fernández

Andrés Fernández 5 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Which version are you running, and was it a fresh install or an update from a previous version?

Perch 2.7.5 and is a fresh install

Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you show me your diagnostics report?

Perch information

    Perch: 2.7.5
    Production mode: Production (100)
    Installed apps: content (2.7.5), assets (2.7.5), categories (2.7.5)
    DB driver: PDO
    DB tables: perch2_categories, perch2_category_counts, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_navigation, perch2_navigation_pages, perch2_page_templates, perch2_pages, perch2_resource_tags, perch2_resources, perch2_resources_to_tags, perch2_settings, perch2_user_privileges, perch2_user_role_privileges, perch2_user_roles, perch2_users
    Users: 2
    App runtimes:

    <?php

    $apps_list = [
        'content', 
        'categories',
    ];

    Editor plug-ins: markitup
    H1: 49ebdb8af68a16cf1dbab0900d7beb2b
    L1: 2147489b37335199521a34ee073cefa0
    headerColour: #232320
    content_singlePageEdit: 1
    helpURL:
    siteURL: /
    hideBranding: 1
    content_collapseList: 1
    lang: en-gb
    update_2.7.5: done
    headerScheme: dark
    content_hideNonEditableRegions: 1
    dashboard: 0
    hide_pwd_reset: 0
    content_frontend_edit: 0
    latest_version: 2.5.3
    on_sale_version: 2.7.5
    PERCH_DEVELOPMENT: 10
    PERCH_STAGING: 50
    PERCH_PRODUCTION: 100
    PERCH_DEBUG: 1
    PERCH_DB_USERNAME: root
    PERCH_DB_SERVER: localhost
    PERCH_DB_DATABASE: molin.dev
    PERCH_DB_PREFIX: perch2_
    PERCH_TZ: UTC
    PERCH_EMAIL_FROM: you@example.com
    PERCH_EMAIL_FROM_NAME: andres fdez
    PERCH_LOGINPATH: /perch
    PERCH_PATH: webServer/sites/molin/public/perch
    PERCH_CORE: webServer/sites/molin/public/perch/core
    PERCH_RESFILEPATH: webServer/sites/molin/public//public/assets
    PERCH_RESPATH: /assets
    PERCH_HTML5: 1
    PERCH_RUNWAY:
    PERCH_ERROR_MODE: DIE
    PERCH_DATE_LONG: %d %B %Y
    PERCH_DATE_SHORT: %d %b %Y
    PERCH_TIME_SHORT: %H:%M
    PERCH_TIME_LONG: %H:%M:%S
    PERCH_PREVIEW_ARG: preview
    PERCH_TEMPLATE_PATH: webServer/sites/molin/public/perch/templates
    PERCH_DEFAULT_DOC: index.php
    PERCH_DEFAULT_EXT: .php
    PERCH_PRODUCTION_MODE: 100
    PERCH_RWD:
    PERCH_HTML_ENTITIES:
    PERCH_SSL:
    PERCH_AUTH_PLUGIN:
    PERCH_DB_CHARSET: utf8
    PERCH_DB_PORT:
    PERCH_DB_SOCKET:

Hosting settings

    PHP: 5.6.2
    Zend: 2.6.0
    OS: Darwin
    SAPI: apache2handler
    Safe mode: not detected
    MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: f373ea5dd5538761406a8022a4b8a374418b240e $
    MySQL server: 5.6.22
    Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, json, ldap, mbstring, session, standard, mysqlnd, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, mysql, shmop, SimpleXML, soap, sockets, exif, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, zip, apache2handler, apcu, curl, gmp, igbinary, imap, intl, mcrypt, memcache, memcached, mongo, mssql, OAuth, pdo_dblib, pdo_pgsql, pgsql, propro, raphf, readline, redis, solr, ssh2, xhprof, xsl, http, mhash, apc, Zend OPcache, xdebug
    GD: Yes
    ImageMagick: No
    PHP max upload size: 2M
    PHP max form post size: 8M
    PHP memory limit: 256M
    Total max uploadable file size: 2M
    Resource folder writeable: No
    Session timeout: 240 minutes
    Native JSON: Yes
    Filter functions: Yes
    Transliteration functions: Yes
    UNIQUE_ID: VKSJYcCoT0QAAIoKL3cAAAAJ
    HTTP_HOST: molin.dev
    HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:34.0) Gecko/20100101 Firefox/34.0
    HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_LANGUAGE: en-gb,en;q=0.8,en-us;q=0.6,es;q=0.4,es-es;q=0.2
    HTTP_ACCEPT_ENCODING: gzip, deflate
    HTTP_DNT: 1
    HTTP_REFERER: https://molin.dev/perch/core/settings/diagnostics/
    HTTP_COOKIE: PHPSESSID=3a9ir5s3f8nu7v43joh30frqj3; cmsa=1; cmssb=1
    HTTP_CONNECTION: keep-alive
    PATH: /usr/local/bin:/usr/local/sbin:/usr/X11/bin:/usr/local/php5/bin:/usr/local/php5/lib/php:/usr/local/mysql/bin:/usr/local/git/bin:/usr/local/share/python:/usr/bin:/usr/sbin:/usr/local/java/libraries:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/git/bin
    DYLD_LIBRARY_PATH: /usr/local/Cellar/httpd24/2.4.10/lib
    SERVER_SOFTWARE: Apache/2.4.10 (Unix) OpenSSL/0.9.8za PHP/5.6.2
    SERVER_NAME: molin.dev
    SERVER_ADDR: 127.0.0.1
    SERVER_PORT: 80
    REMOTE_ADDR: 127.0.0.1
    DOCUMENT_ROOT: /webServer/sites/molin/public
    REQUEST_SCHEME: http
    CONTEXT_DOCUMENT_ROOT: /webServer/sites/molin/public
    SERVER_ADMIN: you@example.com
    SCRIPT_FILENAME: /webServer/sites/molin/public/perch/core/settings/diagnostics/index.php
    REMOTE_PORT: 61149
    GATEWAY_INTERFACE: CGI/1.1
    SERVER_PROTOCOL: HTTP/1.1
    REQUEST_METHOD: GET
    QUERY_STRING: extended
    REQUEST_URI: /perch/core/settings/diagnostics/?extended
    SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
    PHP_SELF: /perch/core/settings/diagnostics/index.php
    REQUEST_TIME_FLOAT: 1420069217.75
    REQUEST_TIME: 1420069217
Drew McLellan

Drew McLellan 2638 points
Perch Support

Should all be ok, but I'll see if I can reproduce it. Does forcing an update help?

/perch/core/update/?force=update

no, it doesn't solve the problem.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, thanks. I'm trying to reproduce it here.

you can close this, i was trying to create links to pages, that's why i got the errors .