Jump to content

Erik Richter

  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

1,245 profile views

Erik Richter's Achievements

Jr. Member

Jr. Member (3/6)



  1. 500 Internal Server Error... 😬 as soon as I add $finder->query->where
  2. @bernhard Thanks for the quick response! Would I add the regular field names in the selector? <? $finder = $rockfinder ->find("template=physician, limit=12") ->addColumns(['title', 'created']); $finder->query->where("physician_profile_geo_lat >= $roundMinLat"); ... $finder->query->where("physician_profile_geo_lat >= $roundMinLat"); $rows = $finder->getRows();?> Thank you!!
  3. @bernhard Really great module!! I have around 1 mio pages, and it is pretty fast as long as I don't do comparisons. With more complex finders it is really slow on my end. I need to do a radius search, comparing lat/long fields to min max: <? $finder = $rockfinder ->find("template=physician, physician_profile_geo_lat>=$roundMinLat, physician_profile_geo_lat<=$roundMaxLat, physician_profile_geo_long>=$roundMaxLon, physician_profile_geo_long<=$roundMinLon, limit=12") ->addColumns(['title', 'created']); $rows = $finder->getRows();?> This is really realy slow - any tips on optimizing this? I switched to RockFinder, hoping that it would increase speed, as I reached the limits of usability with the usual $pages->find with this, too. If anyone has ideas or tips, I'd appreciate it!
  4. @cst989 Hey! I changed the fieldtyp to float in database, but still: as soon as I have negative longitude, I get no results.. any tips? Thank you!!!
  5. EDIT2: Actually I've been stupid, mixed up Max and Min for the negatives. Everything works now - pretty slow tho.. If anyone has tipps on making queries faster (talking 1 mio pages) Let me know! Hey guys, Is it possible to change fieldtype text to float for a live website? I have about 1 Mio pages with Lat/Long coordinates (from geocoding) stored in a TEXT field. Works perfectly for displaying on maps etc. - but now I wanted to implement a query filtering for radius (min/max gets calculated correctly before). This $pages->find does not find results, and I suspect it is because some values are negative? (Lang: -80.45550 for example). $pages->find("lat>=$minlat, lat<=$maxlat, lang>=$minlng, lang<=$maxlng") -> fields are TEXT fields. It looks like the Comparison operator is not working here. Any tips on this? Thank you!! EDIT: I just changed the fieldtype to Float via Tracy Adminer... no change. The operators are still not giving any results. Strange. Hopefully anyone here has an idea!
  6. @elabx thanks for the fast response! Search is fast - as long as one picks at least one filter/selector. Displaying all 1,2 mio results takes about 14-16 seconds, even with the limit and pagination. I guess its because of the count?
  7. Hey @elabx, what solution did you come up with in the end? I also am paginating (when no filters have been selected) 1,2 Million pages, and the response time is about 15 seconds - which is not usable. Let me know if you found a good solution - thank you!!
  8. Hey guys, Im trying to sort pages depening on the count of pages who has them selected as page reference (the new owner selector might be handy for this?). my array is: $array = $pages->find("template=xx, sort=-profile_linked, sort=title"); I want to add a third sort which sorts the count of pages that have the array pages in a page reference field called "refField". What I tried: $array = $pages->find("template=xx, sort=-profile_linked, sort=title, sort=refField.owner.count"); Obviously this isn't working.. can I use the owner-selector for this at all? Or what would be the best practice? Thanks in advance!
  9. @LostKobrakai thanks for the explanation! very helpful. Actually I created a second datetime field now, where I store the walltime of the user when the post is created. I just use this field then to display the time on frontend, instead of created. Messing with the actual created date could really make problems - thanks for the insights - especially because you still want to keep the real "order" (dependend on UTC or a universal time) of posts, even tho individual local time is different.
  10. @kongondo, @Sergio thank you guys! Users are logged in, but only use the fronend of the website. Would best practice be to store the users time in a hidden field (get it via javascript), submit it with the form, save it as a variable to php, do the $p->save and after that change the created date with the one from the variable and save again?
  11. Hey Guys! Hopefully someone can point me to the right direction. On my Website logged-in users can publish posts, like facebook or twitter on the frontend. These posts are created as pages via API. Since I have visitors/users from different places of the world, I need to have the created-date of the page respecting their timezone. Anyone has an idea how to grab the visitors/browsers timezone/time and use it for $page->created instead of server time? Thank you so much in advance!
  12. thank you everyone!! bernhard, this last link is awesome - just tried it. great stuff, also with a nice UI. Just what I was looking for.
  13. Hey everyone! Have just been using Ryans "Import pages from csv" module, because the UI is really nice and easy (connect fields). I always get 500 Timeouts after about 30sec, when the csv has more than 1500 rows. I already increased memory limit and other php.ini settings - doesn't help at all. When I double-check after the timeout, always only about 1500 pages have been created.. Surprisingly: deleting 2500 pages via Api or admin-actions is possible and no timeouts. So what is best practice to import 1 Million pages from a .csv ? (I already have smaller chunks of the .csv, tried with 2000, 3000 - only 1500 worked..) Help is much appreciated 🙂
  14. Shame on me! Looks like you HAVE to set a title when creating via api? at least inside a foreach loop. When I set a title, everything works - thank you again! Now I need to solve this ajax admin endless spinner thing, when trashing pages..
  15. Crazy, since today I have it all the time, and nothing has really changed. The never ending spinning circle and then the Bad gateway/unknown error. Regarding the main issue: $period is just a placeholder, I also tried it with other variables. The template file only has this little piece of code: <?php $pgs = array("1","2","3","4","5"); foreach ($pgs as $pi) { $p = new Page(); $p->setOutputFormatting(false); $p->template = 'test'; $p->parent = $pages->get(1); $p->save(); $p->title = $pi; $pages->uncacheAll(); } ?> I also tried it with title and name, that should not be the problem tho, since PW gives titles automatically if none are provided. Also creating only one page like this works perfectly. I work with the latest stable version of PW, not too many modules, since I just started to build the site. Also debugging is on, and Tracy doesn't provide interesting insights. Also: after the page breaks I can't access admin for some seconds to minutes. If I open a new private window tho, it works? Also: it seems like sometimes at least 2 or 3 of those pages are being created (see them in admin), even tho the page with the template gives the error and doesnt load when accessed. This is really crazy and I have no idea whereelse I could look
  • Create New...