جستجو در انجمن

سلام دوستان وقت بخیرمن نسخته تجاری کامپوننت jbusiness رو خریدم و نصب کردم همه بخش هاش هم اکی هست فقط وقتی رو لیست مشاغل میزنم با این خطا مواجه میشم. کسی میدونه چطور رفعش کنم؟ ورژن جوملا هم 3.X هست.ممنون Error Unknown column 're.companyId' in 'on clause' SQL=SELECT bc.*,ct.name as typeName,cnt.country_name as country, clm.id as claimId, inv.state = 1 as paid, u.username as username, COUNT(DISTINCT ev.id) as eventCount, COUNT(DISTINCT of.id) as offerCount, COUNT(DISTINCT re.id) as reviewCount, (now() > (inv.start_date) and (now() < (inv.start_date + INTERVAL p.days DAY))) as active, (inv.start_date + INTERVAL p.days DAY) as expirationDate, p.name as packageName, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias ORDER BY cg.name separator '#') as categories FROM `#__jbusinessdirectory_companies` AS bc left join `#__jbusinessdirectory_company_category` cc on bc.id=cc.companyId left join `#__jbusinessdirectory_categories` cg on cg.id=cc.categoryId and cg.published=1 LEFT JOIN `#__jbusinessdirectory_company_types` AS ct ON bc.typeId=ct.id LEFT JOIN `#__jbusinessdirectory_countries` AS cnt ON bc.countryId=cnt.id LEFT JOIN `#__jbusinessdirectory_company_claim` AS clm ON bc.id=clm.companyId LEFT JOIN `#__jbusinessdirectory_packages` p on bc.package_id=p.id LEFT JOIN `#__jbusinessdirectory_company_events` ev on ev.company_id=bc.id LEFT JOIN `#__jbusinessdirectory_company_offers` of on of.companyId=bc.id LEFT JOIN `#__jbusinessdirectory_company_reviews` re on re.companyId=bc.id LEFT JOIN `#__users` u on bc.userId=u.id left join ( SELECT t1.* FROM `#__jbusinessdirectory_orders` t1 JOIN (SELECT company_id, MAX(id) as id FROM `#__jbusinessdirectory_orders` where start_date <= DATE(now()) GROUP BY company_id ) t2 ON t1.company_id = t2.company_id AND t1.id = t2.id where t1.start_date <= DATE(now()) )inv on inv.package_id = p.id and inv.company_id = bc.id where 1 group by bc.id order by bc.id desc LIMIT 0, 20 Unknown column 're.companyId' in 'on clause' SQL=SELECT bc.*,ct.name as typeName,cnt.country_name as country, clm.id as claimId, inv.state = 1 as paid, u.username as username, COUNT(DISTINCT ev.id) as eventCount, COUNT(DISTINCT of.id) as offerCount, COUNT(DISTINCT re.id) as reviewCount, (now() > (inv.start_date) and (now() < (inv.start_date + INTERVAL p.days DAY))) as active, (inv.start_date + INTERVAL p.days DAY) as expirationDate, p.name as packageName, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias ORDER BY cg.name separator '#') as categories FROM `#__jbusinessdirectory_companies` AS bc left join `#__jbusinessdirectory_company_category` cc on bc.id=cc.companyId left join `#__jbusinessdirectory_categories` cg on cg.id=cc.categoryId and cg.published=1 LEFT JOIN `#__jbusinessdirectory_company_types` AS ct ON bc.typeId=ct.id LEFT JOIN `#__jbusinessdirectory_countries` AS cnt ON bc.countryId=cnt.id LEFT JOIN `#__jbusinessdirectory_company_claim` AS clm ON bc.id=clm.companyId LEFT JOIN `#__jbusinessdirectory_packages` p on bc.package_id=p.id LEFT JOIN `#__jbusinessdirectory_company_events` ev on ev.company_id=bc.id LEFT JOIN `#__jbusinessdirectory_company_offers` of on of.companyId=bc.id LEFT JOIN `#__jbusinessdirectory_company_reviews` re on re.companyId=bc.id LEFT JOIN `#__users` u on bc.userId=u.id left join ( SELECT t1.* FROM `#__jbusinessdirectory_orders` t1 JOIN (SELECT company_id, MAX(id) as id FROM `#__jbusinessdirectory_orders` where start_date <= DATE(now()) GROUP BY company_id ) t2 ON t1.company_id = t2.company_id AND t1.id = t2.id where t1.start_date <= DATE(now()) )inv on inv.package_id = p.id and inv.company_id = bc.id where 1 group by bc.id order by bc.id desc