{"action":"closed","issue":{"url":"https://api.github.com/repos/fisharebest/webtrees/issues/672","labels_url":"https://api.github.com/repos/fisharebest/webtrees/issues/672/labels{/name}","comments_url":"https://api.github.com/repos/fisharebest/webtrees/issues/672/comments","events_url":"https://api.github.com/repos/fisharebest/webtrees/issues/672/events","html_url":"https://github.com/fisharebest/webtrees/issues/672","id":99568163,"number":672,"title":"SQL error when accessing preferred individual (#1)","user":{"login":"torefahlstrom","id":13642367,"avatar_url":"https://avatars.githubusercontent.com/u/13642367?v=3","gravatar_id":"","url":"https://api.github.com/users/torefahlstrom","html_url":"https://github.com/torefahlstrom","followers_url":"https://api.github.com/users/torefahlstrom/followers","following_url":"https://api.github.com/users/torefahlstrom/following{/other_user}","gists_url":"https://api.github.com/users/torefahlstrom/gists{/gist_id}","starred_url":"https://api.github.com/users/torefahlstrom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/torefahlstrom/subscriptions","organizations_url":"https://api.github.com/users/torefahlstrom/orgs","repos_url":"https://api.github.com/users/torefahlstrom/repos","events_url":"https://api.github.com/users/torefahlstrom/events{/privacy}","received_events_url":"https://api.github.com/users/torefahlstrom/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-08-07T03:10:20Z","updated_at":"2015-08-10T17:40:42Z","closed_at":"2015-08-10T17:40:42Z","body":"Created a tree and inserted records from a .ged-file. After that, added and updated records manually. At some point in time, i tried to access the preferred individual (me, record nr 1) and got the following error:\r\n\r\n#0 /app/Statement.php:82 PDOException(\"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''223')' at line 1\")\r\n#1 /app/Individual.php:64 execute()\r\n#2 /app/Family.php:45 load()\r\n#3 /app/GedcomRecord.php:205 __construct()\r\n#4 /app/Fact.php:97 getInstance()\r\n#5 /app/Controller/GedcomRecordController.php:48 getTarget()\r\n#6 /app/Controller/IndividualController.php:61 __construct()\r\n#7 /individual.php:31 __construct()\r\n\r\nI am running webtrees 1.7.1. and php 5.5.x. I have been using older versions of webtrees (1.6.2) without seeing this type of error before.\r\n\r\n"}}