DELETE FROM gave the same error, but TRUNCATE TABLE worked.

I'll re-post if this happens again,

Jerry Kornbluth 

I'll give them a try first thing in the AM

Appreciate your help.

Jerry Kornbluth

Sorry to bother you all, but I can't seem to clear the developer log on one of my sites. GreenwichVillageFolkFestival.org (942 entries) and I'm out of ideas.

I thought that it might be related to the corruption of one of the files in my installation, so I tried both refreshing the files and then upgrading to CMSB 3.60 and PHP 8.2 but that didn't help.

I keep getting the MySQL Error: MySQL server has gone away in /home3/greenxm0/public_html/gvff/cmsAdmin/admin.php (line 46)

Any Thoughts?

Thanks,

Jerry Kornbluth

Nice addition, glad you had the time.

Do you mind if I include it as a recipe in my CMSB Cookbook

Thanks,

Jerry Kornbluth

What are you using now?

Jerry

Thanks for the insight.

It's so hard to tell.

I switched to Chrome and the code in Dreamweaver was fine.

After a few upgrades of Firefox, the issue seems to have dissapeared also. I'm using a really old version of Dreamweaveer though so maybe it was that after all.

Thanks for putting on your thinking cap though.

Best,

Jerry Kornbluth

That's good news.

Jerry Kornbluth

Jerry Kornbluth

I checkerd and it seems that it is fixed on this site, however I'd like to fix this on the other sites that I've got.

Can you share the fix?

Is this fix going to be rolled into an update?

Thanks,

Jerry Kornbluth

You can always resize the photos after upload by choosing the Maximum upload size:  as unlimited and then checking the Resize images larger than: and setting that for your optimum size.

I haven't had any issues with that, however, it sounds like you're still saying that you want a lower file size uploaded from the phone.

That would suggest a phone setting or 3rd party app for the phone.

Jerry Kornbluth

So is the problem that the file size is too large and take too long to upload? 

I assume you have the 'Maximum upload size:' unchecked in the field editor for the image in question.

Jerry Kornbluth

Just curuious if you were able to make any progress on this issue?

Jerry Kornbluth

I've submitted the support request

Jerry Kornbluth

Glad you could find a possible culprit.

Is there any way for you to check the php recipe code for any issues or required updates through consulting?

Thanks,

Jerry Kornbluth

That's Great News!

I have no idea what's possible, but I was thinking of an 'auto save' checkbox on the record that's being worked on that a non admin user could check,  If possible, the 'auto save' check box could be a special field that could optionally  be added to the section by the admin during design. 

And an option in the admin to set the auto save repitition rate (every 5 min, every 10 min, etc.) and possibly an 'always autosave' option for admins.

It would be nice if the auto save didn't bring the user back to the record list each 

It might be helpful if you asked the forum community for their input as well.

Best,

Jerry Kornbluth

Any chance that there's some interim code to effect the change youi suggested before it makes it to a finished feature request?

It has become torturous to access logs and clean up issues on my client's sites..

Thanks,

Jerry Kornbluth

Lately, when I copy any php code snippets from my CMSB Cookbook recipe detail page (that is displayed in the latest version of Firefox with standard security settings and no plugins), and try to paste it into a blank php page, I get a multitude of errors (I’m seeing them in Dreamweaver, image attached) and the errors also keep the page from displaying in a browser. A copy of a page with malformed code is also attached.

I can, however, generate clean detail viewer code for the detail page and any code copied from that page viewed in Firefox throws no errors and works correctly.

I can also view the recipe detail page in either Chrome or Edge, and any copied code snippet show no errors.

I'm running CMSB Version 3.57 (discovered the issue in 3.55 before I updated today) and PHP 7.4 (Bluehost hasn't updated my server to PHP8+ yet)

I’m pretty sure that it has something to do with the code on the detail page (attached) that is generating some non printable characters that mess with Firefox, but I’m pretty much at the limit of my expertise here.

The original code was created in December 2018 with much help from Daniel Louwe.

The original forum thread was: https://www.interactivetools.com/forum/forum-posts.php?81509
And the CMSB Cookbook recipe is at: http://www.thecmsbcookbook.com/recipedetail.php?324

Thanks,

Jerry Kornbluth

I first approached this topic back in 2020 but it seems to have fallen through the cracks.

I know it’s good practice to automatically expire login sessions after 30 minutes or so, and it’s also a good practice to save changes often.

But a number of times my clients (and I) have written text directly into a text box, or made other changes to a section, and have been so caught up in the moment, or distracted before saving our work, that our sessions have timed out, or we’re told that a "Security Error: No _CSRFToken exists in session. Try reloading or going back to previous page". After an attempt to comply, the information is lost forever and we have to go back to square 1.

So, my question is:

Is optional autosave  for the current open page a possibility?

Any other thoughts are welcome.

Thanks and stay safe,

Jerry Kornbluth

No worries...

I may have downloaded some from the forum itself, and a few others may have fallen by the wayside because of compatibility/update issues.

I'm going through what I have and will add them to the Cookbook soon.

Best wishes for the new year.

Jerry Kornbluth

Sounds like a useful plugin.

I'm sorry that the some of the user submitted plugins have disappeared from the IT site.

I'm going to go through the ones I have and make sure to add them to the CMSB Cookbook Site as well

Jerry Kornbluth

Care to share?

Happy New Year!

Jerry Kornbluth

Clearing worked, thanks for the tip.

I think that the feature request would solve what seems to be a recurring issue.

Thanks for your wisdom.

Jerry Kornbluth

I tried a whole range of perPage numbers and came up with 3 working (extremely slowly).

Could you explain why PHP is so finicky about memory with this section and not other sections with many records

Thanks,

Jerry

Jerry Kornbluth

Probably too simple to be the case, but clearing their cache sometimes does wonders in solving issues.

Give it a try,

There's also a recipe in my CMSB Cookbook that helped with a login loop using the Website Membership plugin

htttp://thecmsbcookbook.com/recipedetail.php?592

Good luck

Jerry Kornbluth