PhpMyAdmin: Unterschied zwischen den Versionen

Aus Doku-Wiki
Zur Navigation springenZur Suche springen
Zeile 10: Zeile 10:
 
  $cfg['Servers'][$i]['password']      = 'Geheim';    // MySQL password (only needed
 
  $cfg['Servers'][$i]['password']      = 'Geheim';    // MySQL password (only needed
  
 +
=Fehlerbehebung=
 +
==Fehler: ./libraries/sql.lib.php#601==
 +
* vi /usr/share/phpmyadmin/libraries/sql.lib.php
 +
'''search /PMA_isRememberSortingOrder or goto 601'''
 +
 +
* old
 +
600        && ((empty($analyzed_sql_results['select_expr']))
 +
601            || (count($analyzed_sql_results['select_expr'] == 1)
 +
602                && ($analyzed_sql_results['select_expr'][0] == '*')))
 +
603        && count($analyzed_sql_results['select_tables']) == 1;
 +
604 }
 +
*new
 +
600        && ((empty($analyzed_sql_results['select_expr']))
 +
601            || (count($analyzed_sql_results['select_expr']) == 1)
 +
602                && ($analyzed_sql_results['select_expr'][0] == '*'))
 +
603        && count($analyzed_sql_results['select_tables']) == 1;
 +
604 }
  
  
 
[[Kategorie:Anwendungen]]
 
[[Kategorie:Anwendungen]]

Version vom 17. Juli 2020, 10:17 Uhr

Installation und Konfiguration

Installation

Konfiguration

  • Für eine erste Funktion reicht es, folgende Angaben anzupassen:
vi /etc/phpmyadmin/config.inc.php
$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = 'Geheim';    // MySQL password (only needed

Fehlerbehebung

Fehler: ./libraries/sql.lib.php#601

  • vi /usr/share/phpmyadmin/libraries/sql.lib.php
search /PMA_isRememberSortingOrder or goto 601
  • old
600         && ((empty($analyzed_sql_results['select_expr']))
601             || (count($analyzed_sql_results['select_expr'] == 1)
602                 && ($analyzed_sql_results['select_expr'][0] == '*')))
603         && count($analyzed_sql_results['select_tables']) == 1;
604 }
  • new
600         && ((empty($analyzed_sql_results['select_expr']))
601             || (count($analyzed_sql_results['select_expr']) == 1)
602                 && ($analyzed_sql_results['select_expr'][0] == '*'))
603         && count($analyzed_sql_results['select_tables']) == 1;
604 }