[Building Sakai] Problem when adding non-official participants
Brian Baillargeon
bbailla2 at uwo.ca
Wed Jul 3 08:03:52 PDT 2013
Oh, right this rings a bell! I'm running mysql locally which was fine,
but I had seen this issue when deploying to our dev server which is
running Oracle. I got it working by inserting a single space when null
was detected. Removing the constraint makes more sense to me though.
I've been submitting a few reset-pass/account-validator patches lately,
I think I'll test this out and submit it. You're essentially doing this,
right?
Index:
account-validator-api/src/java/org/sakaiproject/accountvalidator/model/ValidationAccount.hbm.xml
===================================================================
---
account-validator-api/src/java/org/sakaiproject/accountvalidator/model/ValidationAccount.hbm.xml
(revision 125984)
+++
account-validator-api/src/java/org/sakaiproject/accountvalidator/model/ValidationAccount.hbm.xml
(working copy)
@@ -21,8 +21,8 @@
<property name="validationReceived"
column="VALIDATION_RECEIVED" type="timestamp" />
<property name="validationsSent"
column="VALIDATIONS_SENT" type="integer" />
<property name="status" type="integer" column="STATUS" />
- <property name="firstName" column="FIRST_NAME"
type="string" length="255" not-null="true" />
- <property name="surname" column="SURNAME" type="string"
length="255" not-null="true" />
+ <property name="firstName" column="FIRST_NAME"
type="string" length="255" />
+ <property name="surname" column="SURNAME" type="string"
length="255" />
<property name="accountStatus" column="ACCOUNT_STATUS"
type="integer"/>
</class>
</hibernate-mapping>
On 13-07-03 10:13 AM, Curtis Van-Osch wrote:
> Thanks Brian,
>
> We're not using either of those jobs, nor have we set any new
> properties for account validation. I can't seem to find any
> documentation on them, and not much on the new properties (other than
> accountValidator.maxDays and accountValidator.maxResendAttempts)
>
> The tokens aren't inserted into the validationaccount_item table:
> I'm getting constraint violations, the FIRST_NAME column cannot be
> null (though a user account created through the "add participants"
> screen cannot yet have a first or last name...)
>
> I'm getting the same behaviour on http://qa5-us.sakaiproject.org/
>
> If I disable the two constraints, everything seems to work fine. I
> guess we will add that to our DB conversion scripts when we upgrade,
> unless someone can point out a good reason not to.
>
> <http://www.hec.ca>
>
> Curtis Van Osch
> Analyste-Programmeur
> Direction des technologies de l'information
> hec.ca <http://www.hec.ca>
> Agréments
> 3000, chemin de la Côte-Sainte-Catherine, Montréal (Québec) H3T 2A7
> Téléphone : 514 340-6000, poste 2029
>
>
> recyclez
> Pensons à l'environnement
> avant d'imprimer
>
>
> -------- Message original --------
> Sujet: Re: [Building Sakai] Problem when adding non-official participants
> De : Brian Baillargeon <bbailla2 at uwo.ca>
> Pour : Curtis Van-Osch <curtis.van-osch at hec.ca>
> Copie à : sakai-dev Developers <sakai-dev at collab.sakaiproject.org>,
> zonecours2 <zonecours2 at hec.ca>, tcollins at uwindsor.ca
> Date : 2013-06-27 11:54
>> We're on 2.9.1 and we don't have this issue (we have customizations,
>> but I don't recall ever experiencing this bug during development
>> either). I've been working with trunk as well and haven't experienced
>> this problem.
>>
>> Are you using the CheckAccountsJob or CheckValidations jobs?
>> What are your account-validation relevant sakai.properties?
>> Can you see the tokens in the validationaccount_item table?
>>
>> On 13-06-26 02:33 PM, Curtis Van-Osch wrote:
>>> Hi,
>>> We're preparing to deploy our upgrade to Sakai 2.9.1, but are
>>> experiencing a bug with adding non-official participants where the
>>> validation code is never valid (the url in the email doesn't work -
>>> see SAK-23409 <https://jira.sakaiproject.org/browse/SAK-23409>).
>>> Just wondering if anyone has resolved this issue anywhere else, as
>>> this functionality is used quite a bit here so this is a potential
>>> blocker for us.
>>>
>>> --
>>> <http://www.hec.ca>
>>>
>>> Curtis Van Osch
>>> Analyste-Programmeur
>>> Direction des technologies de l'information
>>> hec.ca <http://www.hec.ca>
>>> Agréments
>>> 3000, chemin de la Côte-Sainte-Catherine, Montréal (Québec) H3T 2A7
>>> Téléphone : 514 340-6000, poste 2029
>>>
>>>
>>> recyclez
>>> Pensons à l'environnement
>>> avant d'imprimer
>>>
>>>
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email tosakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 4883 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 345 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment-0001.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 5127 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment-0002.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 20493 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment.jpe
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 4883 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment-0003.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 345 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment-0004.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 5127 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment-0005.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 20493 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130703/1352f9c2/attachment-0001.jpe
More information about the sakai-dev
mailing list