I've done two searches in the top right search window since I went to 4.2.2. Both times, the site "locks up" in the sense that it takes 10 to 15 minutes until I can use the site again. I get the little whirligig that tells me something is trying to happen during this time. Eventually it seems to time out, as I get the focus back on the present screen without any search results or search window. This would be a pretty major problem and I don't see any bug reports or complaints about this, so I presume it has to do with something in my data. The only thing in my log file though is the entry for my search - no errors or anything.
Can anyone suggest how I might further troubleshoot for this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Okay, thanks, Greg, I did have a collation mismatch. All the rows and tables are utf8-unicode, but the database itself was utf8-general. I changed the database to utf8-unicode from PhpMyAdmin, but I presume it's not as easy as this because I'm still getting the problem. Thanks for the tip. I'll keep plugging away at it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
FYI, the database setting is just the default value used to create new tables. The table setting is just the default value used to create new columns. It is the actual column settings that you need to look at.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Victor - why use the GMAIL link and not simply copy the URL from Greg's post? It works fine. However, I'd say you have an issue with your GEDCOM structure, or server setup, rather than a miscollation if all are noted as UTF8-unicode. Every previous instance of these issues involve either:
1) database structure (collation)
2) GEDCOM structure problems (have you run GEDCHECK in critical-only mode?), or
3) server setup. Lack of sufficient RAM, bad support progs (old SQL, old html-server, old PHP) or simply a slow machine.
Is your site private? If not, please furnish a URL for a general examination. It makes discussing problems like this much easier.
- stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've done two searches in the top right search window since I went to 4.2.2. Both times, the site "locks up" in the sense that it takes 10 to 15 minutes until I can use the site again. I get the little whirligig that tells me something is trying to happen during this time. Eventually it seems to time out, as I get the focus back on the present screen without any search results or search window. This would be a pretty major problem and I don't see any bug reports or complaints about this, so I presume it has to do with something in my data. The only thing in my log file though is the entry for my search - no errors or anything.
Can anyone suggest how I might further troubleshoot for this?
The usual cause of this problem is a mismatch in column/table collations in your database, causing MySQL to convert every entry.
Okay, thanks, Greg, I did have a collation mismatch. All the rows and tables are utf8-unicode, but the database itself was utf8-general. I changed the database to utf8-unicode from PhpMyAdmin, but I presume it's not as easy as this because I'm still getting the problem. Thanks for the tip. I'll keep plugging away at it.
FYI, the database setting is just the default value used to create new tables. The table setting is just the default value used to create new columns. It is the actual column settings that you need to look at.
Victor, use this patch to fix your problem:
https://sourceforge.net/tracker/?func=detail&aid=2318005&group_id=55456&atid=477081
Follow the instructions very carefully and remember to make backups of EVERYTHING first.
Greg, in that case I don't know what the problem is because all columns and all tables were already utf8_unicode.
Nigel, can you tell me which patch that one is? When I click on it (out of Gmail) I get an Error ArtifactType: Invalid ArtifactTypeID message.
Victor, its "Database import/export/conversion utility - ID: 2318005"
Victor - why use the GMAIL link and not simply copy the URL from Greg's post? It works fine. However, I'd say you have an issue with your GEDCOM structure, or server setup, rather than a miscollation if all are noted as UTF8-unicode. Every previous instance of these issues involve either:
1) database structure (collation)
2) GEDCOM structure problems (have you run GEDCHECK in critical-only mode?), or
3) server setup. Lack of sufficient RAM, bad support progs (old SQL, old html-server, old PHP) or simply a slow machine.
Is your site private? If not, please furnish a URL for a general examination. It makes discussing problems like this much easier.
- stephen
You guys rock. Greg's DB conversion utility cured it. Many thanks.