price resetting in item database

14 posts / 0 new
Last post
sayumi's picture
Offline
Last seen: 7 years 9 months ago
Joined: 27/09/2009 - 10:25am
price resetting in item database

When i enter a new price of a couple of items in the item database (buy at & sell at) and start the program the next time, some of the items' prices have changed into something completely else :s
leaving me with bad graphs and false profit calculation etc ofcourse...
anyone had this problem too?

saudor's picture
Offline
Last seen: 16 hours 36 min ago
Joined: 10/06/2007 - 12:30pm

[KB#01 - Intro]
Please try to provide screenshots and as much details as possible including the following

1. Operating System & Language Ex: Windows XP PRO English 32-bit Edition, Service Pack 2
2. Browser & Version Ex: Firefox 3.0 English
3. Your NeoMallers Portal Version. This is shown at the bottom of the main screen

It's a database hiccup that happens randomly. I dont know why but it just does that from time to time. There was a fix that was patched to prevent values from being reset to zero (since that was the case back then), now it's being reset to something else. Funny thing is, I've added extra spaces and all kinds of corrupt data and portal has refused to screw up, both in Vista and XP

-----------------------------
Protect your account
http://www.neopets.com/~punchback_bob
CG information & more

sayumi's picture
Offline
Last seen: 7 years 9 months ago
Joined: 27/09/2009 - 10:25am

thx for answering!

well i'm on vista home premium SP1 32-bit (if there's anything else you need to know, just tell me)
version is pro 8.5.0
browser is firefox 3.0.14 english, but i dont use my browser with the program, so i dont know if this is important?

i dont know what kind of scrshots i should give, but on the ones i added the price difference is shown
funnily enough it always seems to be the same price he's resetting to

saudor's picture
Offline
Last seen: 16 hours 36 min ago
Joined: 10/06/2007 - 12:30pm

Browser is very important since different browsers output text in different ways. For instance in IE, the description of the pictures are omitted whereas in FF, it shows up as []

Anyways there is nothing that can be done at this time except make sequential backups of your data every now and then. Im guessing if you open up you c:\neomallers\users\PROFILE NAME\db_shopstock\data_shopstock.db file in notepad, there are multiple blank entries at the top which appear to be part of the reason. You can delete it and just basically move on.

Have no idea why it happens but it could be related to any security programs/language that you might have installed and via the shop front. For instance, under certain languages 1,000 becomes 1.000 and under the Swedish version of XP, it becomes 1 000 (this one took 2 and a half years to detect and fix - LOL). All these tiny details can throw off the portal's processing system. Again, i really dont know the cause of it, so i'm just poking around.

-----------------------------
Protect your account
http://www.neopets.com/~punchback_bob
CG information & more

sayumi's picture
Offline
Last seen: 7 years 9 months ago
Joined: 27/09/2009 - 10:25am

ok nvr mind then
i'll just try to take enough back-ups

davymuncher's picture
Offline
Last seen: 6 months 2 weeks ago
Joined: 10/08/2009 - 10:41pm

Lol Dmitri, I can't make it crash either Wink so it's not just your computer.

Good Idea: Feeding stray kittens in the park.
Bad Idea: Feeding stray kittens in the park... to a bear.

temps_bons's picture
Offline
Last seen: 7 years 5 months ago
Joined: 10/04/2009 - 10:58pm

sayumi wrote:
When i enter a new price of a couple of items in the item database (buy at & sell at) and start the program the next time, some of the items' prices have changed into something completely else :s
leaving me with bad graphs and false profit calculation etc ofcourse...
anyone had this problem too?

Yes. I just noticed it tonight. Many of my prices are set to 28 for the cost and in several instances the cost is higher than the price -- one item I had a -14K in sales Sad I'll look up all the various info later so maybe Dmitri can figure-out the problem....right now I'm going back to bed Smile

EDIT:

Searched on cost = 28
I had 259 items with that cost

Each of those items had the same stats on the right hand side of the page --
#Sold: 6;
Total Sales: 714;
Total Costs:168;
Net: 546

Also the comments field was the same for each--
AVATAR 10/14 Not even this field is correct because there are many items which were not AVATAR items and the last date I stocked the item was not 10/14

