Question

Scrapy pipeline not showing errors but not inserting items in mysql (on local works)

Posted March 10, 2017 2.7k views
UbuntuMySQLPython

I have a scrapy spider that is working correctly on local, but on the server is not adding the items to the database, it doesn’t show any error and all the modules are imported correctly, for the connection to mysql i use twisted adbapi. I checked over and over again the credentials of mysql, but the problem persist, i also changed the bind-address in mysql conf and restarted mysql, but with no luck, I really don’t know what can be the problem. Please help. Thanks.

2 comments

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

This question was answered by @ashram78:

i solved by adding a debug to the query, mysql was translating warnings in errors. thanks

View the original comment

Submit an Answer