No credit card required

MySQL Insert

petr_cermak/mysql-insert

Try for free

No credit card required

This act takes a crawler execution and inserts it's results into a remote MySQL database.

All issues Create new issue

Passing invalid SQL

Open

giant_crab opened this issue

2024-03-27T19:42:16.984Z ERROR processResults 2024-03-27T19:42:16.986Z Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ','[object Object]','[object Object]', '[object Object]', '[object Object]', '[ob' at line 1 2024-03-27T19:42:16.987Z at PromisePool.query (/usr/src/app/node_modules/mysql2/promise.js:341:22) 2024-03-27T19:42:16.989Z at processResults (/usr/src/app/main.js:61:44) 2024-03-27T19:42:16.990Z at processTicksAndRejections (node:internal/process/task_queues:96:5) 2024-03-27T19:42:16.991Z at async processFn (/usr/src/app/main.js:80:21) 2024-03-27T19:42:16.993Z at async bluebird.map.concurrency (/usr/src/app/src/fns.js:260:17)

Add comment

Developer

Petr Cermak

Actor metrics

1 monthly users
0.0% runs succeeded
75.2 days response time
Created in Jul 2017
Modified 8 months ago

Categories

Developer tools

Integrations

Web Scraper

apify/web-scraper

Crawls arbitrary websites using the Chrome browser and extracts data from pages using a provided JavaScript code. The actor supports both recursive crawling and lists of URLs and automatically manages concurrency for maximum performance. This is Apify's basic tool for web crawling and scraping.

Apify

62.7k

Website Content Crawler

apify/website-content-crawler

Automatically crawl and extract text content from websites with documentation, knowledge bases, help centers, or blogs. This Actor is designed to provide data to feed, fine-tune, or train large language models such as ChatGPT or LLaMA.

Apify

12.9k

Cheerio Scraper

apify/cheerio-scraper

Crawls websites using raw HTTP requests, parses the HTML with the Cheerio library, and extracts data from the pages using a Node.js code. Supports both recursive crawling and lists of URLs. This actor is a high-performance alternative to apify/web-scraper for websites that do not require JavaScript.

Apify

4.2k

Puppeteer Scraper

apify/puppeteer-scraper

Crawls websites with the headless Chrome and Puppeteer library using a provided server-side Node.js code. This crawler is an alternative to apify/web-scraper that gives you finer control over the process. Supports both recursive crawling and list of URLs. Supports login to website.

Apify

3.2k

Merge, Dedup & Transform Datasets

lukaskrivka/dedup-datasets

The ultimate dataset processor. Extremely fast merging, deduplications & transformations all in a single run.

Lukáš Křivka

1.7k

Actor fail manager

lukaskrivka/actor-fail-manager

Automatically triggered on a failed run to analyze if the run should be resurrected and to create an error report for the author.

Lukáš Křivka

2.6k

Send Email

apify/send-mail

The actor automatically sends an email to a specific address. This actor is useful for notifications and reporting. With only 3 lines of javascript code, you'll be on top of your scraping actors and never miss important results or issues.

Apify

2.4k

BeautifulSoup Scraper

apify/beautifulsoup-scraper

Crawls websites using raw HTTP requests. It parses the HTML with the BeautifulSoup library and extracts data from the pages using Python code. Supports both recursive crawling and lists of URLs. This Actor is a Python alternative to Cheerio Scraper.

Apify

599

Website Screenshot Generator

apify/screenshot-url

Create a screenshot of a website based on a specified URL. The screenshot is stored as the output in a key-value store. It can be used to monitor web changes regularly after setting up the scheduler.

Apify

2.4k