DrewPH

I found that all I needed at the end of my config.php was $config->dbInitCommand = "SET time_zone = '+08:00' "; and all is good, warning gone. Thanks again.

So the correct place is config.php - thanks very much, will try this.

This refers to the issue posted here: https://processwire.com/talk/topic/30845-solved-database-time-vs-php-time/ However I've posted a new topic because the above topic was marked solved by the OP. I'm getting the same error: Warning, the database time differs from PHP time by 8 hours. 2025-02-12 09:51:44 - database time 2025-02-12 17:51:44 - PHP time Please edit your /site/config.php file and update your $config->timezone to match that of your database. See PHP timezones list My MySQL installation has to remain set to UTC, because it serves various sites in various timezones. I learned here: https://stackoverflow.com/questions/19023978/should-mysql-have-its-timezone-set-to-utc/19075291 that I can set the session timezone in MySQL, with this command, which I think will solve my problem: SET @@session.time_zone = "+08:00"; My question is, from which ProcessWire file should I execute this, in order for it to prevent the above warning? site/templates/_init.php or somewhere else? Thanks in advance.

Well spotted! Except I emigrated from Malta to the Philippines in 2019, so I don't think I could claim that! But the (100% genuine) testimonial stays because Malta is where I grew my business and is still where most of my active clients are.

Now tested (I used the module configuration field) and it works perfectly. Thanks again.

Brilliant, and once again very fast. I'll try it out as soon as I can.

Hehe, ProcessWire Weekly #546 RSS just dropped into my Reeder app and it seems ZigPress is site of the week! 😊 I'm extremely flattered and honestly quite surprised considering the high standard of sites in the showcase... thanks to whoever made the choice.

JS error resolved with the new file, thank you! I'm not using the language option at all (and don't expect to in the near future), so an independent override would be really great when you have the time, thanks.

Quick note: my logs are telling me that someone viewed the site from here with Mobile Safari and the page tried to load script files from the wrong path. Only possible reason: they must have viewed the page before (when it was still WordPress!) and it got cached. So if you took a look and the site looked completely broken, just clear your browser cache :-) I've now added anti-caching directives.

Here's my next ProcessWire build. After dipping my toe in the ProcessWater with a simple holding page ( https://www.threehills.farm/ ) followed by a blog ( https://www.eltikon.online/ ) that I shared here, this time I have focussed on a site that uses the Repeater Matrix to manage blocks of content, in order to see how easy it is to transfer my WordPress "Advanced Custom Fields Flexible Content" approach to ProcessWire. Result: it's really easy once you get the hang of it. Site: https://www.zigpress.com/ This is my business site, and is a single-page site (plus 404 etc) where each section of content is managed in a Repeater Matrix. Modules installed: AdminStyleRock (so I can use my Nord admin stylesheet!), Pro Fields Repeater Matrix, Seo Maestro, FrontendForms, Less, Redirects, my own ZP Traffic module, and Wire Mail SMTP. I also included Perishable Press's 7G Firewall. I still have more testing to do now that it's live, but it seems to be behaving OK so far. All feedback welcome, including criticism/bugs/whatever.

I'm almost done with my integration of this module, and it's working great. WireMail and WireMailSMTP integration was easy. I have 2 issues though: 1. On AJAX submission, the loading message "Please be patient... the form will be validated!" seems to be hard-wired. Would you be able to offer some way for developers to override it with their own custom text? For example, I'd like my site to simply show "Submitting your enquiry...". 2. Whenever I type into my textarea form field, my JavaScript console gives me this error: Uncaught TypeError: Cannot read properties of null (reading 'children') at HTMLTextAreaElement.<anonymous> (frontendforms.js?v=2.2.17:455:29) I think it's something to do with the character counter, which I have not enabled. And the form still submits OK. Thanks in advance for looking into these issues!

That was unbelievably quick... thanks very much :-)

I'm trying this module out in a site I'm building, and it looks like being ideal. I appreciate you developing and supporting it. However, I've run up against a class naming conflict... In frontendforms.css, in the "Slider Captcha" section, there is .block { position: absolute; left: 0; top: 0; } This has instantly nuked my entire page layout, since I'm building the site with RepeaterMatrix fields and am using "block" as the main class for each matrix! I know I can use a different class name or override the attributes, but I'd like to suggest that modules should be as specific as possible in their CSS usage in order to avoid conflicts, especially with a word as generic as "block". Is it possible for you to use a wrapper class in the css file, so that other classes named "block" are not affected when this module is installed? Something like this: .sliderCaptcha .block { position: absolute; left: 0; top: 0; } Then, in AbstractSliderCapture.php, you could have something like this on line 48: return '<div class="sliderCaptcha" id="' . $formID . '-captcha" data-validated="false"></div>'; I may have missed something you'll need to change but I'm sure you get my point. Hope you can consider this - thanks!

Thanks, I'll check it out.

@Ivan Gretsky Thanks, that works! I came across the columnWidth attribute at some point but then lost where I had seen it. @bernhard Thanks for the link. For commercial sites I'd probably install that - however this is my "learn how to build a module" module 😀