herr rilke

✅ yes, database is mysql 8

hi there i get a 500 server error when trying to switch to any other view ("Days of Month", "Last 30 Days" ...) than the initially displayed one. found an entry in exceptions: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 1' at line 1 In /site/modules/ProcessPageViewStat/ProcessPageViewStat.module line 1693 any idea?

here is a short update on the spam issue: the switch to reverse input of characters has brought peace: no more spam! hurray ?

hi jürgen, put that reverse wording thingy in place. will report ? all the best

hello, does anyone have experience with this module on publicly accessible pages (i.e. not behind a login or something)? despite the honeypot, maximum failed attempts, minimum completion time and captcha, i still receive at least 3 spam emails a day.

that's why i choose your module!

OT: That is one main point that attracted me. I've been working with Contao for years, but it's complicated in another dimension and very error-prone in setup and update when dealing with different customer environments. It consumes hours of my time in places I can't foresee. (but has a built in form builder ?)

junge, wie genial!? thanks a lot for your fast & brillant support! as a newbie i'm impressed by a community that seems to be not to big at first sight but is quick, friendly & helpful!

... nearly too easy ? any chance to wrap the input field? and can i translate the wording? thanks for your patience & time, jürgen! all the best

all right. then it was me looking in the wrong place. so the file's there and same as on github.

thanks for your quick answer, jürgen! more than strange: the file was not even in the directory at all! usually i'd expected a 404 error. is the generated path correct? https://www.domain.de/captchaimage.php?formID=contact&cat=text&type=SimpleMathTextCaptcha best

other question: h ow can CSRF be implemented in the form?c any help is apreciated

ok, good to know! thanks for sharing! there are approximatley 100 documents and > 200 users. so i think i'm heading to the SQL solution.

wunderful! thanks for the hint! that does the job exactly as otherwise done with SQL

hello jürgen, thanks a lot for your work! while getting 5 spam mails during the first 12 hours of having my form online (even using honey pot option) i decided to enable a captcha. but that doesn't show! PHP 8.1.22 processwire 3.0.224 frontendforms 3.1.45 phpinfo(): GD Support enabled GD headers Version 2.3.0 GD library Version 2.3.0 FreeType Support enabled FreeType Linkage with freetype GIF Read Support enabled GIF Create Support enabled JPEG Support enabled PNG Support enabled WBMP Support enabled XPM Support enabled XBM Support enabled WebP Support enabled BMP Support enabled TGA Read Support enabled Directive Local Value Master Value gd.jpeg_ignore_warning 1 1 the HTML output is: <div class="form-control captcha" id="contact-captcha-inputwrapper"> <div class="image-wrapper"> <img class="captcha" alt="Captcha" src="/captchaimage.php?formID=contact&amp;cat=text&amp;type=SimpleMathTextCaptcha" id="contact-captcha-image"></div> <div class="reload-link-wrapper"> <a class="reload" href="#" title="Click to load a new captcha" id="contact-reload-link" onclick="reloadCaptcha('contact-captcha-image', event)">Reload image</a> </div><input id="contact-captcha" name="contact-captcha" type="text" class="input" required=""> </div> any idea? edit: an error 500 is reported for captchaimage.php

thank you, bernhard, that was very enlightening! I think the third approach (with an own table) is the most suitable for me. i also understood better how i can implement such an approach.

Hello all, I am thinking about the following requirement: there are documents (pages) and users. the user should now be able to mark a document as "read" by pressing a button. when he then calls up the document again, he finds a "read" marking - so he knows that he has done everything here. do i now create a new subpage via API, which only has the fields "pageID" and "userID" for that? and would that be an extra query on each page load to see if the combination of userID and pageID already exists to display a marker?

thanks anyone and thank yout, robin s, that was the solution! plus i guess i spent some money on pro fields ?

hi everyone, i'm pretty new to processwire and trying to figure out if pw is a replacement for contao in same use cases. so many interesting concepts - but still not to easy to set up a page with sections and all that ? anyway: i am able to output all children of a given page by their template: // only templates starting "section_" $tpls = $templates->find("name^=section_"); foreach ($page->children("template=$tpls") as $child){ $content .= $child->render(); } these children were insertet by a pagetabel field and they are rendered as expected. if i try to do that using the pagetable object, it does not work: if ($page->pagetable) { foreach ($page->pagetable as $pt) { $content .= $pt->name .'<br>'; // works $content .= $pt->id .'<br>'; // works too $content .= $pages->find('id=' . $pt->id)->render(); // returns a formatted link ... ?! } } surprisingly that only give's me a link to the child page instead of display it's contents. anyone to guide me... ?

hi aComAdi, how did you solve the problem? running into this... some years lager ?

ah: processwire is 3.0.210

hey kaz, how did you solve that error? i ran into the same issue today.