Jump to content

Beluga

Members
  • Posts

    528
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by Beluga

  1. Any more interesting problems discovered? pwFoo: did you get the frontend stuff working? If you are confident that it works flawlessly, the a guide could be added to https://github.com/caddyserver/examples
  2. Unfortunately, the shared hosting does not support SSH access Another minus..
  3. Ok, it seems the images were not the only problem after all. Still crashing and with this: Error: Exception: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /home/sitename/www/wire/core/Pages.php line 2103) #0 /home/sitename/www/wire/core/Pages.php(2103): PDOStatement->execute() #1 /home/sitename/www/wire/core/Pages.php(546): Pages->executeQuery(Object(PDOStatement)) #2 /home/sitename/www/wire/core/PagesType.php(260): Pages->getById(Array, Object(Template)) #3 /home/sitename/www/wire/core/Users.php(33): PagesType->get(1122) #4 /home/sitename/www/wire/core/Session.php(102): Users->get(1122) #5 /home/sitename/www/wire/core/ProcessWire.php(279): Session->__construct() #6 /home/sitename/www/wire/core/ProcessWire.php(94): ProcessWire->load(Object(Config)) #7 /home/sitename/www/index.php(232): ProcessWire->__construct(Object(Config)) #8 {main} and also the max_user_connections error. I think the user was in the admin trying to expand some pages for editing, at least he said so to me. Yet the big choking seems to be gone. I personally did not encounter any problems with quick testing.
  4. So what is the mechanism that wrong permissions cause files to not be skipped? The files that seemed to be in a processing loop were huge pngs (two files, 14.3M and 9.5M). It had done processing on them at 05:40 in the morning. I replaced them with jpgs. Now the problem seems to be gone. However, images these days are big. I need the memory headroom so I will continue to try to get the Kimsufi server.
  5. Now I checked with FTP and to my dismay, there are freshly generated -pim2 versions in the assets! What should I be looking for regarding permissions? Images are 0644 and asset folders 0755. Thanks for the insight. As you can guess, this has been a major pain in the butt for weeks. That said, when I started using PIM and generated the files for a gallery, it already choked on the first run. So I think I have to get the Kimsufi in any case. It will also enable users to upload files larger than 60M without me having to do a workaround with PW API every time.
  6. It can't be crawled as there is a .htaccess password protection in place. I can't check the caching currently as I cannot enter the site or admin at all (since Feb 25th). Image resizing happens with Page Image Manipulator, but if copies have been rendered to disk, it will skip those, right? This is how it seems to have worked based on the file creation dates. It can't be all because of PIM, as even direct admin access has failed many times since January. Front page does not have images to resize and same phenomenon has happened with it. New image uploads are rare.
  7. For 3 euros, yes, but the limits are the same in ALL of their shared hosting offerings. Visitors are only a handful of people maximum at the same time. But now it has been completely inaccessible for me for 4 days. Even the webtrees install (genealogical db)! So something is wrong with their system. OVH is fine otherwise and I would like to stay with them, but their shared hosting limits obviously do not mesh with PW. I ran the command show status like '%onn%'; in phpMyAdmin and got this: Aborted_connects 66404 Connections 49920995 Max_used_connections 286 Ssl_client_connects 0 Ssl_connect_renegotiates 0 Ssl_finished_connects 0 Threads_connected 7
  8. The reason is those errors and how it is crashing all the time. It is a very normal site and not much visitors, as it is restricted to (genealogical) family members. I have a menu done with this technique: https://processwire.com/talk/topic/10448-css-only-responsive-multi-level-menu/ It has 4 levels maximum. The menu and page image manipulator are the most demanding tasks I guess.. but the host falls on its face.
  9. So my site is completely unusable now for 4 days straight. Intermittent crashes have happened all the time since January. I might get nearly 300 error emails in one go. Page: http://sitename.fi/?/ User: ? Error: Exception: SQLSTATE[42000] [1203] User sitename already has more than 'max_user_connections' active connections (in /home/sitename/www/wire/core/ProcessWire.php line 216) #0 /home/sitename/www/wire/core/ProcessWire.php(94): ProcessWire->load(Object(Config)) #1 /home/sitename/www/index.php(232): ProcessWire->__construct(Object(Config)) #2 {main} OVH told me max_user_connections cannot be raised. I also got these related to Page Image Manipulator module: Error: Maximum execution time of 1200 seconds exceeded (line 157 of /home/sitename/www/wire/core/Pageimage.php) and SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /wire/core/Pages.php line 2103) One tip on the PW forum was to raise the MySQL max_allowed_packet value, even up to 32M, but OVH told me it is 1M and cannot be changed. No OVH shared plan helps with these limits. I've been trying to get a hold of the cheapest dedicated Kimsufi servers: https://www.kimsufi.com/ They are very hard to get as supply does not meet demand. Hopefully this will improve my chances: https://github.com/MA3STR0/kimsufi-crawler I read some have even written bots to automate the purchase. I'm afraid I can't beat that..
  10. PW = Framework + a CMS as a little bonus
  11. Free gogs hosting for open source projects is offered by https://notabug.org/
  12. So what do you think of Halite? It was in the post I linked to in my own topic. Interestingly the upcoming version will require PHP 7.
  13. I have asked this before: Should PW use a cryptography library?
  14. http://processwire.com/blog/posts/happy-new-year-heres-a-roadmap-for-processwire-in-2016/#what-else-is-coming-for-processwire-3.x-in-2016
  15. Thanks for this. I do get the assets copied over to the destination page's asset folder, but somehow the actual contents of the fields do not get copied over. I wonder, why that might be? They have the exact same fields. Textarea, Image and File. Same result, if all or some of the fields have content. I do get the echo for all the fields per the foreach. Here is how I run it: include 'index.php'; //copies the fields of one page to replace the fields of another page. function copyFields ($sourcePage, $destinationPage) { //Copy Fields between pages $destinationPage->of(false); $sourcePage->of(false); foreach ($destinationPage->template->fieldgroup as $field){ if($field->type instanceOf FieldtypeTable){ //You get duplicate SQL index errors if you don't use clone. $destinationPage->$field = clone $sourcePage->$field; }elseif($field->type instanceOf FieldtypeTextarea){ //Update image and file links in rich text fields $destinationPage->$field = str_replace("/files/{$sourcePage->id}/","/files/{$destinationPage->id}/",$sourcePage->$field); echo "kloonattu textarea"; }else{ $destinationPage->$field = $sourcePage->$field; echo "kloonattu joku kenttä"; } } // Copy $sourcePage's files over to new page if(PagefilesManager::hasFiles($sourcePage)) { $destinationPage->filesManager->init($destinationPage); $sourcePage->filesManager->copyFiles($destinationPage->filesManager->path()); } return $destinationPage; } $lahde = $pages->get('1077'); $kohde = $pages->get('1225'); copyFields($lahde, $kohde);
  16. I get these in OVH shared hosting. Updated PHP from 5.6 to 7, but it didn't help (well, it really seems to be about the db itself..) I get this even when trying to access the front page which doesn't have much else than the navigation menu. Menu is done using this: https://processwire.com/talk/topic/10448-css-only-responsive-multi-level-menu/ Root has 4 children. One of them has 9 children and each of those 3 grandchildren and some of the grandchildren have children of their own. Could walking this structure really bring the DB down? Is there anything I can do except switch to dedicated hosting (cheapest Kimsufi is only 6 euros per month)? According to OVH support, the MySQL variable max_allowed_packet is probably 1M and it cannot be raised. Edit: here is the other type of message I get: I might get over 200 error emails in one go.
  17. Well I am running PW 2.7 in OVH shared hosting with PHP 7 and no issues so far.
  18. @jordanlev: I wonder, if this recent improvement would make your reporting use-case fast: http://processwire.com/blog/posts/processwire-3.0.6-brings-pages-upgrades-and-link-abstraction/
  19. I have mentioned Lost Grid before. Recently Cory Simmons transferred the project to Peter Ramsing: https://github.com/peterramsing/lost From the roadmap: Looks like Cory can't stop creating new grids, though https://github.com/posthumans/postcss-ant-grid
  20. You guys find out anything to improve in PW core?
  21. A little tip that non-advanced users like me might appreciate: foreach ($galleryimages as $image) { ini_set('max_execution_time', 1200); // this line resets the timer for max_execution_time with every loop. $infoarray = $image->pim2Load('f-')->getImageInfo(); $thumb = $image->pim2Load('t-')->width(200)->pimSave()->url; $full = $image->url; if ($infoarray['width'] > 2000) { $full = $image->pim2Load('f-')->width(2000)->pimSave()->url; } echo "<div class='galleryimage'><img class='jslghtbx-thmb' src='$thumb' data-jslghtbx='$full' data-jslghtbx-group='galtsu' data-jslghtbx-caption='$image->description'></img></div>"; } That code will skip resizing with PIM, if the original width is not over 2000px.
  22. I just discovered that if I have a Leaflet Map marker field in a template, but leave the lat and long empty in a page, CKEditor text field will not display its toolbar. Must be some JS meltdown. I left the lat and long empty, because I am populating the map with an array of markers. It is no problem after I discovered this (just added lat & long values to make it work), but it was quite frustrating at first
  23. In the future, please only post once. Now you just made unnecessary work for the moderators as they will delete your other posts.
×
×
  • Create New...