All of the prices are still correct though and the glitch did not retroactively change my sales because my graph still looks the same as it always did -- (correct # of sales and profit/cost ratio)

I have to go look for the other info you requested so will edit again... BRB

~ Mimi
-----------------------------------------------------------------------------------
~ Mimi's Ménagerie ~
http://www.neopets.com/browseshop.phtml?owner=temps_bons&misc

temps_bons's picture
Offline
Last seen: 7 years 5 months ago
Joined: 10/04/2009 - 10:58pm

Dmitri wrote:
Browser is very important since different browsers output text in different ways. For instance in IE, the description of the pictures are omitted whereas in FF, it shows up as []

  • I am using FF v3.5.3

    Dmitri wrote:
    Anyways there is nothing that can be done at this time except make sequential backups of your data every now and then. Im guessing if you open up you c:\neomallers\users\PROFILE NAME\db_shopstock\data_shopstock.db file in notepad, there are multiple blank entries at the top which appear to be part of the reason. You can delete it and just basically move on.

  • I looked at mine and have 10 rows of this(before the data looks right)

    []{***}{***}{***}{***}{***}{***}{***}{***}{***}{***}{***}

    Dmitri wrote:
    Have no idea why it happens but it could be related to any security programs/language that you might have installed and via the shop front. For instance, under certain languages 1,000 becomes 1.000 and under the Swedish version of XP, it becomes 1 000 (this one took 2 and a half years to detect and fix - LOL). All these tiny details can throw off the portal's processing system. Again, i really dont know the cause of it, so i'm just poking around.

  • I use English but if you meant computer language, I haven't the foggiest! Security programs that maybe the culprit: KeyScrambler just had an upgrade available around that time, maybe that's it? I know I have to turn it off to play certain games and even when I am typing quickly here my text will go into the KeyScrambler window and the scrambled text goes here...

    I'll bet the bug-finding is the most aggravating! Kinda like balancing a checkbook, Profits & Losses, etc. and being off by .01 -- ANNOYING!

    Thanks for everything, D!

    ~ Mimi
    -----------------------------------------------------------------------------------
    ~ Mimi's Ménagerie ~
    http://www.neopets.com/browseshop.phtml?owner=temps_bons&misc

  • saudor's picture
    Offline
    Last seen: 16 hours 36 min ago
    Joined: 10/06/2007 - 12:30pm

    Yeah you should delete all of that non sense and dont rush in copying and pasting. Since as far as I can tell, it's caused by the shop front and since it doesnt happen all the time, it's most likely user error such as forgetting to copy something

    EDIT: Went through another marathon of trying to f*** up the database system (pasting the entire shop, pasting next 80 items text, omitting the item title, pasting up to N and leaving the P in NP out, etc etc) but it still fails. The protection system keeps kicking in and shuts down the portal

    Also, if possible, can you install a program called TeamViewer? It will allow me to see how you use the NeoMallers Portal and maybe there is a certain thing that causes problems - thanks

    Edit again: Did you recently use the bulk add feature? since that creates blank/weird entries at the end. dont know if that's relevant but...

    For s = 0 To (lstShopFrontNew.ListCount) 
    Call NoDuplicatesInList(frmShopStock.lstShopStock, lstShopFrontNew.List(s))
    Call frmShopStock.AddItem(lstShopFrontNew.List(s))
    
    If chkShopFrontScan.Value = 1 Then
    lngInStock = Val(ReadIniValue(App.Path & "\users\" & strUsername & "\" & "cache\shopnew.db", lstShopFrontNew.List(s), "High"))
    lngInStockWarn = Val(frmSettings.txtWarnLevel)
    Call frmShopStock.UpdateItem(lstShopFrontNew.List(s))
    End If
    
    If chkFrontAssignMall.Value = 1 Then
    
    lngMallPrice = Val(ReadIniValue(App.Path & "\users\" & strUsername & "\" & "cache\shopnew2.db", lstShopFrontNew.List(s), "Mall"))
    Debug.Print "Assigning mall price " & lngMallPrice & " to " & lstShopFrontNew.List(s)
    End If
    Call frmShopStock.UpdateItem(lstShopFrontNew.List(s))
    Next s

    For s = 0 To[b] (lstShopFrontNew.ListCount)
    ^ well that's a glitch - should lstshopfrontnew.listcount - 1

    -----------------------------
    Protect your account
    http://www.neopets.com/~punchback_bob
    CG information & more

    saudor's picture
    Offline
    Last seen: 16 hours 36 min ago
    Joined: 10/06/2007 - 12:30pm

    I think i got it!
    Problem was, the existing stuff (like wiz price, mall price) wasnt being retrieved each and every time in the shop front database so under certain circumstances, it would use the last value that was retrieved and spread that over across every other entry. I was quite surprised it even worked in the first place. I guess the portal was "remembering" that from another line of code up above (which has the retrieve data from the DB code) but whenever that part of code doesnt execute for some whatever reason like bad inputted data, the stored values for that particular item isnt retrieved from the database so it uses whatever the program was using last and applies that, hence the duplication issue. Something like that...

    Hope this was the source. New portal will be come by tonight

    -----------------------------
    Protect your account
    http://www.neopets.com/~punchback_bob
    CG information & more

    temps_bons's picture
    Offline
    Last seen: 7 years 5 months ago
    Joined: 10/04/2009 - 10:58pm

    Dmitri wrote:
    I think i got it!
    Problem was, the existing stuff (like wiz price, mall price) wasnt being retrieved each and every time in the shop front database so under certain circumstances, it would use the last value that was retrieved and spread that over across every other entry. I was quite surprised it even worked in the first place. I guess the portal was "remembering" that from another line of code up above (which has the retrieve data from the DB code) but whenever that part of code doesnt execute for some whatever reason like bad inputted data, the stored values for that particular item isnt retrieved from the database so it uses whatever the program was using last and applies that, hence the duplication issue. Something like that...

    Hope this was the source. New portal will be come by tonight

    WOW! That was amazingly fast, great job! I am thrilled that I was selling completely different stock when this happened so I can just delete the entries instead of looking up each item and trying to put a real cost in there. I-m so happy

    ~ Mimi
    -----------------------------------------------------------------------------------
    ~ Mimi's Ménagerie ~
    http://www.neopets.com/browseshop.phtml?owner=temps_bons&misc

    Pages