There's always been a limit of 1,000. I have no idea where 43 could be coming from. Why would you regular search all person records ever? Is your browser's autofill feature putting something in one of the search boxes maybe?
I've checked for any autofill but couldn't see any. Sometimes some of the staff like to do that to see how many people are on the system etc.
Sorry to keep pestering on this subject but I'm getting a lot of people asking me to try and fix this issue... I still only get 43 results (all beginning with 'A') on a blank person search. I've just done another search with the word 'Kent' in the County contains box' and I only get 31 results with only the 'A's and 'B's' (firstnames) being returned yet I know through reports that there are a whole lot more than this. Is there a way for me to refresh the database somehow or clean the data or something? I'm at a bit of a loss! It's only recently started happening. Thanks again in advance for your help. I really do appreciate it.
are you a sheltermanager.com customer? Drop us a line at [email protected] with your account number and we'll take a look. If it's ASM3 open source, could you paste the address bar URL of the person find results screen? It contains an encoded version of the search and it does sound very much like autofill putting something in one of your name boxes prior to the search. Thankfully, no-one else is reporting this as a problem.
Thanks for replying so quick. I'm not a customer I use the ASM3 open source. The URL after doing a person search is:- http://box.pawprints2freedom.co.uk:5000/person_find_results?mode=ADVANCED&county=kent&jurisdiction=-1 I can't see anywhere where there is some autofill being put in. This above search returns 32 results showing just people with first names beginning with 'A' and about 4 people with first names beginning with 'B'. If I do a blank person search which used to bring up all 1000 results (we have many more but I know there is a 1000 person result limit) I only get the first 43 in alphabetical order. The result URL for that is: - http://box.pawprints2freedom.co.uk:5000/person_find_results?mode=ADVANCED&jurisdiction=-1 I tried removing jurisdiction=-1 and get the same result. Hope you can see something obvious that I'm missing! Many Thanks in advance.
Ok, what version of ASM3 do you have? Here are some other things that might cause it depending on updates: 1. Your user doesn't have the "View staff person record" or "View volunteer person record" permission and the flag is null in your database. Try logging in with a super user (disregard if you already are). 2. The SiteID value on your person records is null and your user is set to a non-zero value. Fix with this query at Settings->SQL Interface: --- UPDATE owner SET SiteID = 0 WHERE SiteID Is Null ---
Hi, I ran the SQL query above. (0 rows affected). then tried the searches again and I still have the same results. I am logged in as the system admin. I'm running ASM3_40.
If you run some queries to search people records directly, what do you get? --- SELECT COUNT(*) FROM owner --- --- SELECT ID, OwnerName, OwnerAddress FROM owner ORDER BY ID ---
With the first query I get 3880. With the second I get 3938 rows returned.
Anymore thoughts on this one Rob? I'm currently trying to upgrade to v 42 but I'm having issues just doing that at the moment (probably my fault!).
42 isn't actually released yet, so I guess you're trying to update to 41? Let's get that sorted and see if it fixes the search issue as that code was rewritten in 41.
Hi there, I've managed to upgrade, when I create the .deb file it definitely says version 42! After the upgrade I restarted everything and I still have the same issue with the search results :( We are looking to move over to your paid system now as I am unable to keep up with everyone's requests. Am I able to export the DB entirely in order to be able to import into a new account on your hosted system? If so, what is the best way to do this as it is a large DB and I don't want to mess it up! Many Thanks
Oh, you've downloaded the source and are building your own deb file. That's a bit hardcore for most, well done! There are multiple ways to do a person search. What happens if you enter this into the search box at the top? It should also do a blank person search. --- p: --- If you do want to move to sheltermanager.com, we can take a MySQL dump of your database and will handle import for you.
If I do that in the main search box on the main page I just get the same 43 results :(
I've just signed up. so will do a SQL dump now and when the account is setup will go through getting that imported. Thanks for all your help anyway!