{"action":"created","issue":{"url":"https://api.github.com/repos/ant-vel/antVel/issues/71","repository_url":"https://api.github.com/repos/ant-vel/antVel","labels_url":"https://api.github.com/repos/ant-vel/antVel/issues/71/labels{/name}","comments_url":"https://api.github.com/repos/ant-vel/antVel/issues/71/comments","events_url":"https://api.github.com/repos/ant-vel/antVel/issues/71/events","html_url":"https://github.com/ant-vel/antVel/issues/71","id":141952820,"number":71,"title":"Errors in MySQL tables: products, product_details and users (3 tables)","user":{"login":"protodevsystems","id":16254005,"avatar_url":"https://avatars.githubusercontent.com/u/16254005?v=3","gravatar_id":"","url":"https://api.github.com/users/protodevsystems","html_url":"https://github.com/protodevsystems","followers_url":"https://api.github.com/users/protodevsystems/followers","following_url":"https://api.github.com/users/protodevsystems/following{/other_user}","gists_url":"https://api.github.com/users/protodevsystems/gists{/gist_id}","starred_url":"https://api.github.com/users/protodevsystems/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/protodevsystems/subscriptions","organizations_url":"https://api.github.com/users/protodevsystems/orgs","repos_url":"https://api.github.com/users/protodevsystems/repos","events_url":"https://api.github.com/users/protodevsystems/events{/privacy}","received_events_url":"https://api.github.com/users/protodevsystems/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-18T19:06:14Z","updated_at":"2016-03-18T19:35:49Z","closed_at":null,"body":"Is this a migration issue?\r\n\r\nIn phpMyAdmin, upon clicking the said tables, an error appears (all other tables seem to load fine) except for these 3:\r\n\r\n> Some errors have been detected on the server! Please look at the bottom of this window.\r\n\r\n[Ignore All]     [Ignore]\r\n\r\n\r\nThis is the output when [users] table has been clicked: (but it shows the records at the top) this is found at the bottom===>\r\n\r\n`Notice in ./libraries/dbi/DBIMysqli.class.php#522\r\n Undefined offset: 245\r\n\r\nBacktrace\r\n\r\n./libraries/DatabaseInterface.class.php#2971: PMA_DBI_Mysqli->getFieldsMeta(object)\r\n./libraries/sql.lib.php#1777: PMA_DatabaseInterface->getFieldsMeta(object)\r\n./libraries/sql.lib.php#2107: PMA_getQueryResponseForResultsReturned(\r\nobject,\r\narray,\r\nstring 'homestead',\r\nstring 'users',\r\nNULL,\r\nNULL,\r\nobject,\r\nstring './themes/pmahomme/img/',\r\nstring '28',\r\ninteger 25,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring 'SELECT * FROM `users`',\r\nNULL,\r\n)\r\n./libraries/sql.lib.php#1966: PMA_executeQueryAndGetQueryResponse(\r\narray,\r\nboolean true,\r\nstring 'homestead',\r\nstring 'users',\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring '',\r\nstring './themes/pmahomme/img/',\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring 'SELECT * FROM `users`',\r\nNULL,\r\nNULL,\r\n)\r\n./sql.php#216: PMA_executeQueryAndSendQueryResponse(\r\narray,\r\nboolean true,\r\nstring 'homestead',\r\nstring 'users',\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring '',\r\nstring './themes/pmahomme/img/',\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring 'SELECT * FROM `users`',\r\nNULL,\r\nNULL,\r\n)\r\nNotice in ./libraries/dbi/DBIMysqli.class.php#522\r\n Undefined offset: 245\r\n\r\nBacktrace\r\n\r\n./libraries/DatabaseInterface.class.php#2971: PMA_DBI_Mysqli->getFieldsMeta(object)\r\n./libraries/sql.lib.php#1596: PMA_DatabaseInterface->getFieldsMeta(object)\r\n./libraries/sql.lib.php#1897: PMA_getHtmlForSqlQueryResultsTable(\r\nobject,\r\nstring './themes/pmahomme/img/',\r\nNULL,\r\narray,\r\nboolean true,\r\nstring '28',\r\ninteger 25,\r\nNULL,\r\nobject,\r\narray,\r\n)\r\n./libraries/sql.lib.php#2107: PMA_getQueryResponseForResultsReturned(\r\nobject,\r\narray,\r\nstring 'homestead',\r\nstring 'users',\r\nNULL,\r\nNULL,\r\nobject,\r\nstring './themes/pmahomme/img/',\r\nstring '28',\r\ninteger 25,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring 'SELECT * FROM `users`',\r\nNULL,\r\n)\r\n./libraries/sql.lib.php#1966: PMA_executeQueryAndGetQueryResponse(\r\narray,\r\nboolean true,\r\nstring 'homestead',\r\nstring 'users',\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring '',\r\nstring './themes/pmahomme/img/',\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring 'SELECT * FROM `users`',\r\nNULL,\r\nNULL,\r\n)\r\n./sql.php#216: PMA_executeQueryAndSendQueryResponse(\r\narray,\r\nboolean true,\r\nstring 'homestead',\r\nstring 'users',\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring '',\r\nstring './themes/pmahomme/img/',\r\nNULL,\r\nNULL,\r\nNULL,\r\nstring 'SELECT * FROM `users`',\r\nNULL,\r\nNULL,\r\n)`"},"comment":{"url":"https://api.github.com/repos/ant-vel/antVel/issues/comments/198512921","html_url":"https://github.com/ant-vel/antVel/issues/71#issuecomment-198512921","issue_url":"https://api.github.com/repos/ant-vel/antVel/issues/71","id":198512921,"user":{"login":"protodevsystems","id":16254005,"avatar_url":"https://avatars.githubusercontent.com/u/16254005?v=3","gravatar_id":"","url":"https://api.github.com/users/protodevsystems","html_url":"https://github.com/protodevsystems","followers_url":"https://api.github.com/users/protodevsystems/followers","following_url":"https://api.github.com/users/protodevsystems/following{/other_user}","gists_url":"https://api.github.com/users/protodevsystems/gists{/gist_id}","starred_url":"https://api.github.com/users/protodevsystems/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/protodevsystems/subscriptions","organizations_url":"https://api.github.com/users/protodevsystems/orgs","repos_url":"https://api.github.com/users/protodevsystems/repos","events_url":"https://api.github.com/users/protodevsystems/events{/privacy}","received_events_url":"https://api.github.com/users/protodevsystems/received_events","type":"User","site_admin":false},"created_at":"2016-03-18T19:35:49Z","updated_at":"2016-03-18T19:35:49Z","body":"yep, homestead.\r\n\r\nhere's the screenshot:\r\n![image](https://cloud.githubusercontent.com/assets/16254005/13889828/99c33ed4-ed83-11e5-8a89-0260c1a53c7b.png)\r\n"}}