Bagisto Forum

    Bagisto
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    image category is not

    Bug Report
    2
    21
    45610
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • V
      Vaishali Agarwal last edited by

      @cmpengineers
      may I know your Database version details.

      1 Reply Last reply Reply Quote 0
      • C
        cmpengineers last edited by

        Dear all

        sure

        Screen Shot 2020-10-16 at 11.44.30 AM.png

        I did create another database but for some reason I cant do PHP artisan migrate:fresh

        Screen Shot 2020-10-16 at 11.47.18 AM.png

        why is he looking for a base table or channels when I fleshing all the table from scratch ?

        please advise

        regards

        1 Reply Last reply Reply Quote 0
        • C
          cmpengineers last edited by

          Dear all

          why is always facing the problem I cloned the same project from my git hub still giving me the same error

          Screen Shot 2020-10-17 at 10.28.15 AM.png

          > @php artisan package:discover

In Connection.php line 669:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drov112.channels  
  ' doesn't exist (SQL: select * from `channels` where `hostname` in (drov112  
  .test, http://drov112.test, https://drov112.test))                           
                                                                               

In PDOConnection.php line 63:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drov112.channels  
  ' doesn't exist                                                              
                                                                               

In PDOConnection.php line 61:
                                                                               
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drov112.channels  
  ' doesn't exist                                                              
                                                                               

Script @php artisan package:discover handling the post-autoload-dump event returned with error code 1
(base) drov112:

          every time i do composer install i get this error

          I'm tired from chasing your bugs , it would much quicker and even more faster i build my own ecommerce

          regards

          1 Reply Last reply Reply Quote 0
          • V
            Vaishali Agarwal last edited by

            @cmpengineers said in image category is not:

            Base table or view not found

            @cmpengineers
            please go through with link https://forums.bagisto.com/topic/1563/error-while-installinghttps-forums-bagisto-com-post-2388/9
            hope this will work for you.

            C 1 Reply Last reply Reply Quote 0
            • C
              cmpengineers @Vaishali Agarwal last edited by

              @Vaishali-Agarwal

              its not working same error exactly

              regards

              1 Reply Last reply Reply Quote 0
              • C
                cmpengineers last edited by

                Hello

                every time i do composr intall it give me the same error

                Screen Shot 2020-10-17 at 10.58.42 AM.png

                why is he looking for base table !!! and still I did not do migrate or seed !!!

                regards

                1 Reply Last reply Reply Quote 0
                • V
                  Vaishali Agarwal last edited by

                  @cmpengineers
                  if you have not run migrate command then please run
                  php artisan migrate , it will show you the exact error.

                  C 2 Replies Last reply Reply Quote 0
                  • C
                    cmpengineers @Vaishali Agarwal last edited by

                    @Vaishali-Agarwal

                    same error my dear what ever command for artisan it will give me the same error

                    regards

                    1 Reply Last reply Reply Quote 0
                    • C
                      cmpengineers @Vaishali Agarwal last edited by

                      @Vaishali-Agarwal

                      Screen Shot 2020-10-17 at 11.13.47 AM.png

                      1 Reply Last reply Reply Quote 0
                      • C
                        cmpengineers last edited by

                        i found the solution

                        which is weird , i copy one table the channels and insert inside the database it work , then i did
                        php artisan migrate:fresh --seed

                        it work but i have problem with multi-vendor
                        so please check the image its not displaying

                        Screen Shot 2020-10-17 at 11.40.53 AM.png

                        regards

                        1 Reply Last reply Reply Quote 0
                        • V
                          Vaishali Agarwal last edited by

                          @cmpengineers
                          once try to follow the below step:

                          1. go to the .env and check the database name should be valid
                          2. run the below command,
                            php artisan config:cache
                            php artisan migrate:refresh --seed
                          1 Reply Last reply Reply Quote 0
                          • V
                            Vaishali Agarwal last edited by Vaishali Agarwal

                            @cmpengineers
                            link your storage folder

                            php artisan storage:link

                            you may also follow all the possible solution mention here
                            https://forums.bagisto.com/topic/188/broken-image-logo-in-bagisto-with-causes-and-solutions/1

                            C 1 Reply Last reply Reply Quote 0
                            • C
                              cmpengineers @Vaishali Agarwal last edited by

                              @Vaishali-Agarwal

                              its already linked

                              Generated optimized autoload files containing 6627 classes
(base) drov112:pa s:l
The "public/storage" directory already exists.
(base) drov112:
                              1 Reply Last reply Reply Quote 0
                              • V
                                Vaishali Agarwal last edited by

                                @Vaishali-Agarwal said in image category is not:

                                https://forums.bagisto.com/topic/188/broken-image-logo-in-bagisto-with-causes-and-solutions/1

                                As already provided please check this link https://forums.bagisto.com/topic/188/broken-image-logo-in-bagisto-with-causes-and-solutions/1 and follow the solutions

                                C 1 Reply Last reply Reply Quote 0
                                • C
                                  cmpengineers @Vaishali Agarwal last edited by

                                  @Vaishali-Agarwal

                                  Dear Vaishali

                                  i have already created more than 10+ project from laravel

                                  i did exactly and still its not showing I'm using laravel valet

                                  regards

                                  1 Reply Last reply Reply Quote 0
                                  • V
                                    Vaishali Agarwal last edited by

                                    @cmpengineers

                                    • Inspect to the image and check the image path

                                    • could you please check whether products or categories images are showing at admin end or front end both?

                                    You can see this issue does not exist at my end https://prnt.sc/v12iq9

                                    C 2 Replies Last reply Reply Quote 0
                                    • C
                                      cmpengineers @Vaishali Agarwal last edited by

                                      @Vaishali-Agarwal said in image category is not:

                                      https://prnt.sc/v12iq9

                                      everything is showing except for the multi-vendor
                                      in production is working fine drov.app but in local its not working

                                      regards

                                      1 Reply Last reply Reply Quote 0
                                      • C
                                        cmpengineers @Vaishali Agarwal last edited by

                                        @Vaishali-Agarwal

                                        what local env you are using laravel valet ? homestead vapor ? xampp ?

                                        regatds

                                        1 Reply Last reply Reply Quote 0
                                        • V
                                          Vaishali Agarwal last edited by

                                          @cmpengineers
                                          I am using Linux server.

                                          1 Reply Last reply Reply Quote 0
                                          • C
                                            cmpengineers last edited by cmpengineers

                                            @Vaishali-Agarwal

                                            Dear Vaishali

                                            everything its working now but in production I cant upload category image
                                            Screen Shot 2020-10-17 at 5.11.41 PM.png

                                            Illuminate\Database\QueryException thrown with message "SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION drovapp.get_url_path_of_category does not exist (SQL: update `categories` set `_lft` = case when `_lft` >= 18 then `_lft`+2 else `_lft` end, `_rgt` = case when `_rgt` >= 18 then `_rgt`+2 else `_rgt` end where (`_lft` >= 18 or `_rgt` >= 18))"

Stacktrace:
#62 Illuminate\Database\QueryException in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
#61 Doctrine\DBAL\Driver\PDOException in /home/forge/drov.app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
#60 PDOException in /home/forge/drov.app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
#59 PDOStatement:execute in /home/forge/drov.app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
#58 Doctrine\DBAL\Driver\PDOStatement:execute in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:488
#57 Illuminate\Database\Connection:Illuminate\Database\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:662
#56 Illuminate\Database\Connection:runQueryCallback in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:629
#55 Illuminate\Database\Connection:run in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:495
#54 Illuminate\Database\Connection:affectingStatement in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:428
#53 Illuminate\Database\Connection:update in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2726
#52 Illuminate\Database\Query\Builder:update in /home/forge/drov.app/vendor/kalnoy/nestedset/src/QueryBuilder.php:603
#51 Kalnoy\Nestedset\QueryBuilder:makeGap in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:609
#50 Webkul\Category\Models\Category:insertNode in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:574
#49 Webkul\Category\Models\Category:insertAt in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:171
#48 Webkul\Category\Models\Category:actionAppendOrPrepend in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:102
#47 call_user_func_array in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:102
#46 Webkul\Category\Models\Category:callPendingAction in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:47
#45 Webkul\Category\Models\Category:Kalnoy\Nestedset\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php:369
#44 Illuminate\Events\Dispatcher:Illuminate\Events\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php:218
#43 Illuminate\Events\Dispatcher:dispatch in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php:191
#42 Illuminate\Events\Dispatcher:until in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasEvents.php:188
#41 Illuminate\Database\Eloquent\Model:fireModelEvent in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:651
#40 Illuminate\Database\Eloquent\Model:save in /home/forge/drov.app/vendor/kalnoy/nestedset/src/NodeTrait.php:764
#39 Webkul\Category\Models\Category:create in /home/forge/drov.app/packages/Webkul/Category/src/Repositories/CategoryRepository.php:47
#38 Webkul\Category\Repositories\CategoryRepository:create in /home/forge/drov.app/packages/Webkul/Category/src/Http/Controllers/CategoryController.php:102
#37 Webkul\Category\Http\Controllers\CategoryController:store in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#36 call_user_func_array in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#35 Illuminate\Routing\Controller:callAction in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
#34 Illuminate\Routing\ControllerDispatcher:dispatch in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
#33 Illuminate\Routing\Route:runController in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
#32 Illuminate\Routing\Route:run in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
#31 Illuminate\Routing\Router:Illuminate\Routing\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
#30 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/packages/Webkul/User/src/Http/Middleware/Bouncer.php:27
#29 Webkul\User\Http\Middleware\Bouncer:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#28 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41
#27 Illuminate\Routing\Middleware\SubstituteBindings:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76
#25 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#24 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Session/Middleware/AuthenticateSession.php:39
#23 Illuminate\Session\Middleware\AuthenticateSession:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#22 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
#21 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#20 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
#19 Illuminate\Pipeline\Pipeline:then in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
#18 Illuminate\Routing\Router:runRouteWithinStack in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
#17 Illuminate\Routing\Router:runRoute in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
#16 Illuminate\Routing\Router:dispatchToRoute in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
#15 Illuminate\Routing\Router:dispatch in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
#14 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:65
#12 Barryvdh\Debugbar\Middleware\InjectDebugbar:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#11 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
#10 Illuminate\Session\Middleware\StartSession:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#9 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
#8 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
#6 Illuminate\Cookie\Middleware\EncryptCookies:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#5 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
#4 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#3 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
#2 Illuminate\Pipeline\Pipeline:then in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:145
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /home/forge/drov.app/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:110
#0 Illuminate\Foundation\Http\Kernel:handle in /home/forge/drov.app/public/index.php:74

                                            my SQL version is 5.7

                                            I did alter the database still not working
                                            ALTER DATABASE drovapp DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

                                            I can add product image no problem only the category

                                            regards

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post