トピックモデルの表を開くとMySQLのエラーが発生 #1344
Answered
by
ko-ichi-h
tai0212
asked this question in
1.1 Errors and Problems (in Japanese)
-
お使いのKH Coderのバージョン3.02d macOS エラー・不具合について詳しくお書きください■お使いのOS ■KH Coderのインストール先フォルダ（解凍先フォルダ） ■どんなエラー・不具合・問題ですか？ ■スクリーンショット ■どのように操作すればその問題を再現できますか？ メニューから「ツール」「文書」「トピックモデル」「トピック推定」「ok」「表」を順にクリック ■エラー・メッセージ ■その問題はチュートリアルの漱石「こころ」データでも同様に発生しましたか？ ■その問題を再現できるファイル（群） ■分析しようとしているのは何語のテキストですか？ ■分析対象として指定しているファイルの形式は何ですか？ ■お使いのセキュリティ対策／ウイルス対策ソフトウェア ■お使いのCPU コンソール・ウィンドウの表示内容（Macではターミナルの表示内容）を貼り付けてくださいLast login: Wed Jul 9 10:28:24 on ttys000
casper@tais-macbook-air ~ % mysql --version
zsh: command not found: mysql
casper@tais-macbook-air ~ % bash -c ' cd "/Applications/khcoder3/";export LANG_BAK=$LANG;export TMPDIR="/Applications/khcoder3/config";export LANG=ja_JP.UTF-8;export LC_ALL=ja_JP.UTF-8;export XMODIFIERS="@im=uim";export GTK_IM_MODULE=uim;export DYLD_FALLBACK_LIBRARY_PATH="/Applications/khcoder3/deps/mysql-5.6.17/lib"; ./x_mac64'
Encoding of this Console: UTF-8
Encoding of this file system: UTF-8
Perl/Tk: 804.032
Locale: ja_JP.UTF-8
This is KH Coder 3.02d macOS on darwin.
CWD: /Applications/khcoder3
Private dir: /Applications/khcoder3/config
Executing Mac OS X 64-bit Package
Checking MySQL connection...
starting R: "/Applications/khcoder3/deps/R-3.1.0/Resources/bin/R" --slave --vanilla
ram_r 16384
R Version: 3.1, x86_64
Using un-threaded functions...
Connected to MySQL 5.6, khc24.
MySQL integrity check: pass, /Applications/khcoder3/deps/mysql-5.6.17
Trying out a different dialog method for darwin...
ignore: 12,13,
............
1 wallclock secs ( 0.20 usr + 0.01 sys = 0.21 CPU)
Data matrix for R: 73 words x 6093 (6093) docs
Statistics::R::Bridge::pipe::read_processR, Sleep and Retry!
Warning: package ‘topicmodels’ was built under R version 3.1.3
Statistics::R::Bridge::pipe::read_processR, Retry:
done: 00:00:09
Checking icode (jp2)... utf8
MySQL: FLUSH
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /</Applications/khcoder3/x_mac64>mysql_exec.pm line 445.
SQL Input:
SELECT val, lab
FROM outvar_lab
WHERE var_id =
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
SQL Caller: /</Applications/khcoder3/x_mac64>mysql_outvar/a_var.pm line 42
Trying out a different dialog method for darwin...
Exit (gui_errormsg.pm)
win.ini changed:
34c34
< w_topic_fitting 586x431+248+110
---
> w_topic_fitting 586x431+932+93
saving win.ini, tmp file: /Applications/khcoder3/config/win.ini.j0onC
sh: line 1: 14123 Killed: 9 "/Applications/khcoder3/deps/R-3.1.0/Resources/bin/R" --slave --vanilla < start.r > output.log
casper@tais-macbook-air ~ % bash -c ' cd "/Applications/khcoder3/";export LANG_BAK=$LANG;export TMPDIR="/Applications/khcoder3/config";export LANG=ja_JP.UTF-8;export LC_ALL=ja_JP.UTF-8;export XMODIFIERS="@im=uim";export GTK_IM_MODULE=uim;export DYLD_FALLBACK_LIBRARY_PATH="/Applications/khcoder3/deps/mysql-5.6.17/lib"; ./x_mac64'
Encoding of this Console: UTF-8
Encoding of this file system: UTF-8
Perl/Tk: 804.032
Locale: ja_JP.UTF-8
This is KH Coder 3.02d macOS on darwin.
CWD: /Applications/khcoder3
Private dir: /Applications/khcoder3/config
Executing Mac OS X 64-bit Package
Checking MySQL connection...
Starting MySQL...
2025-07-09 10:48:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-07-09 10:48:04 14187 [Warning] Setting lower_case_table_names=2 because file system for /Applications/khcoder3/deps/mysql-5.6.17/data/ is case insensitive
2025-07-09 10:48:04 14187 [Note] Plugin 'FEDERATED' is disabled.
2025-07-09 10:48:04 14187 [Warning] Using unique option prefix innodb-locks instead of innodb-locks-unsafe-for-binlog is deprecated and will be removed in a future release. Please use the full name instead.
2025-07-09 10:48:04 14187 [Warning] Using unique option prefix innodb-cmp instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2025-07-09 10:48:04 14187 [Note] Plugin 'InnoDB' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_TRX' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_CMPMEM' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_METRICS' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2025-07-09 10:48:04 14187 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2025-07-09 10:48:04 14187 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2025-07-09 10:48:04 14187 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2025-07-09 10:48:04 14187 [Note] Event Scheduler: Loaded 0 events
2025-07-09 10:48:04 14187 [Note] /Applications/khcoder3/deps/mysql-5.6.17/bin/mysqld: ready for connections.
Version: '5.6.17' socket: '/tmp/mysql.sock.khc3' port: 0 MySQL Community Server (GPL)
starting R: "/Applications/khcoder3/deps/R-3.1.0/Resources/bin/R" --slave --vanilla
ram_r 16384
R Version: 3.1, x86_64
Using un-threaded functions...
Connected to MySQL 5.6, khc24.
MySQL integrity check: pass, /Applications/khcoder3/deps/mysql-5.6.17
Trying out a different dialog method for darwin...
ignore: 12,13,
............
1 wallclock secs ( 0.15 usr + 0.00 sys = 0.15 CPU)
Data matrix for R: 74 words x 400 (400) docs
Warning: package ‘topicmodels’ was built under R version 3.1.3
done: 00:00:08
Checking icode (jp2)... utf8
MySQL: FLUSH
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /</Applications/khcoder3/x_mac64>mysql_exec.pm line 445.
SQL Input:
SELECT val, lab
FROM outvar_lab
WHERE var_id =
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
SQL Caller: /</Applications/khcoder3/x_mac64>mysql_outvar/a_var.pm line 42
Trying out a different dialog method for darwin...
Exit (gui_errormsg.pm)
win.ini changed:
34c34
< w_topic_fitting 586x431+932+93
---
> w_topic_fitting 586x431+325+93
saving win.ini, tmp file: /Applications/khcoder3/config/win.ini.R1qYp
2025-07-09 10:48:47 14187 [Note] /Applications/khcoder3/deps/mysql-5.6.17/bin/mysqld: Normal shutdown
2025-07-09 10:48:47 14187 [Note] Giving 1 client threads a chance to die gracefully
2025-07-09 10:48:47 14187 [Note] Event Scheduler: Purging the queue. 0 events
2025-07-09 10:48:47 14187 [Note] Shutting down slave threads
sh: line 1: 14192 Killed: 9 "/Applications/khcoder3/deps/R-3.1.0/Resources/bin/R" --slave --vanilla < start.r > output.log
casper@tais-macbook-air ~ % 2025-07-09 10:48:49 14187 [Note] Forcefully disconnecting 0 remaining clients
2025-07-09 10:48:49 14187 [Note] Binlog end
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'partition'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'INNODB_CMP'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'INNODB_LOCKS'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'BLACKHOLE'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'ARCHIVE'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'MRG_MYISAM'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'MyISAM'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'MEMORY'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'CSV'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'sha256_password'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'mysql_old_password'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'mysql_native_password'
2025-07-09 10:48:49 14187 [Note] Shutting down plugin 'binlog'
2025-07-09 10:48:49 14187 [Note] /Applications/khcoder3/deps/mysql-5.6.17/bin/mysqld: Shutdown complete
AK=$LANG;export TMPDIR="/Applications/khcoder3/config";export LANG=ja_JP.UTF-8;export LC_ALL=ja_JP.UTF-8;export XMODIFIERS="@im=uim";export GTK_IM_MODULE=uim;export DYLD_FALLBACK_LIBRARY_PATH="/Applications/khcoder3/deps/mysql-5.6.17/lib"; ./x_mac64'
Encoding of this Console: UTF-8
Encoding of this file system: UTF-8
Perl/Tk: 804.032
Locale: ja_JP.UTF-8
This is KH Coder 3.02d macOS on darwin.
CWD: /Applications/khcoder3
Private dir: /Applications/khcoder3/config
Executing Mac OS X 64-bit Package
Checking MySQL connection...
Starting MySQL...
2025-07-09 19:14:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-07-09 19:14:05 16219 [Warning] Setting lower_case_table_names=2 because file system for /Applications/khcoder3/deps/mysql-5.6.17/data/ is case insensitive
2025-07-09 19:14:06 16219 [Note] Plugin 'FEDERATED' is disabled.
2025-07-09 19:14:06 16219 [Warning] Using unique option prefix innodb-locks instead of innodb-locks-unsafe-for-binlog is deprecated and will be removed in a future release. Please use the full name instead.
2025-07-09 19:14:06 16219 [Warning] Using unique option prefix innodb-cmp instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2025-07-09 19:14:06 16219 [Note] Plugin 'InnoDB' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_TRX' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_CMPMEM' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_METRICS' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2025-07-09 19:14:06 16219 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2025-07-09 19:14:06 16219 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2025-07-09 19:14:06 16219 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2025-07-09 19:14:06 16219 [Note] Event Scheduler: Loaded 0 events
2025-07-09 19:14:06 16219 [Note] /Applications/khcoder3/deps/mysql-5.6.17/bin/mysqld: ready for connections.
Version: '5.6.17' socket: '/tmp/mysql.sock.khc3' port: 0 MySQL Community Server (GPL)
starting R: "/Applications/khcoder3/deps/R-3.1.0/Resources/bin/R" --slave --vanilla
ram_r 16384
R Version: 3.1, x86_64
Using un-threaded functions...
Connected to MySQL 5.6, khc25.
MySQL integrity check: pass, /Applications/khcoder3/deps/mysql-5.6.17
copied file moved: /Applications/khcoder3/config/khc25/khc25_tgt.txt
stage 1: 190, 76, 1 ; 195, 74, 1 ; 75
Trying out a different dialog method for darwin...
ignore: 17,18,
............
0 wallclock secs ( 0.23 usr + 0.01 sys = 0.24 CPU)
Data matrix for R: 74 words x 8163 (8163) docs
Statistics::R::Bridge::pipe::read_processR, Sleep and Retry!
Warning: package ‘topicmodels’ was built under R version 3.1.3
Statistics::R::Bridge::pipe::read_processR, Retry:
done: 00:00:10
Checking icode (jp2)... utf8
MySQL: FLUSH
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /</Applications/khcoder3/x_mac64>mysql_exec.pm line 445.
SQL Input:
SELECT val, lab
FROM outvar_lab
WHERE var_id =
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
SQL Caller: /</Applications/khcoder3/x_mac64>mysql_outvar/a_var.pm line 42
Trying out a different dialog method for darwin...
Exit (gui_errormsg.pm)
2025-07-09 19:22:11 16219 [Note] /Applications/khcoder3/deps/mysql-5.6.17/bin/mysqld: Normal shutdown
2025-07-09 19:22:11 16219 [Note] Giving 1 client threads a chance to die gracefully
2025-07-09 19:22:11 16219 [Note] Event Scheduler: Purging the queue. 0 events
2025-07-09 19:22:11 16219 [Note] Shutting down slave threads
sh: line 1: 16224 Killed: 9 "/Applications/khcoder3/deps/R-3.1.0/Resources/bin/R" --slave --vanilla < start.r > output.log
casper@tais-macbook-air ~ % 2025-07-09 19:22:13 16219 [Note] Forcefully disconnecting 0 remaining clients
2025-07-09 19:22:13 16219 [Note] Binlog end
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'partition'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'INNODB_CMP'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'INNODB_LOCKS'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'BLACKHOLE'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'ARCHIVE'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'MRG_MYISAM'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'MyISAM'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'MEMORY'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'CSV'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'sha256_password'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'mysql_old_password'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'mysql_native_password'
2025-07-09 19:22:13 16219 [Note] Shutting down plugin 'binlog'
2025-07-09 19:22:13 16219 [Note] /Applications/khcoder3/deps/mysql-5.6.17/bin/mysqld: Shutdown complete
AK=$LANG;export TMPDIR="/Applications/khcoder3/config";export LANG=ja_JP.UTF-8;export LC_ALL=ja_JP.UTF-8;export XMODIFIERS="@im=uim";export GTK_IM_MODULE=uim;export DYLD_FALLBACK_LIBRARY_PATH="/Applications/khcoder3/deps/mysql-5.6.17/lib"; ./x_mac64'
Encoding of this Console: UTF-8
Encoding of this file system: UTF-8
Perl/Tk: 804.032
Locale: ja_JP.UTF-8
This is KH Coder 3.02d macOS on darwin.
CWD: /Applications/khcoder3
Private dir: /Applications/khcoder3/config
Executing Mac OS X 64-bit Package
Checking MySQL connection...
Starting MySQL...
2025-07-09 19:22:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-07-09 19:22:15 16311 [Warning] Setting lower_case_table_names=2 because file system for /Applications/khcoder3/deps/mysql-5.6.17/data/ is case insensitive
2025-07-09 19:22:15 16311 [Note] Plugin 'FEDERATED' is disabled.
2025-07-09 19:22:15 16311 [Warning] Using unique option prefix innodb-locks instead of innodb-locks-unsafe-for-binlog is deprecated and will be removed in a future release. Please use the full name instead.
2025-07-09 19:22:15 16311 [Warning] Using unique option prefix innodb-cmp instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2025-07-09 19:22:15 16311 [Note] Plugin 'InnoDB' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_TRX' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_CMPMEM' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_METRICS' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2025-07-09 19:22:15 16311 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2025-07-09 19:22:15 16311 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2025-07-09 19:22:15 16311 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2025-07-09 19:22:15 16311 [Note] Event Scheduler: Loaded 0 events
2025-07-09 19:22:15 16311 [Note] /Applications/khcoder3/deps/mysql-5.6.17/bin/mysqld: ready for connections.
Version: '5.6.17' socket: '/tmp/mysql.sock.khc3' port: 0 MySQL Community Server (GPL)
starting R: "/Applications/khcoder3/deps/R-3.1.0/Resources/bin/R" --slave --vanilla
ram_r 16384
R Version: 3.1, x86_64
Using un-threaded functions...
Perl 5.016003, Perl/Tk 804.032
kh_sysconfig::os_code: UTF-8
Connected to MySQL 5.6, khc24.
MySQL integrity check: pass, /Applications/khcoder3/deps/mysql-5.6.17
Trying out a different dialog method for darwin...
ignore: 12,13,
............
1 wallclock secs ( 0.17 usr + 0.00 sys = 0.17 CPU)
Data matrix for R: 74 words x 400 (400) docs
Warning: package ‘topicmodels’ was built under R version 3.1.3
done: 00:00:08
Checking icode (jp2)... utf8
MySQL: FLUSH
Trying out a different dialog method for darwin...
ignore: 12,13,
............
1 wallclock secs ( 0.17 usr + 0.01 sys = 0.18 CPU)
Data matrix for R: 74 words x 400 (400) docs
done: 00:00:08
Checking icode (jp2)... utf8
MySQL: FLUSH
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 at /</Applications/khcoder3/x_mac64>mysql_exec.pm line 445.
SQL Input:
SELECT val, lab
FROM outvar_lab
WHERE var_id =
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
SQL Caller: /</Applications/khcoder3/x_mac64>mysql_outvar/a_var.pm line 42
Trying out a different dialog method for darwin... |
Beta Was this translation helpful? Give feedback.
Answered by
ko-ichi-h
Jul 9, 2025
Replies: 2 comments 3 replies
-
|
KH Coderを開発している樋口です。書き込みありがとうございます。 これはKH Coderのバグでした。外部変数、それも値の数が200種類以内の変数がないとご報告いただいたエラーになるバグでした。 ひとまず、このファイルを外部変数として読み込んでいただければ、エラーを回避できるかと思います。［ツール］→［外部変数と見出し］→「▽読み込み」→［CSVファイル］→［読み込み単位：H3］を順にクリックして、このファイルを読み込んでください。 本来はそうした変数がなくてもエラーなしに動くべきなのですが、修正には1日か2日を要すると思いますので、ひとまず上記のファイルをお使いいただけましたら幸いです。 ※なお蛇足ながら、トピックモデルのグラフや表の機能をお使いいただく際には、たとえば時期ごとに10～50程度に分割した変数をご準備いただくと、時期ごとの各トピックの推移を見られて便利かと思います。 |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
KH Coderを開発している樋口です。書き込みありがとうございます。 バグの修正を行いました。
以上の操作で、このエラーはでなくなるかと思います。 |
Beta Was this translation helpful? Give feedback.
3 replies
-
|
樋口先生 いつもお世話になっております。 この度はご多忙の中、ご返答いただき、誠にありがとうございます。 |
Beta Was this translation helpful? Give feedback.
-
|
「x_mac64は開いていません」が出たら、いったん「完了」をクリックしてください。 その後、［システム設定］［プライバシーとセキュリティ］と進み、一番下の方までスクロールして、「お使いのMacを保護するためにx_mac64がブロックされました」の箇所で［このまま許可］をクリックしてください。 再度kh_coderをダブルクリックし、「このまま開く」を選ぶと起動するかと思います。 |
Beta Was this translation helpful? Give feedback.
-
|
起動できるようになりました！ ご丁寧なご返答誠に有難うございます。 |
Beta Was this translation helpful? Give feedback.
Answer selected by
tai0212
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
KH Coderを開発している樋口です。書き込みありがとうございます。
バグの修正を行いました。
以上の操作で、このエラーはでなくなるかと思います。
この度はバグをお知らせいただきましてありがとうございました。