From: "Aleksey E. Birukov" <birukov@vladinfo.ru>
To: Sisyphus@lists.altlinux.org
Subject: [sisyphus] mysql+phpmyadmin
Date: Thu, 9 Feb 2006 11:26:19 +0300
Message-ID: <200602091126.20187.birukov@vladinfo.ru> (raw)
После обновления mysql заметил ошибку, работая в phpmyadmin.
1. Нажимаем "Искать"
2. Набираем слово для поиска, жмем "Enter"
3. На странице результатов поиска жмем на "Обзор"
В результате получаем ошибку: "sql.php: Missing sql_query"
С чем это связано?
По совету майнтейнера выполнил:
[root@localhost phpMyAdmin]#
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql
--no-defaults --force --user=root --host=localhost --database=mysql -p
Enter password:
ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
@hadGrantPriv:=1
1
1
1
1
1
1
1
1
ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
ERROR 1060 (42S21) at line 70: Duplicate column name 'Routine_type'
ERROR 1054 (42S22) at line 94: Unknown column 'Type' in 'columns_priv'
ERROR 1060 (42S21) at line 100: Duplicate column name 'type'
@hadShowDbPriv:=1
1
1
1
1
1
1
1
1
ERROR 1060 (42S21) at line 110: Duplicate column name 'Show_db_priv'
ERROR 1060 (42S21) at line 127: Duplicate column name 'max_questions'
ERROR 1060 (42S21) at line 137: Duplicate column name 'Create_tmp_table_priv'
ERROR 1060 (42S21) at line 140: Duplicate column name 'Create_tmp_table_priv'
ERROR 1061 (42000) at line 145: Duplicate key name 'Grantor'
ERROR 1054 (42S22) at line 247: Unknown column 'Create_view_priv' in 'where
clause'
ERROR 1054 (42S22) at line 277: Unknown column 'Create_routine_priv' in 'where
clause'
ERROR 1054 (42S22) at line 313: Unknown column 'Create_user_priv' in 'where
clause'
--
$respect
next reply other threads:[~2006-02-09 8:26 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2006-02-09 8:26 Aleksey E. Birukov [this message]
2006-02-09 17:21 ` [sisyphus] mysql+phpmyadmin Konstantin A. Lepikhov
2006-02-11 21:59 ` Sasha Martsinuk
2006-02-22 22:25 ` [sisyphus] mysql+phpmyadmin --> for sale Michael Shigorin
2006-02-23 13:01 ` Nick S. Grechukh
2006-02-23 16:54 ` [sisyphus] phpMyAdmin --> orphaned Michael Shigorin
2006-02-23 17:03 ` Nick S. Grechukh
2006-02-23 19:17 ` [sisyphus] phpMyAdmin --> gns@ Michael Shigorin
2006-02-11 22:21 ` [sisyphus] mysql+phpmyadmin Ivan Adzhubey
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=200602091126.20187.birukov@vladinfo.ru \
--to=birukov@vladinfo.ru \
--cc=Sisyphus@lists.altlinux.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
ALT Linux Sisyphus discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \
sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru
public-inbox-index sisyphus
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.sisyphus
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git