Crosstabs: error on coding rule for "single phrase" or "nearby words"

[Gladzooks65]

Description of the problem:

When I run Crosstabs on a text file that I have run many times in other KH modules [with no problems] :
Crosstabs works fine, with any or all of the following single word codes:
*One
one

*But
but

*Well
well

*Why
why

*Heh
heh - and many other single word codes.

But if I add any of the codes below [one at a time]:

*Going_to
going+to

*going_to
near(going-to)

*To_after_going
seq(going-to)

*Going_and_to_Couple
near(going-to)

I get the error message shown in the attached screen shot.

Any help greatly appreciated
thanks
Greg Peters

---

What happens if you perform the same operation with the tutorial file (Anne.xls)
-same error occurs

Files to Reproduce the Error
If we can't reproduce the error with the tutorial file "Anne.xls" -same error occurs

Language of the Text
What language of text are you trying to analyze?
English

Type of the data file
What kind of file are you trying to analyze?
e.g. Plain text (.txt)

Screenshots
If applicable, add screenshots to help explain your problem. - see attached

Version number of KH Coder
3.Alpha.17k

OS

Windows 10

Antivirus or Security software running on the PC
Norton 360

Additional context
Add any other context about the problem. -no

[ko-ichi-h]

Hi,

(1) Please update your KH Coder. 3.Alpha.17k has the bug that 0 frequency codes raise MySQL error.

(2) In the menu of KH Coder, please go to "PRe-Processing", "Select Words to Analyze", check "OTHER", and enter "going" as "force pick up". Then run pre-processing again.

In the default settings, "to" is considered OTHER.

Also, KH Coder convert words into their base forms (lemma) and recognize them with base forms. To avoid converting "going" into "go", you have to "force pick up" "going".

[Gladzooks65]

Dear Prof Higuchi thanks for your very prompt reply. My problem is now solved! However, I remain a bit surprised that it arose. I was aware of the lemma issues for "going", and so I had always included the TAG "going_to" in my forced pick up. I thought that would address the lemma problem, and it does seem to work for many KH3 modules. But not for CrossTabs! As you advised, I have downloaded the new version of the program, but I'm a bit loath to adopt it. I suspect that would require the re-initiating of the many projects I have installed within the old version. Is that so? yours Greg Peters

…

On Thu, Oct 7, 2021 at 4:03 PM HIGUCHI Koichi ***@***.***> wrote: Hi, (1) Please update your KH Coder. (2) In the menu of KH Coder, please go to "PRe-Processing", "Select Words to Analyze". Then check "OTHER" and enter "going" as "force pick up". [image: 2021-10-07 13_54_34-Select Words to Analyze] <https://user-images.githubusercontent.com/12220822/136322664-fed43d9b-5cd5-4ae4-a29d-f3ca61aa9c90.png> In the default settings, "to" is considered OTHERS. Also, KH Coder convert words into their base forms (lemma) and recognize them with base forms. To avoid converting "going" into "go", you have to "force pickup" "going". — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://github.com/ko-ichi-h/khcoder/issues/405#issuecomment-937447623>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AV6NT56CXVSAXCBDPRXQCGLUFUSZFANCNFSM5FQJ5PPQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[ko-ichi-h]

Dear Greg Peters,

Hmm, I think force picking up "going to" and specifying "going_to" in the coding rule file would work in CrossTabs too.

Anyway, I have not tested the procedure, but I think just unzipping latest version and overwriting the 3.Alpha.17k would do it. You will be able to open existing projects with the overwritten latest version.

Best,