Posts by davidroberts

  • MariaDB (MySQL) database server upgrade from 10.2 to 10.5

    Hi,


    The server that I run a number of perch and perch runway sites on is upgrading the MariaDB (MySQL) database from 10.2 to 10.5 due to the end of the line for 10.2. I was wondering if anybody knew if this would have any negative effects on the sites that I run?


    I am running Perch Runway: 3.2, PHP: 8.0.17, MySQL: mysqlnd 8.0.17, with PDO and Perch: 3.1.7, PHP: 7.0.33, MySQL: 10.2.43, with PDO.


    Many thanks


    David

  • Archive URL's not listing the correct page

    That does not seem to work. On the Archive page I have a list of tags. When you click on a tag e.g. URL/blog/archive?/architecture it just give you a list of blog posts and not the architecture posts.


    The code that I have in the archive.php template is


  • Archive URL's not listing the correct page

    The Tag/Category URL's on the Archive page are not going to the correct URL and so are not showing the Tag/Category.


    For example on the blog page the URL is /blog/2017-10-25-handmade and the Tag is Handmade - /blog/tag/handmade. When you click on that it works. On the Archive page there are a list of Tags, when you click on Handmade the URL is /blog/archive?/handmade it just takes you to list of blog posts and not the specific tag. The same issue happens with the Category URL. How do I get the correct URL?

  • Editable region not showing on webpage

  • Editable region not showing on webpage

    I don't get anything on the page.


    But get this on the settings page.

    recover(): "> [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='6e6f5f5148ad4af007fde938963dcab0' LIMIT 1
    update(): ">UPDATE perch3_users SET userHash='f1a0f6806d99b4298f6e039143af3fb5' WHERE userID='1'
    get(): "> [20] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
    add_new_apps(): "> [6] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
    get_as_array(): "> [20] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
    get_menu(): "> [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
    get_items(): "> [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=1 ORDER BY mi.itemOrder ASC
    get_value(): "> [1] SELECT itemTitle FROM perch3_menu_items WHERE itemType='app' AND itemValue='settings' LIMIT 1
    get_menu(): "> [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
    get_items(): "> [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
    title_panel(): ">File: /core/settings/modes/basic.post.php
    Queries: 11
    Memory: 0.6501

  • Editable region not showing on webpage

    I have created an editable region on the home page called <?php perch_content('intro');?> and it shows up under pages Region= (intro) in the Perch Control Panel and I have added the text to the region (text block). The problem is it is not showing on the web page? Under location/path I have just added (/) as it is the 'home page' . The 'site' is just the index.html page with a number of editable regions.


    I have set up a rewrite in the .htaccess page to remove .php

    # Redirect index.php Requests