Page 1 of 1

newbie question: The Procedure does not exist... (RUNFF)

Posted: Sat Dec 18, 2021 4:11 pm
by lxnunes
Hi, this is my 1st post and also the 1st time I am using nubuilder, so please excuse me if this has been answered already elsewhere.

I have just made a clean install of nubuilder 4.5, using mysql 8 as a backend, with an existing database. Nubuilder created all the zzz(..) tables so I guess it was properly installed.

When trying to create my 1st fast form, and following the pizza delivery video, I added the table and the fields and I was able to scroll through the different values.

However, when clicking the "build fast form" button I get an error "The Procedure does not exist... (RUNFF)" and nothing is created.

I tried searching the documentation but couldn't find anything regarding the meaning of this message nor why it popped up. Any hint would be much apreciated.

Many thanks!

Re: newbie question: The Procedure does not exist... (RUNFF)

Posted: Sat Dec 18, 2021 4:33 pm
by kev1n
Hi and welcome :hi:

There should be a PHP Procedure with sph_code RUNFF in the table zzzzsys_php.

Code: Select all

SELECT * FROM `zzzzsys_php` WHERE `sph_code` = 'RUNFF' 
If it does not exist, run this INSERT statement in phpMyAdmin to create it:

Code: Select all

INSERT INTO `zzzzsys_php` (`zzzzsys_php_id`, `sph_code`, `sph_description`, `sph_group`, `sph_php`, `sph_run`, `sph_zzzzsys_form_id`, `sph_system`, `sph_global`, `sph_hide`) VALUES ('nufastform', 'RUNFF', 'Run Fast Form', 'nubuilder', 'nuBuildFastForm(\'#fastform_table#\', \'#fastform_type#\');\r\n\r\n', '', 'nufflaunch', '1', '0', '')

Re: newbie question: The Procedure does not exist... (RUNFF)

Posted: Sat Dec 18, 2021 4:37 pm
by lxnunes
Hi kev1n and thakn you for the lighning-fast reply!

Meanwhile I noticed an Update button and gave it a shot. Indeed the UI changed a bit (e.g. the form builder table selector is now a combobox) and the form was created fine.

The question now is which version am I running? :) Before the update version.txt had
nuBuilder Forte 4.5
DB Version: V.4.5-2021.12.02.03
Files Version: V.4.5-2021.12.04.00

Now it still seems to be the same...

Re: newbie question: The Procedure does not exist... (RUNFF)

Posted: Sat Dec 18, 2021 4:42 pm
by kev1n
Where did you download it from?

The latest version is always on Github: https://github.com/nuBuilder/nuBuilder-4.5

Re: newbie question: The Procedure does not exist... (RUNFF)

Posted: Sat Dec 18, 2021 4:45 pm
by lxnunes
from https://github.com/nuBuilder/nuBuilder- ... .5.1.0.zip

anyway, the update feature seems to have worked like a charm!
Many thanks.