Invalid text representation 7 error invalid input syntax for type bigint

Tag1 supports the Drupal Project.

im trying figure out with this problem, already search on every website getting same error, not work at all,.,

here is my simple code hope u guys understand

migration diagnosa

public function up()
{
    Schema::create('diagnosas', function (Blueprint $table) {
        $table->id();
        $table->foreignId('user_id')->constrained();
        $table->double('hasil_nilai');
        $table->date('diagnosa_date');
        $table->timestamps();
    });
}

migration diagnosa_gejala

public function up()
{
    Schema::create('diagnosa_gejalas', function (Blueprint $table) {
        $table->id();
        $table->unsignedBigInteger('diagnosa_gejala_id');
    $table->foreign('diagnosa_gejala_id')->references('id')->on('diagnosas')
        ->onDelete('cascade');
        $table->unsignedBigInteger('gejala_id');
        $table->foreign('gejala_id')->references('id')->on('gejalas');
        $table->timestamps();
    });
}

migration dianosa_kerusakan

public function up()
{
    Schema::create('diagnosa_kerusakans', function (Blueprint $table) {
        $table->id();
        $table->unsignedBigInteger('diagnosa_kerusakan_id');
        $table->foreign('diagnosa_kerusakan_id')->references('id')->on('diagnosas')
        ->onDelete('cascade');
        $table->unsignedBigInteger('kerusakan_id');
        $table->foreign('kerusakan_id')->references('id')->on('kerusakans');
        $table->timestamps();
    });
}

model diagnosa

public function user_id() {
    return $this->belongsTo(User::class, 'user_id');
}
public function diagnosaGejala()
{
    return $this->hasMany(DiagnosaGejala::class);
}
public function diagnosaKerusakan()
{
    return $this->hasMany(DiagnosaKerusakan::class);
}

model diagnosa gejala

public function diagnosa_gejala_id() {
    return $this->belongsTo(Diagnosa::class, 'diagnosa_gejala_id');
}
public function gejala_id() {
    return $this->belongsTo(Gejala::class, 'gejala_id');
}

}

model diagnosa kerusakan

public function diagnosa_kerusakan_id() {
    return $this->belongsTo(Diagnosa::class, 'diagnosa_kerusakan_id');
}
public function kerusakan_id() {
    return $this->belongsTo(Kerusakan::class, 'kerusakan_id');
}

here is little code controller post/save to database diagnosa, diagnosa_gejala, and diagnosa_kerusakan

$kerusakan = Kerusakan::where('kode_kerusakan', $getCode)->select('id')->get();
                $authUser = Auth::user()->id;
                $diagnosa = new Diagnosa;
                $diagnosa->user_id = $authUser;
                $diagnosa->hasil_nilai = $getValue * 100;
                $diagnosa->diagnosa_date = date('Y-m-d');
                $diagnosa->save();
                $diagnosaGejalaBody = [];
                foreach ($gejala as $key => $result) {
                    $diagnosaGejalaBody[$key]['diagnosa_gejala_id'] = $diagnosa->id;
                    $diagnosaGejalaBody[$key]['gejala_id'] = $result;
                }
                DiagnosaGejala::insert($diagnosaGejalaBody);
                $diagnosaKerusakanBody = [];
                foreach ($kerusakan as $key => $result) {
                    $diagnosaKerusakanBody[$key]['diagnosa_kerusakan_id'] = $diagnosa->id;
                    $diagnosaKerusakanBody[$key]['kerusakan_id'] = $result['id'];
                }
                DiagnosaKerusakan::insert($diagnosaKerusakanBody);
                return redirect('diagnosa-hasil/' . $diagnosa->id);

this is little code, controller trying to get data by parameter $id, for sending to blade with url «diagnosa-hasil/{id}»

