Database error in vBulletin 3.7.3:
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` = 6
AND `pm`.`folderid` != -1
AND SUBSTR(`pmt`.`title`, 1, 11) != 'Respuesta: '
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`, 12) AS `title`
FROM `pm` AS `pm`
LEFT JOIN `pmtext`
AS `pmt`
ON `pmt`.`pmtextid` = `pm`.`pmtextid`
WHERE `pm`.`userid` = 6
AND `pm`.`folderid` != -1
AND SUBSTR(`pmt`.`title`, 1, 11) = 'Respuesta: '
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 Error : Every derived table must have its own alias
Error Number : 1248
Request Date : Thursday, October 30th 2008 @ 11:44:02 AM
Error Date : Thursday, October 30th 2008 @ 11:44:02 AM
Script : http://www.espiritucustom.com/foro/private.php
Referrer : http://www.espiritucustom.com/foro/member.php?u=450
IP Address : el cocherito lere
Username : SuperCoco
Classname : vB_Database
MySQL Version : 4.1.10-standard
