- Posts: 1
- Thank you received: 0
OS Property support center
Difficulties uploading data from 2.0.6 to 2.6.6
- Henrik
- Topic Author
- Offline
- New Member
-
Less
More
10 years 9 months ago #47931
by Henrik
Difficulties uploading data from 2.0.6 to 2.6.6 was created 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
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.
- Mr. Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13058
- Thank you received: 1696
10 years 9 months ago #47936
by Mr. Dam
Replied by Mr. Dam on topic Difficulties uploading data from 2.0.6 to 2.6.6
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
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. Dam, Nguyen Phu Quan
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.