{"action":"created","issue":{"url":"https://api.github.com/repos/e107inc/e107/issues/1260","labels_url":"https://api.github.com/repos/e107inc/e107/issues/1260/labels{/name}","comments_url":"https://api.github.com/repos/e107inc/e107/issues/1260/comments","events_url":"https://api.github.com/repos/e107inc/e107/issues/1260/events","html_url":"https://github.com/e107inc/e107/issues/1260","id":120406479,"number":1260,"title":"Support request: Issue with creating plugin tables","user":{"login":"lonalore","id":6043821,"avatar_url":"https://avatars.githubusercontent.com/u/6043821?v=3","gravatar_id":"","url":"https://api.github.com/users/lonalore","html_url":"https://github.com/lonalore","followers_url":"https://api.github.com/users/lonalore/followers","following_url":"https://api.github.com/users/lonalore/following{/other_user}","gists_url":"https://api.github.com/users/lonalore/gists{/gist_id}","starred_url":"https://api.github.com/users/lonalore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lonalore/subscriptions","organizations_url":"https://api.github.com/users/lonalore/orgs","repos_url":"https://api.github.com/users/lonalore/repos","events_url":"https://api.github.com/users/lonalore/events{/privacy}","received_events_url":"https://api.github.com/users/lonalore/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/e107inc/e107/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"CaMer0n","id":2825679,"avatar_url":"https://avatars.githubusercontent.com/u/2825679?v=3","gravatar_id":"","url":"https://api.github.com/users/CaMer0n","html_url":"https://github.com/CaMer0n","followers_url":"https://api.github.com/users/CaMer0n/followers","following_url":"https://api.github.com/users/CaMer0n/following{/other_user}","gists_url":"https://api.github.com/users/CaMer0n/gists{/gist_id}","starred_url":"https://api.github.com/users/CaMer0n/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CaMer0n/subscriptions","organizations_url":"https://api.github.com/users/CaMer0n/orgs","repos_url":"https://api.github.com/users/CaMer0n/repos","events_url":"https://api.github.com/users/CaMer0n/events{/privacy}","received_events_url":"https://api.github.com/users/CaMer0n/received_events","type":"User","site_admin":false},"milestone":null,"comments":8,"created_at":"2015-12-04T13:56:50Z","updated_at":"2015-12-05T16:32:39Z","closed_at":null,"body":"Hi,\r\n\r\nI would like to create three tables for my custom plugin, so I created MY_PLUGIN_sql.php file, and I pasted MySQL commands to it. \r\n\r\nTwo out of three have been created successfully, but one table not. Message:\r\n\r\n> Success\r\n> Settings successfully saved.\r\n> Adding Table: paypal_donation_amount\r\n> Adding Table: paypal_donation_ipn\r\n> Installation Complete.\r\n\r\nMy table structure: https://github.com/lonalore/paypal_donation/blob/master/paypal_donation_sql.php\r\n\r\nI spent hours trying to figure out what's wrong. :/\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/e107inc/e107/issues/comments/162218526","html_url":"https://github.com/e107inc/e107/issues/1260#issuecomment-162218526","issue_url":"https://api.github.com/repos/e107inc/e107/issues/1260","id":162218526,"user":{"login":"Moc","id":577978,"avatar_url":"https://avatars.githubusercontent.com/u/577978?v=3","gravatar_id":"","url":"https://api.github.com/users/Moc","html_url":"https://github.com/Moc","followers_url":"https://api.github.com/users/Moc/followers","following_url":"https://api.github.com/users/Moc/following{/other_user}","gists_url":"https://api.github.com/users/Moc/gists{/gist_id}","starred_url":"https://api.github.com/users/Moc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Moc/subscriptions","organizations_url":"https://api.github.com/users/Moc/orgs","repos_url":"https://api.github.com/users/Moc/repos","events_url":"https://api.github.com/users/Moc/events{/privacy}","received_events_url":"https://api.github.com/users/Moc/received_events","type":"User","site_admin":false},"created_at":"2015-12-05T16:32:39Z","updated_at":"2015-12-05T16:32:39Z","body":"I think the issue here is the colon sign (`:`) and not the syntax (NOT NULL) or the quotes. \r\n\r\n@tgtje In this case, the colon is used purely as a comment. Comments in MySQL are not that commonly used. The SQL parser in e107 has an issue with this colon sign, hence my question to Cameron asking if this is a bug. \r\n\r\n@willem010 The NOT NULL in SQL means that it cannot be left empty. It needs a value. Zero (0) is also a value, but not (always) equal to NULL. NULL is not necessarily 0. I know this may seem a little strange :) \r\n\r\n"}}