How can I analyze why a query is so slow?

|
gaspar giddson 2022-04-04 13:44:00
laravel_discuss-113982.jpg
Any one to save me am getting this error after deployment of my project on server
mynameisbrad 2022-04-04 13:47:25
How can I analyze why a query is so slow? Basically i just deleted an SQL database, then created a new one and returned a backup (source /backup.sql), and now some of the queries take 5m+ instead of seconds like before?
Bhavyakumar Panchotiya 2022-04-04 13:48:05
how to add show notification on bell icon when user is sent to a request and one’s admin seen the notification after that notification will be remove from bell icon
gaspar giddson 2022-04-04 13:55:56
gaspar giddson 2022-04-04 13:44:00
Any one to save me am getting this error after deployment of my project on server

Any one to solve this error on server

cletuskingdom 2022-04-04 13:57:28
gaspar giddson 2022-04-04 13:44:00
Any one to save me am getting this error after deployment of my project on server

Have you ran your migrations?

gaspar giddson 2022-04-04 13:58:48
cletuskingdom 2022-04-04 13:57:28
Have you ran your migrations?

Yes ,sir
This error occur only after deployment on online server but on local server works

cletuskingdom 2022-04-04 13:59:19
gaspar giddson 2022-04-04 13:58:48
Yes ,sir
This error occur only after deployment on online server but on local server works

Did you ran the migration online?

gaspar giddson 2022-04-04 14:00:20
cletuskingdom 2022-04-04 13:59:19
Did you ran the migration online?

Online there is no option of migration

cletuskingdom 2022-04-04 14:00:45
gaspar giddson 2022-04-04 14:00:20
Online there is no option of migration

Does your server has a terminal enabled?

cletuskingdom 2022-04-04 14:01:30
You need a server that has a terminal or ssh enabled; because you’ll need to migrate your schemas
cletuskingdom 2022-04-04 14:04:28
cletuskingdom 2022-04-04 14:01:30
You need a server that has a terminal or ssh enabled; because you’ll need to migrate your schemas

Do yu understand this?

gaspar giddson 2022-04-04 14:05:18
cletuskingdom 2022-04-04 14:04:28
Do yu understand this?

Noo sir

cletuskingdom 2022-04-04 14:05:40
Which hosting company are you using?
Bhavyakumar Panchotiya 2022-04-04 14:05:40
how to add show notification on bell icon when user is sent to a request and one’s admin seen the notification after that notification will be remove from bell icon
Dubailord 2022-04-04 14:06:56
Is there any free PDF on livewire , or a good YouTube video on livewire.
The YouTube video I downloaded is not cool to me
gaspar giddson 2022-04-04 14:06:58
cletuskingdom 2022-04-04 14:05:40
Which hosting company are you using?

Am using hostinger

cletuskingdom 2022-04-04 14:07:53
gaspar giddson 2022-04-04 14:06:58
Am using hostinger

OKay, then login to your cpanel and check wether you can find a “Cpanel or SHH” icon

gaspar giddson 2022-04-04 14:08:22
cletuskingdom 2022-04-04 14:05:40
Which hosting company are you using?

Already I have see it

Dubailord 2022-04-04 14:13:43
Is there any free PDF on livewire , or a good YouTube video on livewire.
The YouTube video I downloaded is not cool to me
zey34354 2022-04-04 14:30:20
PS C:xampphtdocseCommerceeCommwece> php atrisan migrate
Could not open input file: atrisan
PS C:xampphtdocseCommerceeCommwece> php artisan migrate
Migrating: 2020_05_21_100000_create_teams_table
Migrated: 2020_05_21_100000_create_teams_table (46.76ms)
Migrating: 2020_05_21_200000_create_team_user_table
Migrated: 2020_05_21_200000_create_team_user_table (33.28ms)
Migrating: 2020_05_21_300000_create_team_invitations_table
Migrated: 2020_05_21_300000_create_team_invitations_table (117.39ms)
Migrating: 2022_03_19_181248_create_sessions_table

