The database does not match the target database: Table is missing

[Sameer330]

I have a class called User:

class: User
table: users
fields:
  name: String
  image: String

All CRUD operations work fine for this class.

I have another class called Post which stores a user's posts:

class: Post
table: posts
fields:
  userId: int, relation(parent=users)
  text: String

While docker was running:

1. I ran the command: serverpod create-migration --force
2. Then dart run bin/main.dart --apply-migration

This was the result:

D:\ServerPod-Projects\tbknd\tbknd_server>dart bin/main.dart --apply-migration
Failed to parse command line arguments. Using default values. FormatException: Could not find an option named "apply-migration".
SERVERPOD version: 1.2.3, dart: 3.2.4 (stable) (Thu Dec 21 19:13:53 2023 +0000) on "windows_x64", time: 2024-02-08 05:35:50.558663Z
mode: development, role: monolith, logging: normal, serverId: default
WARNING: The database does not match the target database:
 - Table "posts" is missing.
Hint: Did you forget to apply the migrations (--apply-migrations) or run a repair migration (--apply-repair-migration)?
Insights listening on port 8081
Server default listening on port 8080
Webserver listening on port 8082
CPU and memory usage metrics are not supported on this platform.

I tried running the endpoint for posts table but it didn't work.

How to solve this?

Reading Users is working - OK 200

But adding posts does not work - Bad Request 400

[Isakdl]

From your log Failed to parse command line arguments. Using default values. FormatException: Could not find an option named "apply-migration".

The issue is that there should be an s at the end. The correct flag is --apply-migrations :)

[Sameer330]

I tried running the server with the right flag --apply-migrations and this was the resulting log:

D:\ServerPod-Projects\tbknd\tbknd_server>serverpod create-migration -t "v1.0.0" 
Invalid tag name. Tag names can only contain lowercase letters, number, and dashes.

D:\ServerPod-Projects\tbknd\tbknd_server>serverpod create-migration -t "v1-0-0" 
⠸ Creating migration... (1.0s)
No changes detected.
✗ Creating migration (1.0s)

D:\ServerPod-Projects\tbknd\tbknd_server>serverpod create-migration -t "v1-0-0" --force
✓ Creating migration (0.5s)
 • Migration created: migrations\20240208104102354-v1-0-0
✓ Done.


D:\ServerPod-Projects\tbknd\tbknd_server>dart run bin/main.dart --apply-migrations "v1-0-0" 
SERVERPOD version: 1.2.3, dart: 3.2.4 (stable) (Thu Dec 21 19:13:53 2023 +0000) on "windows_x64", time: 2024-02-08 10:43:06.329684Z
mode: development, role: monolith, logging: normal, serverId: default
Failed to apply database migrations. Exception: Version 20240206171738894 not found in project.
Insights listening on port 8081
Server default listening on port 8080
Webserver listening on port 8082
CPU and memory usage metrics are not supported on this platform.

Also, I deleted some of the previous migrations since I think they are just duplicates. I want to know how to run the latest migration. I tried running the latest migration by assigning a tag but it didn't work.

I also tried calling my post/createPost endpoint but it returned status code 400 again :(

[Isakdl]

I see, the migration command requires the latest applied migration to be in the folder. The error Exception: Version 20240206171738894 not found in project. cannot find the version that was last applied in the database. You have a few options to fix this. If you have the history in git you can bring back this version and create a new migration based on that migration. You can also use the repair migration feature, i.e. serverpod create-repair-migration and then dart bin/main.dart --apply-repair-migration. This will create a special migration that will bring everything in sync.

Or lastly you can also just wipe the database (if you don't care about the data) and apply the migration on a clean database.

[Sameer330]

I think I will go for a new project while taking the current models and endpoint. Anyways, thanks @Isakdl for the assistance. 👍🙌

[Sameer330]

@Isakdl
This time, I created a new project and added the code from my previous project. The user endpoint worked fine but the post endpoint returned 400 status code.

These were the logs:

D:\ServerPod-Projects\tbknd2\tbknd2_server>dart bin/main.dart --apply-migrations
SERVERPOD version: 1.2.3, dart: 3.2.4 (stable) (Thu Dec 21 19:13:53 2023 +0000) on "windows_x64", time: 2024-02-08 17:36:57.352221Z
mode: development, role: monolith, logging: normal, serverId: default
Applied database migration:
 - 20240208173507023
Insights listening on port 8081
Server default listening on port 8080
Webserver listening on port 8082
CPU and memory usage metrics are not supported on this platform.
METHOD CALL: user.readAll duration: 11ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 24ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 25ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 16ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 17ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 8ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 11ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 19ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 186ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 11ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.create duration: 6ms numQueries: 0 authenticatedUser: null
METHOD CALL: user.readAll duration: 4ms numQueries: 0 authenticatedUser: null

The posts table looks like this:

class: Post
table: posts
fields:
  userId: int, relation(parent=users)
  text: String

and the posts endpoint looks like this:

import 'package:serverpod/serverpod.dart';
import 'package:tbknd2_server/src/generated/protocol.dart';

class PostsEndpoint extends Endpoint {
  Future<Map<String, dynamic>> createPost(Session session, Post post) async {
    Map<String, dynamic> res = {};

    print('Creating post: ${post.text} for user: ${post.userId}');

    var newPost = await Post.db.insertRow(
      session,
      post,
    );

    res['statusCode'] = 200;
    res['post'] = newPost.toJson();

    return res;
  }

  Future<Map<String, dynamic>> readAllPosts(Session session) async {
    Map<String, dynamic> res = {};

    res['statusCode'] = 200;
    res['data'] = await Post.db.find(
      session,
    );

    return res;
  }
}

The endpoint posts/readAllPosts works as expected but posts/createPost returns status code 400.

Is it because of the foreign key relation? How to solve this?

[Sameer330]

@Isakdl

I found the solution to the 400 Bad Request error.

Turns out I was calling the post/createPost endpoint instead of the posts/createPost

Always use the table name; not the class name in the endpoints.

[kaljitism]

@Sameer330 What do you mean by "Always use the table name; not the class name in the endpoints." This is my code -

Future<void> createUser(Session session, User user) async { session.log("user: $user"); await User.db.insertRow(session, user); }

I am using class Name User to access the db, how do I use the table name here???