{"action":"created","issue":{"url":"https://api.github.com/repos/nerzhul/ocsms/issues/75","labels_url":"https://api.github.com/repos/nerzhul/ocsms/issues/75/labels{/name}","comments_url":"https://api.github.com/repos/nerzhul/ocsms/issues/75/comments","events_url":"https://api.github.com/repos/nerzhul/ocsms/issues/75/events","html_url":"https://github.com/nerzhul/ocsms/issues/75","id":86047227,"number":75,"title":"Contacts not showed","user":{"login":"delumerlino","id":10596579,"avatar_url":"https://avatars.githubusercontent.com/u/10596579?v=3","gravatar_id":"","url":"https://api.github.com/users/delumerlino","html_url":"https://github.com/delumerlino","followers_url":"https://api.github.com/users/delumerlino/followers","following_url":"https://api.github.com/users/delumerlino/following{/other_user}","gists_url":"https://api.github.com/users/delumerlino/gists{/gist_id}","starred_url":"https://api.github.com/users/delumerlino/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/delumerlino/subscriptions","organizations_url":"https://api.github.com/users/delumerlino/orgs","repos_url":"https://api.github.com/users/delumerlino/repos","events_url":"https://api.github.com/users/delumerlino/events{/privacy}","received_events_url":"https://api.github.com/users/delumerlino/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-06-08T06:25:31Z","updated_at":"2015-06-09T06:58:21Z","closed_at":null,"body":"Hi, I am using ocsms for my sms.\r\nMy phone contacts are synced with native oc_contacts.\r\nI am not able to see my contacts in conversations list, but only their numbers.\r\nTY"},"comment":{"url":"https://api.github.com/repos/nerzhul/ocsms/issues/comments/110253299","html_url":"https://github.com/nerzhul/ocsms/issues/75#issuecomment-110253299","issue_url":"https://api.github.com/repos/nerzhul/ocsms/issues/75","id":110253299,"user":{"login":"delumerlino","id":10596579,"avatar_url":"https://avatars.githubusercontent.com/u/10596579?v=3","gravatar_id":"","url":"https://api.github.com/users/delumerlino","html_url":"https://github.com/delumerlino","followers_url":"https://api.github.com/users/delumerlino/followers","following_url":"https://api.github.com/users/delumerlino/following{/other_user}","gists_url":"https://api.github.com/users/delumerlino/gists{/gist_id}","starred_url":"https://api.github.com/users/delumerlino/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/delumerlino/subscriptions","organizations_url":"https://api.github.com/users/delumerlino/orgs","repos_url":"https://api.github.com/users/delumerlino/repos","events_url":"https://api.github.com/users/delumerlino/events{/privacy}","received_events_url":"https://api.github.com/users/delumerlino/received_events","type":"User","site_admin":false},"created_at":"2015-06-09T06:58:21Z","updated_at":"2015-06-09T06:58:21Z","body":"I have no errors in php / apache2.\nOC has the transaction error:\n\nException: {\"Message\":\"An exception occurred while executing 'DELETE FROM\noc_ocsms_smsdatas WHERE user_id = ? AND sms_id = ?' with params\n[\\\"Andrea\\\", 10347]:\\n\\nSQLSTATE[HY000]: General error: 1205 Lock wait\ntimeout exceeded; try restarting transaction\",\"Code\":0,\"Trace\":\"#0\n\\/var\\/www\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/DBALException.php(116):\nDoctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception\noc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1\n\\/var\\/www\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Statement.php(172):\nDoctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver),\nObject(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'DELETE FROM oc_...',\nArray)\\n#2\n\\/var\\/www\\/owncloud\\/lib\\/private\\/db\\/statementwrapper.php(54):\nDoctrine\\\\DBAL\\\\Statement->execute(Array)\\n#3\n\\/var\\/www\\/owncloud\\/apps\\/ocsms\\/db\\/smsmapper.php(266):\nOC_DB_StatementWrapper->execute(Array)\\n#4\n\\/var\\/www\\/owncloud\\/apps\\/ocsms\\/controller\\/apicontroller.php(103):\nOCA\\\\OcSms\\\\Db\\\\SmsMapper->writeToDB('Andrea', Array)\\n#5 [internal\nfunction]: OCA\\\\OcSms\\\\Controller\\\\ApiController->push(7564, Array)\\n#6\n\\/var\\/www\\/owncloud\\/lib\\/private\\/appframework\\/http\\/dispatcher.php(158):\ncall_user_func_array(Array, Array)\\n#7\n\\/var\\/www\\/owncloud\\/lib\\/private\\/appframework\\/http\\/dispatcher.php(86):\nOC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\OcSms\\\\Controller\\\\ApiController),\n'push')\\n#8 \\/var\\/www\\/owncloud\\/lib\\/private\\/appframework\\/app.php(97):\nOC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\OcSms\\\\Controller\\\\ApiController),\n'push')\\n#9\n\\/var\\/www\\/owncloud\\/lib\\/private\\/appframework\\/routing\\/routeactionhandler.php(44):\nOC\\\\AppFramework\\\\App::main('ApiController', 'push',\nObject(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#10\n[internal function]:\nOC\\\\AppFramework\\\\routing\\\\RouteActionHandler->__invoke(Array)\\n#11\n\\/var\\/www\\/owncloud\\/lib\\/private\\/route\\/router.php(250):\ncall_user_func(Object(OC\\\\AppFramework\\\\routing\\\\RouteActionHandler),\nArray)\\n#12 \\/var\\/www\\/owncloud\\/lib\\/base.php(782):\nOC\\\\Route\\\\Router->match('\\/apps\\/ocsms\\/pus...')\\n#13\n\\/var\\/www\\/owncloud\\/index.php(36): OC::handleRequest()\\n#14\n{main}\",\"File\":\"\\/var\\/www\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractMySQLDriver.php\",\"Line\":115}\n\nIs there a way to clean the installation (and deleting database tables and\nindexes) and start from scratch?\n\n2015-06-08 16:25 GMT+02:00 nerzhul <notifications@github.com>:\n\n> Can you check your PHP logs please ? Maybe there is a PHP error somewhere.\n> Please also look at your owncloud logs\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/nerzhul/ocsms/issues/75#issuecomment-110013185>.\n>\n\n\n\n-- \n--------------------------------------------------------------------------\n*P *Prima di stampare, pensa all'ambiente ** Think about the environment\n"}}