OS Property support center

Difficulties uploading data from 2.0.6 to 2.6.6

  • Henrik
  • Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 9 months ago #47931 by Henrik
Hello OS Property.

Recently I have been trying to upgrade my OS property version from a 2.0.6 to my newly acquired 2.6.6 version. However, I have encountered some difficulties in the process.

Before upgrading the extension in joomla we’ve made a lot of changes on the properties as well as agents manually. This includes changing the category-names, creating cities, adding information in the extra fields, convenience and so forth.
After upgrading OS property, it is no longer possible to access the properties, agents or companies front- or back-end.
The following error code appears:

1054 Unknown column 'company_alias' in 'where clause' SQL=Select count(id) from wn4o2_osrs_companies where company_alias like 'sample-company' and id <> '1'

While we think, we have identified the problem as some added columns in the new version of OS property, for instance an addition of “value_type” and “show_on_list” in the “extra_fields” category we can’t help but wonder if there is an easier solution to our problem than to create the missing columns in our database manually. This would require a lot of work, and it seems like the “search” function gets messed up in doing so.

We’re hoping that you have an easier solution/suggestion?

I’m using joomla 3.3.3 and a mysqli database.

Best regards, Søren

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

More
10 years 9 months ago #47936 by Mr. Dam
Hi Soren,
I am not sure that you installed OS Property 2.6.6 by normal way (Using Joomla installation), because when you install file com_osproperty.zip through Joomla installation form. The system will call file install.osproperty.php to update new missed DB columns to MySQL Tables. All the fields like company_alias, value_type, show_on_list... will be updated if you install new version of component normally.
Please submit ticket and send your site information with super admin acc. We will try to install new version of OS Property for you
Thanks
Dam

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

Moderators: Mr. DamNguyen Phu Quan