I install JUX 2 in template default pack joomla 3, ansudenly I install jux 3.2.1.
Error in Realty
Error
Unknown column 'r.cat_id' in 'field list' SQL=SELECT r.*, r.cat_id , d.sign AS `currency`, t.title AS `type`, c.title AS `category`, CONCAT_WS(" ", a.username) AS `agentname`, u.name AS `username`,c.title AS category_title,uc.name AS editor,l.title AS language_title,ag.title AS access_level FROM gpys9_re_realties AS r LEFT JOIN gpys9_re_types AS t ON t.id = r.type_id LEFT JOIN gpys9_categories AS c ON c.id = r.cat_id LEFT JOIN gpys9_re_currencies AS d ON d.id = r.currency_id LEFT JOIN gpys9_re_agents AS a ON a.id = r.agent_id LEFT JOIN gpys9_users AS u ON u.id = r.user_id LEFT JOIN gpys9_users AS uc ON uc.id=r.checked_out LEFT JOIN `gpys9_languages` AS l ON l.lang_code = r.language LEFT JOIN gpys9_viewlevels AS ag ON ag.id = r.access WHERE (r.published = 0 OR r.published = 1) AND (r.approved = -1 OR r.approved = 1 OR r.approved = 0) AND (r.featured = 0 OR r.featured = 1) GROUP BY r.id ORDER BY r.ordering asc Unknown column 'r.cat_id' in 'field list' SQL=SELECT r.*, r.cat_id , d.sign AS `currency`, t.title AS `type`, c.title AS `category`, CONCAT_WS(" ", a.username) AS `agentname`, u.name AS `username`,c.title AS category_title,uc.name AS editor,l.title AS language_title,ag.title AS access_level FROM gpys9_re_realties AS r LEFT JOIN gpys9_re_types AS t ON t.id = r.type_id LEFT JOIN gpys9_categories AS c ON c.id = r.cat_id LEFT JOIN gpys9_re_currencies AS d ON d.id = r.currency_id LEFT JOIN gpys9_re_agents AS a ON a.id = r.agent_id LEFT JOIN gpys9_users AS u ON u.id = r.user_id LEFT JOIN gpys9_users AS uc ON uc.id=r.checked_out LEFT JOIN `gpys9_languages` AS l ON l.lang_code = r.language LEFT JOIN gpys9_viewlevels AS ag ON ag.id = r.access WHERE (r.published = 0 OR r.published = 1) AND (r.approved = -1 OR r.approved = 1 OR r.approved = 0) AND (r.featured = 0 OR r.featured = 1) GROUP BY r.id ORDER BY r.ordering asc LIMIT 0, 20 Unknown column 'r.cat_id' in 'field list' SQL=SELECT r.*, r.cat_id , d.sign AS `currency`, t.title AS `type`, c.title AS `category`, CONCAT_WS(" ", a.username) AS `agentname`, u.name AS `username`,c.title AS category_title,uc.name AS editor,l.title AS language_title,ag.title AS access_level FROM gpys9_re_realties AS r LEFT JOIN gpys9_re_types AS t ON t.id = r.type_id LEFT JOIN gpys9_categories AS c ON c.id = r.cat_id LEFT JOIN gpys9_re_currencies AS d ON d.id = r.currency_id LEFT JOIN gpys9_re_agents AS a ON a.id = r.agent_id LEFT JOIN gpys9_users AS u ON u.id = r.user_id LEFT JOIN gpys9_users AS uc ON uc.id=r.checked_out LEFT JOIN `gpys9_languages` AS l ON l.lang_code = r.language LEFT JOIN gpys9_viewlevels AS ag ON ag.id = r.access WHERE (r.published = 0 OR r.published = 1) AND (r.approved = -1 OR r.approved = 1 OR r.approved = 0) AND (r.featured = 0 OR r.featured = 1) GROUP BY r.id ORDER BY r.ordering asc
I have more of 100 properties in my web, with jux realty, and I pay for the new version realty 3.2 (One dollar, 17 dollar or 1000 dollar, I paid thinking is a good component). I dont can insert again manualy the 100 properties.
I need a solution now please. The time passed and I dont view solution.
If you change core of component, I do not think it's right to have to wait so long to tell me how to update the tables.
They would have to have thought of that before, or launch the new version 3.2 jux later.
I have a translate spanish COMPLETE (Profesional translation) And I do not want to send up everything that is not fixed.
I hope next week to give a solution.
Thanks