sheltermanager

Open full view…

Search only displays 43 results

glherriott
Fri, 22 Mar 2019 19:39:10 GMT

HI everyone. For some reason, all of a sudden, when doing a person search (with empty parameters) in order to display all person records I am now only receiving the first 43 results. I used to receive all records. Is there a setting somewhere dictating the amount of search records to return? Many Thanks in advance.

robinrt
Fri, 22 Mar 2019 19:40:42 GMT

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?

glherriott
Fri, 22 Mar 2019 20:06:36 GMT

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.

glherriott
Wed, 03 Apr 2019 20:51:55 GMT

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.

robinrt
Thu, 04 Apr 2019 07:40:57 GMT

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.

glherriott
Fri, 05 Apr 2019 08:54:53 GMT

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.

robinrt
Fri, 05 Apr 2019 10:33:00 GMT

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 ---

glherriott
Fri, 05 Apr 2019 10:44:20 GMT

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.

robinrt
Fri, 05 Apr 2019 10:46:47 GMT

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 ---

glherriott
Fri, 05 Apr 2019 12:19:59 GMT

With the first query I get 3880. With the second I get 3938 rows returned.

glherriott
Mon, 08 Apr 2019 10:25:18 GMT

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!).

robinrt
Mon, 08 Apr 2019 11:25:59 GMT

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.

glherriott
Mon, 08 Apr 2019 15:01:16 GMT

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

robinrt
Mon, 08 Apr 2019 15:29:43 GMT

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.

glherriott
Mon, 08 Apr 2019 15:31:56 GMT

If I do that in the main search box on the main page I just get the same 43 results :(

glherriott
Mon, 08 Apr 2019 15:32:27 GMT

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!