Problems with profile

Whity · May 8th, 2008, 12:17 PM

At attempt to look profile, it is displayed only header galleries. Itself profile it is not displayed

Chuck S · May 8th, 2008, 03:08 PM

Please redownload the build and reupload the profile template

Whity · May 9th, 2008, 08:14 AM

Thanks, it works.

Still a question.

I receive email with such mistake:

Quote:

An error was encountered during execution of the query:

SELECT p.id,p.title,p.userid,p.cat,p.approved,p.storecat,p.bigimage FROM pp_photos p LEFT JOIN pp_categories c ON p.cat=c.id WHERE p.userid= AND c.password='' ORDER BY p.date DESC LIMIT 5

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.password='' ORDER BY p.date DESC LIMIT 5' at line 1

It is a serious mistake?

Chuck S · May 9th, 2008, 08:29 AM

You could try making the query on line 541 of member.php this basically encapsulating the userid variable

Code:

Content visible to verified customers only.

Whity · May 9th, 2008, 11:16 AM

I have not understood. What it is necessary to do?

Chuck S · May 9th, 2008, 11:31 AM

Line 541 of member.php is the query noted in your error do a search and replace with the query I have posted.

Whity · May 9th, 2008, 11:50 AM

All has understood, thanks.

Chuck S · May 9th, 2008, 11:57 AM

glad you got it have a good weekend.

adultphotos4u · May 9th, 2008, 01:16 PM

Hi,

I redownloaded and uploaded the templates as well as member.php file but still the profile page won't show.

Any clues...

Chuck S · May 9th, 2008, 01:30 PM

in Profile template add in bold line 62 lines in bold.

Code:

Content visible to verified customers only.

zivester · May 9th, 2008, 03:03 PM

I'm having this same problem.

On my company's license... but I can't view the solution because I can't change our accounts registered e-mail to my own...

What should I do?

Chuck S · May 9th, 2008, 03:07 PM

Should the owner not be able to view this though?

echo<<<PPPRINT
<tr>
<td class="{$Style['tddetails']}" align="center">
 <a href="{$Globals['maindir']}/member.php?uid=$uid&protype=8">{$Globals['pp_lang']['buddylist']}</a> 
</td>
</tr>
PPPRINT;
}

echo<<<PPPRINT
$ppcloseside

zivester · May 9th, 2008, 03:17 PM

Yes... but as he's not always at my disposal, it becomes my problem.

Thanks the fix works...

Is there a way to change the owner email of our license? How would I go about doing that?

Chuck S · May 9th, 2008, 03:19 PM

You cant do that only he can. He would need to email sales and set it to one you can use but then he loses his verified status.

Whity · May 17th, 2008, 05:11 PM

Now such mistake

Code:

Content visible to verified customers only.

Chuck S · May 17th, 2008, 08:14 PM

Line 365 of member.php you could make this but dont understand why uid is empty unless its a bot on your site

Code:

Content visible to verified customers only.

Whity · May 18th, 2008, 03:13 AM

Quote:

Originally Posted by Chuck S

Line 365 of member.php

Code:

Content visible to verified customers only.

After correction

Code:

Content visible to verified customers only.

This mistake arises at viewing buddy list.
Buddy are not present in online. In online only 2 guests.

Chuck S · May 18th, 2008, 10:30 AM

Now You can make line 574 this and see what happens

Code:

Content visible to verified customers only.

Whity · May 18th, 2008, 02:03 PM

Mistakes now are not present. But why in the list of buddy at me guests are displayed?

Chuck S · May 18th, 2008, 02:16 PM

what do you mean by this.

I am not sure what it means when you say list of buddy at me guests are displayed? please provide a link to express what you mean