nuBuilder Forum

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

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

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

I hope it is what you expect.
Thanks

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

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

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

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

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

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.