Value of field "db_file_id" does not exist on referenced table

[radynsade]

Trying to use phalcon model relationships to save related models but get an error: "Value of field "db_file_id" does not exist on referenced table".

Saving and processing services:
FilesService.php
ImagesService.php

Base classes for models:
TraceableModel.php
BaseModel.php

Models:
DbFile.php
Image.php

Errors and logs:
SQL log
Error log

[borisdelev]

Well.. little difficult... i cant understand whole picture, but... i see that "belongs to" in Image model:

		$this->belongsTo(
			'db_file_id',
			DbFile::class,
			'id',
			[
				'alias' => 'dbFile',
				'foreignKey' => true,
				'reusable' => true
			]
		);

and in ImageService.php (see upload function)... is not set. You have "setDbFile" function in image.php, but the db_file_id is not set there and is missing.

[radynsade]

Set accessor of $dbFileId to public, the same error. There are public setter and getter for this field. Maybe SQL definitions of the tables will help, I use PostgreSQL.
`

CREATE SCHEMA "upload";

CREATE TABLE IF NOT EXISTS "upload"."db_file" (
	"id" bigserial NOT NULL PRIMARY KEY,
	"link" varchar(256) NOT NULL,
	"mime_type" varchar(256) NOT NULL,
	"size" int NOT NULL,
	"created_at" timestamptz NOT NULL,
	"updated_at" timestamptz NOT NULL
);

CREATE TABLE IF NOT EXISTS "upload"."image" (
	"id" bigserial NOT NULL PRIMARY KEY,
	"is_vector" boolean NOT NULL,
	"db_file_id" bigint NOT NULL,
	CONSTRAINT fk_upload_image_upload_db_file
		FOREIGN KEY("db_file_id")
		REFERENCES "upload"."db_file"("id")
		ON DELETE CASCADE
);

`
Setters and getters returns 'static' to make model easily extendable (just my over-caution). Can 'static' instead of 'self' impact on phalcon ORM? I got no any type errors. Changed it, the same error 🥲

[borisdelev]

I`ve just asking about "static"... anyway... Hmm... can u try something very simple in controller (for example):

$test = new \Modules\Upload\Images\Image();
$test->is_vector = false;
$test->db_file_id = ''; // Enter some id from db_file table
$test->create();

var_dump($test->getMessages());

Just want to debug from the base stuff. Is something little we didnt see

[radynsade]

Tried this, got the same error

$dbFile = new DbFile();
$dbFile->link = '/test/link.png';
$dbFile->size = 12345;
$dbFile->mimeType = 'image/png';
$dbFile->create();
$image = new Image();
$image->dbFileId = $dbFile->id;
$image->dbFile = $dbFile;
$image->isVector = false;
$image->create();

var_dump:

array(1) {
  [0]=>
  object(Phalcon\Messages\Message)#86 (5) {
    ["code":protected]=>
    int(0)
    ["field":protected]=>
    string(10) "db_file_id"
    ["message":protected]=>
    string(62) "Value of field "db_file_id" does not exist on referenced table"
    ["type":protected]=>
    string(19) "ConstraintViolation"
    ["metaData":protected]=>
    array(0) {
    }
  }
}
null

[borisdelev]

can u try like this:

$dbFile = new DbFile();
$dbFile->link = '/test/link.png';
$dbFile->size = 12345;
$dbFile->mimeType = 'image/png';
$dbFile->create();
$image = new Image();
$image->db_file_id = $dbFile->id;
$image->is_vector = false;
$image->create();

var_dump($dbFile->getMessages());
var_dump($image->getMessages());

[radynsade]

I found where was a problem. In relationships declarations I specified column names instead of property names like $this->belongsTo('db_file_id... instead of $this->belongsTo('dbFileId... . After I changed it to property names, all works.

[radynsade]

I found where was a problem. In relationships declarations I specified column names instead of property names like $this->belongsTo('db_file_id... instead of $this->belongsTo('dbFileId... . After I changed it to property names, all works.