Thread: Dolphin V.5.5 Error in Profiles.inc.php Fixed :p ;)

Hey everyone I finally figured out the errors in members.php and profile_edit.php. I was getting this error in

Code:

Error in /profile_edit.php: You have an error in your SQL syntax near 
';
		' at line 8
Query: '
			SELECT
					*,
					DATE_FORMAT(`LastLoggedIn`,  '%m-%d-%y %H:%i' ) AS LastLoggedIn,
					DATE_FORMAT(`LastModified`,  '%m-%d-%y %H:%i' ) AS LastModified					
			FROM
					`Profiles`
			WHERE `ID` = '1' LIMIT 1;

and this error in member.php

Code:

Error in /member.php: You have an error in your SQL syntax near ';
	' at line 94
Query: '
		SELECT
					`ID`,
					`NickName`,
					`Password`,
					`ProfileType`,
					`RealName`,
					`RealName2`,
					`Country`,
					`City`,
					`Children`,
					`WhereChildren`,
					`Headline`,
					`DescriptionMe`,
					`DescriptionYou`,
					`Sex`,
					`Sex2`,
					`DateOfBirth`,
					`DateOfBirth2`,
					`Relationship`,
					`Height`,
					`Height2`,
					`BodyType`,
					`BodyType2`,
					`Religion`,
					`Religion2`,
					`Ethnicity`,
					`Ethnicity2`,
					`MaritalStatus`,
					`Occupation`,
					`Occupation2`,
					`Language1`,
					`Language12`,
					`Language2`,
					`Language22`,
					`Language3`,
					`Language32`,
					`Education`,
					`Education2`,
					`Income`,
					`Income2`,
					`Smoker`,
					`Smoker2`,
					`Drinker`,
					`Drinker2`,
					`WantChildren`,
					`MerchantPrice`,
					`Email`,
					`EmailFlag`,
					`EmailNotify`,
					`Phone`,
					`HomeAddress`,
					`IM`,
					`IcqUIN`,
					`Status`,					
					DATE_FORMAT(`LastLoggedIn`,  '%m-%d-%y %H:%i' ) AS LastLoggedIn,
					DATE_FORMAT(`LastModified`,  '%m-%d-%y %H:%i' ) AS LastModified,					
					`LastReg`,
					`Priority`,
					`HomePage`,
					`LookingFor`,
					`LookingAge`,
					`LookingHeight`,
					`LookingBodyType`,
					`Picture`,
					`Pic_0_addon`,
					`Pic_1_addon`,
					`Pic_2_addon`,
					`Pic_3_addon`,
					`Pic_4_addon`,
					`Pic_5_addon`,
					`Pic_6_addon`,
					`Pic_7_addon`,
					`Pic_8_addon`,
					`Pic_9_addon`,
					`Pic_10_addon`,
					`Sound`,
					`Sound_addon`,
					`Video`,
					`Video_addon`,
					`LastNavTime`,
					`LastNavPage`,
					`Featured`,
					`aff_num`,
					`priv_passwd`,
					`PPNotify`,
					`seed`,
					`zip`,
					`GuestbookMode`,
					`GuestbookAccess`,
					`PaymentSubscription`
			FROM
					`Profiles`
			WHERE `ID` = '1' LIMIT 1;

The problem was actually in profiles.inc.php on line 928 with this code

Code:

			FROM
					`Profiles`
			WHERE `ID` = '$userID' LIMIT 1;
		";
		$aPreUser = db_assoc_arr( $userQuery );

so I moved this "; one line up closer to LIMIT 1; to get this code

Code:

			FROM
					`Profiles`
			WHERE `ID` = '$userID' LIMIT 1";
		$aPreUser = db_assoc_arr( $userQuery );

That is pretty much it guys with dolphin v.5.5, everything seems to be working great all except for ocra, but after seeing all the errors on the boonex site itself with their ocra and how it takes so long to load, I think i will stick to phpbb2 instead which to me is a much nicer forum that is free and always being upgraded with no BUGS!!! Oh by the way, there might be file with 2 errors on it, but after fixing these bugs 2 days ago, I forget exactly which file had the errors on it. Look for double colons that shouldn't be there. it seems to be what boonex does a lot of lol. If you are still having trouble let me know. Maybe I can lend you the file you are having trouble with.

visit my sites

www.tdotjobs.com
www.postaprofile.com <--- MIphoto script is encrypted, sucks bad what a waste of $200

