Hello,
In SP Property component the SP Properties module doesn't show the price correctly (example: https://prnt.sc/jLDmUW9NZp8s), but when I enter the property the price is corrent (example: https://prnt.sc/ilPeoEA80VZl).
Could you help me?
I have attached the modified database SQL file in the hidden content. Please import it on your site. Hopefully, it will fix the issue.
Hello,
Could someone help me? From what I have seen about 6 months ago someone else had the same problem as I have. You asked him for access and fixed the problem for him. I have also asked you for your help through that discussion.
Please tell me the solution to implement it or prepare a fix. Because I want to build other websites for real estate agencies.
Hi there,
I appreciate you reaching out. I sincerely apologize for this oversight. Will you please provide me the Joomla administrator access and URL to check the issue? I will check & get back to you soon.
-Thanks
Thank you for your response.
The credentials I have given you so that you can log in to the management environment are correct. But probably the server is cutting off access to the IP. Can you tell me your IP to enable an exception?
Here is my ip address.
Hi
I have the same problem. Please share how to fix it when done.
Thanks
Please check now and follow the forum post if you need fix others site also.
I was informed by the technical support of my hosting package that an exception cannot be made for your IP.
Could you connect via VPN?
Alternatively if you want I can send you a copy of the website, so you can make the correction and send it back to me.
I would also like to let you know that I tried the solution you suggested via the forum post https://www.joomshaper.com/forum/question/701.
I have fixed the problem on the home page that has the SP Property Properties module, but the problem still exists in the Menu Item Type Map with Half Map Layout, as can be seen in the following link: https://realpraxis.tanidisit.website/for-sale
What should be?
It should be 69000€ the total price of the property are selling and not 69000€ per square meter.
If the user clicks details and visits the property page, the price is displayed normally.
Other when the properties are displayed in a row the price is shown per square meter.
https://prnt.sc/kLqoOSVnQZzH
Solved.
Thank you very much.
I would like to ask you the following:
If the plugin needs to be updated, then will these fixes need to be made by you again, or will they be included in the next plugin update?
Keep an backup of your template html/com_spproperty and html/layouts directory.
Thank you for your response.
You are most welcome. Will you please spend some to write a review about our product and support quality?
Thank you so much.
I also find anonther problem with the price.
When I put fixed price 2500000 show me the following error:
Save failed with the following error: Out of range value for column 'price' at row 1
Could you please help me;
Provide me the database access. Thanks
Hello,
I have sent you a link to download the database.
Hello Tanidis Triantafillos
You cannot add more that 10,00,000 in SP Property -> Property Price. If you want to increase the digits, then you have to change in the database. Please run this SQL query on your database. By default, the value is FLOAT(8,2). If you make it FLOAT(9,2), then you can add 1 more digit in the price 1,00,00,000
ALTER TABLE `xxxxx_spproperty_properties` CHANGE `price` `price` FLOAT(9,2) NOT NULL DEFAULT ‘0.00’;Use your table prefix instead of xxxxx on the table name.
Best regards
Hello!
Thank you for your response.
I tried to modify the database but failed. It gave me the following error.
ALTER TABLE oalck_spproperty_properties CHANGE price price FLOAT(9,2) NOT NULL DEFAULT ‘0.00’;
‘0.00’' in 'DEFAULT'I have sent you a copy of my database.
Can you please fix this? Because I unfortunately do not know from SQL.
Hello,
Did you manage to fix the problem in the database?
@Ofi Khan Thanks
Hello!
Thank you for your response Ofi Khan. It's fine now Ι can put fixed price 2.500.000 in the property.
You are welcome 😊
I have a humble request. It would be very kind of you if you can manage some moment to give us feedback on
This will inspire us to improve.
I've already done that!
https://www.trustpilot.com/users/64074530c0880700122b5c44
https://extensions.joomla.org/profile/profile/details/256144/
Thank you so much for your appreciation.