.channels' doesn't exist in

trionix

Dear Team

Version

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

devansh-webkul

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.