.channels' doesn't exist in

trionix

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

devansh-webkul

Hi @trionix,

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

trionix

@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

devansh-webkul

Hi @trionix,

May I know your MySQL version?

trionix

Dear Team

Version

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

devansh-webkul

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

rudiculous

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

devansh-webkul

@rudiculous,

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

devansh-webkul

Hi @trionix,

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

Danish Sabir

my sql version upgraded but still not working

sanjay-webkul

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

Danish Sabir

This post is deleted!

Danish Sabir

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

sanjay-webkul

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

Danish Sabir

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

Danish Sabir

i need you on zoom for a minute

sanjay-webkul

Hi there,

Have you installed bagisto first?

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