maximal price is 10 digit?

Write about issues that you have found.

Moderators: Koduc, Xpycm

Forum rules
Pay attention! Forum is not a means for guaranteed support of clients and users. An answer as well as a quick answer is not supposed on the forum. We post messages as soon as possible.

The message limit on the forum is 3 messages per day.
If you want to say "thank you" then use the function "Give good reputation point", which is a green icon "plus" under the nickname of the person, who answered the message.

maximal price is 10 digit?

Postby blogg » 30 Jul 2014, 21:36

when we type a price more than 10 digit, it will show 2 147 483 647. how to fix it? I want it support unlimited digit of price, like 600.000.000.000
blogg
Stranger
 
Posts: 2
Joined: 30 Jul 2014, 21:19
Reputation point: 0

Re: maximal price is 10 digit?

Postby support » 31 Jul 2014, 19:39

Hello.

"price" and "price_to" fields is "integer" - https://www.dropbox.com/s/va8bmu4n5red8 ... -31_01.jpg
change the data type from "int" to "bigint" - http://dev.mysql.com/doc/refman/5.5/en/ ... types.html
support
Citizen
Citizen
 
Posts: 136
Joined: 28 Dec 2011, 13:14
Reputation point: 0

Re: maximal price is 10 digit?

Postby blogg » 31 Jul 2014, 20:33

yesterday I only change price from int to bigint
and now it's work, but when I move right-left the filter of price range of advance search it will back to 2 147 483 647 for max price range. what must I do?
blogg
Stranger
 
Posts: 2
Joined: 30 Jul 2014, 21:19
Reputation point: 0

Re: maximal price is 10 digit?

Postby support » 01 Aug 2014, 08:16

support
Citizen
Citizen
 
Posts: 136
Joined: 28 Dec 2011, 13:14
Reputation point: 0


Return to Issues

Who is online

Users browsing this forum: No registered users and 22 guests

cron