laravel dropzone not uploading to databse

i am working on a dropzone gallery project but when i add the images it saves them on the destination folder but not in the database. can any one help me?

my code is

public function viewGalleryPics($id)

{

$gallery=Gallery::findorFail($id);


return view('gallery.gallery_view')->with('gallery',$gallery);

} public function doImageUpload(Request $request)

{

    //get the file from the post request
    $file=$request->file('file');

    //set my file name
    $filename=uniqid().$file->getClientOriginalName();

    //move the file t0 correct location
    $file->move('assets/img/gallery', $filename);

    //save the file to the database
    $gallery= Gallery::find($request->input('gallery_id'));

    $image = $gallery->images()->create([

        'gallery_id'=>$request->input('gallery_id'),
        'file_name'=>$filename,
        'file_size'=>$file->getClientSize(),
        'file_mime'=>$file->getClientMimeType(),
        'file_path'=>'/assets/img/gallery/'.$filename,
        'created_by'=>Auth::user()->id,


    ]);

    return $image; //for the appended images after upload

}

theUnforgiven

8 years ago

Level 51

Here is a snippet from something I'm working on currently that uses Dropzone, see if this helps you:

public function store(Request $request)
    {
        try {
            if ($request->hasFile('file'))
            {
                // retrieve file from request
                $files = $request->file('file');
                foreach ($files as $file) {

                    // Resize
                    $name = Str::random(25).'.'.$file->getClientOriginalExtension();
                    $imageFile = Image::make($file)->fit(300, 300)->stream();
                    $imageFile = $imageFile->__toString();

                    // Storage S3
                    $s3 = Storage::disk('s3');
                    $s3->put('dogs/'. auth()->user()->dog->dog_name . '/' . $name, $imageFile, 'public');
                    $imageName = Storage::disk('s3')->url('dogs/'. auth()->user()->dog->dog_name . '/' . $name);

                    // Save to local db
                    $gallery = new Gallery;
                    $gallery->user_id = auth()->user()->id;
                    $gallery->dog_id = auth()->user()->dog->id;
                    $gallery->privacy = request()->get('privacy');
                    $gallery->name = request()->get('name');
                    $gallery->path = $imageName;
                    $gallery->save();
                }
            }
            // check for file upload
            if ($request->hasFile('file'))
            {
                // return with json response - this feeds the dropzone success method in profile-dz.js
                return response()->json(['error' => false, 'message' => ['type'     => 'success',
                    'title' => 'Profile',
                    'body'  => "Your profile has been updated!"]]);
            }
            else
            {
                // response - this feeds the simple form submission with return back to profile
                flash('Profile successfully updated', 'success');

                // return
                return back();
            }

        } catch (Exception $e) {

            // check for file upload
            if ($request->hasFile('file'))
            {
                // return with json response - this feeds the dropzone success method in profile-dz.js
                return response()->json(['error' => true, 'message' => ['type'  => 'warning',
                    'title' => 'Profile',
                    'body'  => 'A problem was encountered updating your profile!' . $e->getMessage()]]);
            }
            else
            {
                // response - this feeds the simple form submission with return back to profile
                alert()->error('Profile Update', 'There was a problem updating your profile!' . $e->getMessage());

                // return
                return back();
            }
        }
    }

<script>
        Dropzone.autoDiscover = false;

        $(document).ready(function() {
            $("div#app").dropzone({
                url: "/your/url/endpoint",
                maxFilesize: 25,
                autoDiscover: false,
                autoProcessQueue: false,
                uploadMultiple: true,
                parallelUploads: 150,
                addRemoveLinks: true,
                acceptedFiles: 'image/*',
                createImageThumbnails: true,

                init: function() {

                    /** define */
                    var submitButton = $(".btn-success");
                    var thisDropzone = this;

                    /** onclick event */
                    submitButton.on("click", function (event) {

                        /** prevent submission of form */
                        event.preventDefault();

                        /** process dropzone queue and form data */
                        thisDropzone.processQueue();
                    });


                    this.on("sending", function(file, xhr, formData) {
                        formData.append('privacy', $("#privacy").val());
                        formData.append('name', $("#name").val());
                    });

                    this.on("complete", function(xhr, formData) {

                        swal(
                            {
                                title: "Success",
                                text: "Files successfully uploaded",
                                type: "success",
                                timer: 3000,
                                showConfirmButton: false
                            },
                            setTimeout(function () {
                                location.reload();
                            }, 2300)
                        );
                    });

                    this.on("error", function(xhr, formData) {
                        swal(
                            {
                                title: "Whoops!",
                                text: "Files not uploaded, there was a problem.",
                                type: "error",
                                timer: 3000,
                                showConfirmButton: false
                            },
                            setTimeout(function () {
                                location.reload();
                            }, 2300)
                        );
                    });
                }
            });
        });

    </script>

The form:

<form action="" method="post" class="form-horizontal" enctype="multipart/form-data">

            {{ csrf_field() }}

            <div class="form-group">
                <div class="col-sm-3">Gallery Name</div>
                <div class="col-lg-7">
                    <input type="text" name="name" class="form-control" value="" id="name">
                </div>
            </div>

            <div class="form-group">
                <div class="col-sm-3">Gallery Privacy</div>
                <div class="col-lg-7">
                    <select class="form-control" name="privacy" id="privacy">
                        <option selected>Please Select</option>
                        <option value="1">Public</option>
                        <option value="0">Private</option>
                    </select>
                </div>
            </div>

            <div class="form-group">
                <div class="col-sm-3"></div>
                <div class="col-lg-12">
                    <div id="app" class="dropzone"></div>
                    <div class="fallback">
                        <input name="file" type="file" multiple />
                    </div>
                </div>
            </div>

            <div class="form-group">
              <div class="col-lg-3">
                 <button class="btn btn-success">Upload</button>
              </div>
            </div>

        </form>

