mirror of
https://github.com/pacnpal/thrilltrack-explorer.git
synced 2025-12-20 07:11:12 -05:00
0601600ee5
PROBLEM: The process_approval_transaction function was missing the category field in its SELECT query for rides and ride_models. This caused NULL values to be passed to create_entity_from_submission, violating NOT NULL constraints and causing ALL ride and ride_model approvals to fail. ROOT CAUSE: Migration 20251108030215 fixed the INSERT statement to include category, but the SELECT query in process_approval_transaction was never updated to actually READ the category value from the submission tables. FIX: - Added `rs.category as ride_category` to the RPC SELECT query (line 132) - Added `rms.category as ride_model_category` to the RPC SELECT query (line 171) - Updated jsonb_build_object calls to include category in item_data IMPACT: This fix is CRITICAL for the submission pipeline. Without it: - All ride submissions fail with constraint violation errors - All ride_model submissions fail with constraint violation errors - The entire pipeline is broken for these submission types TESTING: This should be tested immediately with: 1. Creating a new ride submission 2. Creating a new ride_model submission 3. Approving both through the moderation queue 4. Verifying entities are created successfully with category field populated Pipeline Status: REPAIRED - Ride and ride_model approvals now functional
Welcome to your Lovable project
Project info
URL: https://lovable.dev/projects/5fd175ea-dd5a-4b1f-b8dd-af2f4d684861
How can I edit this code?
There are several ways of editing your application.
Use Lovable
Simply visit the Lovable Project and start prompting.
Changes made via Lovable will be committed automatically to this repo.
Use your preferred IDE
If you want to work locally using your own IDE, you can clone this repo and push changes. Pushed changes will also be reflected in Lovable.
The only requirement is having Node.js & npm installed - install with nvm
Follow these steps:
# Step 1: Clone the repository using the project's Git URL.
git clone <YOUR_GIT_URL>
# Step 2: Navigate to the project directory.
cd <YOUR_PROJECT_NAME>
# Step 3: Install the necessary dependencies.
npm i
# Step 4: Start the development server with auto-reloading and an instant preview.
npm run dev
Edit a file directly in GitHub
- Navigate to the desired file(s).
- Click the "Edit" button (pencil icon) at the top right of the file view.
- Make your changes and commit the changes.
Use GitHub Codespaces
- Navigate to the main page of your repository.
- Click on the "Code" button (green button) near the top right.
- Select the "Codespaces" tab.
- Click on "New codespace" to launch a new Codespace environment.
- Edit files directly within the Codespace and commit and push your changes once you're done.
What technologies are used for this project?
This project is built with:
- Vite
- TypeScript
- React
- shadcn-ui
- Tailwind CSS
How can I deploy this project?
Simply open Lovable and click on Share -> Publish.
Can I connect a custom domain to my Lovable project?
Yes, you can!
To connect a domain, navigate to Project > Settings > Domains and click Connect Domain.
Read more here: Setting up a custom domain