Shop front update crash

6 posts / 0 new
Last post
cinderellie7
cinderellie7's picture
Offline
Last seen: 7 years 11 months ago
Joined: 30/09/2007 - 11:58am
Shop front update crash
Okay, so I have the newest version of the portal dled, and I'm on XP pro, using firefox 3.5.2 I was updating my shop front, got to the end submitted and got the following error: [quote]UpdateItem Error! The update sequence for item [Black Bearog] was halted because the program tried to write empty values for this entry. Portal will now close to prevent damaage to the database[/quote] In case I'd copied something wrong I restarted it and went through the process again, and still same error. HALP! Cheers, Arden
saudor
saudor's picture
Offline
Last seen: 8 hours 23 min ago
Joined: 10/06/2007 - 12:30pm
[KB#03 - Portal Sample] Can you please provide a sample of what you're pasting into portal? To do this, first copy your shop front into neomallers portal as normal. Then when the text is pasted into portal, instead of clicking process, re-select that by pressing CTRL+A and CTRL+C, then paste it into this forum window Also, is this a new empty database or a pre-existing database with data?
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
cinderellie7
cinderellie7's picture
Offline
Last seen: 7 years 11 months ago
Joined: 30/09/2007 - 11:58am
existing database, been using it for nearly 2 years didn't have the problem until today, can't remember if I've posted the shop front succesfully since updating to the newest version, but I think probably not since it's been only 2 days, and I'm a lazy pants :P [quote]Neonip Critter 9 in stock Cost : 1,000 NP [A yarn ball can provide hours of amusement for a young pet.] Red Yarn Ball 1 in stock Cost : 1,000 NP [A yarn ball can provide hours of amusement for a young pet.] Blue Yarn Ball 1 in stock Cost : 1,000 NP [This scratching post can provide hours of amusement for you and your pet.] Scratching Post 1 in stock Cost : 10,000 NP [Take this magical paint brush to the Rainbow Pool and you can transform your pet into a ravishing red colour.] Red Paint Brush 1 in stock Cost : 94,000 NP [Go to the Rainbow Pool with this special brush and your pet will now become yellow.] Yellow Paint Brush 1 in stock Cost : 92,000 NP [Take this brush to the rainbow pool and you can turn your pet green.] Green Paint Brush 1 in stock Cost : 85,000 NP [Take this strange paint brush to the Rainbow Pool and you can make your Neopet glow in the dark.] Glowing Paint Brush 1 in stock Cost : 77,000 NP [Go to the Rainbow Pool with this special brush and your pet will turn invisible.] Invisible Paint Brush 1 in stock Cost : 85,000 NP [Give your loved one the "weathered" look! Go to the Rainbow Pool (via the shops menu) to use this brush.] Cloud Paint Brush 2 in stock Cost : 78,000 NP [Your pets will love the "ping pong balls over grass" look! Cool! Go to the Rainbow Pool (via the shops menu) to use this brush.] Speckled Paint Brush 2 in stock Cost : 74,000 NP [Turn your pet into a blueline drawing! Go to the Rainbow Pool (via the shops menu) to use this brush.] Scritchy Sketchy Paint Brush 1 in stock Cost : 87,000 NP [An ancient reminder of a time long gone.] Stone Paint Brush 1 in stock Cost : 75,000 NP [Create a spectacular fence with these miniscule trees.] Dwarf Tree 4 in stock Cost : 2,500 NP [This mean looking plant helps keep bugs under control.] Bad Seed 6 in stock Cost : 1,000 NP [Give your pet a mystical coat of paint with this rare item! Go to the Rainbow Pool (via the shops menu) to use this brush.] Starry Paint Brush 2 in stock Cost : 99,999 NP [Angelpi are sweet adorable little kitties for your Neopet to look after.] Angelpuss 10 in stock Cost : 5,000 NP [A Warf is a cross between a thingy, and erm...something else!] Warf 2 in stock Cost : 6,000 NP [Buzz buzz buzz! Keep your pet happy all day, playing with this buzzy thing!] Buzzer 6 in stock Cost : 2,000 NP [Why not adopt this cute baby piggy today? But beware, it eats a lot of food. What a pig!] Snorkle 5 in stock Cost : 10,000 NP [A really rare pet, the Flishy is said to bring great luck.] Flishy 1 in stock Cost : 23,000 NP [It rarely opens its mouth, but when it does, its 20 foot long tongue can catch any fly.] Greeble 7 in stock Cost : 2,000 NP [Tigermice like taunting Neopets, pulling ears, and biting tails - so beware!] Tigermouse 1 in stock Cost : 11,000 NP [This pretty puppy will fetch anything that is thrown for it. It eats almost anything! It loves children, too!] Puppyblew 2 in stock Cost : 6,000 NP [Ohh...this Spyder is creepy...make sure your Neopet isnt afraid of it!!!] Spyder 2 in stock Cost : 2,000 NP [It looks like a Petpet, acts like a Petpet, but when frightened, it makes a loud wail like a Wocky!] Mallard 2 in stock Cost : 2,000 NP [The Poppit is a strange insect like creature. It uses suction to stick onto walls, and if it needs to, it sucks air into its body and can fire itself up into the sky!] Poppit 4 in stock Cost : 3,333 NP [Huggies gives a hug to anyone they sees. They can be quite overly friendly and sometimes annoyingly so.] Huggy 3 in stock Cost : 20,000 NP [Unioctos swim quickly, which makes them hard to catch. If your Neopet allows it to get away, you may have to get a new Petpet :(] Uniocto 5 in stock Cost : 3,333 NP [The Beekadoodle loves to fly around at speeds faster than any other pet around. It sings beautiful songs all day long.] Beekadoodle 1 in stock Cost : 90,000 NP [This pet is a cross between a Poppit and a Spyder.] Spoppy 4 in stock Cost : 3,333 NP [Blooky is a cross between a Triffin and an Angelpuss.] Blooky 1 in stock Cost : 46,000 NP [This Moink would make a loyal friend to your Neopet.] Moink 1 in stock Cost : 33,333 NP [Pinceron will give anyone who tries to scare your pet a nasty nip!] Pinceron 5 in stock Cost : 12,000 NP [Avabot is the ultimate pet...he never needs feeding and can shoot lasers out of his eyes when provoked.] Avabot 1 in stock Cost : 90,000 NP [The Diddler is one of the least expensive of the Robot Petpets and it will keep your Neopet amused with its variety of built in games.] Diddler 1 in stock Cost : 6,000 NP [The Wheelie was a project gone wrong. This happy little robot just wheels about smiling at people...] Wheelie 2 in stock Cost : 5,000 NP [Screwtop is a fairly simple robot...he has a toolkit hidden in his head, and is helpful when doing DIY.] Screwtop 1 in stock Cost : 21,000 NP [These cheeky little rascals love causing mischief and make perfect play mates for fun loving Neopets.] Pfish 2 in stock Cost : 6,000 NP [An easy to keep, loyal friend, Tanizards love to snuggle on Neopets shoulders as they walk around.] Tanizard 2 in stock Cost : 14,000 NP [Pepitos are quite intelligent for Petpets, and with practice you can teach them to do tricks for small pieces of food.] Pepito 3 in stock Cost : 6,000 NP [So named for its striking resemblance to a Blumaroo... uncanny isnt it!] Baby Blu 3 in stock Cost : 12,000 NP [It may not be the best looking Petpet out there, but it is very easy to look after.] Frillabon 1 in stock Cost : 6,000 NP [Poor little Cubetts arent the brightest Petpets, but what they lack in brain power they make up for with love.] Cubett 7 in stock Cost : 5,555 NP [Bubblisaurs get longer as they get older, if well looked after they can grow to quite a size.] Bubblisaur 5 in stock Cost : 7,000 NP [Your Neopet need never face the dark again with a cute little Filamen to light the way.] Filamen 2 in stock Cost : 11,000 NP [Peos are very pretty, but dont they know it. They are very demanding and have temper tantrums if they dont get what they want.] Peo 1 in stock Cost : 8,000 NP [Crabulas love sneaking up behind people and pinching them by surprise, unfortunately they have giggle fits as soon as they have done it, so they always get caught.] Crabula 2 in stock Cost : 8,000 NP [Phnards are grumpy, lazy little things that like nothing better than basking in a rock pool.] Phnard 2 in stock Cost : 11,000 NP [A lively, jolly little creature that loves to play. Cheerlubs make high pitched meeeba meeb noises when extremely happy.] Cheerlub 2 in stock Cost : 13,000 NP [Eelikas need to swim in cool water at least once a day, otherwise their skin can dry up and become sore.] Eelika 2 in stock Cost : 12,000 NP [Ok so hes not the fastest Petpet in the world, but at least he will never run away :)] Slugawoo 1 in stock Cost : 40,000 NP [A peculiar little chap that will happily scuttle after its Neopet all day long.] Bleamix 1 in stock Cost : 30,000 NP [Catamara rise to the surface of the water if they smell their favourite food, Negg flakes!] Catamara 1 in stock Cost : 5,000 NP [Although the Sproing lives in water it can bounce across land for short periods of time.] Sproing 5 in stock Cost : 5,000 NP [The Ultra Pinceron is a beefed up version of the normal Pinceron. It can extend its arms 30 feet to nip nasty people at a distance!] Ultra Pinceron 4 in stock Cost : 17,000 NP [The Bowla can suck in water and grow to 10 times its normal size before squirting it all at anything that happens to be near!] Bowla 3 in stock Cost : 7,000 NP [A great friend... for as long as the weather stays cold.] Abominable Snowball 4 in stock Cost : 2,000 NP [This mouse can see into the future!!!] Psimouse 5 in stock Cost : 4,500 NP [A cross between a pool ball and a spot of ink, the Bloop] Bloop 7 in stock Cost : 10,000 NP [This scorching fireball wandered too far away from the sun in search of a cooler climate.] Baby Fireball 2 in stock Cost : 12,000 NP [There is always one in every bag...] Candy Vampire 1 in stock Cost : 99,999 NP [If you blow your nose on him then he will not be very happy. Ghostkerchieves haunt Neopets pockets!] Ghostkerchief 1 in stock Cost : 85,000 NP [This friendly freak just wants to be loved. Its three heads never agree on anything.] Bearog 2 in stock Cost : 4,500 NP [Froilers lurk in dark hot places... and can turn themselves invisible. They love eating Chias!] Froiler 3 in stock Cost : 20,000 NP [Wow! The Christmas Paint Brush! Take your pet to the Rainbow Pool and make him or her a shade more festive!] Christmas Paint Brush 2 in stock Cost : 75,000 NP [The Green mixture will turn any Neopet into a beautiful Green Uni.] Green Uni Morphing Potion 1 in stock Cost : 29,000 NP [Legend has it that a band of evil Korbats were transformed into mindless Barbats under a wicked curse.] Barbat 1 in stock Cost : 7,000 NP [Its older brothers Cumulo and Nimbus abandoned it as a child, so now its up to your Neopet to look after it!] Cirrus 6 in stock Cost : 7,000 NP [Harris make very affectionate Petpets, providing you can stop them climbing the trees in the Faerie Queens garden.] Harris 5 in stock Cost : 10,000 NP [Flouds just float around until they bump into something interesting. Never feed them carrots.] Floud 7 in stock Cost : 3,000 NP [The Hornsby is a cross between two other species, we arent sure which. They are sad, and prefer to be alone.] Hornsby 1 in stock Cost : 14,000 NP [A Bloopy will try and steal your Neopets food when it isnt looking. It can store food in its cheeks and double its size!] Bloopy 11 in stock Cost : 25,000 NP [Carmas can catch food for your Neopet with their sticky tongue. Whether your Neopet wants to eat it is another question.] Carma 4 in stock Cost : 2,222 NP [Airaxs will perch on your Neopets arm all day. They love to zoom up into the air and swoop around.] Airax 6 in stock Cost : 2,000 NP [Searex are the water going cousins of Airax. They can breathe out of water as well.] Searex 7 in stock Cost : 2,000 NP [Acko, or Ackosaurus as he is known, is a little dinky dinosaur who loves to brush against things and purr.] Acko 1 in stock Cost : 50,000 NP [Gruslens may appear to be cute and harmless but if you anger them you could be in for a visit to the Neopian Hospital.] Gruslen 1 in stock Cost : 8,000 NP [The Bluna was first sighted under the ice caps of Tyrannia. They are very very cold pets and if you touch them you could get a bad case of Neopian frost bite.] Bluna 1 in stock Cost : 30,000 NP [Scado is an underwater dweller that resembles a coconut. Some Skeith would even say that they taste like Coconut too.] Scado 4 in stock Cost : 1,500 NP[/quote] like so? eta: it sure sounds like it's connected to the new dataguard thing. I know the black bearog is something I've never sold nor do I have in stock, or have a price for it, so might that have something to do with it? also it has a stock value of -1 for some reason. But then there are items that come earlier in the alphabet that I believe have the exact same thing problems.
saudor
saudor's picture
Offline
Last seen: 8 hours 23 min ago
Joined: 10/06/2007 - 12:30pm
well that DB guard thing comes up with the portal tries write 0 for everything, which shouldnt be happening since the bearog has a mall price. Something is not being pasted right but i gotta look into it later since i have a early class tommorow and i need to hit the sack so i can actually wake up at that time lol
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
cinderellie7
cinderellie7's picture
Offline
Last seen: 7 years 11 months ago
Joined: 30/09/2007 - 11:58am
ugh, early classes. How I don't miss them. The joys of doing correspondence courses :P Anyways, I'll play around submitting different things, see if can narrow the problem down at all :P
cinderellie7
cinderellie7's picture
Offline
Last seen: 7 years 11 months ago
Joined: 30/09/2007 - 11:58am
erm, well I thought i'd solved it, because there were a couple of items with -1 in stock, and they're gone, but now items with just plain old 0 are coming up problems :K so far still though all items I've never actually had in stock nor have any prices for, just 0s all around. I've tried pasting different pages of my shop to see if that changes it, but no, it doesn't matter. Grargh... so no problem solving afterall... maybe I should sleep now too :P eta: okay, this is getting silly, it's clearly all the items with 0s for all the values, so it is the dataguard afterall, it's just that it's not the portal having written over any real data, it's just that they never had values to begin with in any of the fields :P ah well, I'm going to manually delete them, since they're all painted petpets I don't carry anyhow atm I'm sure I'll update yet again if I find that they're still problems after having gotten rid of all the known problem entries Cheers, Arden LAST EDIT (I PROMISE!): Removing all the ones with values of 0 worked like a charm! Now I can sleep like a baby :P Hope this at least helps if someone else comes accross the same errors in the future :D