Page keeps blanking out
11 posts by 3 authors in: Forums > CMS Builder
Last Post: January 30, 2018 (RSS)
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.
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,
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.
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.
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.
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.
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,
interactivetools.com
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.