[Fixed 2.4.1] SQL error viewing image following upgrade

[DrMirth]

Okay, next problem! When I try to view a full-size photo I receive the following error:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
posts.postid, posts.pagetext, posts.title, posts.userid, posts.username AS postusername, posts.dateline, posts.ipaddress AS ip, posts.iconid, posts.allowsmilie, posts.showsignature, user.*, userfield.*, usertextfield.*
,icon.title as icontitle, icon.iconpath
,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision


FROM ppgal_posts AS posts
LEFT JOIN user AS user ON (posts.userid = user.userid)
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN icon AS icon ON (posts.iconid = icon.iconid)
LEFT JOIN reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid)

WHERE imageid = '8318' AND posts.visible = 1
ORDER BY posts.dateline
LIMIT 0, 10;

MySQL Error : Unknown table 'usertextfield'
Error Number : 1051
Date : Thursday, December 6th 2007 @ 08:35:35 AM
Script : http://www.aberdeen-music.com/galler...imageuser=1069

Just upgraded from v2.3 to v2.4 of VBGallery and I could view the same image fine in the previous version.

Any help would be much appreciated.

[Zachariah]

Try this:

Edit: gallery/showimage.php

Find:

Content visible to verified customers only.

Under Add:

Content visible to verified customers only.

[DrMirth]

That fixed it. Thanks again!

[Fenriz]

That doesn't help me. Now I have a bug:

MySQL Error : Cross dependency found in OUTER JOIN; examine your ON conditions
Error Number : 1120

Any thoughts?

[Fenriz]

I've just changed

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (user.userid = userfield.userid)

with

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (user.userid = usertextfield.userid)

and now it works. Is that correct?

[Zachariah]

Originally Posted by Fenriz

I've just changed



with



and now it works. Is that correct?

very good