Unable to Convert database

Submitted by the_good_eevil_one on Thu, 28/01/2010 - 6:36am
Hi there I installed the latest version of the portal yesterday which worked fine Opened and closed it with any problems Now when I try to open it up it comes up with this error http://img37.imageshack.us/img37/3285/problemn.jpg Any ideas of what is wrong?
Forums: 
Help & Support (Counter/Portal)
  • 14873 reads

Tried pasting the first page of my shop front and it's still doing it.
angel_shortcake | Sat, 13/02/2010 - 1:59pm |

The entire folder, yep. I got the error with blue moon petpet bed, changed the bought at value from 0 to 1, and the sale price from 0 to 2. And that was fine, now it skips to christmas mazzew. Was there an update you did to change the values or something? Is going through the items and changing all the 0's to another number the best way to approach this?
angel_shortcake | Sat, 13/02/2010 - 2:01pm |

Sale prices and bought prices cannot be 0 because they cant be that anyways so it will give you an error. A database glitch exists where items get reset to 0 so the portal has been updated to stop operation if a 0 is about to be written -------------------------------------------------------------- [url=http://www.neopets.com/pirates/smugglerscove.phtml?thanks=24698]Get a SuAP[/url]
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Sat, 13/02/2010 - 2:06pm |

Is there an easier way to go back and change them all than doing it manually? I have 1100 items.....
angel_shortcake | Sat, 13/02/2010 - 2:12pm |

Why is it even at zero anyways? I thought you transferred the whole thing -------------------------------------------------------------- [url=http://www.neopets.com/pirates/smugglerscove.phtml?thanks=24698]Get a SuAP[/url]
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Sat, 13/02/2010 - 2:15pm |

I did. I haven't used the portal for over 6 months, and they were all zero then. If I didn't add a price, I think it was automatically zero until I did. (But of course that's what I remember, doesn't mean it was true).
angel_shortcake | Sat, 13/02/2010 - 2:16pm |

Well that's the problem lol. Since i would have expected everyone to specify a price when adding stuff to the portal. No point in having it there unless you plan to price and sell -------------------------------------------------------------- [url=http://www.neopets.com/pirates/smugglerscove.phtml?thanks=24698]Get a SuAP[/url]
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Sat, 13/02/2010 - 2:18pm |

They're items I added before that I didn't get to stocking yet, like the painted petpets and some supplies. I was just adding the names of the items before, so that it would tell me it was out of stock and then I'd stock it. I never did have all 1100 items in stock. It worked before, and it's only causing a problem now. Is there an easy fix or should I go through and add a price to everything?
angel_shortcake | Sat, 13/02/2010 - 2:21pm |

Bleh, I just add the cost no matter what. And no there is no way. What you could do is start a new database and then enter in your shop front which will set mall prices to the stuff in your shop -------------------------------------------------------------- [url=http://www.neopets.com/pirates/smugglerscove.phtml?thanks=24698]Get a SuAP[/url]
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Sat, 13/02/2010 - 2:24pm |

Then I lose all my items because I don't have all the items in stock. I guess I'll have to do it manually... And I haven't added a price because I find items in other people's shop when I went to buy something else. I assume that it is not wiz priced like the item I'm buying, and therefore don't put a price on it until I go wiz that item.
angel_shortcake | Sat, 13/02/2010 - 2:28pm |

Pages