$getId = Diagnosa::find($id);
        $diagnosa = Diagnosa::whereIn('diagnosas.id', $getId)
            ->join('diagnosa_gejalas', 'diagnosa_gejala_id', '=', 'diagnosas.id')
            ->join('diagnosa_kerusakans', 'diagnosa_kerusakan_id', '=', 'diagnosas.id')
            ->join('gejalas', 'gejala_id', '=', 'gejalas.id')
            ->join('kerusakans', 'kerusakan_id', '=', 'kerusakans.id')
            ->get()
            ->toArray();

this error from herokuapp

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "95.64" (SQL: select * from "diagnosas" inner join "diagnosa_gejalas" on "diagnosa_gejala_id" = "diagnosas"."id" inner join "gejalas" on "gejala_id" = "gejalas"."id" inner join "diagnosa_kerusakans" on "diagnosa_kerusakan_id" = "diagnosas"."id" inner join "kerusakans" on "kerusakan_id" = "kerusakans"."id" where "diagnosas"."id" in (1, 1, 95.64, 2021-11-18, 2021-11-18T07:02:43.000000Z, 2021-11-18T07:02:43.000000Z))

on my localhost:8000 is work fine,.,

Евгений Вафиев

Добрый вечер) буду благодарен за помощь)
История такая, все сделал, тесты проходили, завис на дестрое…выловил, что приходт в экшн пустой коммент) долго копался, путем переименовая переменных добился, что удаление проходит) нажимаю проверить, и начинают падать тесты на валидации, даже ДД не дает посмотреть, ломается все сразу при приходе в update…
Текст ошибки:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "[]" (SQL: select * from "article_comments" where "id" = [] limit 1)

Ревью

Мозги кипят, не пойму, что делаю не так) буду признателен за помощь решения вопроса с этой ошибкой, а так же пояснением того, как имена аргументов в методах влияют на то, что Коммент приходил пустым)

ЗЫ: вижу, что теперь в апдейт экшн приходит пустой коммент

ЗЫЗЫ: если переименовать $articleComment в $comment, то возникает ошибка с БД, следовательно должно быть $articleComment, значит вопрос сужается и остается одна проблема, почему эта переменная пустая)

1

0

0

320 votes

1 answers

Get the solution ↓↓↓

/src/Entity/Theme.php
/**
     * @ORMManyToOne(targetEntity="AppEntityUser", inversedBy="published")
     * @ORMJoinColumn(nullable=false)
     */
   private $user; 

/**
     * @Route("/theme/show/{lastname}", name="theme_created_by")
     * [email protected] User $ThemeByUser
     */
    public function userThemes(User $ThemeByUser){
        $html =  $this->twig->render('theme/index.html.twig', [
            'themes' => $this->themeRepository->findBy(
                ['User' => $ThemeByUser], ['created_at' => 'DESC']),
        ]);
        return new Response($html);
    }

An exception occurred while executing 'SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM theme t0 WHERE t0.id = ?' with params ["Roland"]:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "Roland"

Write your answer

969

votes

Answer

Solution:

Dont know how and why but in my twig file that rendering the function :

<p class="media-body pb-3 mb-0  small lh-125 border-bottom border-gray">
        <strong class="text-gray-dark">Autheur : </strong>
        <a href="{{ path('theme_created_by', {'lastname': theme.user.lastname}) }}">
             {{ theme.user.lastname }}
        </a>
        <br/>
        <a href="{{ path( 'theme_show', {'id' : theme.id} ) }}">
            <strong>{{ theme.name }}</strong><br/>
        </a>

i replace that path line with :

<a href="{{ path('theme_created_by', {'username': theme.user.username}) }}">
             {{ theme.user.lastname }}
        </a>

changed the paramaters passed in my route too : withusername@Route("/themes/by/{username}", name="theme_created_by")
now it works..

Share solution ↓

Additional Information:

Link To Source

Link To Answer
People are also looking for solutions of the problem: zsh: command not found: php

Similar questions

Find the answer in similar questions on our website.