what does the 500 error say?

[GET] /api/todos status=500

[POST] /api/todos status=500

Are you sending the requests to the deployed URL?

no error message?
try to log the error in a try/catch block on /api/todos

here is my code, i did use try catch:
export async function GET (req: Request) {

try {
const query = SELECT * FROM todos;

const data = (await cassandraDb.execute(query, [], { prepare: true })).rows.map((row ) => ({
id: row.todo_id?.toString(),
title: row.todo,
userId: row.user_id
}))


return NextResponse.json(data)



} catch (error) {

console.log('TODO_ROUTE_ERROR', error);
return new NextResponse('Something went wrong', { status: 500 })

}

};


// ADDING DATA

export async function POST (req: Request) {
try {
const { userId } = auth()
const values = await req.json();
const todoId = crypto.randomUUID();

const validatedFields = formSchema.safeParse(values);
if(!validatedFields.success) {
return new NextResponse('Invalid fields!', { status: 400 })
};

const { todo } = validatedFields.data;





const query = INSERT INTO todos (todo_id, todo, user_id) VALUES (?, ?, ?);

await cassandraDb.execute(query, [todoId, todo, userId], { prepare: true });

return NextResponse.json({ success: todo })







} catch (error) {
console.log('TODO_ROUTE_ERROR', error);
return new NextResponse('Something went wrong', { status: 500 })



}
}

yes

check the environment variables on vercel

see i already have the environmental variables

do you have Restrict Public Access enabled on astra?

no am not using that : also i tried using server actions and i got the same errors too, see my screenshots below:

I think vercel is not recognizing secure-connect.zip, what do i do

what is secure-connect.zip?

could you show the code on where you use it

here is the file, amd am using it in cassandra.ts,

here is my project in github: https://github.com/yaninyzwitty/cassandra-next-14

and my server actions one: https://github.com/yaninyzwitty/cassandra-next-14-server-actions

try

cloud: {
  secureConnectBundle: process.cwd() + '/secure-connect.zip'
}

These are the errors that i get on the browser and logs panel in vercel:

Hi ray, i want to express my sincere gratitude for helping me identify and fix the bug , Am very thankful that it truly works, thanks once again for offering your time to give me that help. 🙏🏼🙏🏼