First, I want to thank you for your help. Now:
At the moment I have two installations of 2.3.3 versions of my site, resulting from two attempts to upgrade my 2.2.4 site.
When I search using profile/search.php in one of them I get one error:
Notice: Use of undefined constant _PROFILE_MI_NEVER_LOGED_IN - assumed '_PROFILE_MI_NEVER_LOGED_IN' in file /modules/profile/class/field.php line 303
I'm not sure why I'm getting that as it is defined in profile/language/english/modinfo.php
The relevant query that I get when I turn debug on is:
SELECT u.uid, u.uname, u.email, u.user_viewemail, u.last_login, u.user_regdate, p.lastname, p.join_date, p.renew_date FROM users AS u LEFT JOIN profile_profile AS p ON u.uid=p.profile_id WHERE 1=1 AND (level > '0' AND lastname LIKE 'cole%' AND join_date <= '1238306400' AND renew_date <= '1238306400' AND last_login <= '1238306400' AND user_regdate <= '1238306400') LIMIT 0, 20
Some of these I would not normally make searchable but I have everything searchable at the moment.
Interesetingly, if I run that query directly from phpmyadmin (entering the prefix value for my tables before users and profile.profile), I get the same three hits, missing the others.
Hoever, if I look, using phpadmin's search tab, for %cole% in the users table they are there (plus a couple of others with cole embedded within the user name. I can also find them all using the admin search menu in 2.3.3. It's just the profile search that's missing them. I also find the correct five hits if I search the table profile.profile using the search tab. That, of course, is where my custom fields such as first name, last name are kept.
Could it be that the profile module is generating incorrect MySQL queries? Either that or there is something wrong with some of the records in my tables?
Collation in all three databases is latin1_swedish_ci
The only difference I have found between the 2.2.4 and 2.3.3 installations is the charset stipulated in language/english/global.php (I assume that is what you are asking me). In my live 2.2.4 site it is ISO-8859-1. In the two 2.3.3 installations it is UTF-8.
BTW, server info:
Apache 2.2.11 (Linux)
PHP version 5.2.9
MySQL version 5.0.75-community-log
Still hoping for a solution.
BC