MySQL Procedure Fixing API stored procedure Errors.
Budget: $15 – $25 USD
I have magento as the base API
when we run the stored procedures the SP works fine
When we then run the SP in loops to cover all areas via PHP that calls the SP then the issue throws SQL error:
"SQLSTATE[HY000]: General error (0)"
I am not sure why. I suspect it it is locking processes but I am not sure.
This is affecting several APIs so it must be resolved immediately
But it seems to be possible to resolve it locally in he phpo code also I have seen on tickets.
The work requires:
- In-depth understanding of MySQL stored procedures
- Extensive knowledge of Magento interface
- Experience in API error troubleshooting
- Expertise in handling 'data missing in response' type errors
The ideal freelancer is one who is meticulous in bug detection and correction, has handled similar API issues in the past, and prioritizes effective, timely communication throughout the project.
when we run the stored procedures the SP works fine
When we then run the SP in loops to cover all areas via PHP that calls the SP then the issue throws SQL error:
"SQLSTATE[HY000]: General error (0)"
I am not sure why. I suspect it it is locking processes but I am not sure.
This is affecting several APIs so it must be resolved immediately
But it seems to be possible to resolve it locally in he phpo code also I have seen on tickets.
The work requires:
- In-depth understanding of MySQL stored procedures
- Extensive knowledge of Magento interface
- Experience in API error troubleshooting
- Expertise in handling 'data missing in response' type errors
The ideal freelancer is one who is meticulous in bug detection and correction, has handled similar API issues in the past, and prioritizes effective, timely communication throughout the project.