Access violation at login and call of stored procedure

[BDemeuse]

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

[kev1n]

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

[BDemeuse]

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

[kev1n]

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

[BDemeuse]

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

[kev1n]

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

Code: Select all

call insert_default_role('1288')

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

[BDemeuse]

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

[kev1n]

Replacing all

Code: Select all

DESCRIBE $n

with

Code: Select all

DESCRIBE `$n`

in nudatabase.php should eliminate the "TABLE 127" error.


If you get the error when running

Code: Select all

call insert_default_role('1288')

from phpMyAdmin, check the permissions to execute a stored procedure.

[BDemeuse]

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