安裝 MySQL-python(mysqlclient 前身)時,GCC 在 _mysql.c:602 報錯 expected expression before ')' token,原因是條件編譯區塊導致函數參數列表尾部多出逗號。
_mysql.c: In function '_mysql_ConnectionObject_Initialize':
_mysql.c:602: error: expected expression before ')' token
if (!PyArg_ParseTupleAndKeywords(args, kwargs,
#ifdef HAVE_MYSQL_OPT_READ_TIMEOUT
"|ssssisOiiisssiOii:connect",
#else
"|ssssisOiiisssiOi:connect",
#endif
kwlist,
&host, &user, &passwd, &db,
&port, &unix_socket, &conv,
&connect_timeout,
&compress, &named_pipe,
&init_command, &read_default_file,
&read_default_group,
&client_flag, &ssl,
&local_infile,
#ifdef HAVE_MYSQL_OPT_READ_TIMEOUT
&read_timeout
#endif
))
當 HAVE_MYSQL_OPT_READ_TIMEOUT 未定義時,最後一個參數 &local_infile 後保留逗號,導致語法錯誤。
將條件編譯的參數逗號前置,確保參數列表語法正確:
if (!PyArg_ParseTupleAndKeywords(args, kwargs,
#ifdef HAVE_MYSQL_OPT_READ_TIMEOUT
"|ssssisOiiisssiOii:connect",
#else
"|ssssisOiiisssiOi:connect",
#endif
kwlist,
&host, &user, &passwd, &db,
&port, &unix_socket, &conv,
&connect_timeout,
&compress, &named_pipe,
&init_command, &read_default_file,
&read_default_group,
&client_flag, &ssl,
&local_infile
#ifdef HAVE_MYSQL_OPT_READ_TIMEOUT
, &read_timeout
#endif
))
關鍵變更:
&local_infile 後的逗號#ifdef HAVE_MYSQL_OPT_READ_TIMEOUT 區塊前加上逗號 , &read_timeouttar xzf MySQL-python-1.2.x.tar.gz_mysql.c,定位 PyArg_ParseTupleAndKeywords 呼叫處python setup.py build && python setup.py install
MySQL-python 已停止維護,建議改用:
pip install mysqlclient(C 擴充,相容 MySQL-python API)pip install PyMySQL(純 Python,無編譯問題)
# Django 設定範例(mysqlclient)
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'OPTIONS': {'charset': 'utf8mb4'},
}
}
若必須維護舊專案,套用補丁即可編譯通過;新專請直接採用 mysqlclient 或 PyMySQL。