{"action":"created","issue":{"url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3301","repository_url":"https://api.github.com/repos/SimpleMachines/SMF2.1","labels_url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3301/labels{/name}","comments_url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3301/comments","events_url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3301/events","html_url":"https://github.com/SimpleMachines/SMF2.1/issues/3301","id":137324673,"number":3301,"title":"Undefined variable: ip_array","user":{"login":"lurkalot","id":6047983,"avatar_url":"https://avatars.githubusercontent.com/u/6047983?v=3","gravatar_id":"","url":"https://api.github.com/users/lurkalot","html_url":"https://github.com/lurkalot","followers_url":"https://api.github.com/users/lurkalot/followers","following_url":"https://api.github.com/users/lurkalot/following{/other_user}","gists_url":"https://api.github.com/users/lurkalot/gists{/gist_id}","starred_url":"https://api.github.com/users/lurkalot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lurkalot/subscriptions","organizations_url":"https://api.github.com/users/lurkalot/orgs","repos_url":"https://api.github.com/users/lurkalot/repos","events_url":"https://api.github.com/users/lurkalot/events{/privacy}","received_events_url":"https://api.github.com/users/lurkalot/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-02-29T17:55:19Z","updated_at":"2016-03-02T20:10:46Z","closed_at":"2016-03-01T04:44:13Z","body":"Not sure if this is a bug of not, or if it's been reported and fixed, thought I'd mention it anyway.\r\n\r\nI went to Admin > Forum > Search Engines.  \r\n\r\nSet Search Engine Tracking Level = Standard\r\nSet Apply restrictive permissions from group = Disabled\r\nSet Show spiders in the online list = Show Spider Names\r\n\r\nWithin a few minutes I got two errors in the log, (now have nineteen errors all the same type).\r\n\r\nGuest\r\nToday at 08:41 PM\r\na1deccd17653562588e401be2c4d795c\r\nType of error: Undefined\r\n8: Undefined variable: ip_array \r\nhttp://cctestsite.info/testsite3/index.php?topic=2.0 \r\nFile: /homex/xxxxxx/xxxxxx/cctestsite.info/testsite3/Sources/Subs.php\r\nLine: 3510\r\n\r\nGuest\r\nToday at 08:34 PM\r\n1e6daff224f2312def4eeddf6378df85\r\nType of error: Undefined\r\n8: Undefined variable: ip_array \r\nhttp://cctestsite.info/testsite3/index.php? \r\nFile: /homex/xxxxxxx/xxxxxxx/cctestsite.info/testsite3/Sources/Subs.php\r\nLine: 3510 \r\n\r\nI also noticed in the users online page a IP address from the guest as 0.0.0.0\r\n![whosol](https://cloud.githubusercontent.com/assets/6047983/13404352/235d9116-df11-11e5-9be7-0a18491ab952.jpg)"},"comment":{"url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/comments/191405679","html_url":"https://github.com/SimpleMachines/SMF2.1/issues/3301#issuecomment-191405679","issue_url":"https://api.github.com/repos/SimpleMachines/SMF2.1/issues/3301","id":191405679,"user":{"login":"MissAllSunday","id":3420756,"avatar_url":"https://avatars.githubusercontent.com/u/3420756?v=3","gravatar_id":"","url":"https://api.github.com/users/MissAllSunday","html_url":"https://github.com/MissAllSunday","followers_url":"https://api.github.com/users/MissAllSunday/followers","following_url":"https://api.github.com/users/MissAllSunday/following{/other_user}","gists_url":"https://api.github.com/users/MissAllSunday/gists{/gist_id}","starred_url":"https://api.github.com/users/MissAllSunday/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MissAllSunday/subscriptions","organizations_url":"https://api.github.com/users/MissAllSunday/orgs","repos_url":"https://api.github.com/users/MissAllSunday/repos","events_url":"https://api.github.com/users/MissAllSunday/events{/privacy}","received_events_url":"https://api.github.com/users/MissAllSunday/received_events","type":"User","site_admin":false},"created_at":"2016-03-02T20:10:46Z","updated_at":"2016-03-02T20:10:46Z","body":"I'm getting the following error:\r\n```\r\nDatabase Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '208.115.113.92' LIKE bi.hostname) OR '????' BETWEEN bi.ip_low and bi.ip_high)' at line 6\r\n\r\n\r\nSELECT bi.id_ban, bi.email_address, bi.id_member, bg.cannot_access, bg.cannot_register,\r\nbg.cannot_post, bg.cannot_login, bg.reason, COALESCE(bg.expire_time, 0) AS expire_time\r\nFROM smf_ban_items AS bi\r\nINNER JOIN suki_ban_groups AS bg ON (bg.id_ban_group = bi.id_ban_group AND (bg.expire_time IS NULL OR bg.expire_time > 1456946594))\r\nWHERE\r\n('\r\n\r\n```\r\n\r\n\r\nIts related to constructqueryban()"}}