Browse screen and pagination

[BDemeuse]

I have removed \n in the generated SQL in phpMyAdmin. Of course, the browse is correctly displayed but nothing is changed in nuBuilder

[BDemeuse]

I have removed \n in the SQL in phpMyAdmin. The browse is correctly displayed in phpMyAdmin but nothing is changed in nuBuilder But I have not changed anything in nuBuilder ... so, I do not see how it could have been solved ?
Something that escapes me

[kev1n]

Here it would also help if you could upload the form's sql + a dump of your table (without data)

[BDemeuse]

I hope it is what you expect.
Thanks

[BDemeuse]

Hi,

I have just verified and made a short test (same table tr_kvp_relation for the selected date) with "my previous version"
(DB Version: V.4.5-2021.04.27.00
Files Version: V.4.5-2021.04.26.02)
and everything is fine with normal users: browse and select also
Sorry to mix posts and both issues but it seems so linked

[kev1n]

I created a new db (e.g. test) with a user test (password test). Both pagination + select seem to work.

test.zip

[BDemeuse]

For testing, I mean I need to create a new DB and new app ?
Or another way without impacting the existing solution ?

[kev1n]

Create a new database, e.g. test.
and copy the nubuilder files into a new directory, e.g. test and change nuconfig.php accordingly.

[BDemeuse]

It works
Many Thanks!!
Now, how can I integrate in the current application?

[kev1n]

Use the cloner in the test db with "Generate new PKs" and "Dump SQL Statements" checked and then run the generated SQL on your prod db.