close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Multiple record update only works once

Thread began 8/04/2022 2:17 am by MWilson | Last modified 8/09/2022 10:50 am by Ray Borduin | 27 views | 3 replies |

MWilson

Multiple record update only works once

Hi Ray, I have a paginated results page (200 per page) for a table that contains over 70,000 entries. My client has just tried to update all entries for a particular user by first searching for the entries, which displayed 311 results over 2 pages, then he used the select multiple checkbox on the first page of results to select them all, but when he tried to update them, they didn't update. He then tried the same thing on page 2 of the results and that did work.

I therefore thought that the issue may be with the pagination so I changed the page to display 500 results at a time so I can now see all 311 results. However when I select multiple records (either all or just a few), they aren't updating.

I tried adding a few test rows and was also able to update them successfully - the issue seems to only be happening with multi-page results.

Could you take a look for me? I've attached the page and have included further access details in the PM.

Sign in to reply to this post

Ray BorduinWebAssist

This may be a php.ini issue. There is a setting for "max_form_fields" that wouldn't allow more than that many values to be submitted at a time.

If you need help, give me a call and I'll help you track down and fix the problem.

Sign in to reply to this post
Did this help? Tips are appreciated...

MWilson

I've checked the phpinfo (v.7.4.30) and don't have a setting for max_form_fields but I do have max_input_vars which is set to 1000 and I think is the same thing? That should be OK though as there were 311 filtered results we were trying to update. Weird thing is that even if I only select two or three of that user's un-updated records they just won't update, but I added some test rows under a different user and was able to update them no problem. When would be a good time to call - remind me if you prefer Skype, Zoom or Teams?

Sign in to reply to this post

Ray BorduinWebAssist

Contact me via skype: webassist.rborduin

I am available this afternoon (PST). I'll be running out for lunch in about an hour, but I should be around the rest of the day.

Sign in to reply to this post
Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...