PS C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project> scrapy crawl maoyan -O output.json
>>
2025-11-14 20:00:28 [scrapy.utils.log] INFO: Scrapy 2.11.0 started (bot: movie_analysis_project)
2025-11-14 20:00:28 [scrapy.utils.log] INFO: Versions: lxml 5.2.1.0, libxml2 2.13.1, cssselect 1.2.0, parsel 1.8.1, w3lib 2.1.2, Twisted 22.10.0, Python 3.12.7 | packaged by Anaconda, Inc. | (main, Oct 4 2024, 13:17:27) [MSC v.1929 64 bit (AMD64)], pyOpenSSL 24.2.1 (OpenSSL 3.0.15 3 Sep 2024), cryptography 43.0.0, Platform Windows-11-10.0.26100-SP0
2025-11-14 20:00:28 [scrapy.addons] INFO: Enabled addons:
[]
2025-11-14 20:00:28 [py.warnings] WARNING: D:\Anaconda\Lib\site-packages\scrapy\utils\request.py:254: ScrapyDeprecationWarning: '2.6' is a deprecated value for the 'REQUEST_FINGERPRINTER_IMPLEMENTATION' setting.
It is also the default value. In other words, it is normal to get this warning if you have not defined a value for the 'REQUEST_FINGERPRINTER_IMPLEMENTATION' setting. This is so for backward compatibility reasons, but it will change in a future version of Scrapy.
See the documentation of the 'REQUEST_FINGERPRINTER_IMPLEMENTATION' setting for information on how to handle this deprecation.
return cls(crawler)
2025-11-14 20:00:28 [scrapy.utils.log] DEBUG: Using reactor: twisted.internet.selectreactor.SelectReactor
2025-11-14 20:00:28 [scrapy.extensions.telnet] INFO: Telnet Password: 59479e7205a4f2a8
2025-11-14 20:00:28 [scrapy.middleware] INFO: Enabled extensions:
['scrapy.extensions.corestats.CoreStats',
'scrapy.extensions.telnet.TelnetConsole',
'scrapy.extensions.feedexport.FeedExporter',
'scrapy.extensions.logstats.LogStats']
2025-11-14 20:00:28 [scrapy.crawler] INFO: Overridden settings:
{'BOT_NAME': 'movie_analysis_project',
'CONCURRENT_REQUESTS': 1,
'DOWNLOAD_DELAY': 3,
'NEWSPIDER_MODULE': 'movie_analysis_project.spiders',
'RETRY_TIMES': 3,
'SPIDER_MODULES': ['movie_analysis_project.spiders'],
'USER_AGENT': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36'}
2025-11-14 20:00:29 [scrapy.middleware] INFO: Enabled downloader middlewares:
['scrapy.downloadermiddlewares.retry.RetryMiddleware',
'scrapy.downloadermiddlewares.httpproxy.HttpProxyMiddleware',
'scrapy.downloadermiddlewares.httpauth.HttpAuthMiddleware',
'scrapy.downloadermiddlewares.downloadtimeout.DownloadTimeoutMiddleware',
'scrapy.downloadermiddlewares.defaultheaders.DefaultHeadersMiddleware',
'scrapy.downloadermiddlewares.redirect.MetaRefreshMiddleware',
'scrapy.downloadermiddlewares.httpcompression.HttpCompressionMiddleware',
'scrapy.downloadermiddlewares.redirect.RedirectMiddleware',
'scrapy.downloadermiddlewares.cookies.CookiesMiddleware',
'scrapy.downloadermiddlewares.stats.DownloaderStats']
2025-11-14 20:00:29 [scrapy.middleware] INFO: Enabled spider middlewares:
['scrapy.spidermiddlewares.httperror.HttpErrorMiddleware',
'scrapy.spidermiddlewares.offsite.OffsiteMiddleware',
'scrapy.spidermiddlewares.referer.RefererMiddleware',
'scrapy.spidermiddlewares.urllength.UrlLengthMiddleware',
'scrapy.spidermiddlewares.depth.DepthMiddleware']
2025-11-14 20:00:32 [scrapy.middleware] INFO: Enabled item pipelines:
['movie_analysis_project.pipelines.DataCleaningPipeline',
'movie_analysis_project.pipelines.MySQLPipeline']
2025-11-14 20:00:32 [scrapy.core.engine] INFO: Spider opened
2025-11-14 20:00:32 [scrapy.extensions.logstats] INFO: Crawled 0 pages (at 0 pages/min), scraped 0 items (at 0 items/min)
2025-11-14 20:00:32 [scrapy.extensions.telnet] INFO: Telnet console listening on 127.0.0.1:6023
2025-11-14 20:00:33 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/movieOnInfoList?token=&optimus_risk_level=71&optimus_code=10> (referer: https://m.maoyan.com/)
2025-11-14 20:00:33 [maoyan] INFO: 状态码: 200
2025-11-14 20:00:36 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1251132> (referer: https://m.maoyan.com/)
2025-11-14 20:00:36 [scrapy.core.scraper] ERROR: Error processing {'title': '三 滴血', 'category': '', 'actors': '胡歌,文淇,高子淇', 'director': None, 'release_date': '2025-11-15', 'score': 0, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:00:38 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1207331> (referer: https://m.maoyan.com/)
2025-11-14 20:00:38 [scrapy.core.scraper] ERROR: Error processing {'title': '731', 'category': '', 'actors': '姜武,王志文,李乃文', 'director': None, 'release_date': '2025-09-18', 'score': 0, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:00:42 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=336673> (referer: https://m.maoyan.com/)
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:00:46 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1500265> (referer: https://m.maoyan.com/)
2025-11-14 20:00:46 [scrapy.core.scraper] ERROR: Error processing {'title': '志愿军:浴血和平', 'category': '', 'actors': '张子枫,宋佳,朱亚文', 'director': None, 'release_date': '2025-09-30', 'score': 9.7, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:00:49 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1523743> (referer: https://m.maoyan.com/)
2025-11-14 20:00:49 [scrapy.core.scraper] ERROR: Error processing {'title': '坏蛋联盟2', 'category': '', 'actors': '山姆·洛克威尔,马克·马龙,奥卡菲娜', 'director': None, 'release_date': '2025-08-16', 'score': 9.3, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:00:52 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1504105> (referer: https://m.maoyan.com/)
2025-11-14 20:00:52 [scrapy.core.scraper] ERROR: Error processing {'title': '狂野时代', 'category': '', 'actors': '易烊千玺,舒淇,赵又廷', 'director': None, 'release_date': '2025-11-22', 'score': 0, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:00:55 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1528086> (referer: https://m.maoyan.com/)
2025-11-14 20:00:55 [scrapy.core.scraper] ERROR: Error processing {'title': '铁血战士:杀戮之地', 'category': '', 'actors': '艾丽·范宁,迪米特里乌斯·舒斯特-科洛阿玛坦吉,Cameron Brown', 'director': None, 'release_date': '2025-11-07', 'score': 9, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:00:59 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1489329> (referer: https://m.maoyan.com/)
2025-11-14 20:00:59 [scrapy.core.scraper] ERROR: Error processing {'title': '浪浪人生', 'category': '', 'actors': '黄渤,范丞丞,殷桃', 'director': None, 'release_date': '2025-09-30', 'score': 9.6, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:01:03 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1505776> (referer: https://m.maoyan.com/)
2025-11-14 20:01:03 [scrapy.core.scraper] ERROR: Error processing {'title': '即兴谋杀', 'category': '', 'actors': '李庚希,邓家佳,刘奕铁', 'director': None, 'release_date': '2025-10-31', 'score': 0, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:01:07 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1515448> (referer: https://m.maoyan.com/)
2025-11-14 20:01:07 [scrapy.core.scraper] ERROR: Error processing {'title': '浪浪山小妖怪', 'category': '', 'actors': '陈子平,路扬,董汶亮', 'director': None, 'release_date': '2025-08-02', 'score': 9.5, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:01:09 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=346650> (referer: https://m.maoyan.com/)
2025-11-14 20:01:09 [scrapy.core.scraper] ERROR: Error processing {'title': '惊天魔盗团3', 'category': '', 'actors': '杰西·艾森伯格,伍迪·哈里森,戴夫·弗兰科', 'director': None, 'release_date': '2025-11-14', 'score': 0, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:01:12 [scrapy.core.engine] DEBUG: Crawled (200) <GET https://m.maoyan.com/ajax/detailmovie?movieId=1528577> (referer: https://m.maoyan.com/)
2025-11-14 20:01:12 [scrapy.core.scraper] ERROR: Error processing {'title': '鬼灭之刃:无限城篇 第一章 猗窝座再袭', 'category': '', 'actors': '花江夏树,鬼头明里,下野纮', 'director': None, 'release_date': '2025-11-14', 'score': 9.7, 'source': 'maoyan'}
Traceback (most recent call last):
File "D:\Anaconda\Lib\site-packages\twisted\internet\defer.py", line 892, in _runCallbacks
current.result = callback( # type: ignore[misc]
File "D:\Anaconda\Lib\site-packages\scrapy\utils\defer.py", line 340, in f
return deferred_from_coro(coro_f(*coro_args, **coro_kwargs))
File "C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project\movie_analysis_project\pipelines.py", line 32, in process_item
adapter['release_date'] = rd.strftime('%Y-%m-%d')
AttributeError: 'str' object has no attribute 'strftime'
2025-11-14 20:01:12 [scrapy.core.engine] INFO: Closing spider (finished)
2025-11-14 20:01:12 [scrapy.extensions.feedexport] INFO: Stored json feed (0 items) in: output.json
2025-11-14 20:01:12 [scrapy.statscollectors] INFO: Dumping Scrapy stats:
{'downloader/request_bytes': 6878,
'downloader/request_count': 13,
'downloader/request_method_count/GET': 13,
'downloader/response_bytes': 33685,
'downloader/response_count': 13,
'downloader/response_status_count/200': 13,
'elapsed_time_seconds': 39.976042,
'feedexport/success_count/FileFeedStorage': 1,
'finish_reason': 'finished',
'finish_time': datetime.datetime(2025, 11, 14, 12, 1, 12, 408271, tzinfo=datetime.timezone.utc),
'httpcompression/response_bytes': 79696,
'httpcompression/response_count': 13,
'log_count/DEBUG': 14,
'log_count/ERROR': 12,
'log_count/INFO': 12,
'log_count/WARNING': 1,
'request_depth_max': 1,
'response_received_count': 13,
'scheduler/dequeued': 13,
'scheduler/dequeued/memory': 13,
'scheduler/enqueued': 13,
'scheduler/enqueued/memory': 13,
'start_time': datetime.datetime(2025, 11, 14, 12, 0, 32, 432229, tzinfo=datetime.timezone.utc)}
2025-11-14 20:01:12 [scrapy.core.engine] INFO: Spider closed (finished)
PS C:\Users\童琪琪\Desktop\bishe.6\biyesheji.6\movie_analysis_project>
后续有修改的代码统一给出完整的修改代码