• All submissions to this site are governed by Second Life Project Contribution Agreement. By submitting patches and other information using this site, you acknowledge that you have read, understood, and agreed to those terms.
Issue Details (XML | Word | Printable)

Key: SVC-274
Type: Bug Bug
Status: Resolved Resolved
Resolution: Duplicate
Priority: Major Major
Assignee: Mani Linden
Reporter: Zho Golem
Votes: 13
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
2. Second Life Service - SVC

Scripts, notecards, etc. that can't be opened/rezzed and give "Missing From Database" error

Created: 05/Jun/07 10:01 AM   Updated: 16/Aug/07 08:19 PM
Return to search
Component/s: Scripts
Affects Version/s: 1.16.0
Fix Version/s: None

File Attachments: None
Image Attachments:

1. missing_from_Database.PNG
(13 kB)
Issue Links:
Duplicate
 
Relates
 

Linden Lab Issue ID: SL-45442


 Description  « Hide
When opening some (seemingly random) scripts or notecard, the contents will not load. A '<x> is missing from Database' error will show up. The script can sitll be run, recompiled and reset but is uneditable. Depending on the person the damage is more widespread.

Relogging, clearing cache, going to an empty sim will not work.



 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
White Platini added a comment - 05/Jun/07 10:26 AM
Yeah, have the same problem exactly, most for scripts and notes inside my objects.....older ones, I cant open around 95% of them...

winyeala Nadir added a comment - 11/Jun/07 09:27 PM
I have this same issue with my older scripts and AO, my friend is having this same issue with her collar.

Torley Linden added a comment - 13/Jun/07 09:28 AM
I've seen this before too, altho I don't have a better repro.

White Platini added a comment - 14/Jun/07 12:49 PM
What can we do? Torley most of my work is stuck because of this

Torley Linden added a comment - 15/Jun/07 03:22 PM
@White and others affected: do you have any copies of these objects you can send me? That'd be a start. We've had some other reports and I've asked those affected Residents to vote and post details here. I'll also give our devs a heads-up on it.

Prokofy Neva added a comment - 15/Jun/07 04:00 PM
I have this same issue. I just got it again yesterday, with that exact same blue drop-down menu, "Notecard missing from the data base". The cards either generate that message, or they say "loading" and never load, for me, or those who get them.

A separate, and possibly unrelated issue is a set of frequently-used notecards that completely disappear from inventory. I log on – they're all gone, even though just used and edited and saved from the previous log-on. I clear cache, log on again – missing. Some stay missing – some pop back up – still others reappear even weeks later saying "loading".

I'm now really, really tired of this, as it has happened for months, across many patches, and it means that the dozen or so notecards I use the most for customer info and newbie help are constantly borked. I have to stash them inworld around my sims in notecard-givers to give them to myself again as they will be gone from inventory.


Prokofy Neva added a comment - 15/Jun/07 04:01 PM
And I believe the issue to be related possibly to the embedding of landmarks or other notecards within that card that goes missing.

Hoshi Kiama added a comment - 18/Jun/07 03:20 PM
There's nothing to do with imbedded items on this. I have a Force Prophecies attachment that has a configuration notecard that only has several lines of text on it that is now in this condition. I've been wearing this attachment for months now without issues and all of the sudden this notecard can't be read by the scripts. When I tried to read it I get the error described. The FP attachment object is no transfer or I'd send it to Torley. Maybe a UUID would help Torley?

Hoshi Kiama added a comment - 18/Jun/07 03:45 PM
It occured to me that I hadn't tried copying this (UUID obviouslty doesn't apply after all) latest object to have this happen. Incidentally this cropped up under version 1.17. Anyway, after I just now copied and pasted this object in inventory and attached each (their scripts make them delete themselves if rezed in world not attached) the configuration notecard is now accessible in the inventory of both. Some change to the database since two days ago when this was first noticed to be bad or was this a function of copying in inventory?

