Database table mysteriously empty this morning

Hello, I'm testing out appwrite (free) with a simple vue app. This morning a I created a few indexes on a table, and then noticed that it was empty... I don't even have any code that deletes records. The 'Activity' tab only shows those index creation events, no events from before today.

Is it possible to figure out what happened? This makes me a bit nervous.

Please share your project and database IDs. Are you seeing the issue from the API, console or both?

thanks eldad - projectId: 691ae81a0033262592ba, databaseId: 691aed12001d9d4fdd2c, missing table: courses

API and console both show no rows in that table

no problem, I'll ask the team to take a look

Thank you!!

As context, yesterday I tried creating a full-text index with both 'title' and 'summary' columns, but that didn't allow searching, so this morning I deleted both of those indexes, created a new column called 'searchable', and added a full-text index to it. Plan was to copy the text fields I want to search into that column and search that.

can you tell if any specific action caused the issue or can you suggeset any steps to try and reproduce this?

I'm at a loss. Last night I was retrieving records just fine. This morning, all I did was delete two indexes, create a column, and add a full-text index to it. When I was getting no records in my app, I checked the table and it was empty.

Got it, I'll get an engineer to take a look

@tlt7148 can you also share the permissions and data structure?

Guests: read, Any: read, (my user): create, read, update

both are fine

how many records did you had before you've noticed the issue?

just 2

Here is my client code:

async function searchCourses(search?: string, limit: number = 25) { loading.value = true; error.value = undefined;

try {

  const queries = [
    Query.select(['*', 'provider.slug', 'provider.name', 'provider.$id']),
    Query.orderDesc('$createdAt'),
    Query.limit(limit),
  ];

  if (search) {
    queries.push(Query.search('searchable', search));
  }

  const result = await tables.listRows<Course>({
    tableId: 'course', databaseId, queries
  });

  courses.value = result.rows;

} catch (exception) {
  console.error(exception);
  error.value = exception;
} finally {
  loading.value = false;
}

}

appwrite connection is coming from another file:

import { Client, Account, Databases, TablesDB } from 'appwrite';

export const endpoint = import.meta.env.VITE_APPWRITE_ENDPOINT; export const projectId = import.meta.env.VITE_APPWRITE_PROJECT_ID; export const databaseId = import.meta.env.VITE_APPWRITE_DATABASE_ID;

export const client = new Client().setEndpoint(endpoint).setProject(projectId); export const account = new Account(client); export const databases = new Databases(client); export const tables: TablesDB = new TablesDB(client);

console.log([appWrite] connected to ${client.config.endpoint});

OK, I'll follow up on this when I got something or if we can use more info 👍

Great, thank you so much eldad