[Treebase-devel] NULL pointer problems

[William P. <wil...@ya...>]

Also because we have reverted to an older instance of the data, the migrated records contain have NULL in the user_id of the submission table. This causes null pointer errors for the unit tests. To fix the problem, I did the following:

1. I created a user with username "migration" and email address "mig...@tr...". This is the dummy "user" who will now "own" all migrated submissions that lack an owner.

2. I got the user_id for the "migration" user, and it happened to be 9955

3. I ran this statement: "UPDATE submission SET user_id = 9955 WHERE user_id IS NULL"

Now all migrated data belong to the user "migration". 

I'd like to do the same thing to the staging database, but I can't seem to access the UI (http://treebase-staging.nescent.org/treebase-web/) and I don't have the username/password/host parameters for direct psql access. Can someone send me these?

thanks,

Bill