Bagisto Forum

    Bagisto

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

    .channels' doesn't exist in

    Installing Bagisto
    5
    17
    1552
    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.
    • T
      trionix last edited by

      Dear Team

      We are tying to install Bagisto https://trionix.in/desert

      But showing the following error

      Symfony\Component\ErrorHandler\Error\FatalError
      Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'desertlaravel.channels' doesn't exist in /home/pi2sn36qijjp/laravel/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79 Stack trace: #0 /home/pi2sn36qijjp/laravel/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(79): PDO->prepare('select * from ...', Array) #1 /home/pi2sn36qijjp/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Doctrine\DBAL\Driver\PDOConnection->prepare('select * from ...') #2 /home/pi2sn36qijjp/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(671): Illuminate\Database\Connection->Illuminate\Database{closure}('select * from ...', Array) #3 /home/pi2sn36qijjp/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure)) #4 /home/pi2sn36qijjp/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(346): I

      1 Reply Last reply Reply Quote 1
      • devansh-webkul
        devansh-webkul last edited by

        Hi @trionix,

        This seems to be an issue with your setup, just run php artisan migrate:fresh --seed.

        1 Reply Last reply Reply Quote 0
        • T
          trionix last edited by

          @devansh-webkul said in .channels' doesn't exist in:

          php artisan migrate:fresh --seed

          Dear Team

          We run the above command, but showing the following error, Please find the attachment

          2.png 1.png

          1 Reply Last reply Reply Quote 0
          • devansh-webkul
            devansh-webkul last edited by

            Hi @trionix,

            May I know your MySQL version?

            1 Reply Last reply Reply Quote 1
            • T
              trionix last edited by

              Dear Team

              Version

              Server version: 5.6.49-cll-lve - MySQL Community Server (GPL)

              3.png

              1 Reply Last reply Reply Quote 1
              • devansh-webkul
                devansh-webkul last edited by

                Hi @trionix,

                The error is caused by the unsupported MySQL version. Please use the following version,
                https://devdocs.bagisto.com/1.x/introduction/requirements.html#supported-database-servers

                1 Reply Last reply Reply Quote 0
                • R
                  rudiculous last edited by

                  @devansh-webkul
                  @administrators

                  I got the same issue. I upgraded mySQL to 5.7.33.
                  Still have the same error.
                  I tried to run composer install, update, php artisan. all return the same issue:

                  php artisan
                  
                  In Connection.php line 671:
                                                                                                                                                      
                    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_db_name.channels' doesn't exist (SQL: select * from `chann  
                    els` where `hostname` in (localhost9.local, http://localhost9.local, https://localhost9.local))                                   
                                                                                                                                                      
                  
                  In PDOConnection.php line 63:
                                                                                                                           
                    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_db_name.channels' doesn't exist  
                                                                                                                           
                  
                  In PDOConnection.php line 61:
                                                                                                                           
                    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_db_name.channels' doesn't exist  
                                                                                                                           
                  

                  @trionix did u manage to fix it? how?

                  1 Reply Last reply Reply Quote 1
                  • devansh-webkul
                    devansh-webkul last edited by

                    @rudiculous,

                    This is not an issue, just run php artisan migrate:fresh --seed.

                    1 Reply Last reply Reply Quote 0
                    • devansh-webkul
                      devansh-webkul last edited by

                      Hi @trionix,

                      You are using the unsupported version, which doesn't support JSON type. Please upgrade your mysql version and check.

                      1 Reply Last reply Reply Quote 0
                      • D
                        Danish Sabir last edited by

                        my sql version upgraded but still not working

                        1 Reply Last reply Reply Quote 0
                        • sanjay-webkul
                          sanjay-webkul last edited by

                          @trionix
                          Are you getting still the same issue ?
                          Can you please share the screenshot of the error.?

                          1 Reply Last reply Reply Quote 0
                          • D
                            Danish Sabir last edited by

                            This post is deleted!
                            1 Reply Last reply Reply Quote 0
                            • D
                              Danish Sabir last edited by

                              In Connection.php line 678:

                              SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_store.channels' doesn't exist (SQL: select * from ch annels where hostname in (localhost, http://localhost, https://localhost))

                              In Exception.php line 18:

                              SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_store.channels' doesn't exist

                              In PDOConnection.php line 82:

                              SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_store.channels' doesn't exist

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

                              1 Reply Last reply Reply Quote 0
                              • sanjay-webkul
                                sanjay-webkul last edited by

                                @Danish-Sabir
                                Please share the steps. Whatever step you are following.

                                1 Reply Last reply Reply Quote 0
                                • D
                                  Danish Sabir last edited by

                                  i download the zip from client and run composer update , in the last i get these errors,

                                  1 Reply Last reply Reply Quote 0
                                  • D
                                    Danish Sabir last edited by

                                    i need you on zoom for a minute

                                    1 Reply Last reply Reply Quote 0
                                    • sanjay-webkul
                                      sanjay-webkul last edited by

                                      Hi there,

                                      Have you installed bagisto first?

                                      Because it looks like you have customized or added some
                                      third party package.

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