Announcement

Collapse
No announcement yet.

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

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

  • Lynne
    replied
    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)
    )

    Leave a comment:


  • Trevor Hannant
    replied
    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.

    Leave a comment:


  • 1yesfan
    replied
    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?

    Leave a comment:


  • 1yesfan
    replied
    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???

    Leave a comment:


  • 1yesfan
    replied
    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!!!

    Leave a comment:


  • 1yesfan
    replied
    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.

    Leave a comment:


  • 1yesfan
    replied
    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.

    Leave a comment:


  • Lynne
    replied
    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?

    Leave a comment:


  • 1yesfan
    replied
    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?

    Leave a comment:


  • Lynne
    replied
    If you are missing tables, then you should restore to a good backup.

    Leave a comment:


  • 1yesfan
    replied
    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?

    Leave a comment:


  • 1yesfan
    replied
    found another table for social groups that is missing. Seems I need to reload all the tables for that stuff.

    Leave a comment:


  • 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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X