1054 - Unknown column 't.prefix' in 'on clause' probleem

hallo,
ik heb op mn forum een 1054 - Unknown column 't.prefix' in 'on clause' probleem , kan iemand me aub uitleggen hoe ik dit kan oplossen?

zie hieronder het volledige foutmelding

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 't.prefix' in 'on clause'
Query:
SELECT t.*, u.username AS userusername, p.displaystyle AS threadprefix FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid=t.uid) LEFT JOIN mybb_threadprefixes p ON (p.pid=t.prefix) WHERE t.tid IN (17564,19515,9873,5041,17342,40,39,19408,13096,1873,19403,8253,18733,19380,6653,19373,14397,3945,3913,6989,8252,19307,17419,56,3063,12184,4311,18379,11110,17550,8414,4829,17552,1674,18923,18983,11530,7867,4456,17566,17568,1676,4451,737,15008,18749,12281,9974,14436,14437,4441,17560,18380,18732,17892,150,153,14579,2492,18544,158,2299,18542,18541,149,235,17244,3552,17215,3784,70,18497,4409,44,17889,3782,11779,2981,18378,2296,2085,160,13094,41,17563,2188,10559,17850,2090,2175,17561,157,245,13942,18016,18042,2283,4309,12358,10832,7335,17672,6838,1147,2982,7330,17930,17899,7315,7297,42,17212,4314,17549,17555,17556,17551,17553,7338,17214,17554,7326,17558,4772,17428,4303,2323,17607,12199,17635,17729,17740,17599,2402,17741,17742,17739,7174,17700,17671,7303,7627,17608,17605,17606,14263,17545,17548,17562,17565,17567,17546,17547,2986,17361,10757,17486,14460,1164,17462,17463,17464,17362,17245,2170,16859,17424,17422,17421,17420,3772,17360,17363,496,12153,17332,16955,17270,17271,17247,14847,4307,11268,38,17213,4308,4315,4302,11841,10116,12075,12136,12183,14075,16993,6652,17103,17053,17104,17105,6451,2891,16956,17045,17054,16668,5199,14324,14381,43,16907,5202,16863,16745,5045,5082,5061,16713,16711,16710,16459,2595,5028,10803,5062,10899,5046,15109,244,8822,15801,15847,15848,997,15763,10898,5034,3778,8844,15147,2746,4439,3775,3780,4437,2173,15241,15004,15003,10758,15002,13616,4310,14881,14876,4305,2355,4306,14580,14435,3777,14434,14438,14198,14433,224,14454,14440,14439,14382,14364,14323,14322,14267,14301,14300,9931,10519,14088,14077,14066,14076,13666,13918,13644,13862,13836,13835,703,12233,13597,4429,13496,13522,24,13253,13245,13248,2357,2359,12669,13246,13310,1432,10850,13257,13247,13201,156,13204,13080,13069,13095,12357,13086,13087,13038,2295,7621,4425,13006,7629,7628,2172,7501,7318,2748,6269,12760,7606,2987,1868,12345,12724,12688,12440,12593,12658,12558,11739,12636,12621,83,12626,12625,12624,12623,12622,7183,12530,12529,12528,12527,12526,12525,12524,12523,12522,12521,12520,12519,12518,12517,12516,12390,12366,12300,2346,12414,12396,12389,12374,12388,12376,12375,12373,12372,12371,12370,12369,9970,11833,10967,2883,11638,12026,11968,11207,8827,11003,103,2242,11787,11786,11785,11784,2336,2344,12009,12008,12007,998,11967,11966,11840,11842,11839,11838,11782,11783,11780,3214,11693,11439,11278,11465,2465,11529,11645,2989,11566,11438,1672,11540,11539,11538,11537,11536,11533,1565,10685,11501,11244,11461,11440,11427,11426,10941,11137,5060,10516,6959,11279,135,9354,8801,11238,11029,10937,9672,11022,5049,11073,5037,10801,5210,11130,10900,8410,5032,5035,5036,5038,5077,8405,10981,11030,5047,10901,11075,11074,11072,11071,11033,11036,11035,11034,11032,11031,9190,10978,10802,8825,10934,10980,10956,10820,1206,10936,10890,2330,10925,10922,10920,10919,10918,10917,10916,10915,10914,10913,10904,10903,10902,10897,10857,2841,10868,10854,1151,10476,10849,10831,10834,10833,10830,10814,10813,10812,10609,9872,10781,4686,4417,10510,4428,10720,4430,4426,10711,9335,9671,10665,10664,9976,10542,10629,10628,10627,10625,10612,10613,10611,2988,10551,10550,10549,10548,9871,10537,10538,10539,10540,10541,10514,10515,10513,10511,10512,10478,10484,10483,10482,10481,10480,10479,10477,10418,10417,10416,10207,7203,2494,9960,10330,8176,10222,10217,10215,10214,10213,10212,8483,10206,10092,10093,9326,9867,9968,10091,10040,10083,9818,9999,10028,6493,10072,10073,10071,10070,10069,10068,8952,10050,10049,10048,10047,10035,10034,10033,10032,10031,10030,10029,10027,10025,2985,9975,9669,9972,9971,9770,8315,8472,9895,9668,9894,9893,9892,9891,9890,9889,9888,9887,9886,9884,9883,9870,8845,2209,2203,8352,9782,2106,2984,9715,2167,1675,8802,9570,4440,1003,2049,2074,9529,8191,9696,9695,9694,9693,9692,139,4422,9330,1853,2599,2366,9421,9641,4300,4304,9524,8910,7162,8513,8515,8514,152,9386,9535,9523,9522,9521,9520,9519,9518,9517,9516,9515,9514,89,3287,2373,9419,8842,8979,2840,9327,4454,9325,8797,8800,8990,4449,999,8840,8820,8914,8832,4062,8830,8663,3785,3779,7164,8915,9085,9082,2123,8991,8972,8989,3394,8848,8719,2493,8966,8677,8961,8908,8912,8911,8906,8902,8898,8884,8819,8847,8831,8836,8839,8841,8843,8838,8837,8834,8829,8828,8826,8824,8823,8821,8818,8817,8682,8805,8804,8799,8798,8796,8795,8784,8783,8782,8728,8679,8658,8720,1005,8688,8676,8675,8678,8660,8174,8657,8647,8648,8646,8645,8644,8643,8642,8641,8640,8639,8638,8637,8636,8635,8634,8633,8632,8631,8630,8604,8597,8603,8602,8601,8600,8599,8598,8401,3770,8484,5086,7059,7634,8444,8443,8442,8400,8433,8432,8431,8430,8429,8428,8427,8426,8425,8424,8423,8422,8421,8420,8419,8418,8417,8416,8415,8413,8412,8411,8409,8408,8407,8406,8404,6048,8403,8402,8399,8398,8397,8385,8369,8368,6851,8361,8360,8359,8358,8357,8355,8300,8317,8329,186,183,1789,8263,7911,8251,8250,7295,4771,4825,2983,8193,4455,3261,7776,7175,8073,8089,8088,8087,8086,8085,8084,8083,8082,8081,8080,77,8045,3275,3263,7844,6913,7832,7831,7815,7793,7798,7797,7796,7795,7794,7792,7791,7790,7789,7788,7787,7786,7785,7784,7783,7782,7781,7780,7779,7778,7777,7761,7746,19,4445,4450,4453,4459,4446,2823,221,7605,6655,7304,7324,7630,7626,7625,7624,7623,7622,7620,7619,7618,7617,7616,7615,7614,7613,7612,7611,7610,7609,7608,7607,6309,7334,7436,6036,2177,7332,7430,6888,7337,7047,7342,7341,7340,7339,7336,7333,7331,7329,7328,7327,7325,7323,7322,7321,7320,7319,7317,7316,7314,7313,7312,7311,7310,7309,7308,7307,7306,7305,7302,7300,4634,7268,7270,7269,7267,7266,7259,7249,7144,7216,5728,2374,2354,6936,7177,7176,7172,7170,7169,7168,7167,7166,7165,7163,7157,7156,7143,6977,7142,7141,7140,7114,6980,7099,7098,7097,7096,7095,1791,6034,6975,6978,6979,6982,6983,6985,6986,6987,6988,193,6906,6950,6939,6951,6940,6997,4824,7001,6990,6984,6981,6976,6974,6973,6972,6047,6902,6844,3563,6858,6841,6812,6819,6850,6849,6848,6847,1934,6836,6776,6825,6824,6316,3264,137,4737,6349,6627,6615,6494,6246,6251,6255,6386,6408,2118,6126,102,6296,6295,6294,6293,6292,6291,6290,6289,6288,6286,6277,6284,6283,6282,6281,6280,6279,6278,6276,6275,6274,6273,6272,6271,6270,6268,6267,6266,6265,6264,6263,6262,6261,6260,6259,6258,6257,6256,6254,6253,6252,6250,6249,6248,6247,6302,6303,6304,6305,6306,6307,6308,6310,6311,6312,6313,6314,6315,6317,6318,6319,6301,6300,6299,6298,6297,6019,3551,6082,5165,6063,6062,6061,6060,6059,6058,6057,6056,6053,6052,6051,6050,6049,6006,6046,6045,6044,6042,6041,6040,6039,6038,6037,6035,2091,3224,2912,5887,2980,3260,5807,5161,5290,3536,5677,5664,2992,4659,2513,1537,771,3478,2788,789,4036,3474,2043,1898,5134,3477,2185,2183,2187,3265,1154,5489,2709,2371,2370,2356,2884,5330,1698,1568,2990,154,5133,4778,5215,5214,5213,5212,5211,5209,5208,5207,5206,5205,5204,5203,5201,5200,2468,5147,5162,5163,5146,5145,5144,5143,5142,5141,5140,5139,5138,5137,4736,3783,4774,3776,5085,5084,5083,5081,5080,5079,5078,5059,5058,5057,5056,5055,5054,5053,5052,5051,5050,5048,5044,5043,5042,5040,5039,5033,5031,5030,5029,5027,5026,5025,5024,5023,5022,5021,3773,3781,2189,2182,2181,3262,1,4847,4846,4845,4844,4843,4842,4841,4840,4839,4838,4837,4836,4835,4834,4833,4832,4831,4830,4828,4827,4826,4823,4822,4821,4820,63,486,4746,4745,4744,4742,4741,4735,4734,4687,4416,4057,216,4461,4460,4458,4457,4442,4448,4447,4443,4438,4436,4411,4427,4424,4423,4421,4420,4418,3415,4291,4290,4289,4161,4082,4102,4094,4089,4286,4078,4104,4284,4077,4096,2180,4262,4163,537,4162,590,2573,4106,4061,4060,4059,4058,3012,4037,3930,3914,1730,3931,2979,3817,3444,3381,2369,3670,3656,3791,3648,3790,3789,3788,3787,3786,3774,3395,3649,3400,3382,3554,3734,3733,3475,2681,3476,73,3195,133,1850,3565,3564,3562,3561,3560,3559,3558,3557,3556,3555,3553,3537,3540,3538,1780,3213,3479,2178,132,1804,3406,3443,3442,3441,3440,3439,3438,3437,3436,3435,3434,3433,3432,3431,3407,3430,3429,3428,3427,3426,3425,3424,3423,2399,1797,3408,3405,3404,3403,3402,3401,3399,3398,3397,3393,3392,3391,3384,3383,3216,2721,3286,2254,3040,2617,2882,3169,3222,3215,3145,2092,2586,2176,223,2991,3011,3010,3009,3008,2997,2978,2675,2842,2306,2819,2795,2644,2646,2645,2643,2619,2616,1293,2587,2286,2554,2572,2571,2570,2569,2560,2558,2557,2556,2555,2512,71,2496,2490,2488,2484,2479,2478,2476,2475,2473,2469,2466,1152,2282,80,2411,1940,2412,2410,2409,2407,2406,2405,2404,2403,2400,2398,2397,2396,2395,2394,2393,2392,2391,2367,2375,2372,2368,2365,2364,2363,2362,2361,2360,2358,2353,2352,2351,2350,2349,2348,2347,2345,2343,2342,2341,2340,2339,2338,2337,2335,2334,2333,2332,2331,2329,2328,2327,2326,2325,2324,2322,2321,2320,2319,2318,2317,2316,2315,2314,2313,2312,2307,2297,2257,2255,2253,2252,2251,2249,2243,2190,147,2205,67,2210,2208,2207,2206,2204,2202,2201,2200,2199,2198,2197,2196,2195,2194,2186,2184,2179,2174,2171,2169,2168,2166,2154,1144,1434,2093,700,2089,2046,2044,1721,217,1731,1943,1946,1937,1405,1945,1944,1942,1941,1939,1938,1936,1536,1212,1753,1556,14,1872,1871,1870,1869,1867,1866,1852,1851,1849,1847,1842,1841,1840,1839,1838,1837,1836,1835,1834,1831,1830,1829,1828,1827,1826,1825,1824,1823,1821,1820,1819,1818,1817,1816,1815,1813,1812,1811,1810,1809,1808,1807,1806,1805,1803,1802,1801,1800,1799,1798,1772,292,1769,25,1153,1459,1549,1437,1671,1673,1670,1669,1668,1667,1666,1665,1664,1663,739,1650,1577,146,1562,1570,1527,1569,1567,1564,1563,1561,1559,1553,1548,1406,1469,1014,1015,1404,1099,148,142,26,1149,143,1150,1098,15,1148,1146,1145,1143,1017,1016,1013,1012,1011,1010,1009,1008,1007,1006,1004,1002,1001,1000,996,30,34,35,738,138,191,487,136,33,192,194,488,489,1787,1790,1792,1794,1795,1793,1796,1788,1784,1783,293,1782,1781,214,212,190,187,185,184,182,172,171,170,169,159,155,151,145,144,141,140,134,90,88,86,85,84,82,79,78,76,75,72,69,68,65,64,32,31,29,28,27,23,22,21,20,18,16,13,12,11,10) AND t.visible>-1 AND t.fid NOT IN ('377','71','80','173') AND t.fid NOT IN (377,71,80,173) AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost desc LIMIT 0, 50

