HELP !!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I GOT THIS ERROR AND I HAVE NO IDEA WHAT IT MEANS AND HOW I CAN FIX IT, PLEAS CAN ANYONE HELP ME???

 

 

 

 

 

 

Query:
SELECT * FROM `Profiles` WHERE `Status` = 'Active' AND `Featured` = '1' ORDER BY RAND() LIMIT 10

Mysql error:
Got error 28 from storage engine

Found error in file /home/c916brit/public_html/home/templates/base/scripts/BxBaseIndex.php
at line 298. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/c916brit/public_html/home/templates/base/scripts/BxBaseIndex.php
[line] => 298
[function] => db_res
[args] => Array
(
[0] => SELECT * FROM `Profiles` WHERE `Status` = 'Active' AND `Featured` = '1' ORDER BY RAND() LIMIT 10
)

)

[2] => Array
(
[file] => /home/c916brit/public_html/home/inc/classes/BxDolPageView.php
[line] => 167
[function] => getBlockCode_Featured
[class] => BxBaseIndexPageView
[type] => ->
[object] => BxTemplIndexPageView Object
(
[sPageName] => index
[aPage] => Array
(
[Width] => 960px
[Columns] => Array
(
[1] => Array
(
[Width] => 51
[Blocks] => Array
(
[10] => Array
(
[Func] => Members
[Content] =>
[Caption] => _Members
[Visible] => non,memb
[DesignBox] => 1
)

[21] => Array
(
[Func] => ShareVideos
[Content] =>
[Caption] => _Videos
[Visible] => non,memb
[DesignBox] => 1
)

[22] => Array
(
[Func] => ShareMusic
[Content] =>
[Caption] => _Music
[Visible] => non,memb
[DesignBox] => 1
)

[7] => Array
(
[Func] => Featured
[Content] =>
[Caption] => _featured members
[Visible] => non,memb
[DesignBox] => 1
)

[12] => Array
(
[Func] => ProfilePhotos
[Content] =>
[Caption] => _Profile Photos
[Visible] => non,memb
[DesignBox] => 1
)

[3] => Array
(
[Func] => Subscribe
[Content] =>
[Caption] => _Subscribe
[Visible] => non,memb
[DesignBox] => 1
)

[9] => Array
(
[Func] => Tags
[Content] =>
[Caption] => _Tags
[Visible] => non,memb
[DesignBox] => 1
)

)

)

[2] => Array
(
[Width] => 49
[Blocks] => Array
(
[14] => Array
(
[Func] => LoginSection
[Content] =>
[Caption] => _Member Login
[Visible] => non
[DesignBox] => 1
)

[2] => Array
(
[Func] => News
[Content] =>
[Caption] => Couples Club news
[Visible] => non,memb
[DesignBox] => 1
)

[4] => Array
(
[Func] => QuickSearch
[Content] =>
[Caption] => _Quick Search
[Visible] => non,memb
[DesignBox] => 1
)

[13] => Array
(
[Func] => Shoutbox
[Content] =>
[Caption] => Wall Chat
[Visible] => non,memb
[DesignBox] => 1
)

[20] => Array
(
[Func] => SharePhotos
[Content] =>
[Caption] => _Photo Gallery
[Visible] => non,memb
[DesignBox] => 1
)

[8] => Array
(
[Func] => ProfilePoll
[Content] =>
[Caption] => _Polls
[Visible] => non,memb
[DesignBox] => 1
)

[18] => Array
(
[Func] => Groups
[Content] =>
[Caption] => _Groups
[Visible] => non,memb
[DesignBox] => 1
)

[11] => Array
(
[Func] => Blogs
[Content] =>
[Caption] => _Blogs
[Visible] => non,memb
[DesignBox] => 1

 

 

 

 

 

MY WEBSITE WONT RUN NOW, HOW DO I FIX IT?????

You Creature!!
Quote · 19 Sep 2009

its ok i fixed it :)

but now i have another problem,

when i click on browse all members it only shows me 16 members and i have a lot more members than 16, but it says total 16 and it allows 30 showing at a time, so it cant be that their are only 16 allowed on each page etc    ,,,,, whats wrong???

You Creature!!
Quote · 19 Sep 2009

its ok i fixed it :)

but now i have another problem,

when i click on browse all members it only shows me 16 members and i have a lot more members than 16, but it says total 16 and it allows 30 showing at a time, so it cant be that their are only 16 allowed on each page etc    ,,,,, whats wrong???

Do the remaining members have birth dates on file in the correct format?  If they entered it mm/dd/yyyy for example then it will show 00/00/0000 as a birthdate and then not show in the search pages or anywhere else on the site except for the admin panel

Quote · 20 Sep 2009

no they dont as i changed it to a box where members put their age instead as i wanted their ages to show up on their profiles,,,,is their any other way i can get all the members to show without putting bk the date of birth function???  thanks

You Creature!!
Quote · 22 Sep 2009

 

no they dont as i changed it to a box where members put their age instead as i wanted their ages to show up on their profiles,,,,is their any other way i can get all the members to show without putting bk the date of birth function???  thanks

 Nope.  Dolphin requires DOB field in order to be able to locate profiles.  You need to kill the item you created and place DOB back into the join form/edit form/profile pages as it was.  Then follow these steps to make the Age appear and Date of Birth disappear.

 

1.  open file templates/base/scripts/BxBaseProfileView.php

 

Locate the following code:

 

function showBlockPFBlock( $sCaption, $sContent, $bNoDB = false ) {
$iBlockID = (int)$sContent;
if( !isset( $this -> aPFBlocks[$iBlockID] ) or empty( $this -> aPFBlocks[$iBlockID]['Items'] ) )
return '';
$aItems = $this -> aPFBlocks[$iBlockID]['Items'];

$sRet = '<table class="profile_info_block" cellspacing="0" cellpadding="1">';

foreach( $aItems as $aItem ) {
$sValue1 = $this -> oPF -> getViewableValue( $aItem, $this -> _aProfile[ $aItem['Name'] ] );
if( !$sValue1 ) //if empty, do not draw
continue;

$sRet .= '<tr>';
$sRet .=         '<td class="profile_info_label">' . htmlspecialchars( _t( $aItem['Caption'] ) ) . ':</td>';

if( $this -> bCouple ) {
if( in_array( $aItem['Name'], $this -> aCoupleMutualItems ) ) {
$sRet .= '<td class="profile_info_value" colspan="2">' . $sValue1 . '</td>';
} else {
$sValue2 = $this -> oPF -> getViewableValue( $aItem, $this -> _aCouple[ $aItem['Name'] ] );

$sRet .= '<td class="profile_info_value1">' . $sValue1 . '</td>';
$sRet .= '<td class="profile_info_value2">' . $sValue2 . '</td>';
}
} else {
$sRet .=     '<td class="profile_info_value" >' . $sValue1 . '</td>';
}

$sRet .= '</tr>';
}

$sRet .= '</table>';

if ($bNoDB) {
return $sRet;
} else {
echo DesignBoxContent( _t($sCaption), $sRet, 1 );
}
}

 

 

You then need to replace it with:

 

//Date of Birth to Age Modification by Gameutopia

function showBlockPFBlock( $sCaption, $sContent, $bNoDB = false ) {
$iBlockID = (int)$sContent;
if( !isset( $this -> aPFBlocks[$iBlockID] ) or empty( $this -> aPFBlocks[$iBlockID]['Items'] ) )
return '';
$aItems = $this -> aPFBlocks[$iBlockID]['Items'];

$sRet = '<table class="profile_info_block" cellspacing="0" cellpadding="1">';

foreach( $aItems as $aItem ) {
$sValue1 = $this -> oPF -> getViewableValue( $aItem, $this -> _aProfile[ $aItem['Name'] ] );
if( !$sValue1 ) //if empty, do not draw
continue;

if($aItem['Name'] == "DateOfBirth")
{

$sRet .= '<tr>';
$sRet .= '<td class="profile_info_label">' . _t( "_Age" ) . ':</td>';

$ageValue1 = age($sValue1);
if( $this -> bCouple ) {
if( in_array( $aItem['Name'], $this -> aCoupleMutualItems ) ) {
$sRet .= '<td class="profile_info_value" colspan="2">' . $ageValue1 . '</td>';
} else {
$sValue2 = $this -> oPF -> getViewableValue( $aItem, $this -> _aCouple[ $aItem['Name'] ] );

$ageValue2 = age($sValue2);

$sRet .= '<td class="profile_info_value1">' . $ageValue1 . '</td>';
$sRet .= '<td class="profile_info_value2">' . $ageValue2 . '</td>';
}
} else {
$sRet .= '<td class="profile_info_value" >' . $ageValue1 . '</td>';
}

}else{

$sRet .= '<tr>';
$sRet .= '<td class="profile_info_label">' . htmlspecialchars( _t( $aItem['Caption'] ) ) . ':</td>';

if( $this -> bCouple ) {
if( in_array( $aItem['Name'], $this -> aCoupleMutualItems ) ) {
$sRet .= '<td class="profile_info_value" colspan="2">' . $sValue1 . '</td>';
} else {
$sValue2 = $this -> oPF -> getViewableValue( $aItem, $this -> _aCouple[ $aItem['Name'] ] );

$sRet .= '<td class="profile_info_value1">' . $sValue1 . '</td>';
$sRet .= '<td class="profile_info_value2">' . $sValue2 . '</td>';
}
} else {
$sRet .= '<td class="profile_info_value" >' . $sValue1 . '</td>';
}
}
$sRet .= '</tr>';
}

$sRet .= '</table>';

if ($bNoDB) {
return $sRet;
} else {
echo DesignBoxContent( _t($sCaption), $sRet, 1 );
}
}


Once you've done that, go into Admin -> Settings -> Language Settings and create add a new language key.

_Age

Age

Save it all and your done.  The Age will now appear on the Profile instead of the Date of Birth and you have privacy and such. 

This modification was done about a year ago by Gameutopia, I'm just reposting it here as it's fallen way down and most are having problems finding it now in searches.  This has been tested on Dolphin 6.1.x versions and I know it still works on 6.1.6 because I still use it.

 

 


 

Final Note:  Because of what you did, to get the members to appear, you will need to go in after you do the above and place an actual date of birth for each of them in their profiles.  Welcome to the world of long and tedious data entry.  Next time, stop in and ask for help if your not sure how to do something.  We're more than happy to help save you some time and point you in the right direction.

Quote · 22 Sep 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.