Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.

Browse screen and pagination

Questions related to using nuBuilder Forte.
BDemeuse
Posts: 92
Joined: Mon Apr 12, 2021 3:09 pm
Has thanked: 1 time
Been thanked: 2 times

Re: Browse screen and pagination

Unread post by 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
Posts: 92
Joined: Mon Apr 12, 2021 3:09 pm
Has thanked: 1 time
Been thanked: 2 times

Re: Browse screen and pagination

Unread post by 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
nuBuilder Team
Posts: 4581
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 76 times
Been thanked: 536 times
Contact:

Re: Browse screen and pagination

Unread post by kev1n »

Here it would also help if you could upload the form's sql + a dump of your table (without data)
BDemeuse
Posts: 92
Joined: Mon Apr 12, 2021 3:09 pm
Has thanked: 1 time
Been thanked: 2 times

Re: Browse screen and pagination

Unread post by BDemeuse »

I hope it is what you expect.
Thanks :-)
You do not have the required permissions to view the files attached to this post.
BDemeuse
Posts: 92
Joined: Mon Apr 12, 2021 3:09 pm
Has thanked: 1 time
Been thanked: 2 times

Re: Browse screen and pagination

Unread post by 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
nuBuilder Team
Posts: 4581
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 76 times
Been thanked: 536 times
Contact:

Re: Browse screen and pagination

Unread post by kev1n »

I created a new db (e.g. test) with a user test (password test). Both pagination + select seem to work.
test.zip
You do not have the required permissions to view the files attached to this post.
BDemeuse
Posts: 92
Joined: Mon Apr 12, 2021 3:09 pm
Has thanked: 1 time
Been thanked: 2 times

Re: Browse screen and pagination

Unread post by BDemeuse »

For testing, I mean I need to create a new DB and new app ?
Or another way without impacting the existing solution ?
kev1n
nuBuilder Team
Posts: 4581
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 76 times
Been thanked: 536 times
Contact:

Re: Browse screen and pagination

Unread post by 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
Posts: 92
Joined: Mon Apr 12, 2021 3:09 pm
Has thanked: 1 time
Been thanked: 2 times

Re: Browse screen and pagination

Unread post by BDemeuse »

It works :-)
Many Thanks!!
Now, how can I integrate in the current application?
kev1n
nuBuilder Team
Posts: 4581
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 76 times
Been thanked: 536 times
Contact:

Re: Browse screen and pagination

Unread post by 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.
Post Reply