Вот такая ошибка появляется при генерации табличного отчета.
Код:
[root@bgbilling log]# cat ./server.error.log
server 08-05/13:09:50 ERROR ["http-bio-/127.0.0.1-8080"-exec-6] LoggingPrintStream - SELECT c.id, c.title, c.comment, c.date1, address.address, IF(scid>0,concat('Субдоговор для ',(SELECT title FROM contract WHERE id = c.scid)),'') AS sub_contract, (SELECT val FROM contract_parameter_type_1 WHERE cid = c.id and pid = 11) as pasp, (SELECT val FROM contract_parameter_type_1 WHERE cid = c.id and pid = 9) as phone, (SELECT title FROM contract_parameter_type_7_values WHERE man.val = id) AS manager, comm.val FROM contract c LEFT JOIN contract_parameter_type_8 as cpar on c.id=cpar.cid AND cpar.pid = 19 LEFT JOIN contract_parameter_type_2 as address ON c.id=address.cid AND address.pid=25 LEFT JOIN contract_parameter_type_7 as man ON c.id=man.cid AND man.pid=27 LEFT JOIN address_house AS house ON address.hid=house.id LEFT JOIN address_street AS street ON house.streetid =street.id LEFT JOIN address_city AS city ON city.id=street.cityid LEFT JOIN contract_parameter_type_1 as comm on c.id=comm.cid AND comm.pid = 18 WHERE 1=1 AND cpar.val = 21769 AND cpar.cid <> 21769 AND c.date1 BETWEEN '2013-07-01' AND '2013-07-31' ORDER BY c.date1
server 08-05/13:09:50 ERROR ["http-bio-/127.0.0.1-8080"-exec-6] LoggingPrintStream - SELECT c.id, c.title, c.comment, c.date1, address.address, IF(scid>0,concat('Субдоговор для ',(SELECT title FROM contract WHERE id = c.scid)),'') AS sub_contract, (SELECT val FROM contract_parameter_type_1 WHERE cid = c.id and pid = 11) as pasp, (SELECT val FROM contract_parameter_type_1 WHERE cid = c.id and pid = 9) as phone, (SELECT title FROM contract_parameter_type_7_values WHERE man.val = id) AS manager, comm.val FROM contract c LEFT JOIN contract_parameter_type_8 as cpar on c.id=cpar.cid AND cpar.pid = 19 LEFT JOIN contract_parameter_type_2 as address ON c.id=address.cid AND address.pid=25 LEFT JOIN contract_parameter_type_7 as man ON c.id=man.cid AND man.pid=27 LEFT JOIN address_house AS house ON address.hid=house.id LEFT JOIN address_street AS street ON house.streetid =street.id LEFT JOIN address_city AS city ON city.id=street.cityid LEFT JOIN contract_parameter_type_1 as comm on c.id=comm.cid AND comm.pid = 18 WHERE 1=1 AND cpar.val = 21769 AND cpar.cid <> 21769 AND c.date1 BETWEEN '2013-07-01' AND '2013-07-31' ORDER BY c.date1
Сам запрос отрабатывает нормально
Код:
SELECT c.id, c.title, c.comment, c.date1, address.address,
IF(scid>0,CONCAT('Субдоговор для ',(SELECT title FROM contract WHERE id = c.scid)),'') AS sub_contract,
(SELECT val FROM contract_parameter_type_1 WHERE cid = c.id AND pid = 11) AS pasp,
(SELECT val FROM contract_parameter_type_1 WHERE cid = c.id AND pid = 9) AS phone,
(SELECT title FROM contract_parameter_type_7_values WHERE man.val = id) AS manager,
comm.val
FROM contract c
LEFT JOIN contract_parameter_type_8 AS cpar ON c.id=cpar.cid AND cpar.pid = 19
LEFT JOIN contract_parameter_type_2 AS address ON c.id=address.cid AND address.pid=25
LEFT JOIN contract_parameter_type_7 AS man ON c.id=man.cid AND man.pid=27
LEFT JOIN address_house AS house ON address.hid=house.id
LEFT JOIN address_street AS street ON house.streetid =street.id
LEFT JOIN address_city AS city ON city.id=street.cityid
LEFT JOIN contract_parameter_type_1 AS comm ON c.id=comm.cid AND comm.pid = 18
WHERE 1=1
AND cpar.val = 21769
AND cpar.cid <> 21769
AND c.date1 BETWEEN '2013-07-01' AND '2013-07-31'
ORDER BY c.date1
IF(scid>0,CONCAT('Субдоговор для ',(SELECT title FROM contract WHERE id = c.scid)),'') AS sub_contract,
(SELECT val FROM contract_parameter_type_1 WHERE cid = c.id AND pid = 11) AS pasp,
(SELECT val FROM contract_parameter_type_1 WHERE cid = c.id AND pid = 9) AS phone,
(SELECT title FROM contract_parameter_type_7_values WHERE man.val = id) AS manager,
comm.val
FROM contract c
LEFT JOIN contract_parameter_type_8 AS cpar ON c.id=cpar.cid AND cpar.pid = 19
LEFT JOIN contract_parameter_type_2 AS address ON c.id=address.cid AND address.pid=25
LEFT JOIN contract_parameter_type_7 AS man ON c.id=man.cid AND man.pid=27
LEFT JOIN address_house AS house ON address.hid=house.id
LEFT JOIN address_street AS street ON house.streetid =street.id
LEFT JOIN address_city AS city ON city.id=street.cityid
LEFT JOIN contract_parameter_type_1 AS comm ON c.id=comm.cid AND comm.pid = 18
WHERE 1=1
AND cpar.val = 21769
AND cpar.cid <> 21769
AND c.date1 BETWEEN '2013-07-01' AND '2013-07-31'
ORDER BY c.date1
Что от меня хочет этот лог?
да запрос кривой и мог бы быть чуть получше, но это один из первых моих отчетов