www.votemehot.com
www.lifeoracle.com
www.desktopheat.com
www.openswinging.com
www.dateahotty.com

Thanks,

Alicia

Well done Alicia! Thanks heaps for sorting it out. No doubt I will be needing the mods very soon LOL.

I downloaded 5.5 and see it is quite a bit different to 5.4 with a heap of plugins.

Going to get it up and running and see how it goes with a test.

hi dear can u tell what error it gives if I DONT update my profiles.inc.php file...

I have clean install of dolphin 5.5

Regards,
Anand
www.perzon.com

Originally Posted by anand8900

hi dear can u tell what error it gives if I DONT update my profiles.inc.php file...

It appears spokenart posted the errors in his/her original post in this thread.

Please look again.

Smoge

MANY MANY THANKS SPOKENART YOU MADE MY SITE WORK IT WAS GIVING ME THIS EROR

Catchable fatal error: Object of class BxTemplConfig could not be converted to string in /mnt/path of my site/www/gndusite.com/inc/profiles.inc.php on line 106


AND THEN I DID AS U HAVE TOLD AND EDITED THE profiles.inc.php and now my communicator is showing.

MANY MANY THANKS TO YOU.

REGARDS,
ANAND
WWW.GNDUSITE.COM

i found this code in inc/profiles.inc.php and it has double ; (semi colons)

do we need to edit this also..... plz reply.

Code:

function get_video_size ( $id )
{
    global $dir;
	global $video_ext;	

    $p_arr = db_arr( "SELECT `ID`, `NickName`, `Video_addon` FROM `Profiles` WHERE `ID` = '$id';" );
    $file = "{$dir['profileVideo']}{$p_arr['ID']}_0_{$p_arr['Video_addon']}";

    if ( file_exists( $file ) ) return filesize( $file ); else return 0;
}


function get_sound_size ( $id )
{    
	global $dir;

	$p_arr = db_arr( "SELECT ID, NickName, Sound_addon FROM Profiles WHERE ID = $id" );
	$file = "{$dir['profileSound']}{$p_arr['ID']}_0_{$p_arr['Sound_addon']}";

	return filesize( $file );
}

Code:

if( isset( $aPreUser ) )
		{
			
			$aUser = '<?';
			$aUser .= "\n\n";
			$aUser .= '$aUser[' . $userID . '] = array();';
			$aUser .= "\n";
			$aUser .= '$aUser[' . $userID . '][\'datafile\'] = true;';
			$aUser .= "\n";
			foreach( $aPreUser as $key =>  $value )
			{
				$aUser .= '$aUser[' . $userID . '][\'' . $key . '\']' . ' = ' . '\'' . addslashes( $value )  . '\'' . ";\n";
			}
			$aUser .= "\n" . '?>';

hi anand, i managed to get 5.5 working straight out of the box, i have done some cosmetic changes and few minor code tweaks to my liking but nothing major, i am not php user friendly . i even managed to get that orca thing working, but don't use it.

i will be having a looky at 5.6 to see how different it is to 5.5, some reports seem interesting so far.

I don't know why, but my profiles page doesn't come up at all! It used to be editable, (profile_edit.php) but now the background comes up but not the main screen.

This is why I am staying with 5.5, so far very stable and had no issues other then self induced, which I think is 90% of most issues 9.5% server related and the rest BooneX (in 5.5 only)....I wonder if someone would take the time to post the real issues of each version to determine how much is really human error vs code/server related....Um? I am finding more and more it is a people issue not a software issue most of the time. Thoughts are welcome, The reason I posted here is because I have the same ver and never had any of these issues and I know others that agree....Thoughts??

Originally Posted by slipknot

hi anand, i managed to get 5.5 working straight out of the box, i have done some cosmetic changes and few minor code tweaks to my liking but nothing major, i am not php user friendly . i even managed to get that orca thing working, but don't use it.

i will be having a looky at 5.6 to see how different it is to 5.5, some reports seem interesting so far.

Rick,

I agree. A lot of the issues are conflicts. Hardware, Software, Human.

I have a few issues with Dolphin 5.6.0002 right now. Just fixed an issue with photos not showing (I Think) It was a permission issue.

It's easy to blame the software, as it IS buggy.. But, I don't think it's all that.

I worked through issues with Ray not working, server side. 5.6.0002 was the first install I could get Ray and Orca working with not too much effort. I am starting to get a few users, so now the real fun begins..

John