Can't acccess my developer log

12 posts by 2 authors in: Forums > CMS Builder
Last Post: February 14, 2023   (RSS)

Hi All,

I can't seem to access my developer log (626 records in the log) even when appending &perPage=5 to the URL https://greenwichvillagefolkfestival.org/gvff/cmsAdmin/admin.php?menu=_error_log&perPage=5

I keep getting what I think are a version of a time out errors like: Notice: MySQL Error: MySQL server has gone away - in mysql_functions.php on line 226 by mysql_get_query() in /home3/greenxm0/public_html/gvff/cmsAdmin/lib/common.php on line 281 

I'm using Version 3.57 with PHP 7.4 with Server Resource Limits CPU Time: unlimited, Memory Limit: unlimited, Processes: unlimited - ulimit >>

I just tried to access 'View PHP Errors and Warnings >>' from the Admin General page and got this error: Warning: mysqli::query(): (HY000/2006): MySQL server has gone away in /home3/greenxm0/public_html/gvff/cmsAdmin/lib/viewer_functions.php on line 443 MySQL Error: Malformed packet 

Any thoughts?

Thanks,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By Dave - December 22, 2022

Hi Jerry, 

This sometimes happens when there is so much data in the error log that PHP runs out of memory trying to load it.  

Can you try &perPage=1 on the end of the URL and see if that works?  

If so try larger and larger numbers until you find the limit and try and erase some of the records (if you don't need them).

Let me know what happens.  

Thanks!

Dave Edis - Senior Developer
interactivetools.com

By gkornbluth - December 23, 2022 - edited: December 23, 2022

Good morning Dave,

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

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By Dave - December 27, 2022

Hi Jerry, 

Can you try clearing the log with this direct link?  

?menu=_error_log&action=clearLog

The error log logs *everything* in memory so loading it can also take a lot of memory.  We can add a feature request to optimize that page so it just loads whats needed for the list display in future.

Let me know if clearing it works.

Dave Edis - Senior Developer
interactivetools.com

Hi Dave,

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

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By Dave - January 12, 2023 - edited: January 12, 2023

Hi Jerry, 

Sure.  Can you email me CMS and FTP details for a site that's having the issues?  Then we can use that to develop a solution.

Note, email, don't post login credentials to the forum.  I know you know, but I always say that now anyways! ;-)

Thanks,

Dave Edis - Senior Developer
interactivetools.com

Hi Dave,

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

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By Dave - February 3, 2023

Hi Jerry, 

Yea, my understanding was this was fixed on the site.  Can you confirm?  

Sorry if that didn't get communicated back to you.  Let me know if you need anything else.

Cheers, 

Dave Edis - Senior Developer
interactivetools.com

By gkornbluth - February 3, 2023 - edited: February 3, 2023

Hi Dave,

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

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php