Why would this page not display? #87080

Elindo586 · 2025-12-11T21:15:07Z

Elindo586
Dec 11, 2025

Summary

So, it was working before, but maybe some changes happened and the page stopped working?

I changed the code recently to try to fix it, but it just doesn't display the html anymore.

code below:
https://github.com/Elindo586/estuff/blob/main/app/my/un1/%5Bemail%5D/%5Bcampid%5D/route.js


import { neon } from "@neondatabase/serverless";

// Create the sql instance once (reused across invocations)
const sql = neon(process.env.DATABASE_URL);

export async function GET(request, { params }) {
  const { email: userEmail, campid: campId } = params;

  // Basic validation
  if (!userEmail || !campId) {
    return new Response("Missing email or campId", { status: 400 });
  }

  // Properly formatted date: 2025/01/15 at 14:30:05
  const now = new Date();
  const year = now.getFullYear();
  const month = String(now.getMonth() + 1).padStart(2, "0");
  const day = String(now.getDate()).padStart(2, "0");
  const hour = String(now.getHours()).padStart(2, "0");
  const minute = String(now.getMinutes()).padStart(2, "0");
  const second = String(now.getSeconds()).padStart(2, "0");

  const formattedDate = `${year}/${month}/${day} at ${hour}:${minute}:${second}`;

  try {
    // Safe parameterized query – no SQL injection
    await sql`
      INSERT INTO unsub (email, "campId", date)
      VALUES (${userEmail}, ${campId}, ${formattedDate})
    `;

    const html = `
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Unsubscribed</title>
  <style>
    body { font-family: system-ui, sans-serif; text-align: center; padding: 60px; background: #f9fafb; color: #1f2937; }
    .box { max-width: 500px; margin: 0 auto; background: white; padding: 40px; border-radius: 12px; box-shadow: 0 4px 20px rgba(0,0,0,0.1); }
    h1 { color: #3b82f6; }
  </style>
</head>
<body>
  <div class="box">
    <h1>Unsubscribed Successfully</h1>
    <p><strong>Email:</strong> ${userEmail}</p>
    <p><em>${formattedDate}</em></p>
    <p>You will no longer receive emails from this campaign.</p>
  </div>
</body>
</html>
    `;

    return new Response(html, {
      status: 200,
      headers: { "Content-Type": "text/html" },
    });
  } catch (error) {
    console.error("Database error:", error);
    return new Response("Sorry, something went wrong. Please try again later.", {
      status: 500,
    });
  }
}```

Answered by Elindo586

Dec 11, 2025

Ok...

I needed to add "await" before the params..

That was a changed from a while ago, but I needed to fix it on each page....

Must test everything every single time... you never know when something changes.

View full answer

Elindo586 · 2025-12-11T21:18:56Z

Elindo586
Dec 11, 2025
Author

BTW... it does add data to the database, but it doesn't display the html...

0 replies

Elindo586 · 2025-12-11T21:25:35Z

Elindo586
Dec 11, 2025
Author

nope.. not adding data...

maybe something with the database.... must check..

0 replies

Elindo586 · 2025-12-11T21:39:47Z

Elindo586
Dec 11, 2025
Author

Ok...

I needed to add "await" before the params..

That was a changed from a while ago, but I needed to fix it on each page....

Must test everything every single time... you never know when something changes.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Why would this page not display? #87080

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 3 comments

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Why would this page not display? #87080

Uh oh!

Uh oh!

Elindo586 Dec 11, 2025

Summary

Replies: 3 comments

Uh oh!

Elindo586 Dec 11, 2025 Author

Uh oh!

Elindo586 Dec 11, 2025 Author

Uh oh!

Elindo586 Dec 11, 2025 Author

Elindo586
Dec 11, 2025

Elindo586
Dec 11, 2025
Author

Elindo586
Dec 11, 2025
Author

Elindo586
Dec 11, 2025
Author