Failed to insert record into MySQL table.Python type tuple cannot be converted

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Failed to insert record into MySQL table.Python type tuple cannot be converted

buran

Posts: 8,090

Threads: 154

Joined: Sep 2016

Reputation: 582

Dec-26-2019, 02:01 PM

probably because row is tuple
try records_to_insert = (str(row),sentiment_dict['compound'], sentiment) if you really want to insert the whole row tuple

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Find

Messages In This Thread

Failed to insert record into MySQL table.Python type tuple cannot be converted - by farah97 - Dec-26-2019, 12:26 PM

RE: Failed to insert record into MySQL table.Python type tuple cannot be converted - by buran - Dec-26-2019, 12:55 PM

RE: Failed to insert record into MySQL table.Python type tuple cannot be converted - by farah97 - Dec-26-2019, 01:04 PM

RE: Failed to insert record into MySQL table.Python type tuple cannot be converted - by buran - Dec-26-2019, 02:01 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Last record in file doesn't write to newline	gonksoup	3	435	Jan-22-2024, 12:56 PM Last Post: deanhystad
	Failed attempts to load Microsoft Appstore Python DLLs	piyushd	0	439	Oct-31-2023, 10:43 AM Last Post: piyushd
	How do I stream and record at the same time with arducam?	traderjoe	0	468	Oct-23-2023, 12:01 AM Last Post: traderjoe
	Mysql and mysql.connector error	lostintime	2	687	Oct-03-2023, 10:25 PM Last Post: lostintime
	Insert 10gb csv files into sql table via python	mg24	2	1,940	Apr-28-2023, 04:14 PM Last Post: snippsat
	Converted EXE file size is too large	Rajasekaran	0	1,523	Mar-30-2023, 11:50 AM Last Post: Rajasekaran
	Python Serial: How to read the complete line to insert to MySQL?	sylar	1	830	Mar-21-2023, 10:06 PM Last Post: deanhystad
	Mysql Workbench table not updated	CatBall	2	1,116	Feb-13-2023, 05:37 PM Last Post: CatBall
	How to select NULL and blank values from MySQL table into csv	python300	9	2,451	Dec-27-2022, 09:43 PM Last Post: deanhystad
	[ERROR] ParamValidationError: Parameter validation failed: Invalid type for parameter	gdbengo	3	11,080	Dec-26-2022, 08:48 AM Last Post: ibreeden

Users browsing this thread: 2 Guest(s)

View a Printable Version

Failed to insert record into MySQL table.Python type tuple cannot be converted

User Panel Messages

Announcements