Timestamps on entity_translations table break queries

[franzose]

Hi, dimsav. Your package is really great. But somehow I just have faced an issue. So, I would like to add timestamps columns to translations table to distinguish the time a certain translation was posted on. But something went wrong when I did it. $entity->translations became empty.

I have something like this:

 Schema::create('posts', function(Blueprint $table)
{
    $table->increments('id');
    $table->string('slug');

    // something else here

    $table->timestamps();
    $table->softDeletes();
});

Schema::create('post_translations', function(Blueprint $table)
{
    $table->increments('post_translation_id');
    $table->integer('post_id')->unsigned();
    $table->boolean('active')->default(0);

    // title, excerpt and content are in $translatedAttributes as they should
    $table->string('title');
    $table->text('excerpt')->default('');
    $table->longText('content');
    $table->string('locale')->index();
    $table->timestamps();
    $table->softDeletes();

    $table->unique(['post_id', 'locale']);
    $table->foreign('post_id')->references('id')->on('posts')->onDelete('cascade');
});

[dimsav]

Hi @franzose,

try to replace $table->increments('post_translation_id'); with $table->increments('id'); and give me some feedback if this solves the problem.

[franzose]

@dimsav, It seems that changing the primary key name has solved the issue. Thanks!