shelby72 Posted March 17, 2008 Posted March 17, 2008 I cannot price any of my products over $100. The prices convert back to $99.99. If I price something to $130, it still converts back to $99.99. What could be causing this? I've check everything in the admin. Is there something I'm overlooking? Someone please help me out. Quote
web-project Posted March 17, 2008 Posted March 17, 2008 check your installation, probably someone is overwrite the sql query code with default price $99.99. Quote Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you.
shelby72 Posted March 17, 2008 Author Posted March 17, 2008 check your installation, probably someone is overwrite the sql query code with default price $99.99. Where in the installation would I check this? Which file? I've checked the database already and I can't find a default price of $99.99 anywhere. Quote
shelby72 Posted March 17, 2008 Author Posted March 17, 2008 Is there not anyone who knows what might be causing this? I really need some help. Quote
Jan Zonjee Posted March 17, 2008 Posted March 17, 2008 Is there not anyone who knows what might be causing this? I really need some help. Something like that can happen when you changed the properties of the decimal column that contains products_price in the table products. Normally it is size 15, decimals 4 which means the highest number it can contain is 99999999999.9999 If you changed that to say (15, 13) the highest number it could contain would become 99.9999999999999 so every number entered in there higher than that would be truncated to 99.9999999999999 Quote
shelby72 Posted March 18, 2008 Author Posted March 18, 2008 Something like that can happen when you changed the properties of the decimal column that contains products_price in the table products. Normally it is size 15, decimals 4 which means the highest number it can contain is 99999999999.9999If you changed that to say (15, 13) the highest number it could contain would become 99.9999999999999 so every number entered in there higher than that would be truncated to 99.9999999999999 Thank you very much! That solved my problem. My products_price was (3,2) so I changed it. Now everything works fine. Quote
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.