|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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 ); __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
أدوات الموضوع | |
انواع عرض الموضوع | |
| |