CRM · Advertising · Websites · Automation

CRM, advertising and automation guides for businesses.

Learn how to choose a CRM, decide between Google and Facebook ads, calculate campaign budgets, improve lead quality and automate follow-up. The technical troubleshooting library is still available.

Looking for the broader strategy? Explore the marketing, CRM and SEO blog.

Browse by topic

464 English guides

All English business and technical guides

Supabase and databases

Supabase: Administrator sees record, user not — RLS diagnosis

How to compare SELECT roles and principles in the Supabase when the admin panel works and the sales representative's account shows voidness.

Read the solution
Supabase and databases

Supabase: DELETE does not remove the record, although it returns success

After clicking remove the item remains in the database, and the delete() request does not report an exception.

Read the solution
Supabase and databases

Supabase: INSERT Succeeds but SELECT Returns No Rows

Record saved, but invisible after refresh? Check separate INSERT and SELECT, Owner id and JWT policies.

Read the solution
Supabase and databases

Supabase: IPv4 Client Cannot Use Direct Database Connection

The driver outside the host reports a timeout at direct connection, even though the credentials are correct.

Read the solution
Supabase and databases

Supabase: new row Violates row-level security policy at INSERT

Trying to save a new record returns a row-level security policy error, although SELECT works.

Read the solution
Supabase and databases

Supabase: Password Recovery Opens Without a Session

Upon clicking the password change link, the page does not recognize recovery mode.

Read the solution
Supabase and databases

Supabase: Permission Denied for Schema public

The API request ends with a permission denied for scheme public, although RLS policies look correct.

Read the solution
Supabase and databases

Supabase: Refresh Token Expired — Troubleshooting

Diagnostic instruction regarding the situation when token refresh (refresh token) Supabase expired or is rejected. Includes a differential list of causes, specific tests and corrective steps, and methods of post-amendment performance verification.

Read the solution
Supabase and databases

Supabase: Restoring backup does not restore recent changes

Once the database has been recovered, some of the last records are absent.

Read the solution
Supabase and databases

Supabase: SELECT returns empty results despite valid authorization — RLS diagnostic

Analysis of the reasons why Row Level Security (RLS) in Supabase blocks SELECT queries despite the visible user session. It includes differentiation of rules, permission limits, verification of jwt and policies, and specific test steps for repair.

Read the solution
Supabase and databases

Supabase: signed file URL stops working — differentiation and repair

Signed URL with Supabase Storage ceases to work abruptly — causes include the link expired, changed bucket permissions, object removal, server time errors or CDN. Below is differential diagnosis and specific corrective steps.

Read the solution
Supabase and databases

Supabase: SQL view shows other people's data despite RLS enabled

The query directly to the table respects RLS policies, but the SQL view API returns other people's lines to the user.

Read the solution
Supabase and databases

Supabase: too many clients already connected to PostgreSQL

The application periodically stops connecting to the database and logs in too many clients already.

Read the solution
Supabase and databases

Supabase: UPDATE ends without error, but does not change anything

Calling update().eq() returns an empty result, although the record exists in the database.

Read the solution
Supabase and databases

Supabase/PostgreSQL: Foreign Key Constraint Blocks User Deletion

Description of the diagnosis and repair procedure when an attempt to remove the user ends with a reference error: how to find dependent tables, check constraints, RLS policies and triggers, and safely remove or migrate the data.

Read the solution
Business ideas and activity codes

Tattoo studio in Poland: PKD 96.99.Z, VAT and costs

Polish tattoo studio activity code, a sample budget, revenue lump-sum tax and why 8% VAT cannot be assumed.

Read the solution
CRM and lead management

The AI assistant on the site generates costs — how to set limits?

How to protect the company's API chatbot from excessive wear, spam, long contexts and uncontrolled bills.

Read the solution
SEO and Google Search

The company operates all over Poland — how to make SEO without fictional branches?

How to promote nationwide services through industry content, case studies and a real area of activity.

Read the solution
Vercel and hosting

The environmental variable works locally and on Vercel does not

Local env file is not automatically a production configuration. Vercel separates the environment, and some variables of Next.js go to the code already when building

Read the solution
Forms and APIs

The form on the website does not send messages — what do you check in the API?

You click Send and nothing happens? How to track the form from your browser through API to email or CRM.

Read the solution
Domains and email

The login code comes to Apple’s private address — how do I get access back?

Verification sent to Hide My Email or Private Relay. How to find an alias and change your contact address.

Read the solution
Next.js, React and TypeScript

The site in React looks good, but the robot sees little content

CSR vs SSR and static rendering in React/Next.js. How to make sure the text and links are available to Google.

Read the solution
SEO and Google Search

The site works, but Google does not index it — check order

Working domain and site map do not guarantee presence in the results. First check availability and technical signals, then quality and content connections.

Read the solution
Meta Ads and advertising

TikTok Ads for businesses: how to start and when it makes sense

An introduction to TikTok advertising: video creative, audiences, account minimums and conversion tracking.

Read the solution

Switch to Polish guides

Guides for businesses: CRM, online ads, websites and