Forum Is this a stock VB 4.03 pl1 SQL query?
 

Hi,

I am testing a possible upgrade to vb4.03 from 3.85 and whenever I click on settings I get a SQL error (further down). All plugins are disabled via the hook in config.php. The actual error is MySQL has gone away but that is a bogus error as the rest of the forum works correctly and when I cut n paste the SQL query into a Query Browser it complains of an incorrect syntax.

Anyone have any ideas?

SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM attachment AS a
INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
INNER JOIN album AS album ON (album.albumid = a.contentid)
LEFT JOIN profileblockprivacy AS pbp ON (pbp.userid = a.userid AND pbp.blockid = 'albums')
LEFT JOIN user AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 8 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
a.contentid 0
)
)
AND a.userid = 1
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM attachment AS a
INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN post AS post ON (post.postid = a.contentid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN user AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 1 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
thread.forumid IN (0, 376, 314, 2, 301, 329, 67, 83, 85, 3, 13, 14, 48, 49, 50, 52, 61, 372, 15, 17, 18, 19, 68, 20, 21, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 75, 76, 77, 307, 305, 42, 43, 96, 106, 310, 311, 326, 312, 302, 373, 375, 308, 324, 337, 338, 339, 350, 355, 340, 369, 363, 370, 357, 343, 358, 364, 344, 368, 356, 371, 365, 347, 348, 349, 53, 55, 56, 57, 58, 87, 333, 334, 95, 101, 102, 103, 104, 105, 107, 108, 16, 59, 60, 78, 66, 71, 44, 46, 327, 69, 374, 97, 336, 316, 315, 320, 318, 319, 317, 321, 322, 323, 84, 313, 298, 330, 331, 335, 332, 47, 92, 93, 328, 94, 296, 148, 115, 242, 254, 243, 269, 156, 236, 138, 139, 141, 132, 162, 265, 177, 256, 222, 295, 203, 268, 244, 119, 128, 129, 293, 255, 204, 217, 175, 218, 151, 270, 271, 272, 273, 110, 111, 114, 127, 137, 160, 285, 171, 154, 157, 201, 158, 215, 140, 152, 145, 123, 267, 211, 143, 245, 225, 246, 164, 172, 163, 188, 191, 202, 206, 292, 221, 194, 196, 259, 197, 198, 199, 209, 220, 283, 275, 276, 277, 278, 193, 195, 260, 192, 189, 190, 210, 219, 284, 279, 280, 281, 282, 227, 228, 288, 205, 247, 274, 294, 248, 262, 249, 264, 170, 290, 214, 226, 212, 263, 234, 174, 176, 287, 250, 251, 252, 213, 179, 168, 169, 238, 173, 237, 291, 165, 289, 167, 166, 239, 240, 266, 241, 149, 125, 286, 112, 159, 117, 118, 121, 136, 216, 144, 235, 130, 131, 133, 134, 257, 229, 230, 231, 232, 233, 207, 258, 208, 223, 224, 261, 113, 116, 122, 153, 161, 180, 181, 182, 183, 200, 253, 155, 142, 120, 124, 146, 184, 147, 126, 135, 178, 185, 186, 150, 187) AND (
thread.forumid IN (0, 376, 314, 2, 301, 329, 67, 83, 85, 3, 13, 14, 48, 49, 50, 52, 61, 372, 15, 17, 18, 19, 68, 20, 21, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 75, 76, 77, 307, 305, 42, 43, 96, 106, 310, 311, 326, 312, 302, 373, 375, 308, 324, 337, 338, 339, 350, 355, 340, 369, 363, 370, 357, 343, 358, 364, 344, 368, 356, 371, 365, 347, 348, 349, 53, 55, 56, 57, 58, 87, 333, 334, 95, 101, 102, 103, 104, 105, 107, 108, 16, 59, 60, 78, 66, 71, 44, 46, 327, 69, 374, 97, 336, 316, 315, 320, 318, 319, 317, 321, 322, 323, 84, 313, 298, 330, 331, 335, 332, 47, 92, 93, 328, 94, 296, 148, 115, 242, 254, 243, 269, 156, 236, 138, 139, 141, 132, 162, 265, 177, 256, 222, 295, 203, 268, 244, 119, 128, 129, 293, 255, 204, 217, 175, 218, 151, 270, 271, 272, 273, 110, 111, 114, 127, 137, 160, 285, 171, 154, 157, 201, 158, 215, 140, 152, 145, 123, 267, 211, 143, 245, 225, 246, 164, 172, 163, 188, 191, 202, 206, 292, 221, 194, 196, 259, 197, 198, 199, 209, 220, 283, 275, 276, 277, 278, 193, 195, 260, 192, 189, 190, 210, 219, 284, 279, 280, 281, 282, 227, 228, 288, 205, 247, 274, 294, 248, 262, 249, 264, 170, 290, 214, 226, 212, 263, 234, 174, 176, 287, 250, 251, 252, 213, 179, 168, 169, 238, 173, 237, 291, 165, 289, 167, 166, 239, 240, 266, 241, 149, 125, 286, 112, 159, 117, 118, 121, 136, 216, 144, 235, 130, 131, 133, 134, 257, 229, 230, 231, 232, 233, 207, 258, 208, 223, 224, 261, 113, 116, 122, 153, 161, 180, 181, 182, 183, 200, 253, 155, 142, 120, 124, 146, 184, 147, 126, 135, 178, 185, 186, 150, 187)
OR
thread.postuserid = 1
) AND (
a.state 'moderation'
OR
a.userid = 1
OR
thread.forumid IN (0, 376, 314, 2, 301, 329, 67, 83, 85, 3, 13, 14, 48, 49, 50, 52, 61, 372, 15, 17, 18, 19, 68, 20, 21, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 75, 76, 77, 307, 305, 42, 43, 96, 106, 310, 311, 326, 312, 302, 373, 375, 308, 324, 337, 338, 339, 350, 355, 340, 369, 363, 370, 357, 343, 358, 364, 344, 368, 356, 371, 365, 347, 348, 349, 53, 55, 56, 57, 58, 87, 333, 334, 95, 101, 102, 103, 104, 105, 107, 108, 16, 59, 60, 78, 66, 71, 44, 46, 327, 69, 374, 97, 336, 316, 315, 320, 318, 319, 317, 321, 322, 323, 84, 313, 298, 330, 331, 335, 332, 47, 92, 93, 328, 94, 296, 148, 115, 242, 254, 243, 269, 156, 236, 138, 139, 141, 132, 162, 265, 177, 256, 222, 295, 203, 268, 244, 119, 128, 129, 293, 255, 204, 217, 175, 218, 151, 270, 271, 272, 273, 110, 111, 114, 127, 137, 160, 285, 171, 154, 157, 201, 158, 215, 140, 152, 145, 123, 267, 211, 143, 245, 225, 246, 164, 172, 163, 188, 191, 202, 206, 292, 221, 194, 196, 259, 197, 198, 199, 209, 220, 283, 275, 276, 277, 278, 193, 195, 260, 192, 189, 190, 210, 219, 284, 279, 280, 281, 282, 227, 228, 288, 205, 247, 274, 294, 248, 262, 249, 264, 170, 290, 214, 226, 212, 263, 234, 174, 176, 287, 250, 251, 252, 213, 179, 168, 169, 238, 173, 237, 291, 165, 289, 167, 166, 239, 240, 266, 241, 149, 125, 286, 112, 159, 117, 118, 121, 136, 216, 144, 235, 130, 131, 133, 134, 257, 229, 230, 231, 232, 233, 207, 258, 208, 223, 224, 261, 113, 116, 122, 153, 161, 180, 181, 182, 183, 200, 253, 155, 142, 120, 124, 146, 184, 147, 126, 135, 178, 185, 186, 150, 187)
) AND (
(
post.visible = 1
AND
thread.visible = 1
)
OR
(
thread.forumid IN (0, 376, 314, 2, 301, 329, 67, 83, 85, 3, 13, 14, 48, 49, 50, 52, 61, 372, 15, 17, 18, 19, 68, 20, 21, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 75, 76, 77, 307, 305, 42, 43, 96, 106, 310, 311, 326, 312, 302, 373, 375, 308, 324, 337, 338, 339, 350, 355, 340, 369, 363, 370, 357, 343, 358, 364, 344, 368, 356, 371, 365, 347, 348, 349, 53, 55, 56, 57, 58, 87, 333, 334, 95, 101, 102, 103, 104, 105, 107, 108, 16, 59, 60, 78, 66, 71, 44, 46, 327, 69, 374, 97, 336, 316, 315, 320, 318, 319, 317, 321, 322, 323, 84, 313, 298, 330, 331, 335, 332, 47, 92, 93, 328, 94, 296, 148, 115, 242, 254, 243, 269, 156, 236, 138, 139, 141, 132, 162, 265, 177, 256, 222, 295, 203, 268, 244, 119, 128, 129, 293, 255, 204, 217, 175, 218, 151, 270, 271, 272, 273, 110, 111, 114, 127, 137, 160, 285, 171, 154, 157, 201, 158, 215, 140, 152, 145, 123, 267, 211, 143, 245, 225, 246, 164, 172, 163, 188, 191, 202, 206, 292, 221, 194, 196, 259, 197, 198, 199, 209, 220, 283, 275, 276, 277, 278, 193, 195, 260, 192, 189, 190, 210, 219, 284, 279, 280, 281, 282, 227, 228, 288, 205, 247, 274, 294, 248, 262, 249, 264, 170, 290, 214, 226, 212, 263, 234, 174, 176, 287, 250, 251, 252, 213, 179, 168, 169, 238, 173, 237, 291, 165, 289, 167, 166, 239, 240, 266, 241, 149, 125, 286, 112, 159, 117, 118, 121, 136, 216, 144, 235, 130, 131, 133, 134, 257, 229, 230, 231, 232, 233, 207, 258, 208, 223, 224, 261, 113, 116, 122, 153, 161, 180, 181, 182, 183, 200, 253, 155, 142, 120, 124, 146, 184, 147, 126, 135, 178, 185, 186, 150, 187)
)
OR
(
thread.forumid IN (0, 376, 314, 2, 301, 329, 67, 83, 85, 3, 13, 14, 48, 49, 50, 52, 61, 372, 15, 17, 18, 19, 68, 20, 21, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 75, 76, 77, 307, 305, 42, 43, 96, 106, 310, 311, 326, 312, 302, 373, 375, 308, 324, 337, 338, 339, 350, 355, 340, 369, 363, 370, 357, 343, 358, 364, 344, 368, 356, 371, 365, 347, 348, 349, 53, 55, 56, 57, 58, 87, 333, 334, 95, 101, 102, 103, 104, 105, 107, 108, 16, 59, 60, 78, 66, 71, 44, 46, 327, 69, 374, 97, 336, 316, 315, 320, 318, 319, 317, 321, 322, 323, 84, 313, 298, 330, 331, 335, 332, 47, 92, 93, 328, 94, 296, 148, 115, 242, 254, 243, 269, 156, 236, 138, 139, 141, 132, 162, 265, 177, 256, 222, 295, 203, 268, 244, 119, 128, 129, 293, 255, 204, 217, 175, 218, 151, 270, 271, 272, 273, 110, 111, 114, 127, 137, 160, 285, 171, 154, 157, 201, 158, 215, 140, 152, 145, 123, 267, 211, 143, 245, 225, 246, 164, 172, 163, 188, 191, 202, 206, 292, 221, 194, 196, 259, 197, 198, 199, 209, 220, 283, 275, 276, 277, 278, 193, 195, 260, 192, 189, 190, 210, 219, 284, 279, 280, 281, 282, 227, 228, 288, 205, 247, 274, 294, 248, 262, 249, 264, 170, 290, 214, 226, 212, 263, 234, 174, 176, 287, 250, 251, 252, 213, 179, 168, 169, 238, 173, 237, 291, 165, 289, 167, 166, 239, 240, 266, 241, 149, 125, 286, 112, 159, 117, 118, 121, 136, 216, 144, 235, 130, 131, 133, 134, 257, 229, 230, 231, 232, 233, 207, 258, 208, 223, 224, 261, 113, 116, 122, 153, 161, 180, 181, 182, 183, 200, 253, 155, 142, 120, 124, 146, 184, 147, 126, 135, 178, 185, 186, 150, 187)
AND
post.visible = 2
AND
thread.visible = 2
)
)
)
)
AND a.userid = 1
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM attachment AS a
INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
INNER JOIN socialgroupmember AS sgm ON (sgm.userid = a.userid AND sgm.groupid = a.contentid AND sgm.type = 'member')
INNER JOIN socialgroup AS sg ON (sg.groupid = a.contentid)
LEFT JOIN user AS user ON (a.userid = user.userid)
WHERE
a.contenttypeid = 7 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
sg.options & 8 AND (
a.state 'moderation'
OR
a.userid = 1
)
)
)
AND a.userid = 1
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM attachment AS a
INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN blog AS blog ON (a.contentid = blog.blogid)
LEFT JOIN blog_user AS bu ON (bu.bloguserid = blog.userid)
LEFT JOIN user AS user ON (user.userid = blog.userid)
LEFT JOIN blog_groupmembership AS gm ON (blog.userid = gm.bloguserid AND gm.userid = 1)
WHERE
a.contenttypeid = 15 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
a.contentid 0 AND
(
(
blog.state 'draft'
AND
blog.pending = 0
)
OR
blog.userid IN (1)
)

)
)
AND a.userid = 1
) UNION ALL (
SELECT
COUNT(*) AS count, SUM(fd.filesize) AS sum
FROM attachment AS a
INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
LEFT JOIN cms_node AS node ON (a.contentid = node.nodeid)
LEFT JOIN user AS user ON (user.userid = node.userid)
WHERE
a.contenttypeid = 18 AND
(
(
a.contentid = 0
AND
a.userid = 1
)
OR
(
a.contentid 0
)
)
AND a.userid = 1
);