CRM Issue Resolution and Query Optimization

Job ID: 39182455

Budget: €30 – €250 EUR

? Hello, I need a developer to fix an issue in my CRM (built on Lovable CRM).

? Current Issue:

I have a contacts table that stores both businesses and individuals (Admins, Designers, Clients).
When selecting a business for a quotation, I get an error:
? "Failed to update quotation: argument of AND must not return a set."
The CRM is not correctly fetching the business data from the contacts table.
I need the system to correctly select only one business using its id (UUID).

✅ What I Need Done:

Fix the quotation issue (ensure that only one business is selected without errors).
Verify and clean up queries in the system to avoid future problems.
Help prepare for future work, such as database transfer and login management.

? Future Work for the Right Developer:

After this issue is fixed, I will need help with database migration and authentication improvements.
I want a long-term developer who is honest and reliable.

? Budget: Open to fair offers, but I prefer someone who works efficiently.
? Timeline: I need this issue fixed ASAP.
Related categories: SQL CRM MySQL PostgreSQL Database Programming