Two annoying bugs

rsj1 · May 4th, 2008, 06:17 PM

1. Some users avatars are not showing up - I cannot see any reason why this would be as the users whose avatars are displaying correctly don't seem to have any differences set up.

2. When searching if a user puts an apostrophe ( ' ) in the search term it will generate a database error.

Forum Software: VBulletin
Photopost version: 6.02

I would supply a link to my site but as it contains adult content and may offend some I will supply a link on demand via PM to a mod/admin

Chuck S · May 4th, 2008, 08:26 PM

For avatars try this

In vb3.php find this

Code:

Content visible to verified customers only.

replace with this and see if it works

Code:

Content visible to verified customers only.

As far as search terms if I enter an apostrophe I get this

Code:

Content visible to verified customers only.

Please pm a link and login and test to try

rsj1 · May 4th, 2008, 09:11 PM

Your code edit didn't work, however I made a further code edit which fixed the problem. I changed:

Code:

Content visible to verified customers only.

to

Code:

Content visible to verified customers only.

which did the trick

I also made a mistake in my original post as I hadn't tested the error properly. When typing an apostrophe into the search box everything works fine. The problem comes when a user clicks on a keyword link that contains an apostrophe like http://XXXXXXXX.com/gallery/search.php?keywords=Don't

This returns the error:

Code:

Content visible to verified customers only.

Login details sent by pm

(NOTE: url has been removed from this post as site contains adult content and may offend some)

Chuck S · May 4th, 2008, 09:41 PM

I replied with a question thats not a photopost table at all which makes no sense here. Thats not even a photopost query.

rsj1 · May 4th, 2008, 10:01 PM

After a bit of searching I have narrowed down the hack it belongs to. It was a rules and agreement hack (which I cannot find on vbulletin.org anymore for some reason and does not contain a link) that I used to make users agree to a set of rules before they uploaded a picture or joined in a roleplay. The script should only have executed on http://xxxxxx.com/gallery/uploadphoto.php but I assume it was checking the database on every url to see if it matched one it had to trigger. I have now disabled the product and upon testing everything appears to now work as it should.

Is there going to be an easy way of coding in an agreement that users will need to accept the first time they attempt to upload a picture (but only the first time for each account) to the gallery?

Chuck S · May 5th, 2008, 06:17 AM

Okay glad you found your hack that caused your issue.

I could not say there but if some one has the need and means to work something like that out I am sure they could. Good discussion for the MOD CORNER outside the product support area.

TEAMBAJAMARINE · May 8th, 2008, 07:41 PM

[quote=rsj1;1223168]Your code edit didn't work, however I made a further code edit which fixed the problem. I changed:

Code:

Content visible to verified customers only.

to

Code:

Content visible to verified customers only.

which did the trick

I too have this problem with random user profiles not showing avatars, I have updated the file above, but did not help. Any suggestions on what to do?

Chuck S · May 8th, 2008, 09:01 PM

How about applying both what I said and what he said?

TEAMBAJAMARINE · May 8th, 2008, 10:48 PM

All fixed, thank you again.

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

Not a problem glad to assist buddy have a good weekend.