Recent Topics

.channels' doesn't exist in



  • 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



  • Hi @trionix,

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



  • @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



  • Hi @trionix,

    May I know your MySQL version?



  • Dear Team

    Version

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

    3.png



  • 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



  • @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?



  • @rudiculous,

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



  • Hi @trionix,

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


Log in to reply