IlluminateDatabaseQueryException

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sessions’ already exists (SQL: create table sessions (id varchar(255) not null, user_id bigint unsigned null, ip_address varchar(45) null, user_agent text null, payload text not null, last_activity int not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)

at C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:725
721▕ // If an exception occurs when attempting to run a query, we’ll format the error
722▕ // message to include the bindings with SQL, which will make this exception a
723▕ // lot more helpful to the developer instead of just the database’s errors.
724▕ catch (Exception $e) {
➜ 725▕ throw new QueryException(
726▕ $query,
727▕ $this->prepareBindings($bindings),
728▕ $e
729▕ );

1 C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:505
PDOException::(“SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sessions’ already exists”)

2 C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:505
PDOStatement::execute()

zey34354 2022-04-04 14:30:46
can anyone tell me what is going on here
I didn’t go anything in them
cletuskingdom 2022-04-04 14:31:02
gaspar giddson 2022-04-04 14:08:22
Already I have see it

okay, then open it; ‘cd’ into the right folder and run your migrations

cletuskingdom 2022-04-04 14:31:55
zey34354 2022-04-04 14:30:46
can anyone tell me what is going on here
I didn’t go anything in them

Run ‘php artisan migrate:fresh’

zey34354 2022-04-04 14:33:01
cletuskingdom 2022-04-04 14:31:55
Run ‘php artisan migrate:fresh’

C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:725
721▕ // If an exception occurs when attempting to run a query, we’ll format the error
722▕ // message to include the bindings with SQL, which will make this exception a
723▕ // lot more helpful to the developer instead of just the database’s errors.
724▕ catch (Exception $e) {
➜ 725▕ throw new QueryException(
726▕ $query,
727▕ $this->prepareBindings($bindings),
728▕ $e
729▕ );

1 C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:505
PDOException::(“SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sessions’ already exists”)

2 C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:505
PDOStatement::execute()

zey34354 2022-04-04 14:33:14
i got these things again
cletuskingdom 2022-04-04 14:33:47
zey34354 2022-04-04 14:33:14
i got these things again

screenshot please

jonny_gret 2022-04-04 14:34:02
Which one can teach me to install jasmin
zey34354 2022-04-04 14:37:06
cletuskingdom 2022-04-04 14:33:47
screenshot please

laravel_discuss-114009.jpg
okay

Noor153 2022-04-04 14:39:38
laravel_discuss-114010.jpg
Hello, what is the cause of this problem?
ErikPf 2022-04-04 14:44:32
Noor153 2022-04-04 14:39:38
Hello, what is the cause of this problem?

laravel_discuss-114013.jpg

cayetanohosma 2022-04-04 15:25:52
zey34354 2022-04-04 14:33:14
i got these things again

It seems that the Sessions table or it not deleted or some previous process create it.

cayetanohosma 2022-04-04 15:26:48
Could you remove all database? if you can, then try php artisan db:wipe and then php artisan migrate –seed
zey34354 2022-04-04 15:35:52
cayetanohosma 2022-04-04 15:26:48
Could you remove all database? if you can, then try php artisan db:wipe and then php artisan migrate –seed

will it remove everything

zey34354 2022-04-04 15:38:55
PS C:xampphtdocseCommerceeCommwece> php artisan migrate –seed
Migrating: 2022_03_19_181248_create_sessions_table

IlluminateDatabaseQueryException

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sessions’ already exists (SQL: create table sessions (id varchar(255) not null, user_id bigint unsigned null, ip_address varchar(45) null, user_agent text null, payload text not null, last_activity int not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)

at C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:725
721▕ // If an exception occurs when attempting to run a query, we’ll format the error
722▕ // message to include the bindings with SQL, which will make this exception a
723▕ // lot more helpful to the developer instead of just the database’s errors.
724▕ catch (Exception $e) {
➜ 725▕ throw new QueryException(
726▕ $query,
727▕ $this->prepareBindings($bindings),
728▕ $e
729▕ );

1 C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:505
PDOException::(“SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sessions’ already exists”)

2 C:xampphtdocseCommerceeCommwecevendorlaravelframeworksrcIlluminateDatabaseConnection.php:505
PDOStatement::execute()

zey34354 2022-04-04 15:39:05
the same problem
|