Elbereth Witte added a comment - 20/Jun/07 03:53 AM
Yeah, okay, this sucks hard. I clearly must backup everything of value in the future.

Lex Neva added a comment - 21/Jun/07 09:11 AM
That doesn't help if the copies are busted too, Elbereth :/

I've lost two items recently that I valued. Both were objects in attachments that I frequently wear and are rezzed by scripts in the attachments. Both result in "Unable to rez object. Object missing from database." whenever the script tries to rez the object (or when I do). Fortunately I had older copies of both, but I'm not certain that these are the most up-to-date versions.

I tried to bug-report with the asset UUIDs, but... Copy Asset UUID is broken, and copies a null key.


Torley Linden added a comment - 22/Jun/07 08:44 AM
@Lex: I received your items, thanks.

SeanMcPherson Senior added a comment - 22/Jun/07 03:15 PM
Torley, Same thing has happened here. What info do you want from me on it, a copy of the item? ID is 7a0441a8-f121-169c-edff-67c9f7773ebb, notecard is named 'Default Anims' and is an *old item. Even my backup copy is dorked, since I make a copy but didn't make a new card and paste the content into it. sigh

White Platini added a comment - 23/Jun/07 10:46 AM
Sent a few of my scripts to Torley, hope that helps @.@

Elbereth Witte added a comment - 25/Jun/07 12:23 AM
I meant backup to outside of SL. If you ever see me saying "trust SL with your data" please assume that I've been replaced with a can of coffee or something.

I've lost a few scripts I simply require, and am now stuck slowly remaking inferior versions of them. I'm extremely unhappy about this and wish painful drawn-out cartoony death on whoever pushed the wrong buttons to make this happen.


Torley Linden added a comment - 25/Jun/07 10:51 AM
Thanks, I got a bunch of "missing from database" items.

@Everyone who has items which are "missing from database": important to know, when do you last recall them working? Right now we're trying to discern if this is a new cause resulting in "missing from database", because we know there's been cases in which something was actually broken for months, but only noticed more recently. (See VWR-527 for prior context.)

But if you had something you're sure worked a week ago and is now busted, please do say so, all the details you remember help (as hard as it can be to recall).


Torley Linden added a comment - 25/Jun/07 11:07 AM
Also, I've personally received a burst in "missing from database" IMs, emails, and related concerns, so while I need to find out more, something sounds up more recently. As noted originally, this is affecting notecards, scripts, but other inventory types have been noticed too.

From VWR-527:

========-
Sycamore Allen [17/Jun/07 11:05 AM]
I can currently not wear the avatar I paid 900L for because I'm getting this error message for both the head and tail.

