PhpMyAdmin throws errors when displaying tables in new XAMPP

Problems with the Windows version of XAMPP, questions, comments, and anything related.

PhpMyAdmin throws errors when displaying tables in new XAMPP

Postby TomXampp » 02. February 2017 18:05

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,
)
TomXampp
 
Posts: 59
Joined: 12. March 2015 03:58
Operating System: Windows 8.1

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 227 guests