Page 1 of 1

Moved Nubuilder Between Servers

Posted: Mon Dec 09, 2024 8:15 pm
by tpolimeni28
Hello All, I am at a total loss here. I recently went from Redhat6 to RedHat8. I backed up the running instances of Nubuilder installed Nubuilder on the new server RedHat 8 moved over the all Databases and such....

Well now I have created new instances and fast forms on Nubuilder. When I go to update anything or any small tweak on a Fast Form, I get an error Code must be both unique and not blank. This happens when I do any small update from got to the Fast form page, Hamburger, form properties and could be as simple as toggling under browse Auto-resize columns to yes and hitting save. No matter how small or minor of a change I make this is the error in which I get. I've tried the upgrade process as well and I'm finally at my wits end. Can anyone give any help on how to resolve this as the new fast forms' id like to add some custom coding in.

Screenshot added

Re: Moved Nubuilder Between Servers

Posted: Mon Dec 09, 2024 10:57 pm
by nc07
tpolimeni28 wrote: Mon Dec 09, 2024 8:15 pm Hello All, I am at a total loss here. I recently went from Redhat6 to RedHat8. I backed up the running instances of Nubuilder installed Nubuilder on the new server RedHat 8 moved over the all Databases and such....

Well now I have created new instances and fast forms on Nubuilder. When I go to update anything or any small tweak on a Fast Form, I get an error Code must be both unique and not blank. This happens when I do any small update from got to the Fast form page, Hamburger, form properties and could be as simple as toggling under browse Auto-resize columns to yes and hitting save. No matter how small or minor of a change I make this is the error in which I get. I've tried the upgrade process as well and I'm finally at my wits end. Can anyone give any help on how to resolve this as the new fast forms' id like to add some custom coding in.

Screenshot added
Try Changing the form code in the main tab , in your case FF1 to something unique and see if it is working

Re: Moved Nubuilder Between Servers

Posted: Tue Dec 10, 2024 12:04 pm
by Janusz
Based on my experiece form Debian servers.
When I make an exact copy of the DB: I create with MariaDB a database with thne same original DB mane and the same globeadmin name.
If database names are different or globeadmin names are different them there might be some problems.
To export database I use ex: (from terminal on original server)

Code: Select all

mariadb-dump --events  --routines -u globeadmin6 -pxxxxxx MyDB1 > /root/temp/MyDB1.sql
to import on other server (from terminal on new server):

Code: Select all

mariadb -u root -pxxxxxx -e "DROP DATABASE IF EXISTS MyDB1;CREATE DATABASE MyDB1;GRANT ALL PRIVILEGES ON MyDB1.* TO 'globeadmin6'@'%';"
mariadb -u globeadmin6 -pxxxxxx MyDB1 < ./MyDB1.sql
Normally every day with cron I am exporting production DB to back-up server and did not experience any problems. But if the names like in the example above: MyDB1 or globeadmin6 are different I had to adjust them in the exported mysql text file with someting like:
(in case target DB has different name, but here some risk exist and must be evaluated)

Code: Select all

sed -i 's/`'MyDB1'`/`TestDB`/g' /root/temp/TestDBtemp.sql

Re: Moved Nubuilder Between Servers

Posted: Tue Dec 10, 2024 4:39 pm
by tpolimeni28
nc07 wrote: Mon Dec 09, 2024 10:57 pm
tpolimeni28 wrote: Mon Dec 09, 2024 8:15 pm Hello All, I am at a total loss here. I recently went from Redhat6 to RedHat8. I backed up the running instances of Nubuilder installed Nubuilder on the new server RedHat 8 moved over the all Databases and such....

Well now I have created new instances and fast forms on Nubuilder. When I go to update anything or any small tweak on a Fast Form, I get an error Code must be both unique and not blank. This happens when I do any small update from got to the Fast form page, Hamburger, form properties and could be as simple as toggling under browse Auto-resize columns to yes and hitting save. No matter how small or minor of a change I make this is the error in which I get. I've tried the upgrade process as well and I'm finally at my wits end. Can anyone give any help on how to resolve this as the new fast forms' id like to add some custom coding in.

Screenshot added
Try Changing the form code in the main tab , in your case FF1 to something unique and see if it is working
This worked the magic I was going insane over this!!! Thank you very much for the hidden magic. I was going insane

Re: Moved Nubuilder Between Servers

Posted: Tue Dec 10, 2024 10:56 pm
by nc07
tpolimeni28 wrote: Tue Dec 10, 2024 4:39 pm
nc07 wrote: Mon Dec 09, 2024 10:57 pm
tpolimeni28 wrote: Mon Dec 09, 2024 8:15 pm Hello All, I am at a total loss here. I recently went from Redhat6 to RedHat8. I backed up the running instances of Nubuilder installed Nubuilder on the new server RedHat 8 moved over the all Databases and such....

Well now I have created new instances and fast forms on Nubuilder. When I go to update anything or any small tweak on a Fast Form, I get an error Code must be both unique and not blank. This happens when I do any small update from got to the Fast form page, Hamburger, form properties and could be as simple as toggling under browse Auto-resize columns to yes and hitting save. No matter how small or minor of a change I make this is the error in which I get. I've tried the upgrade process as well and I'm finally at my wits end. Can anyone give any help on how to resolve this as the new fast forms' id like to add some custom coding in.

Screenshot added
Try Changing the form code in the main tab , in your case FF1 to something unique and see if it is working
This worked the magic I was going insane over this!!! Thank you very much for the hidden magic. I was going insane
That's great, happy that it worked for you.
regards
Nilesh