What's this sql error?

[Mika]

Any ideas what's wrong here?

Invalid SQL:
SELECT post.postid, post.threadid
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() OR postid IN(32263, 55060, 254456))
AND delpost.primaryid IS NULL
AND post.visible = 1

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR postid IN(32263, 55060, 254456))
AND delpost.primaryi

mysql error number: 1064

Date: Thursday 21st of July 2005 03:27:33 AM
Script: http://www.dvdplaza.fi/forums/search.php
Referer: http://www.dvdplaza.fi/forums/search.php?
Username: removed
IP Address: removed

and

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT post.postid, post.threadid
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() OR postid IN(32263, 55060, 254456)) AND post.postid IN(2427,3660,3662,3753,3853,3897,4377,4447,4561,4802,5079,5613,5685,5732,5915,5918,6232,6525,6848,6898,6914,6962,7314,7393,7836,8093,8392,8518,8534,8774,8855,9104,9172,9180,9909,10012,10198,10627,10634,11162,11382,12051,12151,12156,12327,12551,12633,13410,13698,14118,14671,14679,15453,15937,16477,16743,16826,16913,17255,17259,17518,17833,18186,18466,18525,18658,19178,19251,19268,19425,19545,19564,19591,19639,20121,20347,20992,23030,24741,27039,27068,27279,29896,30171,30454,30602,30615,31507,32067,32216,32858,33388,33733,34323,35533,35714,36122,36308,36737,37527,37632,37983,38475,38877,40916,41154,42176,42681,42837,42841,43579,44317,45750,45754,46624,47080,47796,48288,48296,48486,49149,49153,50200,50790,50969,50981,50987,51105,52604,53188,53817,54406,54575,54581,54670,54693,57089,57665,58627,58688,59846,60196,60244,60294,62170,62315,62673,62751,63082,63729,64742,65092,65579,66592,66661,66835,66858,6710!
4,68450,69981,70013,70732,72567,73945,73947,73952,73957,74037,74313,74529,74678,75035,75399,75941,76727,76841,78001,78181,78745,81313,81398,81837,81857,81983,82011,83106,83153,83161,84585,84968,84971,85557,85577,86268,86317,86327,86328,86643,86656,86697,86699,87595,87636,87661,88098,88128,88225,88281,88335,89243,89255,89827,90011,90615,91499,91503,91912,92263,92592,92903,92906,93029,93282,93523,94111,94268,94859,94892,95670,95915,95919,95946,97301,97607,97614,97616,99206,99930,100646,101425,101772,103191,103689,103691,103697,103767,104157,104227,105644,105645,106321,106471,107323,107686,108192,108203,108523,108783,109113,109287,109538,109873,110515,111419,112249,112586,112907,113110,115565,117413,117571,117679,118347,118927,120118,120477,120547,120904,121341,121813,122841,123702,124318,124533,125759,126126,126843,126884,127631,128498,128886,129300,129925,132294,132305,132309,132310,132311,132415,133056,133208,133417,133477,133566,133796,134937,135975,136002,136112,136814,13!
7843,138482,140039,140257,141434,141519,144117,144120,144140,1!
44144,14
4195,144201,144373,144394,145953,145970,145994,146652,147271,147285,147994,148648,149669,150186,150196,151237,151976,152109,152660,152713,152751,153371,154056,155650,155745,155874,158073,158242,158504,158693,159798,159861,159888,159909,160093,160245,160891,160932,161461,162269,162303,162429,162479,163864,165915,166503,166875,166914,167108,167535,167793,167795,167897,168262,168884,168969,168973,168985,169176,169179,169330,169382,169772,169927,169936,169999,170001,170105,172216,172786,172882,173181,174025,174046,174714,175505,175771,175927,176351,176523,176701,177351,177422,177428,177433,177545,177633,178222,178307,179585,180081,181842,182193,182234,182853,183193,183414,183514,183518,184613,184798,185873,186865,187595,187630,188957,188996,189033,189431,189458,190117,190431,190460,191014,193475,193884,194741,195520,196914,197852,198270,198963,199284,199885,200113,200200,200529,201741,202259,202825,203258,203663,203747,204252,204605,204607,205086,205132,205372,205377,205396,2072!
13,207253,208065,208538,208701,208750,210399,211235,211564,211719,212023,212190,212495,213396,214468,215236,215422,216352,218659,218914,219532,219898,219937,219948,220015,220178,220999,221204,221206,221537,222102,222103,223399,223702,223985,224185,224791,224929,225098,226336,226433,227131,227151,227181,227189,227566,227575,227580,228765,231352,231853,232032,232457,232864,233045,233175,233401,234228,235244,236357,236380,236786,236835,236843,236890,237656,238214,238355,238451,241020,241257,241258,241555,242112,242487,242884,243556,244778,247474,248024,248193,248204,248230,249383,252620,253348,253697,253771,255975,256982,257427,258797,258932,259204,259577,259643,261807,262228,262661,263396,264548,264754,265283,266160,267298,268046,286509,286647,344490,345897,345899,346339,346859,347924,349352,349870,350160,351139,351674,352281,352729,352899,353000,353378,354286,355776,356018,356386,356786,356926,356996,357772,358699,358856,359703,359858,360192,361201,361965,363234,363275,36354!
7,364472,365181,365431,365598,366163,366164,366829,366879,3669!
07,36698
1,367323,367524,368393,368896,369198,370861,371988,373405,375558,375899,376103,376340,376467,377017,377289,378640,379769,380414,380464,380900,381346,382207,382716,383654,384603,385282,386049,386820,387370,387963,388095,388113,388564,389155,389220,389918,390260,390291,391668,392939,393131,394791,394916,396144,396435,396531,396585,397302,399577,399730,399750,400284,400435,400752,401764,401958,402724,402816,405520,406059,407067,407242,407850,408203,408204,410107,413223,413835,414238,414277,415078,416281,416664,417030,417292,417294,417595,417986,418657,419728,419982,420959,421453,421558,421762,422227,422637,422685,423341,425287,426542,427037,427328,427361,427422,427959,430954,432328,432679,433119,433300,433795,434543,435312,436760,437125,437513,438084,439488,440227,443176,445580,445658,445938,446485,447950,448914,449292,449323,449329,450547,450839,451281,451341,451356,451830,453985,456770,456878,457937,458013,458326,458432,460324,460859,462428,462569,463281,465189,465668,466936,!
467449,469728,469940,472594,472756,473886,474465,477324,478594,478847,481023,481026,481300,483761,486066,488150,490508,492256,496439,496888,497705,498159,500124,501040,501281,501451,501597,506089,506560,506669,507077,507952,508040,508977,509958,512062,514070,514251,517048,518588,519775,520474,520538,520792,522642,524393,527294,529031,529058,529315)
AND delpost.primaryid IS NULL
AND post.visible = 1

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR postid IN(32263, 55060, 254456)) AND post.postid IN(2427,3

mysql error number: 1064

Date: Thursday 21st of July 2005 03:27:26 AM
Script: [url]http://www.dvdplaza.fi/forums/search.php[/url]
Referer: [url]http://www.dvdplaza.fi/forums/search.php?[/url]
Username: removed
IP Address: removed

[Colin F]

The problem with both is this:

postid IN()

You can't leave the ()'s empty.