Hello,
I am Cindy from Cameroon and I wish to participate in GSoC 2016 with Phpmyadmin to work on the mobile responsive version of the app.
I have forked and cloned the github repo and I am trying some operations and one caught my attention.
When I select a Database and type DESC <database.table_name> in the Console, I always get this error which says :
*Fatal error*: Call to a member function getClauses() on null in */Users/osiris/Desktop/phpmyadmin/libraries/sql-parser/src/Utils/Query.php* on line *549.*
*This appears after I ignore a dialog box that overplayed some other errors.*
*Here is an example error on the statement: DESC information_schema.FILES;*
*Output:*
) ./libraries/sql.lib.php#2168: PMA_getQueryResponseForResultsReturned( object, array, string 'information_schema', string '', NULL, NULL, object, string './themes/pmahomme/img/', integer 38, integer 38, NULL, NULL, NULL, NULL, NULL, string 'DESC FILES', NULL, ) ./import.php#795: PMA_executeQueryAndGetQueryResponse( array, boolean false, string 'information_schema', string '', NULL, string 'DESC FILES', NULL, NULL, NULL, NULL, string 'db_structure.php', string './themes/pmahomme/img/', NULL, NULL, NULL, string 'DESC FILES', NULL, NULL, ) *Notice* in ./libraries/sql.lib.php#1669 Undefined index: is_explain
*Backtrace*
./libraries/sql.lib.php#1966: PMA_getHtmlForSqlQueryResultsTable( object, string './themes/pmahomme/img/', NULL, array, boolean false, integer 38, integer 38, NULL, object, array, ) ./libraries/sql.lib.php#2168: PMA_getQueryResponseForResultsReturned( object, array, string 'information_schema', string '', NULL, NULL, object, string './themes/pmahomme/img/', integer 38, integer 38, NULL, NULL, NULL, NULL, NULL, string 'DESC FILES', NULL, ) ./import.php#795: PMA_executeQueryAndGetQueryResponse( array, boolean false, string 'information_schema', string '', NULL, string 'DESC FILES', NULL, NULL, NULL, NULL, string 'db_structure.php', string './themes/pmahomme/img/', NULL, NULL, NULL, string 'DESC FILES', NULL, NULL, ) *Notice* in ./libraries/sql.lib.php#1670 Undefined index: is_show
*Backtrace*
./libraries/sql.lib.php#1966: PMA_getHtmlForSqlQueryResultsTable( object, string './themes/pmahomme/img/', NULL, array, boolean false, integer 38, integer 38, NULL, object, array, ) ./libraries/sql.lib.php#2168: PMA_getQueryResponseForResultsReturned( object, array, string 'information_schema', string '', NULL, NULL, object, string './themes/pmahomme/img/', integer 38, integer 38, NULL, NULL, NULL, NULL, NULL, string 'DESC FILES', NULL, ) ./import.php#795: PMA_executeQueryAndGetQueryResponse( array, boolean false, string 'information_schema', string '', NULL, string 'DESC FILES', NULL, NULL, NULL, NULL, string 'db_structure.php', string './themes/pmahomme/img/', NULL, NULL, NULL, string 'DESC FILES', NULL, NULL, ) *Notice* in ./libraries/DisplayResults.php#4234 Undefined index: statement
*Backtrace*
./libraries/sql.lib.php#1683: PMA\libraries\DisplayResults->getTable( object, array, array, boolean false, ) ./libraries/sql.lib.php#1966: PMA_getHtmlForSqlQueryResultsTable( object, string './themes/pmahomme/img/', NULL, array, boolean false, integer 38, integer 38, NULL, object, array, ) ./libraries/sql.lib.php#2168: PMA_getQueryResponseForResultsReturned( object, array, string 'information_schema', string '', NULL, NULL, object, string './themes/pmahomme/img/', integer 38, integer 38, NULL, NULL, NULL, NULL, NULL, string 'DESC FILES', NULL, ) ./import.php#795: PMA_executeQueryAndGetQueryResponse( array, boolean false, string 'information_schema', string '', NULL, string 'DESC FILES', NULL, NULL, NULL, NULL, string 'db_structure.php', string './themes/pmahomme/img/', NULL, NULL, NULL, string 'DESC FILES', NULL, NULL, ) *Notice* in ./libraries/DisplayResults.php#4341 Undefined index: querytype
*Backtrace*
./libraries/sql.lib.php#1683: PMA\libraries\DisplayResults->getTable( object, array, array, boolean false, ) ./libraries/sql.lib.php#1966: PMA_getHtmlForSqlQueryResultsTable( object, string './themes/pmahomme/img/', NULL, array, boolean false, integer 38, integer 38, NULL, object, array, ) ./libraries/sql.lib.php#2168: PMA_getQueryResponseForResultsReturned( object, array, string 'information_schema', string '', NULL, NULL, object, string './themes/pmahomme/img/', integer 38, integer 38, NULL, NULL, NULL, NULL, NULL, string 'DESC FILES', NULL, ) ./import.php#795: PMA_executeQueryAndGetQueryResponse( array, boolean false, string 'information_schema', string '', NULL, string 'DESC FILES', NULL, NULL, NULL, NULL, string 'db_structure.php', string './themes/pmahomme/img/', NULL, NULL, NULL, string 'DESC FILES', NULL, NULL, ) *Notice* in ./libraries/DisplayResults.php#1375 Undefined index: statement
*Backtrace*
./libraries/DisplayResults.php#4362: PMA\libraries\DisplayResults->_getUnsortedSqlAndSortByKeyDropDown( array, string '', ) ./libraries/sql.lib.php#1683: PMA\libraries\DisplayResults->getTable( object, array, array, boolean false, ) ./libraries/sql.lib.php#1966: PMA_getHtmlForSqlQueryResultsTable( object, string './themes/pmahomme/img/', NULL, array, boolean false, integer 38, integer 38, NULL, object, array, ) ./libraries/sql.lib.php#2168: PMA_getQueryResponseForResultsReturned( object, array, string 'information_schema', string '', NULL, NULL, object, string './themes/pmahomme/img/', integer 38, integer 38, NULL, NULL, NULL, NULL, NULL, string 'DESC FILES', NULL, ) ./import.php#795: PMA_executeQueryAndGetQueryResponse( array, boolean false, string 'information_schema', string '', NULL, string 'DESC FILES', NULL, NULL, NULL, NULL, string 'db_structure.php', string './themes/pmahomme/img/', NULL, NULL, NULL, string 'DESC FILES', NULL, NULL, ) *Notice* in ./libraries/DisplayResults.php#1376 Undefined index: parser
*Backtrace*
./libraries/DisplayResults.php#4362: PMA\libraries\DisplayResults->_getUnsortedSqlAndSortByKeyDropDown( array, string '', ) ./libraries/sql.lib.php#1683: PMA\libraries\DisplayResults->getTable( object, array, array, boolean false, ) ./libraries/sql.lib.php#1966: PMA_getHtmlForSqlQueryResultsTable( object, string './themes/pmahomme/img/', NULL, array, boolean false, integer 38, integer 38, NULL, object, array, ) ./libraries/sql.lib.php#2168: PMA_getQueryResponseForResultsReturned( object, array, string 'information_schema', string '', NULL, NULL, object, string './themes/pmahomme/img/', integer 38, integer 38, NULL, NULL, NULL, NULL, NULL, string 'DESC FILES', NULL, ) ./import.php#795: PMA_executeQueryAndGetQueryResponse( array, boolean false, string 'information_schema', string '', NULL, string 'DESC FILES', NULL, NULL, NULL, NULL, string 'db_structure.php', string './themes/pmahomme/img/', NULL, NULL, NULL, string 'DESC FILES', NULL, NULL, ) *Notice* in ./libraries/DisplayResults.php#1376 Trying to get property of non-object
*Backtrace*
./libraries/DisplayResults.php#4362: PMA\libraries\DisplayResults->_getUnsortedSqlAndSortByKeyDropDown( array, string '', ) ./libraries/sql.lib.php#1683: PMA\libraries\DisplayResults->getTable( object, array, array, boolean false, ) ./libraries/sql.lib.php#1966: PMA_getHtmlForSqlQueryResultsTable( object, string './themes/pmahomme/img/', NULL, array, boolean false, integer 38, integer 38, NULL, object, array, ) ./libraries/sql.lib.php#2168: PMA_getQueryResponseForResultsReturned( object, array, string 'information_schema', string '', NULL, NULL, object, string './themes/pmahomme/img/', integer 38, integer 38, NULL, NULL, NULL, NULL, NULL, string 'DESC FILES', NULL, ) ./import.php#795: PMA_executeQueryAndGetQueryResponse( array, boolean false, string 'information_schema', string '', NULL, string 'DESC FILES', NULL, NULL, NULL, NULL, string 'db_structure.php', string './themes/pmahomme/img/', NULL, NULL, NULL, string 'DESC FILES', NULL, NULL,
Le 2016-01-17 08:37, Cynthia Tekwe a écrit :
Hello,
I am Cindy from Cameroon and I wish to participate in GSoC 2016 with Phpmyadmin to work on the mobile responsive version of the app.
I have forked and cloned the github repo and I am trying some operations and one caught my attention.
When I select a Database and type DESC <database.table_name> in the Console, I always get this error which says :
According to http://dev.mysql.com/doc/refman/5.7/en/describe.html I'm not sure that DESC is allowed as an abbreviation for DESCRIBE. I know that the mysql CLI accepts it but it does not mean that the syntax is correct.
Anyway I submitted https://github.com/phpmyadmin/phpmyadmin/issues/11867.
Thanks Marc, I will follow the issue on github.
On Sun, Jan 17, 2016 at 7:27 PM, Marc Delisle marc@infomarc.info wrote:
Le 2016-01-17 08:37, Cynthia Tekwe a écrit :
Hello,
I am Cindy from Cameroon and I wish to participate in GSoC 2016 with Phpmyadmin to work on the mobile responsive version of the app.
I have forked and cloned the github repo and I am trying some operations and one caught my attention.
When I select a Database and type DESC <database.table_name> in the Console, I always get this error which says :
According to http://dev.mysql.com/doc/refman/5.7/en/describe.html I'm not sure that DESC is allowed as an abbreviation for DESCRIBE. I know that the mysql CLI accepts it but it does not mean that the syntax is correct.
Anyway I submitted https://github.com/phpmyadmin/phpmyadmin/issues/11867.
-- Marc Delisle | phpMyAdmin
Developers mailing list Developers@phpmyadmin.net https://lists.phpmyadmin.net/mailman/listinfo/developers
-
Cynthia Tekwe -
Marc Delisle