GNOME Bugzilla – Bug 672571
mysql backend is not work
Last modified: 2018-06-29 23:07:30 UTC
My Env: Windows 7 64bit gnucash 2.4.10-1 File Menu --> Save As --> Data Format: mysql gnucash show the "Database Connection" but I can't write the Host, Database, Username, Password please fix this issue.
I'm unable to replicate the problem with either an admin or an unprivileged account on Windows 7 Professional 64-bit. Make sure that your path does not include any other Gnu/Gnome programs, and test from a newly-created user account.
1st Case In Windows 7 64bit I uninstall gnucash and install gnucash again. Run with Administrative permission and user permission File Menu --> Save As --> Data Format: mysql gnucash show the "Database Connection" but I can't move the cursor to the Host, Database, Username, Password. Windows path is PATH=D:\Tool\ImageMagick;D:\Tool\PHP\;C:\Windows\system32;C:\Windows;C:\Windows\ System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Tool\TortoiseGit\bi n;D:\Tool\Git\bin;D:\Tool\Python25;D:\Server\Subversion\bin;D:\Tool\TortoiseSVN\ bin;D:\Tool\Java\jdk1.6.0_31\bin;D:\Tool\maven\bin;D:\Tool\Ruby187\bin;C:\Progra m Files (x86)\UniUSB\Common;C:\Users\home\AppData\Local\Bandizip\7z 2nd Case In Windows 7 32 bit same case please help me
ImageMagick is also a Gtk program, so the linker might be pulling one or more libraries from there. Either try removing it from your path or running Gnucash while logged in as a different user with the default path. 32/64 bit is unlikely to make a difference.
In Windown 7 32bit Path is PATH=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32 \WindowsPowerShell\v1.0\;C:\Program Files\Google\Google Apps Sync\;C:\Program Fi les\Google\Google Apps Migration\;C:\Users\DBCNI\AppData\Local\Bandizip\7z but I can't move cursor to "Database Connection" (Host, Database, Username, Password)
OK, then it's not ImageMagick. Have you tried yet with a newly created user and only C:\Windows;C:\Windows\System32 for a shell? Another thought: Sometimes a modal dialog will come up behind another dialog box and block focus from going there. Try moving the windows and dialog boxes around and make sure there's nothing hiding.
I created new user and path is C:\Windows;C:\Windows\System32 But I can't move to cursor to gnucash for "Database Connection". also I can't find the another dialog.
Hmmph. Well, I'm stumped, then.
I try to mysql backend with my new notebook. But I can't move to cursor to gnucash for "Database Connection". also I can't find the another dialog. my step is 1. new notebook with new Windows 7 32bit Windows Enterprise 2. I install gnucash 2.4.10-1 3. run gnucash ---> I don't wirte the "Database Connection"
Is this still an issue?
reproduced with LANG=zh_CN, not reproduce-able with LANG=en_US with LANG=zh_CN, after switching to pgsql or mysql. non of the edit box can be type in any character, no cursor appears, even switching back to sqlite or xml which shows file selection, the filename field is not editable. however the file list is click-able using the mouse
Xuefer, what OS are you using? OP, if you're still around, what locale are you using?
Windows 7 64bit System displays Chinese Simplified UI for start menu System is set to default to GB2312 for non-UNICODE programs (which is default value of Chinese simplified windows 7) when LANG is unset, gnucash show interface as if it were LANG=zh_CN i set LANG=zn_CN env before starting gnucash -> gnucash UI shows Chinese Simplified. the bug is reproduce-able i set LANG=en_US env before starting gnucash -> gnucash UI shows English, the bug is not reproduce-able i'm not sure if there're any other "locale" concept you were referring to
"OP" means "original poster", meaning Choiks. Gnucash is a ported Gtk program, and Gtk uses its own input methods. I don't know how to set that up on Win32, but that might be the source of your problem. Are you able to enter Chinese text into any part of Gnucash?
I can input to gnucash (or any other windows gtk app) using google pinyin via Windows IME, with either LANG=zh_CN, or LANG=en_US. with LANG=zh_CN the IME support is a little bit better than LANG=en_US: LANG=zh_CN enable inline IME input (don't the standard name, but it's not relative to this bug) when the bug was reproduced, the cursor disappeared before i do any input, i don't think you have to install an Chinese IME or input any Chinese character to reproduce this bug LANG=zh_CN is just an env variable which gtk uses it to override system default, you may try to set the same value and reproduce
Setting to unconfirmed again as the user replied to the questions. Unconfirmed instead of new because I don't think any developer so far has reproduced the issue.
reproduced in 2.6.2 again with LANG=zh_CN (or no LANG set but system default to Chinese), can't type anything to the configuration input boxes in open->mysql LANG=en_US however works as expected os: windows 8.2
Confirmed and easy to reproduce. If I edit the gnucash environment file and set LANG=zh_CN the entry fields for host, user and so on are disabled. This is on Windows XP. I have no idea why this is yet.
I have looked some more into this but there is nothing in GnuCash that I can see causing this. Just as additional data points, there are more languages that have this problem: languages I have tried that failed: zh_CN, zh_TW, ko_KR. All have windows code pages around 950. I thought this might affect all non-latin languages, but apparently cyrillic is working fine: using ru works with no problem. Note that the problem starts earlier than not being able to type into the fields. Normally the code sets a default value for host and database. This is not done in the problem languages. When running in one of the problem languages, I get output similar to this: * 18:49:18 WARN <qof.engine> [guid_init()] only got 1764 bytes. The identifiers might not be very random. * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:38 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:53 WARN <Gtk> 找不到图标“gtk-file”。“hicolor”主题也没有找到，可能您需要先安装它。 您可以从下面的位置获得一个副本： http://icon-theme.freedesktop.org/releases * 18:49:55 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:49:55 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window * 18:50:14 WARN <Gdk> gdkdrawable-win32.c:2013 drawable is not a pixmap or window I don't know what the message regarding hicolor means, but it's unlikely to be related. To me this looks like a gtk on windows bug.
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=672571. Please continue processing the bug there and please update any external references or bookmarks.