- Posts: 21
- Thank you received: 0
OS Property support center
Can you explain me this message?
- Jaime
- Topic Author
- Offline
- Junior Member
-
Less
More
11 years 8 months ago #39572
by Jaime
Can you explain me this message? was created by Jaime
Hello...
When trying to install sample data, this was shown:
(If there are not country, states and cities avaialble. Please setup the countries and import your location):
I am trying to install sample data for Chile. Who can explain me what to do next?
Thanks
Jaime
When trying to install sample data, this was shown:
(If there are not country, states and cities avaialble. Please setup the countries and import your location):
I am trying to install sample data for Chile. Who can explain me what to do next?
Thanks
Jaime
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13244
- Thank you received: 1729
11 years 8 months ago #39574
by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Re: Can you explain me this message?
Hi Jaime,
Please watch this video
It's the installation steps tutorial. And the "Install sample data" step is included in the clip also.
Thanks
Dam
Please watch this video
It's the installation steps tutorial. And the "Install sample data" step is included in the clip also.
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Jaime
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 21
- Thank you received: 0
11 years 8 months ago - 11 years 8 months ago #39589
by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
Thanks a lot...
however, there is an error. I imported information from Chile, and the following error occurs:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Higgins','39','91',0),(NULL,'Tortel','39','91',0),(NULL,'Cochrane','39','91',0)' at line 1 SQL=INSERT INTO jom_osrs_cities (id,city,country_id,state_id,published) VALUES (NULL,'O'Higgins','39','91',0),(NULL,'Tortel','39','91',0),(NULL,'Cochrane','39','91',0);
This was produced because we have the apostrophe in a name, which breaks the SQL. You should modify the algorithm to accept those cases. I have replaced the quote by two quotes in the txt file in order to import the data.
On the other hand, I have found another problem. When I tried to add sample data, after importing country information, Chile appears by default, with the State/Province dropdown box empty. I tried by adding a second country, for example, United States. In that case, country appears as a combobox. If I select USA, the State dropdown is filled, when I select Chile, dropdown is cleared.
Please see attached image.
Any help will be appreciated
Thanks
Jaime
however, there is an error. I imported information from Chile, and the following error occurs:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Higgins','39','91',0),(NULL,'Tortel','39','91',0),(NULL,'Cochrane','39','91',0)' at line 1 SQL=INSERT INTO jom_osrs_cities (id,city,country_id,state_id,published) VALUES (NULL,'O'Higgins','39','91',0),(NULL,'Tortel','39','91',0),(NULL,'Cochrane','39','91',0);
This was produced because we have the apostrophe in a name, which breaks the SQL. You should modify the algorithm to accept those cases. I have replaced the quote by two quotes in the txt file in order to import the data.
On the other hand, I have found another problem. When I tried to add sample data, after importing country information, Chile appears by default, with the State/Province dropdown box empty. I tried by adding a second country, for example, United States. In that case, country appears as a combobox. If I select USA, the State dropdown is filled, when I select Chile, dropdown is cleared.
Please see attached image.
Any help will be appreciated
Thanks
Jaime
Last edit: 11 years 8 months ago by Jaime.
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13244
- Thank you received: 1729
11 years 8 months ago #39590
by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Re: Can you explain me this message?
Hi,
It seems we have the problem with Chilean location file, please use this version of that file
Thanks
Dam
It seems we have the problem with Chilean location file, please use this version of that file
Thanks
Dam
- Jaime
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 21
- Thank you received: 0
11 years 8 months ago #39888
by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
Hello...
I have imported the file you have sent and the same happen. No Chilean states or provices are shown.
Regards,
Jaime
I have imported the file you have sent and the same happen. No Chilean states or provices are shown.
Regards,
Jaime
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13244
- Thank you received: 1729
11 years 8 months ago #39889
by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Re: Can you explain me this message?
Hi Jaime,
Please submit ticket and send your site information with super admin acc, i will import the Chilean location for you
Thanks
Dam
Please submit ticket and send your site information with super admin acc, i will import the Chilean location for you
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Jaime
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 21
- Thank you received: 0
11 years 8 months ago #39893
by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
done!!
Please Log in or Create an account to join the conversation.
- Jaime
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 21
- Thank you received: 0
11 years 8 months ago #39930
by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
Hello again... I want to warn you that the word "available" in the sentence that is subject of the this thread is badly spelled in the osProperty control panel import sample data module:
(If there are not country, states and cities avaialble. Please setup the countries and import your location)
Regards
Jaime
(If there are not country, states and cities avaialble. Please setup the countries and import your location)
Regards
Jaime
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13244
- Thank you received: 1729
11 years 8 months ago #39934
by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Re: Can you explain me this message?
Hi Jaime,
All the text of OS Property can be defined by using Translator labels feature at back-end of component, you can adjust the content by yourself
Thanks
Dam
All the text of OS Property can be defined by using Translator labels feature at back-end of component, you can adjust the content by yourself
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Jaime
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 21
- Thank you received: 0
11 years 8 months ago #39937
by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
Yes, I know, however I am telling you so that you can provide the software with the right text for the next releases.
Regards,
Jaime
Regards,
Jaime
Please Log in or Create an account to join the conversation.
Moderators: Dang Thuc 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.