Laravel bad query insert

Question

I have a problem inserting data into my database and always get the following error.

SQLSTATE[22003]: Numeric value out of range: 1416 Cannot get geometry object from data you send to the GEOMETRY field

I tried to insert data with my Eloquent model using query builder, but it gave me the same error. In the migration file I have:

Schema::create('books', function (Blueprint $table) {
    $table->bigIncrements('id')->autoIncrement()->primary();
    $table->text("name");
    $table->multiLineString("opinion");
    $table->string("post");
    $table->timestamp("date");
});

I've also tried to insert data with this:

$validatedData = $this->validate($request, [
    'name'    => 'required|alpha_dash|max:40|min:3',
    'opinion' => 'required|alpha_dash|max:40|min:3',
]);

$validatedData = Binput::all();

DB::table("books")->insert([
    "name"    => $validatedData["name"],
    "post"    => $url,
    "opinion" => $validatedData["opinion"],
]);

array:3 [▼ "name" => "string" "opinion" => "string" "submit" => "string" ] — ali filali
– ali filali, Commented Jul 27, 2019 at 19:11

schutte · Accepted Answer · 2019-07-27 22:32:17Z

1

I don't know this Binput::all(); came from.

Can you try to delete this line $validatedData = Binput::all();

Should be:

$validatedData = $this->validate($request, [
    'name'    => 'required|alpha_dash|max:40|min:3',
    'opinion' => 'required|alpha_dash|max:40|min:3',
]);

DB::table("books")->insert([
    "name"    => $validatedData["name"],
    "post"    => $url,
    "opinion" => $validatedData["opinion"],
]);

answered Jul 27, 2019 at 22:32

schutte

2,1768 gold badges35 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ali filali · Accepted Answer · 2019-07-28 11:26:04Z

0

I solve it by changing the migration instead of string and text i did char and it work

            $table->bigIncrements('id')->autoIncrement()->primary();
            $table->char("name");
            $table->char("opinion");
            $table->char("post");
            $table->timestamps();

when i tried this migration it work thank you all

answered Jul 28, 2019 at 11:26

ali filali

3641 gold badge5 silver badges9 bronze badges

Collectives™ on Stack Overflow

Laravel bad query insert

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related