SP Properties Module Doesn't Show The Price Correctly - Question | JoomShaper

SP Properties Module Doesn't Show The Price Correctly

Tanidis Triantafillos

Tanidis Triantafillos

Extension 1 year ago

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).

  • In the property setting the Fixed Price is set to Yes.

Could you help me?

0
28 Answers
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #109530

I have attached the modified database SQL file in the hidden content. Please import it on your site. Hopefully, it will fix the issue.

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #106588

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.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #107096

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. 

https://prnt.sc/ZcdH95Tl-k2y

-Thanks

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #107100

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?

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #107105

Here is my ip address.

0
CT
Claudio Tebaldi
Accepted Answer
1 year ago #107114

Hi I have the same problem. Please share how to fix it when done. Thanks

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #107231

Please check now and follow the forum post if you need fix others site also.

https://www.joomshaper.com/forum/question/701

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #107251

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

https://prnt.sc/u0kZGlDsFSyS

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #107303
0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #107346

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

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #107492

Solved.

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #107578

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?

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #107805

Keep an backup of your template html/com_spproperty and html/layouts directory.

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #107815

Thank you for your response.

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #108025

You are most welcome. Will you please spend some to write a review about our product and support quality? 

https://extensions.joomla.org/extension/sp-page-builder/

https://www.trustpilot.com/review/www.joomshaper.com

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #108080
0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #108315

Thank you so much.

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #108420

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;

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #108516

Provide me the database access. Thanks

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #108704

Hello,

I have sent you a link to download the database.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #109088

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

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #109100

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’;

1054 - Unknown column '‘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.

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #109366

Hello,

Did you manage to fix the problem in the database?

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 1 year ago #109537

@Ofi Khan Thanks

0
Tanidis Triantafillos
Tanidis Triantafillos
Accepted Answer
1 year ago #109549

Hello!

Thank you for your response Ofi Khan. It's fine now Ι can put fixed price 2.500.000 in the property.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #109555

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 

  1. Joomla Extension Directory
  2. TrustPilot

This will inspire us to improve.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #111099

Thank you so much for your appreciation.

0