3,192 questions
0votes
0answers
42views
Python 3 Flask MySQL connection and handle error
I am build a system include server, mobile app and desktop app. server.py from flask import Flask, jsonify, request, g, send_file from flask_cors import CORS import mysql.connector import data.data as ...
0votes
0answers
21views
Mysql 5.5..33 : (5010, "Authentication plugin 'mysql_old_password' couldn't be found in restricted_auth plugin list.") [duplicate]
When I am trying to connect the MySQL db that hosted in remote via the python library MySQLdb, I am getting the following error. (5010, "Authentication plugin 'mysql_old_password' couldn't be ...
0votes
3answers
165views
mysql.connector.connect failing to connect
While trying to connect Python with SQL, it just does not work, with no errors, the execution stops itself, here's the code: import mysql.connector def appen(): print('k') mysq = mysql....
1vote
1answer
64views
Saving data to the database in django [duplicate]
I am working on a website to recommend stocks on the stock market, based on historically reliable trading strategies. When running the server, I can't see any of the data which is supposed to be shown ...
0votes
0answers
33views
I am having a problem in MySQL connection in Python which I never had before [duplicate]
Traceback (most recent call last): File "S:\Python\lib\site-packages\mysql\connector\network.py", line 733, in open_connection self.sock.connect(sockaddr) ConnectionRefusedError: [...
0votes
0answers
21views
Getting intermittent InterfaceError(0, '') in Django3.2 with MySQL5.7
I am using an EC2 server to run a listener cron in python using Django 3.2 and connecting to MySQL 5.7 using a global connection. I am facing intermittent InterfaceError(0, '') in the logs and this is ...
0votes
0answers
64views
Unable to connect MySQL (xampp) using Python
import mysql.connector conn = mysql.connector.connect(host="localhost", user="root", password="") if conn.is_connected(): print("Successful") else: ...
0votes
0answers
37views
Wagtail django.db.utils.OperationalError: (1463, "Non-grouping field 'numchild' is used in HAVING clause")
I'm working on a Django project and I've encountered an issue that I'm unable to resolve. When I try to run my application, I get the following error: django.db.utils.OperationalError: (1463, "...
0votes
1answer
65views
Can't connect to mysql database from the python code using mysql.connector
I m unable to connect to my database and it gives this error that object is not callable. I did search up the error and even what it means. I changed a lots of stuff in the code but it didn't work for ...
0votes
0answers
15views
ATTRIBUTEERROR: module 'mysqldb.constants.er' has no attribute 'constraint_failed' [duplicate]
im trying to connect Mysql database with my django project. i get this after running my project: Traceback (most recent call last): File "C:\python\lib\threading.py", line 1016, in ...
0votes
1answer
68views
Permission danied when reading file from /var/lib/mysql-files
I am using cursor.execute to generate the file my_file.csv and save it in /var/lib/mysql-files. Here is my code: import mysql.connector connection = mysql.connector.connect(host='localhost', port='...
1vote
0answers
20views
Error to parse pickled data to/from database [duplicate]
I am trying to store pickled object into database and unpickle it back. Data is being stored in database, however after reading data its throwing an error during unpickle. Traceback (most recent call ...
2votes
0answers
115views
How do I use a loop to update the progress of my entire code in python using a progress bar
I have a code that pulls data from mysql database using python mysql connector and I want to create a progress bar in python using tkinter that shows query execution progress. I have created a loop ...
0votes
0answers
28views
ERROR: root: Error fetching patient details: PatientView.html
I'm trying to create a simple webpage using Flask. I have written code to fetch data from a MySQL database, but the code is not working, and I keep getting the error: Error: root: Error fetching ...
1vote
0answers
54views
SQLAlchemy difference between regular query and text
I am trying to insert new rows in a table that might already exist with constant values given from my application. I have tried to create the following code: with engine.begin() as con: con....