maximal price is 10 digit?
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.
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.
4 posts
• Page 1 of 1
maximal price is 10 digit?
by 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?
by 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
"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
- Posts: 136
- Joined: 28 Dec 2011, 13:14
- Reputation point: 0
Re: maximal price is 10 digit?
by 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?
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
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 15 guests