Page 1 of 1

Strange behavior with 2 instances

Posted: Thu Jul 27, 2023 5:25 pm
by fmuller
Hello,

My application using nuBuilder is now live so to avoid disruption/ errors & to be able to test as a user several cases, I duplicated the code & base to have a sandbox.

I cloned the database with phpmyadmin, copied the php code to a subdirectory "sandbox", changed the database in the nuconfig.php to point to the sandbox one.
Everything seems to work fine so far ... however I'm a bit puzzled by a cross access to the standard database from the sandbox one :

* I created an edit form in the sandbox, I see it in the forms list.
* I created a button in the user's home (sandbox) and tried to run the previous edit form as popup
* My edit form don't appear there
* I changed a description from the main application (non-sandbox) and ... I see it on the sandbox run Form selector :o

How is that possible ? Is there a magic trick that I missed ? or it isn't possible to have 2 instances and I need to start it on my local computer ?

Regards,
François

Re: Strange behavior with 2 instances

Posted: Fri Jul 28, 2023 5:18 am
by kev1n
Hi,

Does this help?
viewtopic.php?p=23648#p23648

Re: Strange behavior with 2 instances

Posted: Fri Jul 28, 2023 1:56 pm
by fmuller
Hi,
Nop but I did found the problem ... somehow the views zzzzsys_run_list / zzzzsys_report_data / zzzzsys_object_list are referring to the table directly

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `zzzzsys_run_list` AS select `nubuilder4`.`zzzzsys_form` (...)

so I need to update them to work on the sandbox one (choosen solution : remove database from request)

Thanks again,
Regards,