When i try to search my DB front or backend using search.php Mysql dies with the following error.
mysql error: Unknown column 'Pornofan' in 'where clause'
i know user Pornofan is a banned user and the query constructed by vbulletin is wrong ... plz help..
Full query generated by vbulletin below :
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT postid AS itemid, thread.forumid,
IF(postuserid = 4, 'self', 'other') AS starter
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid =
post.threadid)
LEFT JOIN deletionlog AS delpost
ON(delpost.primaryid = post.postid AND delpost.type = 'post')
WHERE postid IN(181166, 181165, 181164, 181162, 181161, 181160, 181159, 181158, 181157, 181156, 181155, 181154, 181153, 180693, 180692, 180690, 180689, 180688, 180687, 180686, 180679, 180678, 180673, 180668, 180667, 180663, 180662, 180657, 180655, 180654, 174935, 174934, 174933, 174930, 174929, 174928, 174878, 174874, 174873, 174872, 174871, 174868, 174867, 174865, 174864, 174863, 174861, 174860, 174857, 170016, 170014, 169406, 168855, 168853, 168852, 168851, 168849, 168837, 168836, 168834, 168833, 168831, 168600, 168366, 167040, 166548, 166547, 166545, 166544, 166543, 166541, 166539, 166538, 166535, 166534, 165393, 165392, 165390, 165389, 165388, 165387, 165386, 165385, 165384, 165383, 165381, 165380, 165379, 165378, 165377, 165376, 165375, 165374, 165373, 164920, 164919, 164916, 164915, 164914, 164913, 164912, 164911, 164910, 164909, 164907, 164904, 164903, 164902, 164900, 164899, 164898, 164897, 164896, 164895, 164893, 164891, 164889, 162492, 162491, 162490, 162489, 16!
2487, 162486, 162485, 162484, 162483, 162482, 162481, 162480, 162479, 162477, 162476, 162475, 162474, 162470, 162469, 162468, 162466, 162465, 162464, 162463, 162462, 162461, 162460, 162459, 161412, 161411, 161410, 161382, 161381, 161380, 161377, 161374, 159784, 159783, 159776, 159775, 159773, 159770, 159769, 158874, 158871, 158867, 158865, 158864, 158862, 158861, 158859, 158857, 158856, 158854, 158851, 158850, 158848, 158846, 158845, 158844, 158842, 158841, 158838, 158836, 158834, 158833, 158830, 158829, 158822, 158821, 158819, 158816, 158814, 158812, 158811, 158810, 158808, 158806, 158805, 158803, 158801, 154028, 154027, 154022, 154021, 153850, 153844, 153843, 153841, 153836, 153834, 153829, 153825, 153824, 153823, 153820, 153818, 153816, 153815, 153812, 153811, 153809, 153807, 153805, 153803, 151716, 151715, 151714, 151710, 151707, 151706, 151705, 151703, 151700, 151697, 151695, 151693, 151690, 151669, 151668, 151666, 151665, 149677, 149676, 149675, 149673, 149668, 149667!
, 149666, 149665, 149663, 149662, 149661, 149659, 148865, 1488!
63, 148861, 148860, 148848, 148845, 148843, 148841, 148839, 148838, 148837, 148835, 148834, 148833, 148832, 148831, 148830, 148829, 148828, 148827, 148826, 147513, 147512, 147511, 147510, 147509, 147507, 147505, 147504, 147499, 147498, 147496, 147495, 147493, 145406, 145405, 145404, 145403, 145402, 145401, 145400, 145399, 145398, 145397, 145396, 145395, 145394, 145393, 145392, 144768, 144766, 144765, 144763, 144762, 144761, 144759, 144156, 144155, 144154, 144153, 144152, 144151, 144149, 144148, 144147, 144146, 144144, 144143, 144141, 144140, 144139, 144138, 144136, 144134, 144133, 144131, 144130, 144128, 143161, 143159, 143158, 143157, 143156, 143155, 143154, 143153, 143152, 143149, 143148, 143146, 143144, 143143, 143141, 143140, 143139, 143138, 143136, 143135, 143134, 143133, 143132, 143131, 143130, 143129, 143127, 143126, 143125, 141661, 141660, 141659, 141658, 141657, 141656, 141655, 141653, 141652, 141649, 141648, 141645, 141643, 141640, 141637, 140911, 140908, 140906, 1!
40903, 140900, 140899, 140897, 140895, 140894, 140892, 140890, 140888, 140887, 140885, 140881, 140880, 140876, 140874, 140871, 140869, 140865, 140864, 139338, 139337, 139335, 139333, 139331, 139330, 139329, 139328, 139326, 139325, 138842, 138840, 138839, 138836, 138832, 138830, 138829, 138826, 138823, 138819, 138817, 138814, 138813, 138812, 138811, 138809, 138806, 138802, 138799, 138798, 138797, 138796, 138794, 138793, 138790, 138789, 138784, 138781, 138779, 138777, 135850, 135849, 135847, 135846, 135845, 135844, 135843, 135842, 135841, 135840, 135839, 135837, 135836, 135835, 135301, 135300, 135299, 135298, 135296, 135295, 135294, 135292, 135291, 135290, 135289, 135288, 135287, 135285, 135284, 135283, 133684, 133680, 133679, 133677, 133676, 133675, 133672, 133670, 133668, 133666, 133664, 133256, 132894, 132892, 132889, 132888, 132886, 132885, 132883, 132882, 132881, 132880, 132879, 132783, 132782, 132781, 132780, 132779, 132778, 132776, 132775, 132774, 132773, 132772, 13277!
1, 132769, 132768, 132766, 132765, 132764, 132763, 132761, 132!
760, 132759, 132304, 132303, 132302, 132301, 132300, 132299, 132298, 132297, 132295, 132294, 132293, 132292, 132291, 132290, 132289, 132288, 132287, 132285, 132283, 132281, 132280, 132279, 132278, 132277, 132276, 132275, 132273, 132272, 132271, 132270, 130687, 130685, 130671, 130670, 130668, 130666, 130665, 130662, 130661, 130659, 130657, 130655, 130654, 130653, 130652, 130651, 129646, 129644, 129587, 129586, 129585, 129584, 129583, 129582, 129581, 129580, 129579, 129578, 129577, 128511, 128510, 128509, 128508, 128507, 128506, 128505, 128504, 128503, 128502, 128501, 128499, 128498, 128497, 128496, 128495, 127298, 127297, 127296, 127294, 127293, 127291, 127290, 127288, 127284, 127282, 126385, 126384, 126382, 126381, 126380, 126379, 126378, 126377, 126376, 126375, 126374, 126373, 126372, 126371, 126370, 126369, 126368, 125837, 125835, 125834, 125833, 125831, 125830, 125828, 125827, 125826, 123921, 123920, 123917, 123916, 123914, 123913, 123912, 123911, 123910, 123909, 123908, !
123907, 122477, 122476, 122475, 122474, 122473, 122472, 122469, 122466, 122465, 122463, 122462, 122461, 122460, 122459, 121861, 121860, 121859, 121858, 121857, 121856, 121855, 121854, 121852, 121851, 121850, 121848, 120508, 120507, 120506, 120505, 120503, 120502, 120501, 120500, 120499, 120494, 120492, 120491, 120490, 120487, 118665, 118663, 118662, 118659, 118216, 118146, 118145, 118144, 118143, 118141, 116753, 116751, 116750, 116749, 116748, 116747, 116743, 116741, 116106, 116100, 116097, 115546, 115543, 115539, 115536, 115535, 115532, 115531, 110562, 110561, 110560, 110559, 110558, 110557, 106228, 106226, 104282, 104281, 104279)
AND delpost.primaryid IS NULL
AND thread.open <> 10
AND thread.visible = 1
AND post.userid NOT IN (Pornofan)
AND thread.postuserid NOT IN (Pornofan)
mysql error: Unknown column 'Pornofan' in 'where clause'
mysql error number: 1054
mysql error: Unknown column 'Pornofan' in 'where clause'
i know user Pornofan is a banned user and the query constructed by vbulletin is wrong ... plz help..
Full query generated by vbulletin below :
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT postid AS itemid, thread.forumid,
IF(postuserid = 4, 'self', 'other') AS starter
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid =
post.threadid)
LEFT JOIN deletionlog AS delpost
ON(delpost.primaryid = post.postid AND delpost.type = 'post')
WHERE postid IN(181166, 181165, 181164, 181162, 181161, 181160, 181159, 181158, 181157, 181156, 181155, 181154, 181153, 180693, 180692, 180690, 180689, 180688, 180687, 180686, 180679, 180678, 180673, 180668, 180667, 180663, 180662, 180657, 180655, 180654, 174935, 174934, 174933, 174930, 174929, 174928, 174878, 174874, 174873, 174872, 174871, 174868, 174867, 174865, 174864, 174863, 174861, 174860, 174857, 170016, 170014, 169406, 168855, 168853, 168852, 168851, 168849, 168837, 168836, 168834, 168833, 168831, 168600, 168366, 167040, 166548, 166547, 166545, 166544, 166543, 166541, 166539, 166538, 166535, 166534, 165393, 165392, 165390, 165389, 165388, 165387, 165386, 165385, 165384, 165383, 165381, 165380, 165379, 165378, 165377, 165376, 165375, 165374, 165373, 164920, 164919, 164916, 164915, 164914, 164913, 164912, 164911, 164910, 164909, 164907, 164904, 164903, 164902, 164900, 164899, 164898, 164897, 164896, 164895, 164893, 164891, 164889, 162492, 162491, 162490, 162489, 16!
2487, 162486, 162485, 162484, 162483, 162482, 162481, 162480, 162479, 162477, 162476, 162475, 162474, 162470, 162469, 162468, 162466, 162465, 162464, 162463, 162462, 162461, 162460, 162459, 161412, 161411, 161410, 161382, 161381, 161380, 161377, 161374, 159784, 159783, 159776, 159775, 159773, 159770, 159769, 158874, 158871, 158867, 158865, 158864, 158862, 158861, 158859, 158857, 158856, 158854, 158851, 158850, 158848, 158846, 158845, 158844, 158842, 158841, 158838, 158836, 158834, 158833, 158830, 158829, 158822, 158821, 158819, 158816, 158814, 158812, 158811, 158810, 158808, 158806, 158805, 158803, 158801, 154028, 154027, 154022, 154021, 153850, 153844, 153843, 153841, 153836, 153834, 153829, 153825, 153824, 153823, 153820, 153818, 153816, 153815, 153812, 153811, 153809, 153807, 153805, 153803, 151716, 151715, 151714, 151710, 151707, 151706, 151705, 151703, 151700, 151697, 151695, 151693, 151690, 151669, 151668, 151666, 151665, 149677, 149676, 149675, 149673, 149668, 149667!
, 149666, 149665, 149663, 149662, 149661, 149659, 148865, 1488!
63, 148861, 148860, 148848, 148845, 148843, 148841, 148839, 148838, 148837, 148835, 148834, 148833, 148832, 148831, 148830, 148829, 148828, 148827, 148826, 147513, 147512, 147511, 147510, 147509, 147507, 147505, 147504, 147499, 147498, 147496, 147495, 147493, 145406, 145405, 145404, 145403, 145402, 145401, 145400, 145399, 145398, 145397, 145396, 145395, 145394, 145393, 145392, 144768, 144766, 144765, 144763, 144762, 144761, 144759, 144156, 144155, 144154, 144153, 144152, 144151, 144149, 144148, 144147, 144146, 144144, 144143, 144141, 144140, 144139, 144138, 144136, 144134, 144133, 144131, 144130, 144128, 143161, 143159, 143158, 143157, 143156, 143155, 143154, 143153, 143152, 143149, 143148, 143146, 143144, 143143, 143141, 143140, 143139, 143138, 143136, 143135, 143134, 143133, 143132, 143131, 143130, 143129, 143127, 143126, 143125, 141661, 141660, 141659, 141658, 141657, 141656, 141655, 141653, 141652, 141649, 141648, 141645, 141643, 141640, 141637, 140911, 140908, 140906, 1!
40903, 140900, 140899, 140897, 140895, 140894, 140892, 140890, 140888, 140887, 140885, 140881, 140880, 140876, 140874, 140871, 140869, 140865, 140864, 139338, 139337, 139335, 139333, 139331, 139330, 139329, 139328, 139326, 139325, 138842, 138840, 138839, 138836, 138832, 138830, 138829, 138826, 138823, 138819, 138817, 138814, 138813, 138812, 138811, 138809, 138806, 138802, 138799, 138798, 138797, 138796, 138794, 138793, 138790, 138789, 138784, 138781, 138779, 138777, 135850, 135849, 135847, 135846, 135845, 135844, 135843, 135842, 135841, 135840, 135839, 135837, 135836, 135835, 135301, 135300, 135299, 135298, 135296, 135295, 135294, 135292, 135291, 135290, 135289, 135288, 135287, 135285, 135284, 135283, 133684, 133680, 133679, 133677, 133676, 133675, 133672, 133670, 133668, 133666, 133664, 133256, 132894, 132892, 132889, 132888, 132886, 132885, 132883, 132882, 132881, 132880, 132879, 132783, 132782, 132781, 132780, 132779, 132778, 132776, 132775, 132774, 132773, 132772, 13277!
1, 132769, 132768, 132766, 132765, 132764, 132763, 132761, 132!
760, 132759, 132304, 132303, 132302, 132301, 132300, 132299, 132298, 132297, 132295, 132294, 132293, 132292, 132291, 132290, 132289, 132288, 132287, 132285, 132283, 132281, 132280, 132279, 132278, 132277, 132276, 132275, 132273, 132272, 132271, 132270, 130687, 130685, 130671, 130670, 130668, 130666, 130665, 130662, 130661, 130659, 130657, 130655, 130654, 130653, 130652, 130651, 129646, 129644, 129587, 129586, 129585, 129584, 129583, 129582, 129581, 129580, 129579, 129578, 129577, 128511, 128510, 128509, 128508, 128507, 128506, 128505, 128504, 128503, 128502, 128501, 128499, 128498, 128497, 128496, 128495, 127298, 127297, 127296, 127294, 127293, 127291, 127290, 127288, 127284, 127282, 126385, 126384, 126382, 126381, 126380, 126379, 126378, 126377, 126376, 126375, 126374, 126373, 126372, 126371, 126370, 126369, 126368, 125837, 125835, 125834, 125833, 125831, 125830, 125828, 125827, 125826, 123921, 123920, 123917, 123916, 123914, 123913, 123912, 123911, 123910, 123909, 123908, !
123907, 122477, 122476, 122475, 122474, 122473, 122472, 122469, 122466, 122465, 122463, 122462, 122461, 122460, 122459, 121861, 121860, 121859, 121858, 121857, 121856, 121855, 121854, 121852, 121851, 121850, 121848, 120508, 120507, 120506, 120505, 120503, 120502, 120501, 120500, 120499, 120494, 120492, 120491, 120490, 120487, 118665, 118663, 118662, 118659, 118216, 118146, 118145, 118144, 118143, 118141, 116753, 116751, 116750, 116749, 116748, 116747, 116743, 116741, 116106, 116100, 116097, 115546, 115543, 115539, 115536, 115535, 115532, 115531, 110562, 110561, 110560, 110559, 110558, 110557, 106228, 106226, 104282, 104281, 104279)
AND delpost.primaryid IS NULL
AND thread.open <> 10
AND thread.visible = 1
AND post.userid NOT IN (Pornofan)
AND thread.postuserid NOT IN (Pornofan)
mysql error: Unknown column 'Pornofan' in 'where clause'
mysql error number: 1054
Comment