Posts by ellimondo

    Hi


    I am getting the following Runway backup error for a client on Ionos shared hosting. Any ideas how to resolve?


    Thanks in advance,


    Jon

    Code
    1. SQLSTATE[HY000]: General error: 1785 Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional

    Hi


    Categories and collections are two core parts of Perch (and Runway) so I don't think you are going to have to transfer categories to collections, unless your categories start storing large amounts of data or relationships.


    The biggest issue you are going to have is that (as far as I am aware) the Events app is not being updated or developed and therefore won't receive support anymore. If there's a new version coming then you'd need to ask the owners. It's all a bit quiet on that front at the moment…


    Most of the Events app can be replicated using Collections as far as I know. Not used Events myself.

    Hi


    You need to contact the host. The entire site is down. This would be due to an unpaid bill or the host shutting down the site because of security issues.


    Many hosts are banning unsecured forms. If they see abuse you have to show some kind of proof of protecting the form submission. Honeypot fields are not enough anymore.


    Jon

    I wouldn't do a global change on such a small phrase. Restrict your search to inside the perch/template folder.


    You should not give too much control to the user in content - use CSS to style for consistency across the website.

    Do you have the ckeditor add-on installed? It's not part of the core Perch these days. Redactor is the default WYSIWYG editor.


    e.g. If not then just change your editor="ckeditor" to editor="redactor".

    It goes the other way round. If you match the filter to the 'location' related in the 'shop' collection then the second collection call in the each loop will populate the first collection with all the results from the location collection that match the 'shop' collection related field.


    In this case all 'location' collections associated with the "shop' collection. It does the same as the template but just gives you the opportunity to manipulate the array before passing it into a template.


    This would also be useful if you want to loop through a collection listing another collection that relates back to that original collection. I've used it for looping through a seminar timetable where I had Days and Seminars. If I want to display the day with associated seminars I then need to loop through the days, and for each day output a collection of seminars that have the same related day field.


    Mine got complicated because I needed a third loop for theatres. But it works fine, apart from being able to order items on multiple fields which is not yet possible in Perch.


    You can see it in action here: https://www.wibexpo.co.uk/whats-on/seminars/. It also generates a pdf using perch_template.