Support Offline : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

Trying to set a price bigger than $2,147,483,647

Featured Lock Resolved Issue
Hi, im using Empire template on a real estate project in Colombia, so the prices for this site must be in Colombian pesos.

Well the problem is that when i put something like $4.000.000.000 pesos, the platform block that price and just set $2,147,483,647 as a maximun.

How can i fix that.

Thanks!!!

----

9 Answers

Toufiq - Staff

More than a month ago #Permalink
Hi,

Thanks for your query. I have set your prices.

http://prntscr.com/e91ish

http://prntscr.com/e91jhd

I think there is no problem.

-Thanks

marco piedrahita

More than a month ago #Permalink
:o :(

Im sorry but is not so easy for me... the problem persist... i dont know what to do...


Is it possible that it has something to do with removing the sqft text?


As you can see in the picture the price does not go up any more ... the price should be 5.196.400.000

the site is http://www.sigoinmobiliaria.com


I think it would be nice if you could review what is happening ... it may be a problem that has not been detected ... it is very strange because the prices below that value are shown without problem ...



Hi,

Thanks for your query. I have set your prices.

http://prntscr.com/e91ish

http://prntscr.com/e91jhd

I think there is no problem.

-Thanks

Attachments (1)

  • empire.jpg
    empire.jpg 76.1 KB

Toufiq - Staff

More than a month ago #Permalink
Hi,

Thanks for your reply. Please go to the language directory.

Open these file & change sqft to your desire text
language/en-GB
en-GB.com_spproperty.ini
en-GB.mod_spproperty_properties.ini

-Thanks

marco piedrahita

More than a month ago #Permalink
Hi Toufiq! Look what i found on wikipedia:

The number 2 147 483 647 is also the maximum value for a signed integer in computational systems with 32-bit architecture. Therefore it is the maximum value of the variables declared as in many programming languages ​​that run on common computers, and the maximum score possible for many video games. The appearance of the number often reflects an error, a mismatch condition, or a missing value.8 Likewise, "(214) 748-3647" is the sequence of digits represented as the United States telephone number and is Phone number that appears on web pages.9


I still can not put a larger number to that.

Try changing the type in the price field in the xml file from number to text but when I record everything remains the same. It is as if the validation does not take into account the type because also when I use letters the changes are not reflected.

Sorry for so much insistence but it is very important

Thanks

Toufiq - Staff

More than a month ago #Permalink
Hi,

Please following the below instruction.

Go to the PHPMyAdmin & click over sp properties
http://prntscr.com/ebve1c

Click over on it
http://prntscr.com/ebve8d

Click on change button
http://prntscr.com/ebvepr

Set this setting
http://prntscr.com/ebveyv

-Thanks
Hi,
I have the same problem, but I can't find the sp property table in PhP myAdmin.

Attached image.

Thanks for your help.

Attachments (1)

  • Price Image.jpg
    Price Image.jpg 286.8 KB

Toufiq - Staff

3 weeks ago #Permalink
Hi,
I have the same problem, but I can't find the sp property table in PhP myAdmin.

Attached image.

Thanks for your help.


Hi there, Thanks for your reply. Please check the screenshot.

https://prnt.sc/pmk8mx

-Thanks
Thanks for your help.
¡already working!

Toufiq - Staff

3 weeks ago #Permalink
Thanks for your help.
¡already working!


Hi there, You are most welcome & Thanks


There are no replies made for this post yet.
Be one of the first to reply to this post!

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 110
Sifat

Sifat

Total Accepted Answers: 61
Toufiq

Toufiq

Total Accepted Answers: 47
Mehtaz Afsana Borsha

Mehtaz Afsana Borsha

Total Accepted Answers: 14
Rashida Rahman

Rashida Rahman

Total Accepted Answers: 12

118

Templates

303043

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us