* Case Number: a20140627.2
  * Status: init
  * Claimant: Marcus M (as support team member)
  * Respondent: CAcert
  * initial Case Manager: EvaStöewe
  * Case Manager: name case manager
  * Arbitrator: name arbitrator
  * Date of arbitration start: 201Y-MM-DD
  * Date of ruling: 201Y-MM-DD
  * Case closed: 201Y-MM-DD
  * Complaint: discrepancies in account

  * Relief: TBD

Before: Arbitrator name arbitrator (A), Respondent: CAcert (R), Claimant: Marcus M (as support team member) (C), Case: a20140627.2


== History Log ==
 . 2014-06-27 (issue.c.o): case [s20140627.129 ]
 . 2014-07-06 (iCM): added to wiki, request for CM / A
 . 2014-07-06 (iCM): notification about case send to C
 . 2014-07-26 (iCM): repeated requst for CM / A

== Private Part ==
 * '''Link to Arbitration case [[Arbitrations/priv/a20140627.2|a20140627.2 (Private Part)]], Access for (CM) + (A) only'''

## ==> INCLUDE SECTION BOT
<<Include(Arbitrations/priv/a20140627.2)>>  
## <== INCLUDE SECTION EOT

==== EOT Private Part ====

== original Dispute ==

 {{{
Hi arbitrators,

we have the ticket [support ticket number] that shows the following problem in the
database a user was bale to grant 15 AP when he entered assurances into
the system on [date]. But recently he is only able to issue
10 AP.

Looking at the account data the following is visible:
Assurances received 10.php
[details about assurances]

Assurances received 15.php
[details about assurances]

The problem is related to the assurance entry with the ID [assurance id] that is
0 in the old calculation. What makes me stumbeling is date for when
which seems to be wrong. The value of the Assurance point in the 10.php
should be 10 points than everything would be fine.

After a short discussion with software I think it might be the best idea
to do a query on the assurances the user got and gave to have a view to
all data to see where the error come from.

Proposed query
SELECT `ID`, `From`, `To`, `Awarded`, `Points`, `Method`, `Date`,
`When`, `Expire`, `Sponsor`, `deleted` FROM  `notary` where `From` = X
or `To` = X
where X is the user account ID with [id] for [name], [email address].

May be there is also the need of the bin log files for the time frame
[date1] to [date2].
}}}

Parts in [] anonymised for privacy reasons.

== Discovery ==

== Ruling ==

== Execution ==

== Similiar Cases ==

----
 . CategoryArbitration
 . CategoryArbCaseAccountCleanup
 . CategoryArbCaseOtherAssurerErrors
 . CategoryArbCaseSystemTasks
 . CategoryArbCaseOthers