Announcement

Collapse
No announcement yet.

What's this sql error?

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

  • What's this sql error?

    Any ideas what's wrong here?
    Code:
    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

    Code:
    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: http://www.dvdplaza.fi/forums/search.php
    Referer: http://www.dvdplaza.fi/forums/search.php?
    Username: removed
    IP Address: removed

  • #2
    The problem with both is this:
    Code:
    postid IN()
    You can't leave the ()'s empty.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment

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