Db limited to 1000 records, again


#1

I’m getting records, and I appear to be limited to 1000 records per pull. I’ve changed the .env file after trying to RTFM, cleared caches, restarted machine, etc. still no joy…

Am I missing something? Version = 2.12 for the record. using the db service.


#2

Hi @JeffBlackwell ,

When you say you changed the .env file, are you referring to the max records returned?
CloudApp

I haven’t changed my default here, so it is still commented out and unchanged.

When you said you cleared the caches, did you mean you had used php artisan config:clear and php artisan cache:clear?

Are you using a Bitnami installer or a manual GitHub install?

Thanks,

Erik


#3

That’s exactly what I changed in the .env file.

Bitnami windows installer.

I didn’t use php artisan, I cleared the caches via the df app config page, cache menu item. Like below:


#4

Thanks for looking at it.
Here’s the steps that I followed.

  1. Normal 2.12. windows install
  2. made a table in the sqlite (db service).
  3. Loaded table with 15000 ish records.
  4. Use either client or API documentation, db service GET /_table/tablename (would expect to get all records)
  5. get 1000 back
  6. change .env file as above
  7. clear caches in the app as noted

…still get 1000 records - would expect to get more.

Thanks so much for taking a look at it!


#5

No problem Jeff. Can you please go to the services tab and increase the max records returned on your SQLite service?

When you clear the system caches, it only clears the local cache of the services, it doesn’t clear and reset configuration changes in the underlying PHP / Laravel code. An easy workaround should be what I suggest. If you are wanting to be able to use some of the Linux based commands, you can always use https://git-scm.com/download/win . I use this on my Windows box since my primary coding interface is through the Mac O/S. This will create a Git shell that will mimic a Linux environment, enabling you to run a lot of the commands easily through the terminal interface.

An easier answer:
You can also restart the servers on the Bitnami widget and that should have the same effect.


#6

Thank you , sir. That appears to do the trick.


#7

Awesome, @JeffBlackwell! So glad it is up and running for you. Have a great week!