All Questions
Tagged with error-handling mysql
560
questions
0
votes
1
answer
71
views
Error handling with typeorm, sql in Nestjs
I'm writing a service in Nestjs which uses typeorm to communicate with a MySQL server. Say, I create a table, test_table with two columns col1 and col2, col1 having a UNIQUE constraint.
If try to ...
0
votes
1
answer
18
views
php 8.1 + mysql 5.7: error handler in stored procedure dosen't work
I have a stored procedure with which I try to insert some data into two tables but I don't want to insert duplicate keys. So I wrote the following procedure with the handling of error 1062: duplicate ...
1
vote
1
answer
31
views
How do i specifically save the data without it showing in the jTable?
I want the program to be precise on putting the data in the Jtable, without messing up my sql database.
The Jtable structure only has, NAME, USERNAME, EMAIL, PASS, GENDER, and STATUS.
my sql database ...
-1
votes
1
answer
40
views
Can't replace linebreaks in an mysql error string [closed]
I try to catch erros from a prepared MySQL statement.
try {
if ($stmt = $this->db->prepare($q)) {
array_unshift($sqlData, $sqlTypes); // prepend the types
if(call_user_func_array(...
-2
votes
2
answers
173
views
artifactory upgrade from 7.19.4 to 7.77.5
[ steps ]
stop artifactory
stop mysql
Upgrade Ubuntu 14.04 to 16.07
Upgrade mysql-server to 5.7
Downloaded 7.75.5.tar.gz file put it into /opt/jfrog/artifactory
untared 7.77.5.tar.gz
removed /opt/...
0
votes
1
answer
41
views
MySQL ERR in Express Back-End Server
I am facing an MySQL err while I am executing a query on my Express server.
My code is as follows.
module.exports.generateDailyWords = async function () {
try {
// generate the shape of word ...
0
votes
1
answer
46
views
Whenever I submit a user update form in my dashboard, my error array returns a flag for unchanged values
Currently working on a project that requires me to build an admin area for an admin to manage users and permissions.
I'm using an array to return errors to admins if they submit duplicate data to ...
0
votes
2
answers
143
views
How can I parse through an array in PHP and treat each element as a string? [duplicate]
I am working on a project where I need to turn an array of strings into an SQL query. In order to do so, I am attempting to parse through the array and place each element in a string to be sent to ...
0
votes
0
answers
118
views
MySQL Dealing with Nested Transactional Stored Procedures [8.0.34]
UPDATE 11.22.2023
Helpful documentation confirming a deadlock always nullifies the entire transaction.
https://dev.mysql.com/doc/refman/8.0/en/innodb-error-handling.html
Still haven't found a rock-...
1
vote
0
answers
102
views
MySQL AWS Record Locking Timeout not appearing in Slow Query Log?
UPDATED BELOW 11.09.2023
We have a sizeable database of roughly 200,000 lines of code complete with read-replica hosted on AWS. The problem is we're occasionally encountering a deadlock timeout error ...
2
votes
2
answers
141
views
MySQL - Best Internal Error Handling Technique for AWS RDS and RR Support
We have a custom-built CRM system that's deployed on AWS RDS. Our FE and BE systems are JavaScript, and the database prohibits the JS devs from directly manipulating the database. They must go through ...
0
votes
0
answers
420
views
Why null pointer exception was giving in jQuary section please give me brief explanation [duplicate]
this is the problem while I am hitting api it will give this error
java.lang.NullPointerException: Cannot invoke "org.hibernate.metamodel.mapping.JdbcMapping.getJdbcValueBinder()" because &...
0
votes
0
answers
53
views
How we can get the response back while calling stored procedure in laravel
call temp(1, 1, 155823); When I run this query in my MySQL workbench, it gives me error like Subquery returns more than 1 row.
But when I call the exact same stored Procedure from my Laravel ...
0
votes
0
answers
18
views
Error: Packets out of order. Got: 0 Expected: 88 on node.js server using mysql library
I have a project in production that since users that using it, im getting the error Error: Packets out of order. Got: 0 Expected: 88 once in a while mostly at night times when there is no users active ...
0
votes
2
answers
392
views
Error: Access denied for user 'root'@'localhost' (using password: YES) using mysql in Spring Boot
I am creating a Spring Boot application using the mysql database dependency however I am getting the error:
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
I ...