HI, i have a Problem with that Addonn. If its activ i get this failure:
Datenbankfehler in vBulletin 3.7.0:
Invalid SQL:
SELECT `pm`.*
FROM
(
(
SELECT `pm`.`pmid`, `pm`.`userid`, `pm`.`folderid`,
`pm`.`messageread`,`pmt`.`pmtextid`, `pmt`.`fromuserid`,
`pmt`.`fromusername`, `pmt`.`message`, `pmt`.`touserarray`,
`pmt`.`iconid`, `pmt`.`dateline`, `pmt`.`showsignature`,
`pmt`.`allowsmilie`, `pmt`.`title`
FROM `pm` AS `pm`
LEFT JOIN `pmtext`
AS `pmt`
ON `pmt`.`pmtextid` = `pm`.`pmtextid`
WHERE `pm`.`userid` = 1
AND `pm`.`folderid` != -1
AND SUBSTR(`pmt`.`title`, 1, 4) != 'AW: '
ORDER BY `pm`.`pmid` DESC
) UNION (
SELECT `pm`.`pmid`, `pm`.`userid`, `pm`.`folderid`,
`pm`.`messageread`,`pmt`.`pmtextid`, `pmt`.`fromuserid`,
`pmt`.`fromusername`, `pmt`.`message`, `pmt`.`touserarray`,
`pmt`.`iconid`, `pmt`.`dateline`, `pmt`.`showsignature`,
`pmt`.`allowsmilie`,
SUBSTR(`pmt`.`title`, 5) AS `title`
FROM `pm` AS `pm`
LEFT JOIN `pmtext`
AS `pmt`
ON `pmt`.`pmtextid` = `pm`.`pmtextid`
WHERE `pm`.`userid` = 1
AND `pm`.`folderid` != -1
AND SUBSTR(`pmt`.`title`, 1, 4) = 'AW: '
ORDER BY `pm`.`pmid` DESC
)
ORDER BY `pmid` DESC
) AS `pm`
GROUP BY `pm`.`title`, `pm`.`fromuserid`
ORDER BY `pm`.`dateline` DESC
LIMIT 0, 50;
MySQL-Fehler : Every derived table must have its own alias
Fehler-Nr. : 1248
Can someone Help me?
Thats a nice Addonn so i wanna use it :-)
Kai
|