OS Property support center

Error in View aeditdetails after update to 2.9.2

  • DiGiFast
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 11 months ago - 9 years 11 months ago #70266 by DiGiFast
I just have opened a support ticket (Ticket ID 35038).
After update to version 2.9.2, when i open the view aeditdetails (menu item -> User: Edit profile) I receive this error page:

1054 Unknown column 'a.posted_by' in 'field list' SQL=Select a.id, a.ref, a.pro_name,a.posted_by,a.company_id, d.id as typeid,d.type_name as type_name,g.name as agent_name,a.published,a.approved, a.isFeatured,a.curr,a.price,a.price_call,a.rent_time,a.show_address,a.hits,c.city,s.state_name as state_name,a.address, ex.expired_time,ex.expired_feature_time,a.total_request_info,a.total_points,a.number_votes from #_osrs_properties as a INNER JOIN #_osrs_agents as g on g.id = a.agent_id LEFT JOIN #_osrs_types as d on d.id = a.pro_type INNER JOIN #_osrs_countries as e on e.id = a.country LEFT JOIN #_osrs_states as s on s.id = a.state LEFT JOIN #_osrs_cities as c on c.id = a.city LEFT JOIN #_osrs_expired as ex on ex.pid = a.id WHERE a.agent_id = '1' ORDER BY a.id desc LIMIT 0, 20

Last edit: 9 years 11 months ago by DiGiFast.

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #70267 by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Error in View aeditdetails after update to 2.9.2
Hi,
The issue has been solved
Thanks
Dam

Please Log in or Create an account to join the conversation.

Moderators: Dang Thuc DamNguyen Phu Quan