Ab.net

8 years ago

Level 1

yes there is!! and the error on my console is just "500 internal server error"

Ab.net

8 years ago

Level 1

thanks all but i have a method(relationship) in my images model

and i injected it in my controller i don't know what the problem is but it isn't uploading to the database :( there are 2 models involved in the process...

Ab.net

8 years ago

Level 1

this is the log file....please help!

[2017-07-31 14:45:25] local.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'file_name' in 'field list' in /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php:445 Stack trace: #0 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php(445): PDO->prepare('insert into im...') #1 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert intoim...', Array) #2 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('insert into im...', Array, Object(Closure)) #3 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php(450): Illuminate\Database\Connection->run('insert intoim...', Array, Object(Closure)) #4 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->statement('insert into im...', Array) #5 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert intoim...', Array) #6 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2138): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `im...', Array, 'id') #7 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1247): Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #8 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(684): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #9 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(649): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #10 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(518): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder)) #11 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/HasOneOrMany.php(284): Illuminate\Database\Eloquent\Model->save() #12 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Support/helpers.php(936): Illuminate\Database\Eloquent\Relations\HasOneOrMany->Illuminate\Database\Eloquent\Relations{closure}(Object(App\images)) #13 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/HasOneOrMany.php(285): tap(Object(App\images), Object(Closure)) #14 /opt/lampp/htdocs/enrichmentforthedisadvantage/app/Http/Controllers/Backend/GalleryController.php(80): Illuminate\Database\Eloquent\Relations\HasOneOrMany->create(Array) #15 [internal function]: App\Http\Controllers\Backend\GalleryController->doImageUpload(Object(Illuminate\Http\Request)) #16 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #17 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('doImageUpload', Array) #18 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Backend\GalleryController), 'doImageUpload') #19 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #20 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\Routing\Route->run() #21 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #22 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #23 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #24 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #25 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #26 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #27 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #28 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #29 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #30 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #31 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #32 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #33 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #34 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #35 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #36 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #37 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #38 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #40 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #41 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #42 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #43 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #44 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Router.php(576): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #45 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Router.php(535): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #46 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Router.php(513): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #47 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #48 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request)) #49 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #50 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #51 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #52 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #53 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #54 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #55 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #56 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #57 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #58 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #59 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #60 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #61 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #62 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #63 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #64 /opt/lampp/htdocs/enrichmentforthedisadvantage/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #65 /opt/lampp/htdocs/enrichmentforthedisadvantage/server.php(21): require_once('/opt/lampp/htdo...') #66 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'file_name' in 'field list' (SQL: insert into images (gallery_id, file_name, file_size, file_mime, file_path, created_by, updated_at, created_at) values (2, 597f42851b702_ECD_airplane.jpg, 58420, image/jpeg, /uploads/Gallery/597f42851b702_ECD_airplane.jpg, 1, 2017-07-31 14:45:25, 2017-07-31 14:45:25)) in /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('insert into im...', Array, Object(Closure)) #1 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php(450): Illuminate\Database\Connection->run('insert intoim...', Array, Object(Closure)) #2 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->statement('insert into im...', Array) #3 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert intoim...', Array) #4 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2138): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `im...', Array, 'id') #5 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1247): Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #6 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(684): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #7 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(649): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #8 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(518): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder)) #9 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/HasOneOrMany.php(284): Illuminate\Database\Eloquent\Model->save() #10 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Support/helpers.php(936): Illuminate\Database\Eloquent\Relations\HasOneOrMany->Illuminate\Database\Eloquent\Relations{closure}(Object(App\images)) #11 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/HasOneOrMany.php(285): tap(Object(App\images), Object(Closure)) #12 /opt/lampp/htdocs/enrichmentforthedisadvantage/app/Http/Controllers/Backend/GalleryController.php(80): Illuminate\Database\Eloquent\Relations\HasOneOrMany->create(Array) #13 [internal function]: App\Http\Controllers\Backend\GalleryController->doImageUpload(Object(Illuminate\Http\Request)) #14 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #15 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('doImageUpload', Array) #16 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Backend\GalleryController), 'doImageUpload') #17 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #18 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\Routing\Route->run() #19 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #20 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #21 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #22 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #23 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #24 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #26 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #27 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #29 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #30 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #32 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #33 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #35 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #36 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #38 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #39 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #41 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #42 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Router.php(576): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #43 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Router.php(535): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #44 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Router.php(513): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #45 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #46 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request)) #47 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #48 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #50 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #51 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #52 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #53 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #54 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #55 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #56 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #57 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request)) #59 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request)) #60 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #61 /opt/lampp/htdocs/enrichmentforthedisadvantage/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #62 /opt/lampp/htdocs/enrichmentforthedisadvantage/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #63 /opt/lampp/htdocs/enrichmentforthedisadvantage/server.php(21): require_once('/opt/lampp/htdo...') #64 {main}

ActiveMonkey

8 years ago

Level 5

Check your migration file to see whether "file_name" has been defined.

Ab.net

8 years ago

Level 1

thanks i have got it solved!!

Please or to participate in this conversation.