/var/log/mysqlОшибка: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting\import cv2
import pickle
import face_recognition
import mysql.connector as mysql
conn = mysql.connect(
host = 'localhost',
user = 'root',
passwd = 'superpassword'
)
# Open image
img = face_recognition.load_image_file('test.jpg')
# Get vector
face_vector = face_recognition.face_encodings(img)[0]
cur = conn.cursor(buffered=True)
cur.execute("CREATE DATABASE IF NOT EXISTS test;")
cur.execute("USE test;")
# WITHOUT UTF-8 I GETTING THIS ERROR:
# Error: mysql.connector.errors.DataError: 1366 (22007): Incorrect string value: '\xF0\x9D\x95\xB2' for column `test`.`test`.`bug_char` at row 1
#cur.execute("SET NAMES 'utf8';")
#cur.execute("SET CHARACTER SET utf8;")
cur.execute("CREATE TABLE faces(bug_char VARCHAR(32), vectors BLOB)")
data_insert = ('', pickle.dumps(face_vector))
cur.execute('INSERT INTO faces(bug_char, vectors) VALUES(%s, %s)', data_insert)
cur.execute("SELECT * FROM faces;")
face_data = cur.fetchall()
for f in face_data:
print(pickle.loads(f[1]))
# AND WITH UTF-8 I GETTING THIS ERROR WHEN I TRY TO GET MY OBJ FROM DB:
'''
Traceback (most recent call last):
File "/home/user/Desktop/parser_steam/image_recognition/test/./test.py", line 203, in <module>
print(pickle.loads(f[1]))
_pickle.UnpicklingError: invalid load key, '?'.
'''
Одно фото с котиком и одно с лицом?
Какая информация хранится в faces и photos? Если это только загадочный h1 INT - то нет смысла в отдельных таблицах
и обнаружил что в момент работы скрипта постоянно вылетает вот такая штука: