Announcement

Collapse
No announcement yet.

Table 'yesfan1_bates.socialgroup' doesn't exist??????

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Table 'yesfan1_bates.socialgroup' doesn't exist??????

    When me and my users on my site click on PM box or SETTINGS for profile we are getting these errors, how do I get this table back???
    this is for PM access..............


    Database error in vBulletin 4.1.4:
    Invalid SQL:
    (
    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, 1106, 1, 372, 374, 455, 375, 376, 666, 221, 223, 29, 163, 164, 166, 167, 168, 853, 1094, 175, 178, 1135, 176, 179, 177, 180, 181, 183, 184, 182, 185, 186, 187, 188, 189, 193, 190, 191, 194, 195, 220, 196, 207, 208, 206, 197, 198, 199, 200, 209, 201, 205, 203, 204, 202, 238, 421, 437, 1016, 1064, 8, 32, 51, 235, 1105, 165, 997, 998, 59, 985, 53, 55, 60, 52, 58, 61, 50, 54, 56, 854, 33, 255, 9, 232, 422, 434, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 436, 435, 495, 673, 674, 675, 999, 145, 63, 147, 146, 150, 218, 39, 27, 257, 36, 268, 269, 26, 34, 855, 856, 448, 458, 294, 222, 68, 1017, 1018, 1126, 1127, 1128, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1029, 1030, 1031, 1129, 1130, 1131, 1132, 1032, 1033, 1034, 1035, 1036, 1097, 1098, 1100, 1101, 1099, 1102, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1073, 1074, 1076, 1079, 1078, 1080, 1081, 1082, 1083, 1084, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1096, 1038, 1039, 1049, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1051, 1050, 1058, 1052, 1053, 1059, 1054, 1055, 1056, 1057, 1103, 1104, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1010, 1011, 1012, 1013, 1014, 904, 905, 938, 939, 940, 947, 906, 907, 908, 950, 909, 910, 919, 930, 931, 957, 920, 921, 941, 942, 911, 964, 912, 913, 914, 923, 924, 932, 857, 858, 876, 859, 860, 861, 875, 862, 864, 865, 866, 879, 863, 868, 877, 869, 867, 870, 871, 872, 873, 874, 818, 819, 847, 846, 841, 848, 849, 850, 839, 840, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 832, 831, 830, 833, 834, 835, 836, 837, 838, 842, 843, 844, 775, 777, 776, 778, 779, 780, 781, 782, 810, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 719, 720, 750, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 751, 743, 744, 745, 746, 752, 747, 748, 749, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 680, 774, 681, 682, 683, 684, 685, 686, 687, 715, 688, 689, 690, 695, 696, 697, 698, 699, 700, 701, 702, 713, 704, 705, 706, 707, 716, 708, 709, 710, 459, 460, 536, 461, 1063, 880, 917, 881, 882, 883, 884, 915, 916, 918, 945, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 986, 987, 988, 989, 990, 991, 802, 807, 803, 805, 806, 815, 814, 816, 813, 811, 812, 446, 451, 473, 474, 475, 476, 477, 478, 480, 479, 481, 482, 484, 483, 485, 486, 487, 518, 519, 520, 521, 522, 523, 524, 525, 711, 499, 511, 885, 886, 887, 888, 889, 890, 891, 892, 893, 953, 954, 955, 894, 895, 896, 956, 897, 898, 952, 899, 900, 535, 500, 501, 534, 532, 569, 502, 508, 533, 510, 526, 527, 537, 531, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 528, 529, 530, 558, 559, 560, 566, 634, 635, 636, 579, 580, 581, 582, 583, 584, 670, 671, 672, 691, 804, 992, 604, 605, 606, 1110, 1125, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 927, 928, 984, 965, 966, 967, 968, 969, 963, 944, 943, 951, 929, 958, 970, 948, 962, 937, 971, 972, 959, 960, 961, 925, 926, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 35, 45, 228, 229, 568, 381, 64, 382, 383, 384, 995, 949, 46, 170, 983, 391, 668, 49, 43, 420, 497, 246, 41, 282, 851, 922, 575, 385, 387, 62, 230, 878, 454, 994, 388, 1028, 852, 809, 754, 44, 48, 389, 808, 42, 453, 773, 817, 993, 576, 935, 386, 30, 159, 174, 377, 996, 281, 572, 273, 438, 157, 158, 233, 155, 717, 234, 266, 638, 160, 161, 493, 278, 1095, 271, 169, 247, 936, 643, 1015, 236, 276, 1109, 1000, 845, 753, 676, 577, 417, 540, 371, 275, 274, 364, 365, 367, 366, 370, 1027, 378, 379, 677, 380, 678, 390, 679, 445, 642, 369, 1133, 570, 571, 1108, 225, 25, 565, 491, 517, 1062, 1136, 219, 718, 37, 173, 210, 578, 148, 149, 492, 637, 214, 237, 224, 217, 272, 901, 902, 903, 156, 1061) AND (
    thread.forumid IN (0, 1106, 1, 372, 374, 455, 375, 376, 666, 221, 223, 29, 163, 164, 166, 167, 168, 853, 1094, 175, 178, 1135, 176, 179, 177, 180, 181, 183, 184, 182, 185, 186, 187, 188, 189, 193, 190, 191, 194, 195, 220, 196, 207, 208, 206, 197, 198, 199, 200, 209, 201, 205, 203, 204, 202, 238, 421, 437, 1016, 1064, 8, 32, 51, 235, 1105, 165, 997, 998, 59, 985, 53, 55, 60, 52, 58, 61, 50, 54, 56, 854, 33, 255, 9, 232, 422, 434, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 436, 435, 495, 673, 674, 675, 999, 145, 63, 147, 146, 150, 218, 39, 27, 257, 36, 268, 269, 26, 34, 855, 856, 448, 458, 294, 222, 68, 1017, 1018, 1126, 1127, 1128, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1029, 1030, 1031, 1129, 1130, 1131, 1132, 1032, 1033, 1034, 1035, 1036, 1097, 1098, 1100, 1101, 1099, 1102, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1073, 1074, 1076, 1079, 1078, 1080, 1081, 1082, 1083, 1084, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1096, 1038, 1039, 1049, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1051, 1050, 1058, 1052, 1053, 1059, 1054, 1055, 1056, 1057, 1103, 1104, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1010, 1011, 1012, 1013, 1014, 904, 905, 938, 939, 940, 947, 906, 907, 908, 950, 909, 910, 919, 930, 931, 957, 920, 921, 941, 942, 911, 964, 912, 913, 914, 923, 924, 932, 857, 858, 876, 859, 860, 861, 875, 862, 864, 865, 866, 879, 863, 868, 877, 869, 867, 870, 871, 872, 873, 874, 818, 819, 847, 846, 841, 848, 849, 850, 839, 840, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 832, 831, 830, 833, 834, 835, 836, 837, 838, 842, 843, 844, 775, 777, 776, 778, 779, 780, 781, 782, 810, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 719, 720, 750, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 751, 743, 744, 745, 746, 752, 747, 748, 749, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 680, 774, 681, 682, 683, 684, 685, 686, 687, 715, 688, 689, 690, 695, 696, 697, 698, 699, 700, 701, 702, 713, 704, 705, 706, 707, 716, 708, 709, 710, 459, 460, 536, 461, 1063, 880, 917, 881, 882, 883, 884, 915, 916, 918, 945, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 986, 987, 988, 989, 990, 991, 802, 807, 803, 805, 806, 815, 814, 816, 813, 811, 812, 446, 451, 473, 474, 475, 476, 477, 478, 480, 479, 481, 482, 484, 483, 485, 486, 487, 518, 519, 520, 521, 522, 523, 524, 525, 711, 499, 511, 885, 886, 887, 888, 889, 890, 891, 892, 893, 953, 954, 955, 894, 895, 896, 956, 897, 898, 952, 899, 900, 535, 500, 501, 534, 532, 569, 502, 508, 533, 510, 526, 527, 537, 531, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 528, 529, 530, 558, 559, 560, 566, 634, 635, 636, 579, 580, 581, 582, 583, 584, 670, 671, 672, 691, 804, 992, 604, 605, 606, 1110, 1125, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 927, 928, 984, 965, 966, 967, 968, 969, 963, 944, 943, 951, 929, 958, 970, 948, 962, 937, 971, 972, 959, 960, 961, 925, 926, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 35, 45, 228, 229, 568, 381, 64, 382, 383, 384, 995, 949, 46, 170, 983, 391, 668, 49, 43, 420, 497, 246, 41, 282, 851, 922, 575, 385, 387, 62, 230, 878, 454, 994, 388, 1028, 852, 809, 754, 44, 48, 389, 808, 42, 453, 773, 817, 993, 576, 935, 386, 30, 159, 174, 377, 996, 281, 572, 273, 438, 157, 158, 233, 155, 717, 234, 266, 638, 160, 161, 493, 278, 1095, 271, 169, 247, 936, 643, 1015, 236, 276, 1109, 1000, 845, 753, 676, 577, 417, 540, 371, 275, 274, 364, 365, 367, 366, 370, 1027, 378, 379, 677, 380, 678, 390, 679, 445, 642, 369, 1133, 570, 571, 1108, 225, 25, 565, 491, 517, 1062, 1136, 219, 718, 37, 173, 210, 578, 148, 149, 492, 637, 214, 237, 224, 217, 272, 901, 902, 903, 156, 1061)
    OR
    thread.postuserid = 1
    ) AND (
    a.state <> 'moderation'
    OR
    a.userid = 1
    OR
    thread.forumid IN (0, 1106, 1, 372, 374, 455, 375, 376, 666, 221, 223, 29, 163, 164, 166, 167, 168, 853, 1094, 175, 178, 1135, 176, 179, 177, 180, 181, 183, 184, 182, 185, 186, 187, 188, 189, 193, 190, 191, 194, 195, 220, 196, 207, 208, 206, 197, 198, 199, 200, 209, 201, 205, 203, 204, 202, 238, 421, 437, 1016, 1064, 8, 32, 51, 235, 1105, 165, 997, 998, 59, 985, 53, 55, 60, 52, 58, 61, 50, 54, 56, 854, 33, 255, 9, 232, 422, 434, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 436, 435, 495, 673, 674, 675, 999, 145, 63, 147, 146, 150, 218, 39, 27, 257, 36, 268, 269, 26, 34, 855, 856, 448, 458, 294, 222, 68, 1017, 1018, 1126, 1127, 1128, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1029, 1030, 1031, 1129, 1130, 1131, 1132, 1032, 1033, 1034, 1035, 1036, 1097, 1098, 1100, 1101, 1099, 1102, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1073, 1074, 1076, 1079, 1078, 1080, 1081, 1082, 1083, 1084, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1096, 1038, 1039, 1049, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1051, 1050, 1058, 1052, 1053, 1059, 1054, 1055, 1056, 1057, 1103, 1104, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1010, 1011, 1012, 1013, 1014, 904, 905, 938, 939, 940, 947, 906, 907, 908, 950, 909, 910, 919, 930, 931, 957, 920, 921, 941, 942, 911, 964, 912, 913, 914, 923, 924, 932, 857, 858, 876, 859, 860, 861, 875, 862, 864, 865, 866, 879, 863, 868, 877, 869, 867, 870, 871, 872, 873, 874, 818, 819, 847, 846, 841, 848, 849, 850, 839, 840, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 832, 831, 830, 833, 834, 835, 836, 837, 838, 842, 843, 844, 775, 777, 776, 778, 779, 780, 781, 782, 810, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 719, 720, 750, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 751, 743, 744, 745, 746, 752, 747, 748, 749, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 680, 774, 681, 682, 683, 684, 685, 686, 687, 715, 688, 689, 690, 695, 696, 697, 698, 699, 700, 701, 702, 713, 704, 705, 706, 707, 716, 708, 709, 710, 459, 460, 536, 461, 1063, 880, 917, 881, 882, 883, 884, 915, 916, 918, 945, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 986, 987, 988, 989, 990, 991, 802, 807, 803, 805, 806, 815, 814, 816, 813, 811, 812, 446, 451, 473, 474, 475, 476, 477, 478, 480, 479, 481, 482, 484, 483, 485, 486, 487, 518, 519, 520, 521, 522, 523, 524, 525, 711, 499, 511, 885, 886, 887, 888, 889, 890, 891, 892, 893, 953, 954, 955, 894, 895, 896, 956, 897, 898, 952, 899, 900, 535, 500, 501, 534, 532, 569, 502, 508, 533, 510, 526, 527, 537, 531, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 528, 529, 530, 558, 559, 560, 566, 634, 635, 636, 579, 580, 581, 582, 583, 584, 670, 671, 672, 691, 804, 992, 604, 605, 606, 1110, 1125, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 927, 928, 984, 965, 966, 967, 968, 969, 963, 944, 943, 951, 929, 958, 970, 948, 962, 937, 971, 972, 959, 960, 961, 925, 926, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 35, 45, 228, 229, 568, 381, 64, 382, 383, 384, 995, 949, 46, 170, 983, 391, 668, 49, 43, 420, 497, 246, 41, 282, 851, 922, 575, 385, 387, 62, 230, 878, 454, 994, 388, 1028, 852, 809, 754, 44, 48, 389, 808, 42, 453, 773, 817, 993, 576, 935, 386, 30, 159, 174, 377, 996, 281, 572, 273, 438, 157, 158, 233, 155, 717, 234, 266, 638, 160, 161, 493, 278, 1095, 271, 169, 247, 936, 643, 1015, 236, 276, 1109, 1000, 845, 753, 676, 577, 417, 540, 371, 275, 274, 364, 365, 367, 366, 370, 1027, 378, 379, 677, 380, 678, 390, 679, 445, 642, 369, 1133, 570, 571, 1108, 225, 25, 565, 491, 517, 1062, 1136, 219, 718, 37, 173, 210, 578, 148, 149, 492, 637, 214, 237, 224, 217, 272, 901, 902, 903, 156, 1061)
    ) AND (
    (
    post.visible = 1
    AND
    thread.visible = 1
    )
    OR
    (
    thread.forumid IN (0, 1106, 1, 372, 374, 455, 375, 376, 666, 221, 223, 29, 163, 164, 166, 167, 168, 853, 1094, 175, 178, 1135, 176, 179, 177, 180, 181, 183, 184, 182, 185, 186, 187, 188, 189, 193, 190, 191, 194, 195, 220, 196, 207, 208, 206, 197, 198, 199, 200, 209, 201, 205, 203, 204, 202, 238, 421, 437, 1016, 1064, 8, 32, 51, 235, 1105, 165, 997, 998, 59, 985, 53, 55, 60, 52, 58, 61, 50, 54, 56, 854, 33, 255, 9, 232, 422, 434, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 436, 435, 495, 673, 674, 675, 999, 145, 63, 147, 146, 150, 218, 39, 27, 257, 36, 268, 269, 26, 34, 855, 856, 448, 458, 294, 222, 68, 1017, 1018, 1126, 1127, 1128, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1029, 1030, 1031, 1129, 1130, 1131, 1132, 1032, 1033, 1034, 1035, 1036, 1097, 1098, 1100, 1101, 1099, 1102, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1073, 1074, 1076, 1079, 1078, 1080, 1081, 1082, 1083, 1084, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1096, 1038, 1039, 1049, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1051, 1050, 1058, 1052, 1053, 1059, 1054, 1055, 1056, 1057, 1103, 1104, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1010, 1011, 1012, 1013, 1014, 904, 905, 938, 939, 940, 947, 906, 907, 908, 950, 909, 910, 919, 930, 931, 957, 920, 921, 941, 942, 911, 964, 912, 913, 914, 923, 924, 932, 857, 858, 876, 859, 860, 861, 875, 862, 864, 865, 866, 879, 863, 868, 877, 869, 867, 870, 871, 872, 873, 874, 818, 819, 847, 846, 841, 848, 849, 850, 839, 840, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 832, 831, 830, 833, 834, 835, 836, 837, 838, 842, 843, 844, 775, 777, 776, 778, 779, 780, 781, 782, 810, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 719, 720, 750, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 751, 743, 744, 745, 746, 752, 747, 748, 749, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 680, 774, 681, 682, 683, 684, 685, 686, 687, 715, 688, 689, 690, 695, 696, 697, 698, 699, 700, 701, 702, 713, 704, 705, 706, 707, 716, 708, 709, 710, 459, 460, 536, 461, 1063, 880, 917, 881, 882, 883, 884, 915, 916, 918, 945, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 986, 987, 988, 989, 990, 991, 802, 807, 803, 805, 806, 815, 814, 816, 813, 811, 812, 446, 451, 473, 474, 475, 476, 477, 478, 480, 479, 481, 482, 484, 483, 485, 486, 487, 518, 519, 520, 521, 522, 523, 524, 525, 711, 499, 511, 885, 886, 887, 888, 889, 890, 891, 892, 893, 953, 954, 955, 894, 895, 896, 956, 897, 898, 952, 899, 900, 535, 500, 501, 534, 532, 569, 502, 508, 533, 510, 526, 527, 537, 531, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 528, 529, 530, 558, 559, 560, 566, 634, 635, 636, 579, 580, 581, 582, 583, 584, 670, 671, 672, 691, 804, 992, 604, 605, 606, 1110, 1125, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 927, 928, 984, 965, 966, 967, 968, 969, 963, 944, 943, 951, 929, 958, 970, 948, 962, 937, 971, 972, 959, 960, 961, 925, 926, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 35, 45, 228, 229, 568, 381, 64, 382, 383, 384, 995, 949, 46, 170, 983, 391, 668, 49, 43, 420, 497, 246, 41, 282, 851, 922, 575, 385, 387, 62, 230, 878, 454, 994, 388, 1028, 852, 809, 754, 44, 48, 389, 808, 42, 453, 773, 817, 993, 576, 935, 386, 30, 159, 174, 377, 996, 281, 572, 273, 438, 157, 158, 233, 155, 717, 234, 266, 638, 160, 161, 493, 278, 1095, 271, 169, 247, 936, 643, 1015, 236, 276, 1109, 1000, 845, 753, 676, 577, 417, 540, 371, 275, 274, 364, 365, 367, 366, 370, 1027, 378, 379, 677, 380, 678, 390, 679, 445, 642, 369, 1133, 570, 571, 1108, 225, 25, 565, 491, 517, 1062, 1136, 219, 718, 37, 173, 210, 578, 148, 149, 492, 637, 214, 237, 224, 217, 272, 901, 902, 903, 156, 1061)
    )
    OR
    (
    thread.forumid IN (0, 1106, 1, 372, 374, 455, 375, 376, 666, 221, 223, 29, 163, 164, 166, 167, 168, 853, 1094, 175, 178, 1135, 176, 179, 177, 180, 181, 183, 184, 182, 185, 186, 187, 188, 189, 193, 190, 191, 194, 195, 220, 196, 207, 208, 206, 197, 198, 199, 200, 209, 201, 205, 203, 204, 202, 238, 421, 437, 1016, 1064, 8, 32, 51, 235, 1105, 165, 997, 998, 59, 985, 53, 55, 60, 52, 58, 61, 50, 54, 56, 854, 33, 255, 9, 232, 422, 434, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 436, 435, 495, 673, 674, 675, 999, 145, 63, 147, 146, 150, 218, 39, 27, 257, 36, 268, 269, 26, 34, 855, 856, 448, 458, 294, 222, 68, 1017, 1018, 1126, 1127, 1128, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1029, 1030, 1031, 1129, 1130, 1131, 1132, 1032, 1033, 1034, 1035, 1036, 1097, 1098, 1100, 1101, 1099, 1102, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1073, 1074, 1076, 1079, 1078, 1080, 1081, 1082, 1083, 1084, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1096, 1038, 1039, 1049, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1051, 1050, 1058, 1052, 1053, 1059, 1054, 1055, 1056, 1057, 1103, 1104, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1010, 1011, 1012, 1013, 1014, 904, 905, 938, 939, 940, 947, 906, 907, 908, 950, 909, 910, 919, 930, 931, 957, 920, 921, 941, 942, 911, 964, 912, 913, 914, 923, 924, 932, 857, 858, 876, 859, 860, 861, 875, 862, 864, 865, 866, 879, 863, 868, 877, 869, 867, 870, 871, 872, 873, 874, 818, 819, 847, 846, 841, 848, 849, 850, 839, 840, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 832, 831, 830, 833, 834, 835, 836, 837, 838, 842, 843, 844, 775, 777, 776, 778, 779, 780, 781, 782, 810, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 719, 720, 750, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 751, 743, 744, 745, 746, 752, 747, 748, 749, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 680, 774, 681, 682, 683, 684, 685, 686, 687, 715, 688, 689, 690, 695, 696, 697, 698, 699, 700, 701, 702, 713, 704, 705, 706, 707, 716, 708, 709, 710, 459, 460, 536, 461, 1063, 880, 917, 881, 882, 883, 884, 915, 916, 918, 945, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 986, 987, 988, 989, 990, 991, 802, 807, 803, 805, 806, 815, 814, 816, 813, 811, 812, 446, 451, 473, 474, 475, 476, 477, 478, 480, 479, 481, 482, 484, 483, 485, 486, 487, 518, 519, 520, 521, 522, 523, 524, 525, 711, 499, 511, 885, 886, 887, 888, 889, 890, 891, 892, 893, 953, 954, 955, 894, 895, 896, 956, 897, 898, 952, 899, 900, 535, 500, 501, 534, 532, 569, 502, 508, 533, 510, 526, 527, 537, 531, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 528, 529, 530, 558, 559, 560, 566, 634, 635, 636, 579, 580, 581, 582, 583, 584, 670, 671, 672, 691, 804, 992, 604, 605, 606, 1110, 1125, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 927, 928, 984, 965, 966, 967, 968, 969, 963, 944, 943, 951, 929, 958, 970, 948, 962, 937, 971, 972, 959, 960, 961, 925, 926, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 35, 45, 228, 229, 568, 381, 64, 382, 383, 384, 995, 949, 46, 170, 983, 391, 668, 49, 43, 420, 497, 246, 41, 282, 851, 922, 575, 385, 387, 62, 230, 878, 454, 994, 388, 1028, 852, 809, 754, 44, 48, 389, 808, 42, 453, 773, 817, 993, 576, 935, 386, 30, 159, 174, 377, 996, 281, 572, 273, 438, 157, 158, 233, 155, 717, 234, 266, 638, 160, 161, 493, 278, 1095, 271, 169, 247, 936, 643, 1015, 236, 276, 1109, 1000, 845, 753, 676, 577, 417, 540, 371, 275, 274, 364, 365, 367, 366, 370, 1027, 378, 379, 677, 380, 678, 390, 679, 445, 642, 369, 1133, 570, 571, 1108, 225, 25, 565, 491, 517, 1062, 1136, 219, 718, 37, 173, 210, 578, 148, 149, 492, 637, 214, 237, 224, 217, 272, 901, 902, 903, 156, 1061)
    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 = 19 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 = 24 AND
    (
    (
    a.contentid = 0
    AND
    a.userid = 1
    )
    OR
    (
    a.contentid <> 0
    )
    )
    AND a.userid = 1
    );
    MySQL Error : Table 'yesfan1_bates.socialgroup' doesn't exist
    Error Number : 1146
    Request Date : Thursday, November 17th 2011 @ 07:00:55 PM
    Error Date : Thursday, November 17th 2011 @ 07:00:55 PM
    Script : http://www.yesfans.com/private.php
    Referrer : http://www.yesfans.com/forum.php?
    IP Address : 66.42.223.147
    Username : 1yesfan
    Classname : vB_Database
    MySQL Version : 5.1.56





    THIS IS FOR SETTTINGS............


    Database error in vBulletin 4.1.4:
    Invalid SQL:
    SELECT COUNT(*)
    FROM socialgroup
    WHERE creatoruserid = 1
    AND moderatedmembers > 0;
    MySQL Error : Table 'yesfan1_bates.socialgroup' doesn't exist
    Error Number : 1146
    Request Date : Thursday, November 17th 2011 @ 07:02:49 PM
    Error Date : Thursday, November 17th 2011 @ 07:02:49 PM
    Script : http://www.yesfans.com/usercp.php
    Referrer : http://www.yesfans.com/forum.php?
    IP Address : 66.42.223.147
    Username : 1yesfan
    Classname : vB_Database
    MySQL Version : 5.1.56
    Tim L
    www.yesfans.com

  • #2
    found another table for social groups that is missing. Seems I need to reload all the tables for that stuff.
    Tim L
    www.yesfans.com

    Comment


    • #3
      Do I need to reload all of VB package to fix this, create a new table for this (don't know how too) or install a recent known good backup?
      Tim L
      www.yesfans.com

      Comment


      • #4
        If you are missing tables, then you should restore to a good backup.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools &lt;- awesome site for html/css help

        Comment


        • #5
          Appears the good backup is during the time that the issues started. Can't just the table be rebuilt? Could I upload the lastest level of VB, would that install it again?
          Tim L
          www.yesfans.com

          Comment


          • #6
            Have you tried doing a repair/optimize on your database tables?

            If the table really is gone, then I believe running the upgrade script should add it back. However, that table stores all the information about your socialgroups, so all of that will be gone and your social groups area will probably be broken. Do you not have an older backup?

            Please don't PM or VM me for support - I only help out in the threads.
            vBulletin Manual & vBulletin 4.0 Code Documentation (API)
            Want help modifying your vbulletin forum? Head on over to vbulletin.org
            If I post CSS and you don't know where it goes, throw it into the additional.css template.

            W3Schools &lt;- awesome site for html/css help

            Comment


            • #7
              The table is GONE ha ha ha. Let me try to repair optimize. The backup thing, well I have one but it is from the time of the missing table. They were to have a few older ones but seems tnot the case.
              Tim L
              www.yesfans.com

              Comment


              • #8
                Originally posted by Lynne View Post
                Have you tried doing a repair/optimize on your database tables?

                If the table really is gone, then I believe running the upgrade script should add it back. However, that table stores all the information about your socialgroups, so all of that will be gone and your social groups area will probably be broken. Do you not have an older backup?
                I have a few of the other socialgroup named tables but seems this one is gone. If it is restored how will it still be BROKE? It will be there jsut no new/current info till folks start making them again.
                Tim L
                www.yesfans.com

                Comment


                • #9
                  I have upgraded to 4.1.8 and I still am missing the table mentioned in this threads first posts. What now. I have no back up that has them!!!
                  Tim L
                  www.yesfans.com

                  Comment


                  • #10
                    cant I jsut rebuild that one table? What builds it when you uoload the 4.x.x and run the install script. Where is this table/file/what ever kept???
                    Tim L
                    www.yesfans.com

                    Comment


                    • #11
                      where all the VB people that could chime in on this one? I have had one person try to help but that has been it. Do I need to reinstall the first 4.x again and upgrade from there to the current? If so what will that do to my site since I upgraded months ago?
                      Tim L
                      www.yesfans.com

                      Comment


                      • #12
                        Please wait 24 hours before bumping threads as per the forum rules.

                        If you open the install/mysql-schema.php file, you'll see the queries there that you will need to recreate any missing tables and, further down, any default data.
                        Vote for:

                        - *Admin Settable Paid Subscription Reminder Timeframe*
                        -
                        *PM - Add ability to reply to originator only*
                        - Add Admin ability to auto-subscribe users to specific channel(s)
                        - "Quick Route" Interface...

                        Comment


                        • #13
                          As Trevor said, the mysql-schema.php file has the needed information to rebuild the table. However, I really don't know if that will completely fix this issue. You may have to truncate the other socialgroup tables as well. PLEASE make a database backup before doing this.

                          Code:
                          CREATE TABLE socialgroup (
                              groupid INT unsigned NOT NULL auto_increment,
                              socialgroupcategoryid INT unsigned NOT NULL,
                              name VARCHAR(255) NOT NULL DEFAULT '',
                              description TEXT,
                              creatoruserid INT unsigned NOT NULL DEFAULT '0',
                              dateline INT unsigned NOT NULL DEFAULT '0',
                              members INT unsigned NOT NULL DEFAULT '0',
                              picturecount INT unsigned NOT NULL DEFAULT '0',
                              lastpost INT unsigned NOT NULL DEFAULT '0',
                              lastposter VARCHAR(255) NOT NULL DEFAULT '',
                              lastposterid INT UNSIGNED NOT NULL DEFAULT '0',
                              lastgmid INT UNSIGNED NOT NULL DEFAULT '0',
                              visible INT UNSIGNED NOT NULL DEFAULT '0',
                              deleted INT UNSIGNED NOT NULL DEFAULT '0',
                              moderation INT UNSIGNED NOT NULL DEFAULT '0',
                              type ENUM('public', 'moderated', 'inviteonly') NOT NULL default 'public',
                              moderatedmembers INT UNSIGNED NOT NULL DEFAULT '0',
                              options INT UNSIGNED NOT NULL DEFAULT '0',
                              lastdiscussionid INT UNSIGNED NOT NULL DEFAULT '0',
                              discussions INT UNSIGNED DEFAULT NULL DEFAULT '0',
                              lastdiscussion VARCHAR(255) NOT NULL DEFAULT '',
                              lastupdate INT UNSIGNED NOT NULL DEFAULT '0',
                              transferowner INT UNSIGNED NOT NULL DEFAULT '0',
                              PRIMARY KEY (groupid),
                              KEY creatoruserid (creatoruserid),
                              KEY dateline (dateline),
                              KEY members (members),
                              KEY picturecount (picturecount),
                              KEY visible (visible),
                              KEY lastpost (lastpost),
                              KEY socialgroupcategoryid (socialgroupcategoryid)
                          )

                          Please don't PM or VM me for support - I only help out in the threads.
                          vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                          Want help modifying your vbulletin forum? Head on over to vbulletin.org
                          If I post CSS and you don't know where it goes, throw it into the additional.css template.

                          W3Schools &lt;- awesome site for html/css help

                          Comment

                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                          Working...
                          X