Time
S
Nick
Message
03:39
jri joined #dataverse
07:07
jri joined #dataverse
07:09
jri joined #dataverse
10:56
jri joined #dataverse
10:58
jri_ joined #dataverse
14:27
Alejandra joined #dataverse
14:30
Alejandra
Hello, In last november we upgrade Dataverse from 3.6 to 4.7
14:30
pdurbin
Alejandra: awesome!
14:31
Alejandra
yesterday we can't edit some datasets
14:31
Alejandra
New Datasets no problem
14:32
Alejandra
the dataset page don't show versions
14:34
Alejandra
the logs: javax.el.ELException: /dataset.xhtml @30,68 value="#{DatasetPage.datasetAuthors}": java.lang.NullPointerException
14:35
pdurbin
Alejandra: I'm sorry to hear you're having trouble. I don't think anyone in this channel right now can help, unfortunately. Can you please post to https://groups.google.com/forum/#!forum/dataverse-migration-wg or email support dataverse.org?
14:36
Alejandra
But In Dataset page I can see authors
14:36
Alejandra
I'm sorry, I can't write very well in english :D
14:37
Alejandra
yes of course, thanks
14:39
pdurbin
Alejandra: no worries, your English is fine. Please let us know when you are done writing to one of those other channels.
14:51
pdurbin
Alejandra: is your installation of Dataverse on the map at https://dataverse.org ?
14:52
Alejandra
yes, I work at CIMMYT
14:53
pdurbin
Ah, ok. Thanks.
14:54
Alejandra
One question, in the table datasetversion, how can i detect the working Version?
14:55
pdurbin
Let me go look at the schema.
14:55
pdurbin
here's the table: http://phoenix.dataverse.org/schemaspy/latest/tables/datasetversion.html
14:55
pdurbin
Alejandra: it should be "versionstate"
14:57
Alejandra
If a dataset has some datasetversion with versionstate "RELEASED"
14:58
Alejandra
could be with versionnumber and minorversionnumber?
15:03
pameyer joined #dataverse
15:13
pdurbin
Alejandra: hi, sorry, I'm on a video call right now.
15:13
pdurbin
I'm sorry but I don't understand the question.
15:32
Alejandra
A dataset has three datasetversion with versionstate "RELEASED", which es the working Version?
15:32
Alejandra
the last one that is inserted into database?
15:34
pameyer joined #dataverse
16:04
Alejandra
I posted in https://groups.google.com/forum/#!topic/dataverse-migration-wg/1SiDYCNPoc0
16:07
jri joined #dataverse
16:19
jri joined #dataverse
16:21
pameyer
Alejandra: by "working version", are you referring to one that's being currently edited but isn't published yet?
16:21
pameyer
or the most recently published one?
16:21
Alejandra
the most recently published one
16:25
pameyer
I'd go with something like `select id,releasetime,versionnumber,versionstate from datasetversion where dataset_id=$id_of_your_dataset order by releasetime asc;`
16:26
pameyer
… and I'd missed the "published" bit with that statement
16:27
pameyer
should be `select id,releasetime,versionnumber,versionstate from datasetversion where dataset_id=$id_of_your_dataset and versionstate='RELEASED' order by releasetime asc;
16:28
pameyer
I don't have any suggestions for your original question (NullPointerException in edit page), unfortunately
16:30
pdurbin
Alejandra: thanks for posting that message to the migration mailing list
16:31
pdurbin
Alejandra: I think I understand your question now.
16:33
pdurbin
I was a little confused because "working version" has a special meaning in the code.
16:37
Alejandra
what does it mean?
16:37
Alejandra
i have several ideas, that's why I ask
16:39
pdurbin
Please look at '@OrderBy("versionNumber DESC, minorVersionNumber DESC")' at https://github.com/IQSS/dataverse/blob/v4.8.5/src/main/java/edu/harvard/iq/dataverse/Dataset.java#L100
16:39
pdurbin
I'm pretty sure that's how it works.
16:40
pdurbin
Alejandra: does that help?
16:42
Alejandra
First I thought, if datasetversion donŽt show, maybe some value is missing in dataset version
16:42
Alejandra
Gracias
16:43
pdurbin
De nada. :)
16:50
dataverse-user joined #dataverse
16:50
Shirley-CCG joined #dataverse
17:16
pameyer joined #dataverse
17:29
jri joined #dataverse
17:36
pameyer joined #dataverse
17:52
pdurbin
Shirley-CCG: hi! I'm about to go to a meeting but I saw your email.
18:00
pameyer joined #dataverse
18:16
Alejandra20 joined #dataverse
18:29
Shirley-CCG
thank you so much Philip
20:10
pameyer joined #dataverse
21:08
jri joined #dataverse
21:17
pameyer joined #dataverse