Searched for the function public.get_key_and_price_id_2 with parameter api_key or with a single unna
I am trying to deploy FireCrawl and Supabase locally. When requesting the interface with:
curl --location 'http://localhost:3002/v0/scrape' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImV4cCI6MTk4MzgxMjk5Nn0.EGIM96RAZx35lJzdJsyH-qQwv8Hdp7fsn3W0YpN81IU' \
--data '{
"url": "https://www.oschina.net/"
}'
I encountered the error:
Error details: {
code: 'PGRST202',
details: 'Searched for the function public.get_key_and_price_id_2 with parameter api_key or with a single unnamed json/jsonb parameter, but no matches were found in the schema cache.',
hint: null,
message: 'Could not find the function public.get_key_and_price_id_2(api_key) in the schema cache'
}
Data received: null
What is this situation, and how should I resolve it?
OSCHINA - 中文开源技术交流社区
OSCHINA.NET 是目前领先的中文开源技术社区。我们传播开源的理念，推广开源项目，为 IT 开发者提供了一个发现、使用、并交流开源技术的平台
3 Replies
Hey Brandon!
Can you send me a copy of your .env file (with api keys covered up?) that will help us debug.
This is my .env file. I already know where the issue is. If I deploy Supabase and Firecrawl locally, some tables and functions are missing, such as coupons, credit_usage, api_keys, subscriptions, and get_key_and_price_id_2. Why is this happening?
@Caleb When I add a job locally, the job data is:
{
"jobData": {
"jobData": {
"request": {
"url": "http://localhost:3002/v0/scrape",
"method": "POST",
"headers": {
"Content-Type": "application/json",
"Authorization": "Bearer 3d478a29-6e59-403e-85c7-94aba81ffd2a"
},
"body": {
"url": "https://www.linktimecloud.com/"
}
}
},
"returnValue": null
},
"returnValue": null
}
When executing, I get the error:
Missing process handler for job type linktime
at Queue.processJob (/Users/sunyuan/workspace/firecrawl/apps/api/node_modules/.pnpm/bull@4.15.0/node_modules/bull/lib/queue.js:1190:7)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
Error: Missing process handler for job type linktime
at Queue.processJob (/Users/sunyuan/workspace/firecrawl/apps/api/node_modules/.pnpm/bull@4.15.0/node_modules/bull/lib/queue.js:1190:7)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
How can I resolve this? Is it a configuration error?
LINKTIME CLOUD
BDOS 大数据操作系统
智领云科技-连接数据，驱动未来 - BDOS 大数据操作系统
智领云专注于大数据、云计算领域的核心技术研发，为企业级客户提供云原生数据中台系统解决方案，快速实现数据价值，降本增效，助力企业数字化转型，在激烈的市场中获得竞争优势。