Skip to content

rstar327/castiko

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

Profile Schema Fixes

If you encounter issues with profile form fields not being saved or displayed correctly, there are SQL fixes available in the sql/fixes directory.

To apply these fixes, you need to run them in your Supabase SQL Editor in the following order:

  1. 01_fix_columns.sql - Ensures all required columns exist with correct types
  2. 02_social_json_trigger.sql - Adds a trigger to maintain proper JSON structure
  3. 03_debug_view.sql - Creates a view to help with debugging profile issues
  4. 04_migration_script.sql - Updates existing profiles with the proper structure
  5. 05_storage_bucket_policy.sql - Fixes storage bucket configuration for image uploads
  6. 06_fix_profiles_debug.sql - Provides debugging utilities for profile photos

These scripts will fix:

  • Missing date_of_birth and whatsapp_link fields
  • Profile image not being saved
  • Photo gallery not saving properly
  • Skills and languages not being stored as arrays
  • Introduction video and additional video links not being saved
  • Storage permission issues for uploading profile and gallery images

After applying the fixes, you may need to edit your profile again to update the data.

Setting Up the Skills Database

The application uses a categorized skills system that requires initial database setup. If you're seeing errors like:

GET https://byxyyaxpdtsaklfwmszk.supabase.co/rest/v1/skills?select=*&order=category.asc%2Cskill_name.asc 404 (Not Found)
Error fetching skills: {code: '42P01', details: null, hint: null, message: 'relation "public.skills" does not exist'}

You need to set up the skills database tables and seed data. There are several ways to do this:

  1. Recommended: Using the Supabase SQL Editor

    • Log in to your Supabase Dashboard
    • Run the SQL in db/migrations/create_skills_tables.sql to create the tables
    • Run the SQL in db/seed_data/skills_seed.sql to insert the skill data
  2. Using the setup script

    • Set environment variables for Supabase connection
    • Run ./scripts/setup-skills-db.sh

For detailed instructions, see Skills Database Setup Guide.

The skills system has a fallback mode that will still allow the app to function with basic skills even if the database setup isn't complete.

For more information about the skills system architecture, see Skills System Documentation.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •