Find a Xano Expert

Hadi Hassan

Data hidden in another timezone

I'm able to view database records in my own timezone (GMT+5) but my client in (GMT-4) can't view the same data. What can be the issue here?

Data already exists so its not related to data creation

2 replies

This is very likely a timezone issue rather than missing data. In Xano, dates are stored in UTC, so when you or your client query records using filters like “today” or date ranges without properly accounting for timezone differences, the same record can fall inside the range for you (GMT+5) but outside for your client (GMT-4). For example, a timestamp that appears as the same day in your timezone may show as the previous day for your client, which makes it seem like the data is not there.

To fix this, make sure your filtering logic is consistent and timezone-aware. Instead of relying on implicit “today” or local date comparisons, you should normalize everything to UTC and explicitly define your date ranges, or pass the user’s timezone to the backend and calculate the correct start and end of day based on that. The key is ensuring both users are effectively querying the same UTC window, regardless of their local timezone.

Take a closer look at what conversions you are (or aren’t) doing on both the frontend and backend..

Andres

just handle everyting in utc and let the client browser/app handle the timezones you will save headaches

Gordon Kagamba

HTTP-500] Internal Server Error fatal"

I keep running in this error while pulling my Xano workspace "...1: [HTTP-500] Internal Server Error fatal" and "Failed to fetch api endpoints: Unknown Error: ...502 Bad Gateway" which makes my local repo is out of sync with my Xano workspace and yet i work in my local repo. It doesnt matter if i am pulling using my IDE or the XANO CLI, it still brings the same error messages. It has held me back for days and I have reported it to Xano support but i have got nothing for about five days now. Does anyone know how i can overcome this? Its going affect our launch dates...

1
2 replies

If you require any assistance with Xano and need expert help, please contact me at [email protected].

Ray Deck

It does sound like you have a server-side error going on here. The 502 is your Xano being overwhelmed and restarting the web server int he background while refusing traffic, while the 500 is a more common error. What kind of plan are you running? I wonder if the codebase is large and the instance is small (like the old starter plan, or a launch plan), which could put memory pressure on the process.

Jesús Perales Elizondo
Jesús Perales Elizondo
·Building with Xano + Weweb

LinkedIn OAuth

Im getting this error message when trying to take the first steps when installing the extension Does anyone know how to solve it? I think the tutorial video is outdated

1 reply
Jesús Perales Elizondo

A user table does exist

Shri Deshpande

Facing issues with Google Oauth

Hi Team,

I am suddenly facing issues with error : 500 since today morning. I have not made any changes.

My environment variable was unchanged.

this is the exact error I am getting

Please set your "google_oauth_client_id" environment variable.

Can anyone help on this?

mhmd ahmd

Issue: Create File Resource returns NULL / Empty File despite valid Base64 input

Hi Xano Support Team,

I am facing a critical issue where the "Create File Resource" function executes successfully (returns HTTP 200) but fails to generate the file, resulting in a null value or an empty file in the database.

The Workflow:

  1. Generate HTML: I create a variable final_html with valid HTML content.

  2. Encode: I convert it to Base64 using the base64_encode filter.

  3. Create File: I use the "Create File Resource" function, mapping the Base64 variable to the "File Data" input.

  4. Save: I add the result to a database table.

The Problem:

  • The API endpoint runs successfully without throwing any errors.

  • However, the output of the "Create File Resource" step is null (or empty).

  • Consequently, the field in the database remains empty, even though the input variable definitely contains a valid Base64 string (I verified this in the debugger).

What I Checked:

  • The Base64 string is correct and includes the header: data:text/html;base64,...

  • The Input type in the function is set to "Var" (not Text).

  • There are no "Input Error" messages appearing anymore, but the functionality is simply not working as expected.

Could you please investigate why valid Base64 input is being processed as null by the file creation step?

Looking to hire a Xano Expert to help with your project? Post here!

If possible, include the following information in your post:

  • Project Overview

  • Outline what components need to be developed

  • Expected project duration

  • Special requirements

  • Any other information you think is relevant to find someone to meet your project’s needs.