can't clear error log

5 posts by 2 authors in: Forums > CMS Builder
Last Post: July 30, 2020   (RSS)

By gregThomas - July 29, 2020

Hey Craig,

A couple of questions to help me diagnose the issue:

  • Are the other sections appearing in the database with the correct prefix? For example, is there a table called cms_accounts or cmsb_accounts?
  • It sounds like the old version of the CMS and upgraded version is on the same server, is that correct?

Cheers,

Greg

Greg Thomas







PHP Programmer - interactivetools.com

By craig_bcd - July 29, 2020

Hi Greg - 

Thanks - in the database they are all cmsb (see attached).  They were upgraded on the same server - I made a copy of the directory with the website in it and upgraded it so that I could move it to the new version of php and of cmsb.

Regards,

craig

Attachments:

table-prefix.PNG 97K

By craig_bcd - July 29, 2020

Ok Greg - 

After mucking around a bit I was able to resolve the issue - I think the log just got enormous like gigs enormous.  i was able to find it and clean it out at the sql level.  I guess the last question I have is can I remove all of the cmsb_ prefixed tables since it looks like those tables were all copied to cms_ 

thanks for the help - I really appreciate the support you guys provide.

Regards,

Craig

By gregThomas - July 30, 2020

Thanks Craig!

I'm basing this on my understanding of your previous posts, so I can't be 100% sure. But, if you're using the same database for the old and new installation, the cmsb_ prefixed tables are likely from the old installation. I can't really make the call if you're safe to delete those tables without investigating myself. 

If you do decide to delete them, you should ensure you make a full backup of the database before making any modifications and perhaps test by deleting a single table first (perhaps the error log) then confirming that change hasn't had any impact on the new installation. Also, I'd recommend confirming that none of your other sites is using this database and they could be the source of the cmsb_ prefixed tables as well.

You should also make sure that all of your front end pages are connected to the new CMS and any pages that perform CRUD functions on records are being made in the new tables. 

Cheers,

Greg

Greg Thomas







PHP Programmer - interactivetools.com