RESOLVE PHPMYADMIN ERROR CODE : 500 INTERNAL SERVER ERROR


origrata@mrroot:~$ sudo nano -l /usr/share/phpmyadmin/libraries/sql.lib.php   


Cek pada Line 615 ubah yang berwarna merah sepserti dibawah ke warna biru di bawah
-------------------------------------------------------------------------------------------------------------
Sebelum

function PMA_isRememberSortingOrder($analyzed_sql_results)
{
    return $GLOBALS['cfg']['RememberSorting']
        && ! ($analyzed_sql_results['is_count']
            || $analyzed_sql_results['is_export']
            || $analyzed_sql_results['is_func']
            || $analyzed_sql_results['is_analyse'])
        && $analyzed_sql_results['select_from']
        && ((empty($analyzed_sql_results['select_expr']))
            || (count($analyzed_sql_results['select_expr'] == 1)
                && ($analyzed_sql_results['select_expr'][0] == '*')))
        && count($analyzed_sql_results['select_tables']) == 1;
}
========================================================================
Sesudah

function PMA_isRememberSortingOrder($analyzed_sql_results)
{
    return $GLOBALS['cfg']['RememberSorting']
        && ! ($analyzed_sql_results['is_count']
            || $analyzed_sql_results['is_export']
            || $analyzed_sql_results['is_func']
            || $analyzed_sql_results['is_analyse'])
        && $analyzed_sql_results['select_from']
        && ((empty($analyzed_sql_results['select_expr']))
            || (count($analyzed_sql_results['select_expr']) == 1
                && ($analyzed_sql_results['select_expr'][0] == '*')))
        && count($analyzed_sql_results['select_tables']) == 1;
}


setalah di ubah silahkan simpan dengan menekan CTRL + O  kemudian CTRL+M dan CTRL+ X untuk keluar

origrata@mrroot:~$ sudo service apache2 restart     ===> untuk merestart Apache2

Post a Comment

Lebih baru Lebih lama
Tempat Iklas Dinamis
Tempat Iklas Dinamis