nuBuilder Forum

Hi,

I have developed a nuBuilder application on top of an OVH DB and I have 2 cases of access violation errors
1° at login time (no effect but just a nuDebug message). Refer to print screen attached.
2° nuRunQuery of a call of a stored procedure... the stored proc is not called
Is it due to access rights/privileges ?

I also have a local test environment developed on MacOs where I have root access ... and everything is fine.

Thanks in advance ... I hope you will help me to find a solution.

Regards,
Bri

1) It might be because of the space in the table

2) Use the code from the code library to run a stored procedure: https://github.com/nuBuilder/nuBuilder- ... _procedure

Thanks, I will try.
But I do not understand why "a simple "nuRunQuery" with the call procedure works in the local environment (MacOs) and not in the web OVH environment

Regards,

Bri

Do you see an error in nuDebug Results?
And is the same mySQL/PHP version used in both environments?

Hi,

Concerning the sql/php version, I have attached the print screen of both environments.
Also, attached, the 2 error types I have got (Login and stored procedure).
It seems to me that both errors are related to access violation... on one side (environment working), I have root access on the other one not.

Thanks in advance,
Bri

Are you able to execute the sp directly from within phpMyAdmin?

The EXECUTE privilege is required to execute stored routine: https://dev.mysql.com/doc/refman/5.7/en ... leges.html

Not specifically this one but any other stored procedures that I call directly from phpAdmin

Replacing all
with
in nudatabase.php should eliminate the "TABLE 127" error.


If you get the error when running from phpMyAdmin, check the permissions to execute a stored procedure.

Sorry to be late by answering ... It was indeed an error in SP creation.
Nothing to do with nuBuilder or OVH