[SPTUsers] Publisher-adding oddity

[Barry Wiegan]

Hi Scot,

You should under no circumstances have any resource records with a
negative ResourceId. You should only have one resource record with
a negative TempResourceId, and that should only exist while adding
controlled names or classifications to a new record. After you hit
"Add Record", that temporary resource record should be deleted.

I think you still may have some residual temp resource records around
that were caused by the sql error you reported earlier.  These records
should be cleaned out when you add a new record when logged in
as the same user that created those temp records (see approximately
line 580 of SPT--AddRecord.php).  

When you are starting a new record, it is probably displaying (incorrectly)
one of these old temporary resource records. If nothing else, you can
delete all resources with a negative TempResourceId (eg, "Delete from
Resources where TempResourceId < 0") with the mysql command line,
and your problem should go away.

Hope this helps,
Barry

Scot Wilcoxon wrote:

>Anyone else noticed when creating a new resource, after creating a new
>Publisher and selecting it to be added to the resource...the wrong
>resource is displayed?
>
>I see that the ResourceId=-2, and my Resources DB table has a bunch of
>records with non-NULL TempResourceId.  Looks like one -1 (not the
>resource currently being worked on) and several -2.  One of the -2
>resources is being shown.
>
>An Edit Resources search for unreleased resources does find the proper
>resource, so at least the work is not lost.
>
>(I'm still figuring out the internals of SPT, and didn't find the
>problem yet...this is in the current SPT version, with UI Default.)
>
>_______________________________________________
>SPTUsers mailing list
>SPTUsers at scout.wisc.edu
>http://scout.wisc.edu/mailman/listinfo/sptusers
>  
>

-- 
Barry Wiegan
Sr. Software Engineer
Internet Scout Project
Madison, WI
bwiegan at scout.wisc.edu