Login | Sign up | Toll-Free: 1-800-752-0455
 
 

Forum

 

11 posts by 3 authors in: Forums > CMS Builder
Last Post: January 30, 2018

I have been using CMSB for many YEARS and I must say this is an excellent product.

Over this time my database has reached approx. 30,000+ entries.

My issue is that periodically my page keeps blanking out whenever it loads.

I had this issue before and I am guessing there is some code to fix this but I cannot seem to find back that old post.

Any assistance will be appreciated. The php file is attached.

Here is the url: http://www.trinicarsforsale.com/database/featuredcarsList.php

Thank you.

Attachments:

featuredcarsList.php 37K

Hi wevolutions, 

Are there any entries under: Admin > Developer Log?  This would typically log any errors.

And if you're on an earlier version are you able to upgrade to the latest version?

Let me know,

Dave Edis - Senior Developer
interactivetools.com

Hi Dave. I am using CMS Builder 2.61 (Build 1058) and PHP v5.4.29 at the moment.

Before I upgrade to CMS 3.xx I need to upgrade my php version first.

Do you think I should do these upgrades and see if that works?

If yes, hopefully I will not have any issues with my current coding.

You could try just upgrading to 2.65 since error logging was added in 2.64.  The requirements are PHP 5.2.4+ and MySQL 5.0+.

If you email me at dave@interactivetools.com I can send you a zip.

Dave Edis - Senior Developer
interactivetools.com

By wevolutions - January 28, 2018 - edited: January 28, 2018

I did the upgrade to 2.65 and will soon upgrade to 3.11 after I install the new versions of php and MySQL.

I am getting one consistent error message:

E_WARNING: Invalid argument supplied for foreach()
/home/tcfs/public_html/database/featuredcarsDetails.php (line 116)

I am not sure if this is causing my page to blank out but please take a look and let me know.

Here is another one that I found but very few:

E_WARNING: number_format() expects parameter 1 to be double, string given
/home/tcfs/public_html/database/featuredcarsList.php (line 393)

Thank you.

Attachments:

featuredcarsDetails.php 14K

I found the old post concerning my errors from last time which may be similar to what I am experiencing now.

https://www.interactivetools.com/forum/forum-posts.php?postNum=2233553

I am thinking it has to do with my search queries to the database since I have over 30,000 entries.

Last time, editing the WHERE clause solved the problem.

Is there any way I can edit the search function to only check entries that are visible for the past 2 years only?

Hopefully this should be a help.

I did the update to Version v3.11 (Build 2156).

The error messages keep coming and the page still keeps blanking out.

Any assistance with this will be appreciated.

Thank you Leo. The error messages have all stopped now. I will monitor the page loading and let you know. Good job!

Something is still wrong and I believe that it has to do with the number of entries in my database and maybe the Search function is causing the page to crash.

Can I have tech support take a look at this for me please?

I will provide my FTP details and also any necessary fees attached.

I await a response. Thank you.