0 Members and 1 Guest are viewing this topic.

*

heebeha

  • ***
  • 102
  • Me
We installed 150,000 profiles on our osdate evo 1.2 website and now we are getting a 500 error on the index.php page.

When we loaded 1000 profiles as a test the site worked perfect.   

Is there a cache setting that is causing the site to time out?  Its really weird because its only occurring on the index.php homepage.

See the site working on a page other than the index.php page here: http://dateinasianow.com/index.php?page=services
When you go to the homepage it will not load.  But every other page loads fine, even the search feature works fine

Any advise would be very much appreciated.

*

Pharg

  • *****
  • 2,843
    • OsDateFourm
  • osDate Version: osDateEvo v1.2
Hi heebeha,

I don't see a 500 error I see a white page which might suggest there is a template error or a database error.

I also checked the Page source which is also empty.

The cache is in the temp/tempate_c/ folder you can delete anything inside the /tempate_c/ folder but I am betting that won't fix the issue.

If the test worked fine then I would suggest you import the user profiles only from that database into this database.
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.2 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35

*

heebeha

  • ***
  • 102
  • Me
We added this to the index.php file and it solved the problem
<?php ini_set("memory_limit","128M"); ?>

The site was attempting to wish everyone a happy birthday.

Anyone know how I can limit the number of birthday announcements on the homepage?

*

Pharg

  • *****
  • 2,843
    • OsDateFourm
  • osDate Version: osDateEvo v1.2
Hi heebeha,

Commenting it out will stop it from displaying all the birthdays and since you must have heaps of birthdays set on the same date, this will happen at least once a year if they are the same date.

There doesn't seem to be a limit on how many birthdays it searches for so maybe disable it in the index.php on line 386:

Find:
Code: [Select]
include("birthday_profiles_display.php");
Change to:
Code: [Select]
//include("birthday_profiles_display.php");
You might need to comment out these lines also under the above code:
Code: [Select]
$bdp = $osDB->getOne( "SELECT user.id FROM ! as user WHERE user.status in (?, ?)  and month(user.birth_date) = month(now()) and dayofmonth(user.birth_date) = dayofmonth(now()) and user.id = ? ", array( USER_TABLE , get_lang('status_enum','active'), 'active', $_SESSION['UserId'] ) );

if (!isset($bdp)) $bdp = 0;

$t->assign('bdp',$bdp);


Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.2 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35

*

heebeha

  • ***
  • 102
  • Me
Thanks; as usual Pharg, you are the master.