{"action":"created","issue":{"url":"https://api.github.com/repos/matlads/mapcode-postgres/issues/1","repository_url":"https://api.github.com/repos/matlads/mapcode-postgres","labels_url":"https://api.github.com/repos/matlads/mapcode-postgres/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/matlads/mapcode-postgres/issues/1/comments","events_url":"https://api.github.com/repos/matlads/mapcode-postgres/issues/1/events","html_url":"https://github.com/matlads/mapcode-postgres/issues/1","id":126684081,"number":1,"title":"error while executing .sql","user":{"login":"vlasvlasvlas","id":4071796,"avatar_url":"https://avatars.githubusercontent.com/u/4071796?v=3","gravatar_id":"","url":"https://api.github.com/users/vlasvlasvlas","html_url":"https://github.com/vlasvlasvlas","followers_url":"https://api.github.com/users/vlasvlasvlas/followers","following_url":"https://api.github.com/users/vlasvlasvlas/following{/other_user}","gists_url":"https://api.github.com/users/vlasvlasvlas/gists{/gist_id}","starred_url":"https://api.github.com/users/vlasvlasvlas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vlasvlasvlas/subscriptions","organizations_url":"https://api.github.com/users/vlasvlasvlas/orgs","repos_url":"https://api.github.com/users/vlasvlasvlas/repos","events_url":"https://api.github.com/users/vlasvlasvlas/events{/privacy}","received_events_url":"https://api.github.com/users/vlasvlasvlas/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/matlads/mapcode-postgres/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"matlads","id":507861,"avatar_url":"https://avatars.githubusercontent.com/u/507861?v=3","gravatar_id":"","url":"https://api.github.com/users/matlads","html_url":"https://github.com/matlads","followers_url":"https://api.github.com/users/matlads/followers","following_url":"https://api.github.com/users/matlads/following{/other_user}","gists_url":"https://api.github.com/users/matlads/gists{/gist_id}","starred_url":"https://api.github.com/users/matlads/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matlads/subscriptions","organizations_url":"https://api.github.com/users/matlads/orgs","repos_url":"https://api.github.com/users/matlads/repos","events_url":"https://api.github.com/users/matlads/events{/privacy}","received_events_url":"https://api.github.com/users/matlads/received_events","type":"User","site_admin":false},"milestone":null,"comments":4,"created_at":"2016-01-14T15:57:21Z","updated_at":"2016-05-05T23:33:24Z","closed_at":null,"body":"Hi! im using postgres 8.4 + postgis 2.2\r\n\r\nhad no problems or errors on make make install and make installcheck \r\n\r\nbut after i try to execute the .sql file i get this:\r\n\r\n`\r\nuser@mysever:/home/myuser/mapcode$ psql -d regression -f /usr/share/postgresql/8.4/contrib/mapcode.sql\r\npsql:/usr/share/postgresql/8.4/contrib/mapcode.sql:3: LOG:  statement: CREATE OR REPLACE FUNCTION encodeLatLonToMapcodes(float8, float8, cstring) RETURNS text\r\n    AS 'mapcode', 'coord2mc_float_float_cstring'\r\n    LANGUAGE C STRICT;\r\npsql:/usr/share/postgresql/8.4/contrib/mapcode.sql:3: ERROR:  could not load library \"/usr/lib/postgresql/8.4/lib/mapcode.so\": /usr/lib/postgresql/8.4/lib/mapcode.so: undefined symbol: convertTerritoryIsoNameToCode\r\npsql:/usr/share/postgresql/8.4/contrib/mapcode.sql:7: LOG:  statement: CREATE OR REPLACE FUNCTION decodeMapcodeToLatLon(cstring, cstring) RETURNS text\r\n    AS 'mapcode', 'mc2coord_cstring_cstring'\r\n    LANGUAGE C STRICT;\r\npsql:/usr/share/postgresql/8.4/contrib/mapcode.sql:7: ERROR:  could not load library \"/usr/lib/postgresql/8.4/lib/mapcode.so\": /usr/lib/postgresql/8.4/lib/mapcode.so: undefined symbol: convertTerritoryIsoNameToCode\r\n`\r\n\r\n\r\nalso ldd on mapcode.so show this:\r\n\r\n`\r\nuser@myserver:/home/user/mapcode# ldd  /usr/lib/postgresql/8.4/lib/mapcode.so\r\n        linux-vdso.so.1 =>  (0x00007fff235ff000)\r\n        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fd2b5e1f000)\r\n        /lib64/ld-linux-x86-64.so.2 (0x00007fd2b641c000)\r\n`\r\n\r\nwhat should i do? thanks!\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/matlads/mapcode-postgres/issues/comments/217309671","html_url":"https://github.com/matlads/mapcode-postgres/issues/1#issuecomment-217309671","issue_url":"https://api.github.com/repos/matlads/mapcode-postgres/issues/1","id":217309671,"user":{"login":"matlads","id":507861,"avatar_url":"https://avatars.githubusercontent.com/u/507861?v=3","gravatar_id":"","url":"https://api.github.com/users/matlads","html_url":"https://github.com/matlads","followers_url":"https://api.github.com/users/matlads/followers","following_url":"https://api.github.com/users/matlads/following{/other_user}","gists_url":"https://api.github.com/users/matlads/gists{/gist_id}","starred_url":"https://api.github.com/users/matlads/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matlads/subscriptions","organizations_url":"https://api.github.com/users/matlads/orgs","repos_url":"https://api.github.com/users/matlads/repos","events_url":"https://api.github.com/users/matlads/events{/privacy}","received_events_url":"https://api.github.com/users/matlads/received_events","type":"User","site_admin":false},"created_at":"2016-05-05T23:33:24Z","updated_at":"2016-05-05T23:33:24Z","body":"@vlasvlasvlas did it work for you?"}}