Page 1 of 1

PhpMyAdmin throws errors when displaying tables in new XAMPP

PostPosted: 02. February 2017 18:05
by TomXampp
In the new XAMPP 7.1.1 for Windows, running on Windows 8.1, I get the following error when I display all of the entries in a table in PhpMyAdmin (and there are only 115 rows, so it's not large). I'm not sure how to interpret this. How do I debug and fix this?

Code: Select all
Warning in .\libraries\DisplayResults.php#869
 A non-numeric value encountered

Backtrace

.\libraries\DisplayResults.php#4933: PMA\libraries\DisplayResults->_getTableNavigation(
integer 0,
integer 0,
boolean false,
string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="artsite_local" /><input type="hidden" name="table" value="artwork" /><input type="hidden" name="token" value="0022670479565d3ec32a72347e131966" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM `artwork` ORDER BY `id` ASC">PRIMARY (ASC)</option><option value="SELECT * FROM `artwork` ORDER BY `id` DESC">PRIMARY (DESC)</option><option value="SELECT * FROM `artwork` ORDER BY `year_completed` ASC">year_completed (ASC)</option><option value="SELECT * FROM `artwork` ORDER BY `year_completed` DESC">year_completed (DESC)</option><option value="SELECT * FROM `artwork` " selected="selected">None</option></select> </form> ',
)
.\libraries\DisplayResults.php#4378: PMA\libraries\DisplayResults->_getPlacedTableNavigations(
integer 0,
integer 0,
string 'top_direction_dropdown',
boolean false,
string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="artsite_local" /><input type="hidden" name="table" value="artwork" /><input type="hidden" name="token" value="0022670479565d3ec32a72347e131966" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM `artwork` ORDER BY `id` ASC">PRIMARY (ASC)</option><option value="SELECT * FROM `artwork` ORDER BY `id` DESC">PRIMARY (DESC)</option><option value="SELECT * FROM `artwork` ORDER BY `year_completed` ASC">year_completed (ASC)</option><option value="SELECT * FROM `artwork` ORDER BY `year_completed` DESC">year_completed (DESC)</option><option value="SELECT * FROM `artwork` " selected="selected">None</option></select> </form> ',
)
.\libraries\sql.lib.php#1685: PMA\libraries\DisplayResults->getTable(
,
array,
array,
boolean false,
)
.\libraries\sql.lib.php#1976: PMA_getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean true,
integer 116,
integer 116,
NULL,
,
array,
)
.\libraries\sql.lib.php#2199: PMA_getQueryResponseForResultsReturned(
,
array,
string 'artsite_local',
string 'artwork',
NULL,
NULL,
,
string './themes/pmahomme/img/',
integer 116,
integer 116,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'SELECT * FROM `artwork`',
NULL,
)
.\libraries\sql.lib.php#2061: PMA_executeQueryAndGetQueryResponse(
array,
boolean false,
string 'artsite_local',
string 'artwork',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'sql.php?db=artsite_local&amp;table=artwork&amp;sql_query=SELECT+%2A+FROM+%60artwork%60&amp;token=0022670479565d3ec32a72347e131966',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `artwork`',
NULL,
NULL,
)
.\sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean false,
string 'artsite_local',
string 'artwork',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'sql.php?db=artsite_local&amp;table=artwork&amp;sql_query=SELECT+%2A+FROM+%60artwork%60&amp;token=0022670479565d3ec32a72347e131966',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `artwork`',
NULL,
NULL,
)