price resetting in item database

14 posts / 0 new
Last post
sayumi
sayumi's picture
Offline
Last seen: 13 years 2 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
saudor's picture
Offline
Last seen: 1 hour 17 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 [b]1. Operating System & Language [/b]Ex: Windows XP PRO English 32-bit Edition, Service Pack 2 [b]2. Browser & Version[/b] Ex: Firefox 3.0 English [b]3. Your NeoMallers Portal Version. [/b]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
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
sayumi
sayumi's picture
Offline
Last seen: 13 years 2 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
saudor's picture
Offline
Last seen: 1 hour 17 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.
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
sayumi
sayumi's picture
Offline
Last seen: 13 years 2 months ago
Joined: 27/09/2009 - 10:25am
ok nvr mind then i'll just try to take enough back-ups
davymuncher
davymuncher's picture
Offline
Last seen: 8 months 1 week ago
Joined: 10/08/2009 - 10:41pm
Lol Dmitri, I can't make it crash either ;) so it's not just your computer.
[color=Gray]Good Idea: Feeding stray kittens in the park. Bad Idea: Feeding stray kittens in the park... to a bear.[/color]
temps_bons
temps_bons's picture
Offline
Last seen: 12 years 10 months ago
Joined: 10/04/2009 - 10:58pm
[quote=sayumi]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?[/quote] 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 :( 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 :) 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
~ Mimi ~ http://www.neopets.com/~Amyrilli
temps_bons
temps_bons's picture
Offline
Last seen: 12 years 10 months ago
Joined: 10/04/2009 - 10:58pm
[quote=Dmitri]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 [][/quote]
  • I am using FF v3.5.3 [quote=Dmitri]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. [/quote]
  • I looked at mine and have 10 rows of this(before the data looks right) []{***}{***}{***}{***}{***}{***}{***}{***}{***}{***}{***} [quote=Dmitri]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.[/quote]
  • 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
  • ~ Mimi ~ http://www.neopets.com/~Amyrilli
    saudor
    saudor's picture
    Offline
    Last seen: 1 hour 17 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 [b]EDIT: [/b]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 [b]Edit again:[/b] Did you recently use the bulk add feature? since that creates blank/weird entries at the end. dont know if that's relevant but... [code]For s = 0 To[b] (lstShopFrontNew.ListCount)[/b] 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[/code] For s = 0 To[b] (lstShopFrontNew.ListCount) ^ well that's a glitch - should lstshopfrontnew.listcount - 1
    ----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
    saudor
    saudor's picture
    Offline
    Last seen: 1 hour 17 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
    ----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
    temps_bons
    temps_bons's picture
    Offline
    Last seen: 12 years 10 months ago
    Joined: 10/04/2009 - 10:58pm
    [quote=Dmitri]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[/quote] 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. ^^ ~ Mimi ----------------------------------------------------------------------------------- ~ Mimi's Ménagerie ~ http://www.neopets.com/browseshop.phtml?owner=temps_bons&misc
    ~ Mimi ~ http://www.neopets.com/~Amyrilli

    Pages