I get the below DB error when trying to view the PM. Fixed it for now by adding the column to the table.
Database error in vBulletin 4.2.5:
Invalid SQL:
(
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM phenom_attachment AS a
INNER JOIN phenom_filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN phenom_attachmenttype AS at ON (at.extension = fd.extension)
INNER JOIN phenom_album AS album ON (album.albumid = a.contentid)
LEFT JOIN phenom_profileblockprivacy AS pbp ON (pbp.userid = a.userid AND pbp.blockid = 'albums')
LEFT JOIN phenom_user AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 8 AND
(
(
a.contentid = 0
AND
a.userid = 403
)
OR
(
a.contentid <> 0
)
)
AND a.userid = 403
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM phenom_attachment AS a
INNER JOIN phenom_filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN phenom_attachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN phenom_post AS post ON (post.postid = a.contentid)
LEFT JOIN phenom_thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN phenom_user AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 1 AND
(
(
a.contentid = 0
AND
a.userid = 403
)
OR
(
thread.forumid IN (0, 1, 6, 71, 70, 43, 30, 45, 8, 4, 74, 55, 72, 40, 65, 67, 54, 58, 73, 2, 24) AND (
thread.forumid IN (0, 1, 6, 71, 70, 43, 30, 45, 8, 4, 74, 55, 72, 40, 65, 67, 54, 58, 73, 2, 24)
OR
thread.postuserid = 403
) AND (
a.state <> 'moderation'
OR
a.userid = 403
OR
thread.forumid IN (0, 1, 6, 71, 70, 43, 30, 45, 8, 4, 74, 55, 72, 40, 65, 67, 54, 58, 73, 2, 24)
) AND (
(
post.visible = 1
AND
thread.visible = 1
)
OR
(
thread.forumid IN (0, 1, 6, 71, 70, 43, 30, 45, 8, 4, 74, 55, 72, 40, 65, 67, 54, 58, 73, 2, 24)
)
OR
(
thread.forumid IN (0, 1, 6, 71, 70, 43, 30, 45, 8, 4, 74, 55, 72, 40, 65, 67, 54, 58, 73, 2, 24)
AND
post.visible = 2
AND
thread.visible = 2
)
)
)
)
AND a.userid = 403
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM phenom_attachment AS a
INNER JOIN phenom_filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN phenom_attachmenttype AS at ON (at.extension = fd.extension)
INNER JOIN phenom_socialgroupmember AS sgm ON (sgm.userid = a.userid AND sgm.groupid = a.contentid AND sgm.type = 'member')
LEFT JOIN phenom_socialgroupmember AS bm ON (bm.userid = 403 AND bm.groupid = a.contentid)
INNER JOIN phenom_socialgroup AS sg ON (sg.groupid = a.contentid)
LEFT JOIN phenom_user AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 7 AND
(
(
a.contentid = 0
AND
a.userid = 403
)
OR
(
sg.options & 8
)
)
AND a.userid = 403
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM phenom_attachment AS a
INNER JOIN phenom_filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN phenom_attachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN phenom_cms_node AS node ON (a.contentid = node.nodeid)
LEFT JOIN phenom_user AS user ON (user.userid = node.userid)
WHERE
a.contenttypeid = 27 AND
(
(
a.contentid = 0
AND
a.userid = 403
)
OR
(
a.contentid <> 0
)
)
AND a.userid = 403
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM phenom_attachment AS a
INNER JOIN phenom_filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN phenom_attachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN phenom_vw_comment AS comment ON (comment.commentid = a.contentid)
LEFT JOIN phenom_vw_discussion AS talk ON (comment.discussionid = talk.discussionid)
LEFT JOIN phenom_vw_page AS page ON (talk.pageid = page.pageid)
WHERE
a.contenttypeid = 34 AND
(
(
a.contentid = 0
AND
a.userid = 403
)
OR
(
page.areaid IN (0, 2, 13) AND (
a.state <> 'moderation' OR
a.userid = 403 OR
page.areaid IN (0)
) AND (
(
comment.visible = 1 AND
talk.visible = 1 AND
page.visible = 1
) OR
(
page.areaid IN (0)
)
)
)
)
AND a.userid = 403
);
MySQL Error : Unknown column 'talk.pageid' in 'on clause'
Error Number : 1054
Request Date : Friday, October 16th 2020 @ 12:07:36 PM
Error Date : Friday, October 16th 2020 @ 12:07:36 PM
Script :
http://www.phenompilots.org/private.php?do=newpm&u=1860
Referrer :
https://www.phenompilots.org/threads...s-Bugs?p=55797
IP Address : 108.162.212.104
Username : Marcus Adolfsson
Classname : vB_Database_MySQLi
MySQL Version : 8.0.21-0ubuntu0.20.04.4
Server : 10.128.0.3
User Agent :