OS Property support center

square meters limited - acrea / hectars

Matt Kay
Topic Author
Offline
New Member

More

7 years 7 months ago #102755 by Matt Kay

square meters limited - acrea / hectars was created by Matt Kay

dear OS Solution Team,

I cannot put more then 9999 square meters in the land information in the backend.
I have a land for sale with 210000 square meters (so 21 ha)
When I put 210000 square meters in the filed it automatically changes this number to 9999.

Then also I already put in the configuration that I want to use ha and not acres. But in the Backend in the "Land Information" it still says "# Total acres"

Thank you

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

Mr. Dam
Offline
Administrator

More

7 years 7 months ago #102767 by Mr. Dam

Replied by Mr. Dam on topic square meters limited - acrea / hectars

Hi Matt,
To solve the issue, you can follow these steps:
1. Using PHPMyAdmin to open table: #__osrs_properties
2. Find column: square_feet, current attribute of this column is: decimal (7,2). You can change it to decimal (12,2).
Then, the issue will be solved
Thanks
Dam

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

Matt Kay
Topic Author
Offline
New Member

More

7 years 7 months ago #102849 by Matt Kay

Replied by Matt Kay on topic square meters limited - acrea / hectars

dear Dang,

Thank you for your reply. I checked my Database and I canot find a table that is called _osrs_propierties.
I attach 2 screenshots that show you the tables that are in my database.

Furthermore I wanted to ask you if that will fix the issue with the maximum number of 9999?
I think your solutions will only fix the issue from acres to hectar?

Thank you,
Matt

Attachments:

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

Mr. Dam
Offline
Administrator

More

7 years 7 months ago #102889 by Mr. Dam

Replied by Mr. Dam on topic square meters limited - acrea / hectars

Hi Matt,
Your db prefix is: allin1, so the db table is: allin1_osrs_properties
Thanks
Dam

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

Matt Kay
Topic Author
Offline
New Member

More

7 years 7 months ago #102941 by Matt Kay

Replied by Matt Kay on topic square meters limited - acrea / hectars

dear Dang,
Thank you for the reply. I attached the 2 screenshots before to show you that there is no allin1_osrs_properties table in my database.
The tables you see in the screenshots is all I got.

Furthermore I would like to ask you this question again:
If I fix the issue with in this table, there will still be the problem with the maximum number of 9999?
I think fixing the table will only change acres to hectar, but not the maximum number I can type in this field.

best regards,
Matt

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

Mr. Dam
Offline
Administrator

More

7 years 7 months ago #102943 by Mr. Dam

Replied by Mr. Dam on topic square meters limited - acrea / hectars

Hi Matt,
Please submit ticket on category: OS Property and send your site url with super admin account, PHPMyAdmin url and account. We will help you to solve the problem.
Thanks
Dam

The following user(s) said Thank You: Matt Kay

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

Matt Kay
Topic Author
Offline
New Member

More

7 years 7 months ago #102976 by Matt Kay

Replied by Matt Kay on topic square meters limited - acrea / hectars

thank you Dam,
I wrote you an Email with the information.

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

Mr. Dam
Offline
Administrator

More

7 years 7 months ago #103005 by Mr. Dam

Replied by Mr. Dam on topic square meters limited - acrea / hectars

OK, Matt
Thanks
Dam

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

Moderators: Mr. Dam, Nguyen Phu Quan

Powered by Kunena Forum

square meters limited - acrea / hectars

Support

Documentation

Information

Connect Us