Changes

Check Link Table Approval State NEW

1,061 bytes added, 15:36, 9 November 2016
Created page with "Each item that is updated should have one DEF that has ''approval_state'' = '''NEW'''. We have found few items in several database that does not have any row with ''approval_s..."
Each item that is updated should have one DEF that has ''approval_state'' = '''NEW'''. We have found few items in several database that does not have any row with ''approval_state'' = '''NEW'''.

[[Image:Link error.png|600px|center]]
<div align="center">
'' How it should look like''
</div>
The Action ''''Combine'''' and templates with more than one item are currently the main suspects.

{| class="wikitable"
|-
| [[Image:Link error1.png|600px|center]]
<div align="center">
'' Example where the first DEF has Combine instead of New''
</div>
| [[Image:Link error2.png|600px|center]]
<div align="center">
'' Example where the first DEF has Combine instead of New + the DEF template had 2 items''
</div>
|}

But does not happen every time Combine is used so Unapprove and deleting it may be involved. We have not seen this error created with 6.0.

==Case Combine==__NOEDITSECTION__
The solution is actually '''not''' to add rows to the table ''link'' but to update some columns of existing rows.


[[Category:SQL Queries]]
[[Category:NoPublic]]
{{NavBox Hub}}
6,632
edits