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.

Back to 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 user
1 star
0% runs succeeded
Created in Jul 2017
Modified a year ago

Categories

Developer tools

Integrations

MySQL Insert

petr_cermak/MySQL-insert

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

Petr Cermak

Microsoft SQL Server Insert

petr_cermak/MSSQL-insert

This actor takes a crawler execution and inserts its results into a remote MSSQL database.

Petr Cermak

Website Content Crawler

apify/website-content-crawler

Crawl websites and extract text content to feed AI models, LLM applications, vector databases, or RAG pipelines. The Actor supports rich formatting using Markdown, cleans the HTML, downloads files, and integrates well with 🦜🔗 LangChain, LlamaIndex, and the wider LLM ecosystem.

Apify

28.4k

716

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

5.7k

Web Scraper

apify/web-scraper

Crawls arbitrary websites using the Chrome browser and extracts data from pages using 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

72.3k

244

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

4.7k

Legacy PhantomJS Crawler

apify/legacy-phantomjs-crawler

Replacement for the legacy Apify Crawler product with a backward-compatible interface. The actor uses PhantomJS headless browser to recursively crawl websites and extract data from them using a piece of front-end JavaScript code.

Apify

1.6k

Extended GPT Scraper

drobnikj/extended-gpt-scraper

Extract data from any website and feed it into GPT via the OpenAI API. Use ChatGPT to proofread content, analyze sentiment, summarize reviews, extract contact details, and much more.

Jakub Drobník

1.2k

Playwright Scraper

apify/playwright-scraper

Crawls websites with the headless Chromium, Chrome, or Firefox browser and Playwright library using a provided server-side Node.js code. Supports both recursive crawling and a list of URLs. Supports login to a website.

Apify

877

Monitoring Reporter Dashboard

apify/monitoring-reporter-dashboard

The monitoring reporter dashboard is a part of the Apify Monitoring Suite (apify/monitoring). See its readme for more information and how to use this.

Apify