Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About sujag

  • Rank
    Jr. Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks for the suggestion. This works without syntax error, but doesn't give the expected results. Looking for a single (known) parent works. $regionEvents = $pages->find("template=veranstaltung,selectLocation.parent=14692,limit=$limit");
  2. I'm stuck with the selector syntax for a page reference field. After changing the site structure the old query $regionEvents = $pages->find("template=veranstaltung,selectLocation.parent=$reg,limit=$limit"); won't work any more, cause I now need a match for the grandparent of the page that is stored in the "selectLocation" page reference field. Just changing to $regionEvents = $pages->find("template=veranstaltung,selectLocation.has_parent=$reg,limit=$limit"); results in a syntax error "Unknown subfield: has_parent" What would be the right syntax in this case?
  3. I'm stuck finding the right selector syntax for an empty page reference field. I can select all pages with template "fest" that have an entry in selectLocation $oF = $pages->find('template=fest,selectLocation.id>0'); but now I need the contrary. Find all pages with template "fest" and an empty selectLocation My selectLocation Field is setup to reference a single page, but all tests with $oF = $pages->find('template=fest,selectLocation=FALSE'); or 0 or false won't work.
  4. There is no need to xxx the whole IP-address, this would indeed make no sense, only the last three digits are masked. Google analytics implements this as IP Anonymization (or IP masking) in Analytics to allow compliance to privacy statements and laws. https://support.google.com/analytics/answer/2763052?hl=en
  5. Another question. Would it be possible to partly anonymize the IP-Adresses? German (european?) privacy laws prohibit the permanent logging of ip-adresses as private data. A common solution that respects this while still allowing some analysis is to set the last triplet to 0 or xxx before it get's stored.
  6. no it was indeed the old PHP-Version. I finally found the place to switch and now the module works as expected. Thank you
  7. Yes it is the row LIMIT but it's indepedent of the value. Changing the value just alters the text of the error message: 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 ''100'' 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 ''25'' But I just notices, that this server still works with PHP5.6 I ask the hoster, if it is possible / planned to upgrade.
  8. Interesting module. It works in my local environment, but unfortunately online. Trying to view the statistics I get an unspecific server error (500), with Tracy debugger I get some details but don't have a clue what's happening. I assume some security setting on the host, but have no idea to find this.
  9. Thanks, this gave me indeed the necessary hint. a two step query seems to do, what I'm after $regionLocations = $pages->find("has_parent=$page"); $regionEvents = $pages->find("template=veranstaltung,selectLocation=$regionLocations,eventTime>$curYearStart")->sort('selectLocation');
  10. I'm having trouble by finding the right syntax for accessing ancestors of a page Reference field in a selector. I need to find all pages with a given template that include a page reference to some descendants of a given page. Working query is $regionEvents = $pages->find("template=veranstaltung,selectLocation.parent=$page,eventTime>$curYearStart")->sort('selectLocation'); but after changing site structure I need to find not only references to direct children, but also to grandchildren. I tried "selectLocation.has_parent=$page" but this throws an error "Unknown subfield: has_parent" Is this simply a syntax problem or do I need another way to find the pages I need?
  11. I don't really understand why, but it works, if I change lat lng values in a second step. $newPoi = $pages->add("tmbPoi", "$parentPage->url", [ 'name' => $thisPoiId, 'title' => $poi['name'], ... ] $newPoi->geolocation->lat = $lat; $newPoi->geolocation->lng = $lng; $newPoi->of(false); $newPoi->save('geolocation');
  12. I'm trying to automatically add pages containing a field with this fieldtype. while all other fields are populated as expected the lat/lng part of my geolocation field keeps its default values. Is there a special syntax to address these $newPoi = $pages->add("tmbPoi", "$parentPageId->url", [ 'name' => $poi['id'], 'title' => $poi['name'], 'PLZ' => $PLZ, 'Adresse' => $Adresse, 'body' => $descriptionHtml, 'geolocation->lat' => $lat, 'geolocation->lng' => $lng, 'canonical' => $poi->canonical ]);
  13. After adding an initial $gallery = new WireArray(); everything works as expected. Irritating with my first attempt was, that the copies of the image files where only added to the respective folder in assets/files but not to the database and the page images. At least this seems a little buggy to me.
  14. Most probably due to a lack of understanding of basic concepts I just produced a template that led to an explosion of disk space usage for the site. What I need(ed): Reusing images of certain pages for a gallery of other pages. I have a page with events that are linked to locations and want to show the pageImages of the eventPages and those Location-Pages in a gallery on the eventPages What I did: created a PageImages-Array from current (event) page $galleryfrompage = $page->images->findTag('galerie'); $gallery = $galleryfrompage; getting certain Images from connected location page $locImages = $loc->images->findTag('galerie'); adding $locImages to $gallery foreach ($locImages as $li) { if ($li != $introImg) { $gallery->add($li); }} what happened: with every visit of the event page a new copy of the images from the location page was copied to the event page I now try a new attempt without pageimages but wanted to ask, if this behaviour would have been obvious for you.
  • Create New...