I get this error while searching the forums:

 

 

 

 

 

 

 

 

 

 

 

Could not obtain topic ids







DEBUG MODE







SQL Error : 1064 You have an error in your SQL syntax near 'GROUP BY p.topic_id' at line 5







SELECT p.topic_id FROM phpbb_posts p WHERE p.post_id IN (184, 334, 346, 934, 1060, 1096, 1477, 1677, 1877, 1902, 2693, 2698, 4544, 4753, 6560, 7833, 7879, 8102, 8298, 9804, 9224, 9589, 10412, 10629, 10770, 10781, 11262, 11833, 12051, 12093, 12130, 12364, 12370, 12565, 12572, 12629, 12690, 12788, 12789, 12833, 12906, 13014, 13163, 13195, 13238, 13424, 13658, 14029, 15936, 15953, 16094, 17174, 17212, 36154, 17464, 17596, 17606, 17930, 18532, 80587, 18931, 19953, 21482, 21550, 21679, 21826, 21844, 22009, 22638, 22985, 23970, 24165, 24229, 24232, 24470, 25846, 25948, 25977, 26394, 26408, 27847, 28004, 28167, 29447, 31362, 31551, 31685, 32768, 32789, 34420, 34743, 36421, 37388, 38052, 39241, 39637, 39684, 67925, 41360, 41373, 41386, 41822, 43135, 44382, 44684, 45115, 45160, 46655, 50051, 50370, 68001, 143371, 53603, 53804, 55508, 55705, 1633425, 56897, 56949, 56955, 57025, 58342, 58964, 59044, 61580, 62922, 64876, 64886, 65838, 82288, 67032, 68388, 68937, 94685, 69413, 69547, 69746, 69775, 1633484, 1649435, 1649430, 71041, 71623, 72434, 72711, 72870, 72909, 72977, 73147, 73385, 73587, 74911, 123962, 94609, 78987, 94580, 80307, 99628, 99766, 83730, 83752, 83986, 84613, 86419, 89188, 100944, 90456, 144420, 91061, 91632, 91802, 92421, 92627, 92834, 92853, 110748, 95044, 95288, 95336, 97760, 98402, 98427, 98923, 99442, 99959, 102772, 103054, 121940, 109824, 110774, 110803, 110809, 110920, 110922, 111099, 111243, 111285, 111425, 111436, 111470, 111486, 111554, 146379, 112103, 130000, 113798, 113271, 113725, 113745, 113830, 115115, 115154, 115200, 115288, 115829, 115879, 116034, 116625, 116999, 117032, 117211, 117339, 117547, 117663, 117865, 118119, 118339, 119707, 120277, 121882, 124103, 126155, 128322, 128334, 129207, 129275, 129470, 155933, 155931, 131934, 145036, 149718, 133259, 136532, 137459, 137469, 137764, 137778, 137906, 138358, 139230, 155671, 140847, 142433, 143058, 143167, 143168, 143207, 143238, 143243, 143249, 143299, 143325, 143339, 143425, 143439, 143446, 143471, 143474, 143483, 143487, 143490, 143497, 143546, 143627, 143702, 144012, 144348, 144653, 144951, 144768, 145425, 145562, 146182, 146976, 147073, 147229, 147233, 147603, 147981, 148692, 148701, 148905, 149850, 150006, 150860, 165520, 156286, 151388, 151902, 152244, 152274, 153019, 153043, 1572277, 153162, 154448, 154485, 156254, 156298, 156312, 156571, 157474, 158066, 159312, 160424, 160812, 175758, 162429, 162675, 162736, 181897, 163467, 163522, 163874, 163879, 163937, 164964, 181893, 166366, 166377, 166790, 166901, 167064, 169552, 169575, 169581, 169586, 169591, 169621, 170289, 170307, 172159, 172478, 173423, 173689, 173910, 176250, 176270, 199426, 177805, 177859, 177879, 177880, 177916, 178086, 178130, 178153, 179154, 179736, 180523, 181209, 181273, 182736, 185049, 186533, 187332, 187388, 187676, 188569, 206002, 189822, 190666, 190674, 191235, 209429, 192453, 194149, 196068, 197001, 197594, 197736, 199030, 200374, 202396, 202471, 204304, 215467, 205436, 206104, 206110, 206353, 206461, 206677, 206979, 207514, 208866, 208874, 225536, 209160, 209190, 209231, 209841, 210689, 212084, 211427, 225549, 215028, 215097, 215792, 215835, 215847, 215953, 216878, 217123, 217593, 219016, 219374, 219381, 220075, 220452, 249493, 246359, 224216, 224242, 224244, 224250, 224271, 224280, 224363, 238753, 225125, 226737, 226748, 226871, 227211, 227884, 228370, 228436, 228650, 228961, 229871, 230537, 246918, 234976, 235924, 235975, 249356, 1628453, 237941, 238051, 238629, 239489, 239782, 240380, 240851, 240975, 241137, 241141, 241921, 243562, 280059, 243879, 244202, 244471, 247509, 249089, 249333, 250111, 252850, 280036, 253252, 254136, 280018, 256081, 256827, 257165, 258393, 258413, 258452, 258911, 260770, 261296, 275456, 264785, 265031, 265540, 266143, 266195, 266454, 268302, 268845, 270127, 270524, 270889, 271427, 271502, 271614, 271631, 271673, 272540, 272729, 272841, 273012, 273378, 273436, 273467, 273724, 274327, 275254, 275714, 275936, 276273, 276290, 276423, 276962, 277109, 277129, 277144, 277246, 277254, 277262, 277270, 277275, 293185, 278135, 278211, 312340, 292806, 280671, 280956, 282391, 282584, 282657, 283346, 283452, 298115, 283983, 284482, 1649427, 286214, 287577, 287664, 287683, 287688, 287959, 288023, 288395, 289122, 292537, 294571, 295585, 295775, 295788, 296242, 1634400, 299381, 299388, 300136, 300211, 300784, 300970, 301484, 301603, 303024, 303620, 304104, 304821, 327007, 304949, 304998, 306065, 306265, 306647, 307595, 401294, 307849, 314437, 1634502, 310702, 311113, 311448, 327302, 311526, 311580, 311588, 311603, 311759, 312415, 337872, 312910, 314416, 314465, 314630, 315448, 315452, 315569, 315584, 315595, 315701, 315800, 315910, 315975, 316547, 317444, 362878, 318919, 319165, 319266, 320671, 321911, 337655, 322798, 354780, 324578, 324701, 337613, 325550, 326714, 327792, 328548, 328764, 328869, 330826, 348512, 348497, 332077, 332111, 332679, 332892, 332983, 334375, 335002, 335724, 335868, 336094, 336177, 337003, 351267, 337441, 337454, 338633, 338752, 338777, 338849, 339107, 339821, 340114, 341227, 342404, 342696, 342888, 342912, 343185, 343423, 343719, 343850, 345290, 345384, 345480, 345500, 345841, 346868, 348020, 349599, 349866, 351003, 351072, 352283, 352382, 352477, 352868, 353450, 354008, 354642, 354647, 355008, 355223, 355567, 355584, 356381, 356572, 357579, 360993, 358061, 358071, 358228, 358592, 359553, 359798, 360048, 360560, 360577, 361120, 361272, 361511, 361797, 363096, 364030, 364253, 364825, 411728, 365238, 376985, 365593, 365607, 365678, 365727, 386313, 366733, 384012, 384005, 386700, 370410, 371028, 494897, 373616, 373761, 415811, 374884, 494344, 375666, 389156, 389160, 494613, 401328, 398752, 396351, 381037, 399776, 1635475, 382805, 395221, 383835, 383903, 384167, 384174, 384270, 384307, 384321, 384473, 385273, 385297, 385774, 385939, 386361, 386994, 387185, 387639, 387935, 388572, 388676, 388930, 389444, 390048, 390162, 417774, 390323, 390365, 390576, 390763, 390800, 391050, 391750, 392191, 434475, 394408, 394652, 394992, 395038, 1231143, 396032, 396073, 412489, 426729, 397774, 397983, 398164, 399602, 399673, 757832, 401426, 428808, 408613, 411547, 413292, 414853, 418097, 418273, 422347, 1635991, 423020, 424208, 424332, 481661, 425193, 426810, 451931, 425359, 425744, 428364, 428841, 429163, 429476, 429562, 430774, 431323, 431325, 431329, 431337, 431343, 431368, 431523, 431528, 432681, 434262, 434936, 435063, 435175, 435506, 435975, 436242, 436590, 437517, 438164, 439228, 439356, 442473, 442507, 442555, 442565, 442819, 443236, 443922, 443933, 444474, 511351, 457906, 447467, 479197, 449990, 449999, 450843, 454922, 456132, 456446, 456513, 456783, 481624, 459099, 459245, 460841, 460921, 474701, 461862, 461943, 476263, 464275, 464407, 464908, 482712, 481585, 1636560, 468972, 469806, 471272, 472062, 472133, 472220, 472768, 473019, 473220, 473757, 473890, 474539, 475050, 495964, 476205, 476566, 476581, 476712, 478158, 1636653, 481874, 478587, 479749, 479860, 480036, 481687, 481698, 481783, 481963, 481994, 484266, 486760, 509008, 489175, 491975, 493758, 493870, 527088, 496866, 497545, 497798, 497983, 497991, 498066, 498683, 498874, 498923, 499127, 499207, 499348, 499743, 500140, 500362, 500470, 500537, 501175, 501278, 501694, 501829, 501890, 502003, 502116, 502162, 503692, 503745, 503891, 504045, 504085, 504451, 504559, 504664, 504742, 504756, 504944, 505147, 505226, 505867, 505877, 520679, 507124, 507133, 507185, 507360, 507411, 508344, 508520, 509084, 509331, 1645378, 522841, 509964, 510756, 510940, 511403, 536836, 511822, 511929, 512303, 512816, 513557, 513762, 515918, 516034, 516222, 555407, 516900, 517813, 520860, 520999, 542099, 536892, 525372, 530910, 531135, 531273, 532684, 532883, 534671, 545988, 536139, 536294, 537160, 545946, 538508, 538737, 539699, 539795, 540067, 540278, 540411, 571424, 542984, 543850, 544348, 545305, 545676, 545925, 545935, 560904, 571954, 547507, 548002, 550236, 550497, 550995, 551686, 552120, 552573, 552717, 552755, 554517, 558745, 558865, 558913, 560326, 592896, 560830, 561248, 592775, 562952, 578913, 590407, 565653, 599186, 568386, 568403, 568524, 569334, 570619, 571486, 593243, 603471, 573754, 574913, 574676, 574689, 574787, 593309, 605548, 576243, 577381, 578227, 579048, 580186, 580481, 580511, 580678, 581037, 581915, 584261, 591666, 586917, 1637469, 588964, 602077, 589205, 589613, 590046, 590102, 1638289, 591484, 591511, 591625, 607626, 593475, 593491, 594540, 595087, 595138, 595147, 595158, 595389, 611110, 596658, 597039, 597822, 598163, 598210, 598307, 598562, 598583, 599725, 600373, 626712, 602030, 602326, 1637832, 605043, 605401, 605568, 605629, 605661, 605669, 612597, 605913, 605925, 606092, 606113, 606134, 648317, 620023, 609897, 1638008, 610637, 610705, 610931, 633173, 613391, 620215, 621002, 621603, 622078, 653748, 623759, 624289, 626926, 648572, 628188, 628213, 628843, 629178, 648038, 653948, 684227, 634759, 635192, 635748, 636258, 776003, 638249, 1638718, 1638736, 640223, 642351, 642436, 642825, 642940, 643761, 643804, 643869, 644469, 644954, 647563, 649395, 649530, 650253, 650255, 650679, 650734, 1639676, 652000, 652301, 653189, 686214, 653479, 654439, 655020, 657435, 668960, 659907, 688077, 661211, 661539, 661682, 661723, 712318, 662278, 663349, 663810, 666641, 1649483, 688059, 668937, 669123, 669473, 705177, 670012, 670673, 670791, 670807, 672128, 673090, 673138, 673922, 674048, 674962, 675072, 675119, 675124, 677857, 678882, 679228, 700086, 691477, 693098, 681255, 681352, 681475, 681591, 682052, 683893, 683897, 686307, 686391, 686421, 686544, 686575, 686614, 686636, 686689, 687372, 687496, 687759, 688563, 688753, 689349, 689597, 690362, 690706, 691036, 691164, 691410, 693381, 694017, 694371, 695065, 712420, 696735, 697152, 712391, 750035, 704329, 720557, 705914, 706573, 706879, 707824, 747492, 729078, 709558, 709588, 729025, 710636, 735367, 735361, 728752, 714073, 718727, 735334, 717188, 717193, 719415, 720166, 720875, 720911, 721387, 721548, 721962, 722037, 723809, 723847, 724789, 724914, 724925, 725004, 726015, 726203, 727399, 727884, 746580, 731043, 731089, 731759, 770479, 733080, 775973, 756985, 733771, 733827, 746516, 735466, 736114, 736251, 737430, 737669, 761810, 738752, 738920, 739446, 739861, 761794, 779147, 897079, 741188, 742427, 742941, 743440, 743565, 743809, 743926, 744018, 744071, 744287, 770485, 746427, 746838, 746879, 746919, 747626, 747961, 787138, 750655, 750909, 751398, 751448, 754205, 754214, 755245, 755715, 756614, 756684, 757315, 758305, 758328, 779703, 758805, 760981, 761379, 762043, 762449, 763408, 766225, 767037, 767411, 768108, 768136, 769058, 1641728, 1641334, 1647606, 771025, 771076, 771853, 773131, 773879, 773990, 774040, 774369, 788287, 774967, 775339, 777081, 1642115, 778313, 1642156, 778519, 778826, 778984, 1651056, 779781, 780746, 780843, 780928, 781409, 782557, 782770, 783646, 1643485, 1646290, 1652885, 1644143, 1644383, 1645084, 1645858, 1647407, 1648363, 1648730, 1649924, 1651450, 1651708, 1653535, 1651966, 1652331, 1652412, 1652478, 1652784, 1653288, 1653431, 1653564, 1581820, 1653840, 1653950, 1619235, 1655022, 1655053, 1654863, 1655982) AND p.forum_id = 54 GROUP BY p.topic_id GROUP BY p.topic_id







Line : 506



File : search.php

 

 

 

 

 

 

 

 

 

 

 

Any help please?

Yup search aint working atm, grin is playing with it atm :P

Same as zonda's topic. Fixed now though.

Any idea what exactly was wrong or how he fixed it? Just curious :wink:

Search being fixed/rebuilt, change made to speed it up, didn't work - change reversed. :)

 

 

 

 

 

 

 

Thanks for posting the queries here though, appreciate you alerting people of board errors.