[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14393143#comment-14393143
]
NCSU Service Desk commented on VCL-763:
---------------------------------------
This is an automated message from the NC State Service Desk.
Acknowledgement for: [1]INC2504895
The NC State Help Desk has received your message and logged it in our
automated tracking system. This is an automatic response. You will be
receiving a more personal response from us shortly.
Any further communication you have with us will automatically become
part of the log for this call. Please do not alter the Subject line
when replying via email since it contains the identifying "Incident Number".
When contacting us, please refer to this number.
If you do not hear from us soon and would like to check on the status
of your issue, go to our self-service portal:
https://ncsu.service-now.com/ess
Select the "Check Status" button.
We will be getting back to you as soon as possible.
The NC State Help Desk is open for business from 8am-5pm, Monday
through Friday, except during official University holidays.
For information on current and proposed system outages or changes,
you may want to visit Sysnews:
http://sysnews.ncsu.edu/
If you would prefer to search for solutions to your problem while you
await a response from us, you can search our knowledge base at the
self-service portal referenced above. Many of the most frequently asked
questions are answered there.
Please realize that the contact information we utilize to contact you
must be up to date to ensure a timely response to your query. Please
verify your contact information with the proper University department.
Information about maintaining your contact information can be found
at:
http://help.ncsu.edu/kb.php?id=REM-KB0000849
Thanks!
Call Information:
Description [jira] [Commented] (VCL-763) Add missing constraints to
database tables
Created 2015-04-02 14:40:30 EDT
Modified 2015-04-02 14:40:30 EDT
State New
Assignment Group OIT
Customer Info
()
Contact Type Email
Comments:
2015-04-02 14:40:30 EDT - Guest Additional comments
Received from: [email protected]:
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14393104#comment-14393104
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1670950 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1670950 ]
VCL-763 - Add missing constraints to database tables
blockallocations.php:
-modified AJtoggleBlockTime - if setting skip from 1 to 0 in database, also set
processed to 0 in case the blockTime had been processed already. Otherwise,
when skip is set to 0, if the block time had been prevously processed, it will
not get processed again (and what had been set up by the previous processing
would have been undone when skip was set to 1)
-modified processBlockAllocationInput: if $return['groupid'] == 0, set it to
'NULL' so when it is used for an insert or update, it will be NULL instead of 0
utils.php: modified checkClearImageMeta - added check for query that gets
existing imagemeta entry returning no rows - this can happen if the imagemeta
entry is due to subimages, and someone deletes the subimages and then updates
the image profile, in which case the deleting of the subimages will remove the
imagemeta entry, but the continuation for editing the image profile will still
have the imagemetaid
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Links:[2]INC2504895This email was sent from a server at North Carolina State
UniversityRaleigh | NC | 27695
Ref:MSG0065263
----------------------------------------------------------------------------------------
[1]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=47d364776f43f50045ebea6eae3ee411%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
[2]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=47d364776f43f50045ebea6eae3ee411%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
> Add missing constraints to database tables
> ------------------------------------------
>
> Key: VCL-763
> URL: https://issues.apache.org/jira/browse/VCL-763
> Project: VCL
> Issue Type: Improvement
> Components: database
> Affects Versions: 2.3.2
> Reporter: Andy Kurth
> Assignee: Andy Kurth
> Priority: Minor
> Fix For: 2.4
>
>
> There are some database columns which reference another table which are
> missing a constraint. One example is computer.vmhostid. It's handy to have
> the constraints defined.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
