2.3 Update - Prices all messed-up [SOLVED]

[Jesse]

I've updated 3 installations now of OSClass from v2.2.3 to 2.3.

The actual updates were all successful, however the prices were messed up in all 3 upgrades. The dollar amounts are wrong, 4-digit prices became negative, and there are numbers after the decimal point that weren't there before. This all occurred in all 3 updates. Thankfully I'm not "live" yet.

Also I noticed (and not happy about), the fact that any ad that did NOT have a price now says "FREE". It use to just say "Contact Seller". I know I can change this as well, but it was very unexpected.

[Juan Ramón]

Sorry for the problems

Even I haven't  tried yet, the issue will be because in the update it converts the null prices (contact seller) to 0 prices (free). Can you replace the upgrade-funcs.php for this one? https://gist.github.com/1408843

Moreover, it's very strange the 4-digit prices becoming negative :S Can you send me your database via e-mail so I can try to reproduce it? juanramon@osclass.org

[Jesse]

Juan,

Hopefully I've got that file correctly sent to you. As I noted my website in the email, when you take a look at that site you will also notice the prices in my 'test' ads all have non-zero decimal amounts... like $48.03 ..... that .03 wasn't there before. I don't even think the dollar amount was even $48 (I don't know because I used random dollar amounts when generating those test ads).

This isn't a big deal to me right now because I can enter correct dollar amounts... but, anyone else updating may get this error, plus I do NOT want this error happening on future updates. ;-)

Jesse

[Jesse]

Ok, I've located my previous dollar values prior to the update. I will list the "before" and "after" values here:


Before: 2323.00 ....... After: -1971.97 (negative)

Before: 5543.00 ....... After: 1248.03

Before: 123.45 ........ After: 123.45 (unchanged)

Before: 4343.00 ....... After: 48.03


That's a sample. Even on my "demo" site there is one negative value showing (-$69.31): http://ivcity.com/osclass/

[sundance]

That happened to me too. All my items in the thousands were some weird negative number.

[Jesse]

It looks like Juan has done it again! This issue appears to be SOLVED with a fix to the file, upgrade-funcs.php

To test it, I started with a fresh installation of 2.2.3. I added several ads with various dollar amounts. I then manually upgraded to version 2.3 using the updated upgrade-funcs.php file from Juan.

Worked perfectly! I'm sure he'll make this an "official" change shortly.


Jesse

[Juan Ramón]

I forgot to mention it in the post, but I've just updated the post: http://osclass.org/2011/12/05/osclass-2-3-1/

[karthik5b8]

can u tell me how to change the negative price value?