Jayden Beresford [22/Jun/07 06:48 AM]
Great I just lost $2,000 of hair to add to the $3,000 of plants and my $4,000 Composer Flute. Sigh. So much lost inventory, the one thing I notice though it is always objects inside prims. Every thing I have lost (and it's a lot) has been inside another object, pulled out and a rez tried.

With the hair l logged out and tried a clear cache and it went, poof, into thin air.
========-



SeanMcPherson Senior added a comment - 25/Jun/07 12:38 PM
Torley,

The notecard that went missing for me was in the AO I wear every day, and about an hour before I posted my first comment on this bug here (22/Jun/07 03:15 PM), I'd taken my AO off to look at the card as I was helping someone else with their AO (I was making no changes to my AO, poses, or the notecard; I simply detached it, rezzed it in world, and edit mode to open the notecard). It was working fine up to the moment I took it off. When I rezzed it in world and went to open the notecard, it gave the 'notecard missing from DB' entry. I was on our Island (New Conch Republic) when I detached and rezzed it in world, and then went to the mainland with the item to see if it was island specific (obviously not), and then logged out, cleared cache and logged in, testing again on both mainland and the Island. The copies I had in my inv gave the exact same error (and had the same ID). At that point, my only recourse was to rewrite the notecard by hand to get the AO working. Since I was able to find this bug, I wanted to make sure the issue was listed, but that should help give a very specific region and time stamp.

Sean


Celierra Darling added a comment - 28/Jun/07 12:44 AM
This was a comment in a duplicate issue, MISC-324:

Lateknight Marvin [27/Jun/07 11:30 AM]

Some of my affected notecard's UUID's:

77f2152e-4cba-a762-690a-6877d472464f
bbc304a4-8682-91fa-7c08-96d3372f27b5
afa2acd8-6945-bb70-f0e5-e28a222513de
930f4c6c-4d79-14bc-1f98-1f0873d6460d
dc7dd4e7-6df1-45e3-4ac9-2b9831c1eff7
b63b3a8c-64c0-4358-a9a4-033959f64502
df84bdb7-06f0-6db0-d538-6453c004465f
9afb6a02-429c-1abc-cbb0-adfe42f3348c
fd019742-e4ae-4e75-d51d-78aacdc960b2
9812a2bf-d070-479d-3624-cc983b7a9285


White Platini added a comment - 28/Jun/07 07:37 PM
@Torley - this has happened to me several times but instead of complain I just went and rewrote stuff again, though since around 2 months ago most of my stuff from around 8 months to 3 month ago got this database error... so thats stuff from Dec 2006 to May 2007.

Also I found that happens a lot more from scripts/notes inside the objects and in the inventory than from the ones just inside the inventory.


Leara Kohime added a comment - 11/Jul/07 02:39 AM
I'm relativly new to SL, created in April, and bought a pair of primshoes 16.May 2007. These worked fine till midth of June. Since then I'm unable to attach it due to this error. I bought about 10 pairs in different colors... all have the same AO script in it, but only one shoe w/o the AO got the problem.

There is a strange thing in the "Inventory Item Porperties" this one shoe which got the error is listed as acquired the moment I logged of the last time. while the one I can attach keeps the original date of acquire. Since nobody mentioned that earlier, I made a screenie.

Picture of the Inventory Item Properties: http://www.mirsching.de/content/download/MissingFromDB.jpg


Irina Carter added a comment - 17/Jul/07 01:24 PM
The same thing has happened to mee to just right now with the object "flight feather". I had not encountered this before.

Mortuus Lamington added a comment - 22/Jul/07 10:05 PM
Same problem with my own scripts, seems to affect attachments such as my jetpack and flight HUD.

Zi Ree added a comment - 24/Jul/07 01:21 PM
Same issue here. Support-Ticket still ongoing, including a good number of UUIDs. In my case, it's all about notecards in attachments. Copying / Moving them to inventory does not help either.

Torley Linden added a comment - 27/Jul/07 08:21 AM
Following further internal investigation and help from Mani, I'm resolving this as a dupe, because at least some cases in here are likely covered by the very hot VWR-1225. I realize that VWR-1225 doesn't directly address the non-notecard problems mentioned here, but without further insight into the cause besides vague messages like "missing from database", it's difficult to identify how to fix the problem, or when a problem might've originated (e.g., something in your inventory you haven't used in a long time, and you suddenly notice it gives you this error).

Thus, to improve on this in the future and avoid confusion, Mani's also planning to work on having the system provide detailed error messages for specific situations in the future (internal ID SL-50020). This will be more useful than the current situation, where "a single client error message covers several error conditions in the code that check permissions and transfer assets requested via inventory items".

Content loss is understandably painful and it sucks to hear of your losses, so this is another step on our route to squashing these bugs.


Lex Neva added a comment - 16/Aug/07 07:53 PM
Torley, I disagree with marking this as a dupe of VWR-1225. VWR-1225 is a permissions issue relating to notecards, and results in a completely different error message, "Insufficient permissions to view notecard." This issue seems to refer to all kinds of assets, and it involves the message "____ missing from database."