Pointless bug report - Database with 1 item

Submitted by zixianna on Thu, 01/12/2011 - 2:49pm
So, I was making a new DB to track more expensive items (not Shop items per say, but one where I was going to use the price to represent x1000 NP). I only entered a single item into it, saved it, and left it for later. Upon trying to open that database, Portal would crash at 'Optimizing indices...' 0%, 1 of 2002 (at 25 per second). There is only 1 item in the database. If I manually put another item in the data_shopstock and index_shopstock, it would open fine. If I remove the original entry, and leave the one that was manually added, the same error occurs. Not the kind of error many people would ever come across I'm sure 0:-)
Forums: 
Development & Suggestions
  • 8482 reads

So, likely an index initialization type error. I recreated the DB, and added 3 unique items, with a couple each in stock. The Overall stats shows 'Unique Stock: 2/2' (with the other items being off as well, due to them being updated through the Submit Shop Front, so we can't count that part). But, obviously there are 3 items, so maybe there have a 0 vs. 1 array index problem there?
zixianna | Thu, 01/12/2011 - 3:01pm |

the total thing seems to act weird.. but at times it fixes itself.. Have to figure out what's causing it. Version 10.1 will come out soon and it fixes some glitches experienced by some users. However, probably wont fix everything EDIT: version 10.1 is released and fixes a few bugs. Stability for windows vista is increased too
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Fri, 16/12/2011 - 9:30am |

Woot! I have a meeting in 5 minutes, but I'll be playing with it as soon as I'm out! Woohoo!
zixianna | Fri, 16/12/2011 - 10:26am |

When I run the Update1.exe, it extracts, runs and opens the DB fine, displays it's version 10.1, but then when I close it, the Exe deletes itself. I got around it by copying the exe out of the directory while it was running, and copying it back in after it deleted, and it stays just fine.
zixianna | Fri, 16/12/2011 - 11:12am |

Is there a changelog for this version? The first thing I tested out was to see if setting stock to -1 to hide it still reduces the "Value: (Actual)". Unfortunately it does :( So, wondering what changes are in there :)
zixianna | Fri, 16/12/2011 - 11:20am |

oh i didnt patch that glitch :P The exe deleting itself? damn... did i forget to uncheck that feature lol.. hmm.. ----------------------------- [color=purple]Are you protected?[/color] http://www.neopets.com/~punchback_bob CG information & more
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Fri, 16/12/2011 - 6:30pm |

Yea, it was weird, it's the Update1.exe unzipping that does the deleting, since it hangs and does't respond while Portal is open, likely because it's trying to delete the in use file.
zixianna | Fri, 16/12/2011 - 7:35pm |

Yeah i updated the update1.exe file. It's fixed now. no more self destruct feature haha ----------------------------- [color=purple]Are you protected?[/color] http://www.neopets.com/~punchback_bob CG information & more
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Sat, 17/12/2011 - 5:03am |