Page keeps blanking out

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

By wevolutions - January 26, 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

By Dave - January 26, 2018

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

By wevolutions - January 26, 2018

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.

By Dave - January 26, 2018

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

By wevolutions - January 28, 2018

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.

By wevolutions - January 29, 2018

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.

By leo - January 29, 2018

Hi,

I have looked at the lines in the script that gives you those errors. You can try the following methods to fix the errors and see if everything works fine:

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

- Open featuredcarsDetails.php. In line 116 you have this code:

<?php foreach ($featured_carsRecord['main_photo'] as $upload): ?>
...
<?php endforeach ?>

- Try wrapping the foreach loop with an if statement checking if "main_photo" is empty:

<?php if(!empty($featured_carsRecord['main_photo'])): >
<?php foreach ($featured_carsRecord['main_photo'] as $upload): ?>
...
<?php endforeach ?>
<?php endif ?>

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

- Open featuredcarsList.php. In line 375 you have this code:

<?php echo number_format ($record['asking_price'] ,0) ?>

- Use intval() to get the numeric value before passing to number_format:

<?php echo number_format (intval($record['asking_price]), 0) ?>

Let me know if it works!

Thanks,

Leo - PHP Programmer (in training)
interactivetools.com

By wevolutions - January 30, 2018

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.