Das alles habe ich schon begriffen, aber das funktioniert nur, wenn das Programm auch funktioniert:
Fatal error: Invalid SQL: ( SELECT messageTable.postID AS messageID, 'post' AS messageType , MATCH (messageTable.subject, messageTable.message) AGAINST ('Duisburg') + (5 / (1 + POW(LN(1 + (1395494528 - messageTable.time) / 2592000), 2))) AS relevance FROM wbb1_1_post messageTable , wbb1_1_thread thread WHERE MATCH (messageTable.subject, messageTable.message) AGAINST ('Duisburg' IN BOOLEAN MODE) AND ((thread.threadID = messageTable.threadID AND thread.boardID IN (21,263,33,82,83,84,81,61,62,87,96,135,14,15,116,247,248,260,261,76,35,281,1,71,63,26,16,159,160,113,64,205,206,207,94,242,243,244,245,246,34,58,57,60,289,282,298,290,287,288,271,272,273,2,10,162,20,78,11,32,4,9,163,19,73,12,24,31,3,8,161,18,75,13,28,5,6,164,17,74,7,25,29,44,46,165,47,86,89,48,22,101,38,141,142,202,203,204,42,107,114,40,103,105,154,155,156,100,102,104,143,144,145,138,139,140,151,152,153,119,120,121,123,124,125,122,129,130,131,132,133,126,127,128,180,181,182,268,269,270,36,59,264,41,39,157,110,43,108,50,146,191,262,134,265,266,267,255,256,257,258,286,176,51,53,54,52,72,90,92,91,95,111,168,172,173,174,198,199,200,201,214,215,216,217,225,226,229,227,228,249,250,251,252,213,167,169,170,171,194,195,196,197,209,210,211,212,221,222,223,224,177,118,147,175,192,240,183,184,185,186,187,188,189,190,275,276,277,278,279,280,283,291,292,293,294,295,296,297,299,300,301,302,303,304,306,307,308) AND messageTable.isDeleted = 0 AND messageTable.isDisabled = 0 AND thread.languageID IN (0,4))) GROUP BY messageID) UNION ( SELECT messageTable.pmID AS messageID, 'pm' AS messageType , MATCH (messageTable.subject, messageTable.message) AGAINST ('Duisburg') + (5 / (1 + POW(LN(1 + (1395494528 - messageTable.time) / 2592000), 2))) AS relevance FROM wcf1_pm messageTable WHERE MATCH (messageTable.subject, messageTable.message) AGAINST ('Duisburg' IN BOOLEAN MODE) AND (((userID = 27713 AND (saveInOutbox = 1 OR isDraft = 1)) OR pmID IN (SELECT pmID FROM wcf1_pm_to_user WHERE recipientID = 27713 AND isDeleted < 2))) GROUP BY messageID) UNION ( SELECT messageTable.photoID AS messageID, 'userGalleryPhoto' AS messageType , MATCH (messageTable.title, messageTable.description) AGAINST ('Duisburg') + (5 / (1 + POW(LN(1 + (1395494528 - messageTable.uploadTime) / 2592000), 2))) AS relevance FROM wcf1_user_gallery messageTable WHERE MATCH (messageTable.title, messageTable.description) AGAINST ('Duisburg' IN BOOLEAN MODE) GROUP BY messageID) UNION ( SELECT messageTable.linkID AS messageID, 'linkListLink' AS messageType , MATCH (messageTable.subject, messageTable.message) AGAINST ('Duisburg') + (5 / (1 + POW(LN(1 + (1395494528 - messageTable.time) / 2592000), 2))) AS relevance FROM wcf1_linkList_link messageTable WHERE MATCH (messageTable.subject, messageTable.message) AGAINST ('Duisburg' IN BOOLEAN MODE) AND (Array) GROUP BY messageID) ORDER BY relevance DESC LIMIT 1000
Das ist alles, was das Programm auf meine Suche nach Duisburg antwortet.
Leidwer habe ich keinen Linbk gefunden, der es mir erlaubt, den Admin darauf aufmerksam zu machen, das es einen Fehler im Forum gibt.