[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14393286#comment-14393286
]
NCSU Service Desk commented on VCL-763:
---------------------------------------
Your support incident has been updated with the following comment:
2015-04-02 16:06:34 EDT - Guest (Additional comments)
reply from: [email protected]
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andy Kurth updated VCL-763:
---------------------------
Comment: was deleted
(was: Your support incident has been updated with the following comment:
2015-04-01 15:18:02 EDT - Guest (Additional comments)
reply from: [email protected]
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andy Kurth updated VCL-763:
---------------------------
Comment: was deleted
(was: This is an automated message from the NC State Service Desk.
Acknowledgement for: [1]INC2504067
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 "Call ID
Tracking Number". When contacting us, please refer to this number
(this is not a phone number).
If you do not hear from us soon and would like to check on the status
of your call, go to our on-line form on the World Wide Web at the
address:
http://help.ncsu.edu/myhelp.php
Enter your call's tracking number and click the "Lookup" button.
We will be getting back to you as soon as possible.
The NC State Help Desk is open for business from 7am-6pm, 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 might want to take a look at:
http://help.ncsu.edu/
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/services/get-soln.pl?id=849
Thanks!
Call Information:
Description Fwd: [jira] [Commented] (VCL-763) Add missing constraints to
database tables
Created 2015-04-01 09:43:10 EDT
Modified 2015-04-01 09:43:10 EDT
State New
Assignment Group ENGR_CSC_NETLABS
Customer Info Marhn Fullmer
[email protected] (mhfullme)
919-515-5343
Contact Type Email
Comments:
2015-04-01 09:43:10 EDT - Marhn Fullmer Additional comments
Forwarded by: [email protected]:
---------- Forwarded message ----------
From: ASF subversion and git services (JIRA) <[email protected]>
Date: Wed, Apr 1, 2015 at 9:22 AM
Subject: [jira] [Commented] (VCL-763) Add missing constraints to database
tables
To: [email protected]
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390531#comment-14390531
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1670641 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1670641 ]
VCL-763 - Add missing constraints to database tables
statistics.php: modified addToStatGraphCache: added code to set $affilid
and $provid to 'NULL' when they are passed in as 0 so that NULL is used in
the insert query instead of 0 to prevent a foreign key constraint error
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)
Links:[2]INC2504067This email was sent from a server at North Carolina State
UniversityRaleigh | NC | 27695
Ref:MSG0052941
----------------------------------------------------------------------------------------
[1]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
[2]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
2015-04-01 09:43:10 EDT - Marhn Fullmer (Additional comments)
Forwarded by: [email protected]:
---------- Forwarded message ----------
From: ASF subversion and git services (JIRA) <[email protected]>
Date: Wed, Apr 1, 2015 at 9:22 AM
Subject: [jira] [Commented] (VCL-763) Add missing constraints to database
tables
To: [email protected]
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390531#comment-14390531
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1670641 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1670641 ]
VCL-763 - Add missing constraints to database tables
statistics.php: modified addToStatGraphCache: added code to set $affilid
and $provid to 'NULL' when they are passed in as 0 so that NULL is used in
the insert query instead of 0 to prevent a foreign key constraint error
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)
Click here to view:
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
Ref:MSG0057852
)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
2015-04-01 15:18:02 EDT - Guest (Additional comments)
reply from: [email protected]
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andy Kurth updated VCL-763:
---------------------------
Comment: was deleted
(was: This is an automated message from the NC State Service Desk.
Acknowledgement for: [1]INC2504067
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 "Call ID
Tracking Number". When contacting us, please refer to this number
(this is not a phone number).
If you do not hear from us soon and would like to check on the status
of your call, go to our on-line form on the World Wide Web at the
address:
http://help.ncsu.edu/myhelp.php
Enter your call's tracking number and click the "Lookup" button.
We will be getting back to you as soon as possible.
The NC State Help Desk is open for business from 7am-6pm, 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 might want to take a look at:
http://help.ncsu.edu/
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/services/get-soln.pl?id=849
Thanks!
Call Information:
Description Fwd: [jira] [Commented] (VCL-763) Add missing constraints to
database tables
Created 2015-04-01 09:43:10 EDT
Modified 2015-04-01 09:43:10 EDT
State New
Assignment Group ENGR_CSC_NETLABS
Customer Info Marhn Fullmer
[email protected] (mhfullme)
919-515-5343
Contact Type Email
Comments:
2015-04-01 09:43:10 EDT - Marhn Fullmer Additional comments
Forwarded by: [email protected]:
---------- Forwarded message ----------
From: ASF subversion and git services (JIRA) <[email protected]>
Date: Wed, Apr 1, 2015 at 9:22 AM
Subject: [jira] [Commented] (VCL-763) Add missing constraints to database
tables
To: [email protected]
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390531#comment-14390531
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1670641 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1670641 ]
VCL-763 - Add missing constraints to database tables
statistics.php: modified addToStatGraphCache: added code to set $affilid
and $provid to 'NULL' when they are passed in as 0 so that NULL is used in
the insert query instead of 0 to prevent a foreign key constraint error
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)
Links:[2]INC2504067This email was sent from a server at North Carolina State
UniversityRaleigh | NC | 27695
Ref:MSG0052941
----------------------------------------------------------------------------------------
[1]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
[2]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
2015-04-01 09:43:10 EDT - Marhn Fullmer (Additional comments)
Forwarded by: [email protected]:
---------- Forwarded message ----------
From: ASF subversion and git services (JIRA) <[email protected]>
Date: Wed, Apr 1, 2015 at 9:22 AM
Subject: [jira] [Commented] (VCL-763) Add missing constraints to database
tables
To: [email protected]
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390531#comment-14390531
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1670641 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1670641 ]
VCL-763 - Add missing constraints to database tables
statistics.php: modified addToStatGraphCache: added code to set $affilid
and $provid to 'NULL' when they are passed in as 0 so that NULL is used in
the insert query instead of 0 to prevent a foreign key constraint error
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)
Click here to view:
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
Ref:MSG0066379
> 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)