Zal wel over dit gedeelte gaan:

Dus kijk na of tabel mybb_threads wel de colom/veldnaam prefix bevat.

[Mogelijk interpreteer ik het verkeerd, maar dit is wat ik zou (be-)denken o.b.v. de SQL code.]

Tijs.

ik heb gekeken en er is inderdaad geen prefix in , hoe kan ik die toevoegen aub?

??? Dat is geen vraag die je hier moet stellen. Per slot heeft het weinig zin om een kolom prefix toe te voegen waar verder geen (zinvolle) waarden in staan.
Wel zou je, puur om te zien of de melding verandert of verdwijnt, in die tabel TIJDELIJK een kolom/veldnaam prefix kunnen toevoegen en de query opnieuw draaien.

Toevoegen kan met jouw database beheer hulpprogramma, die je (als het goed is) ook hebt gebruikt om te achterhalen dat prefix als veldnaam niet voorkomt.
Als query zou je 'm moeten kunnen toevoegen via

Beste is, overigens, om eerst in mybb_threadprefixes te kijken welk datatype de kolom/veldnaam pid heeft, want daar vergelijk je t.prefix mee en dus het datatype van pid te gebruiken als datatype van de toe te voegen kolom/veldnaam prefix in tabel mybb_threads, zodat je mijn gokje van TEXT(25) kunt vervangen door een zinvoller datatype.

Tijs.

ok , ik ga eens zoals je hebt uitgelegd hebt zien of ik het kan fixen , dank je

Vind je dit trouwens een beheersbare query? Ik niet namelijk . Ik zou een extra boolean veld toevoegen waarin je de records kunt markeren en daar op filteren.

dank je heb het kunnen maken , meeste werkt nu zoals het hoort dank u

deze topic mag dicht