exception 'DBException' with message 'SELECT f.*, t.*, (SELECT c.name FROM city c WHERE c.id=f.cityId) AS cityName, (SELECT MAX(r.createdOn) FROM request r WHERE r.firmId=f.id) as lastRequestOn, (SELECT GROUP_CONCAT(CONCAT(p.modelClassId,',',p.serviceId,',',p.price) SEPARATOR '
') FROM firm_service_model_class p WHERE p.firmId=f.id GROUP BY f.id) AS servicePrices, (SELECT GROUP_CONCAT(CONCAT(fp.id,',',fp.price,',',fp.isUsed) ORDER BY fp.isUsed SEPARATOR '
') FROM v_firm_service_part fp WHERE fp.firmId=f.id AND fp.isPart) AS partPrices FROM firm f LEFT JOIN (SELECT pi.parentId AS FirmImage_parentId, pi.id AS FirmImage_id, pi.ext AS FirmImage_ext, pi.pos AS FirmImage_pos, pi.width AS FirmImage_width, pi.height AS FirmImage_height, pi.cropXIcon AS FirmImage_cropXIcon, pi.cropYIcon AS FirmImage_cropYIcon, pi.cropWidthIcon AS FirmImage_cropWidthIcon, pi.cropHeightIcon AS FirmImage_cropHeightIcon FROM firm_image pi WHERE pi.pos=1) AS t ON f.id=t.FirmImage_parentId WHERE f.isActive AND f.isConfirmed AND (EXISTS( SELECT fa.firmId FROM firm_activity fa WHERE f.id=fa.firmId) OR NOT EXISTS(SELECT fa.firmId FROM firm_activity fa WHERE fa.firmId=f.id)) ORDER BY f.name<br>Access denied for user 'viltu_new'@'localhost' (using password: YES)' in /home/viltu/new/lib/DBMySQL.php:153
Stack trace:
#0 /home/viltu/new/lib/DBMySQL.php(185): DBMySQL::q('SELECT f.*, t.*...', NULL)
#1 /home/viltu/new/lib/DBMySQL.php(175): DBMySQL::fetchAll('Firm', 'SELECT f.*, t.*...', NULL, false)
#2 /home/viltu/new/lib/Entity.php(595): DBMySQL::fetch('Firm', 'SELECT f.*, t.*...')
#3 /home/viltu/new/includes/Firm.php(153): Entity::fetch('SELECT f.*, t.*...')
#4 /home/viltu/new/actions/FirmList.php(85): Firm::fetchList(Array)
#5 /home/viltu/new/lib/PageEntity.php(514): FirmList->init()
#6 /home/viltu/new/lib/PageEntity.php(438): PageEntity->doGet()
#7 /home/viltu/new/htdocs/e5.php(118): PageEntity->show()
#8 /home/viltu/new/htdocs/e5.php(432): E5::showPage(Object(FirmList))
#9 /home/viltu/new/htdocs/e5.php(275): E5::processRequest()
#10 /home/viltu/new/htdocs/e5.php(577): E5::start()
#11 {main}