Is that your expected query?

|
natghi2010 2021-10-24 14:47:52
ttdspp 2021-10-24 14:47:32
i think your query would look like: SELECT (SELECT count(*) FROM ‘matches’ WHERE ‘winner’ = 1 as wins) FROM ‘matches’ as ‘match’ and so on …
Is that your expected query?

I removed the second SELECT

spykelionel 2021-10-24 14:48:04
natghi2010 2021-10-24 14:47:35
normally you have to activally declare namespace at the top

Use namespace?
U prevented that? Okay thanks

ttdspp 2021-10-24 14:48:42
natghi2010 2021-10-24 14:47:52
I removed the second SELECT

still the same error?

natghi2010 2021-10-24 14:48:48
yes
ttdspp 2021-10-24 14:49:27
run php artisan optimize
natghi2010 2021-10-24 14:51:37
ttdspp 2021-10-24 14:48:42
still the same error?

laravel_discuss-98018.jpg

natghi2010 2021-10-24 14:52:01
ttdspp 2021-10-24 14:49:27
run php artisan optimize

for the raw sql?

natghi2010 2021-10-24 14:53:19
spykelionel 2021-10-24 14:48:04
Use namespace?
U prevented that? Okay thanks

not always advisable to do this

ttdspp 2021-10-24 14:56:04
natghi2010 2021-10-24 14:51:37

i think you should revise everything that is inside your select.. try these, replace get() with toSql().. and copy paste to mariadb if it would work.

natghi2010 2021-10-24 14:59:01
ttdspp 2021-10-24 14:56:04
i think you should revise everything that is inside your select.. try these, replace get() with toSql().. and copy paste to mariadb if it would work.

useful

natghi2010 2021-10-24 14:59:11
select (count(*) WHERE ‘match.winner’ = 1 as wins), count(*) WHERE ‘match.winner’ IS NULL as draws, count(*) WHERE ‘match.winner’ != 1 AND ‘winner’ IS NOT NULL as loses from matches as match inner join teams as team on match.team_1_id = team.id where team.id = ?
natghi2010 2021-10-24 14:59:45
natghi2010 2021-10-24 14:59:11
select (count(*) WHERE ‘match.winner’ = 1 as wins), count(*) WHERE ‘match.winner’ IS NULL as draws, count(*) WHERE ‘match.winner’ != 1 AND ‘winner’ IS NOT NULL as loses from matches as match inner join teams as team on match.team_1_id = team.id where team.id = ?

this is messed up

ttdspp 2021-10-24 15:02:06
natghi2010 2021-10-24 14:59:11
select (count(*) WHERE ‘match.winner’ = 1 as wins), count(*) WHERE ‘match.winner’ IS NULL as draws, count(*) WHERE ‘match.winner’ != 1 AND ‘winner’ IS NOT NULL as loses from matches as match inner join teams as team on match.team_1_id = team.id where team.id = ?

did this work in mariadb? if its not, try moving those conditions inside select after join and in a where() function

natghi2010 2021-10-24 15:02:37
ttdspp 2021-10-24 15:02:06
did this work in mariadb? if its not, try moving those conditions inside select after join and in a where() function

no it has a lot of issues. Thanks I will try to repair it.

ttdspp 2021-10-24 15:03:14
sure² no problem..
Manalalsubaei 2021-10-24 17:39:16
Good evening every one.
The language doesn’t change in the browser when I changed it from the config file.
what’s the matter?!
VirtualDemon 2021-10-24 17:40:24
Manalalsubaei 2021-10-24 17:39:16
Good evening every one.
The language doesn’t change in the browser when I changed it from the config file.
what’s the matter?!

php artisan optimize
clear config cache.

pyli_7655 2021-10-24 17:42:04
Manalalsubaei 2021-10-24 17:39:16
Good evening every one.
The language doesn’t change in the browser when I changed it from the config file.
what’s the matter?!

You should need to clear cache and config

pyli_7655 2021-10-24 17:42:25
Using php artisan cache: config
Manalalsubaei 2021-10-24 17:43:12
yah.
all right.
I do it every time ,but I forget it now😅.
Manalalsubaei 2021-10-24 17:43:37
I hope it’s work.
Manalalsubaei 2021-10-24 17:43:50
I will try it.
Manalalsubaei 2021-10-24 17:48:22
VirtualDemon 2021-10-24 17:40:24
php artisan optimize
clear config cache.

It’s work.
Thanks.

Manalalsubaei 2021-10-24 17:48:32
pyli_7655 2021-10-24 17:42:25
Using php artisan cache: config

It’s work.
Thanks.

Manalalsubaei 2021-10-24 17:49:58
laravel_discuss-98040.jpg
Another challenge I meet it.
Manalalsubaei 2021-10-24 17:51:03
It’s take a lot time and doesn’t work.
What’s the matter?
Manalalsubaei 2021-10-24 17:51:42
But another browser work very well.
Manalalsubaei 2021-10-24 17:52:56
I removed the cache and doesn’t work.
VirtualDemon 2021-10-24 17:54:09
Manalalsubaei 2021-10-24 17:51:03
It’s take a lot time and doesn’t work.
What’s the matter?

because of proxy?

2021-10-24 18:03:44
Hello everybody
Is there someone use laravel nova here with excel export library
I need to know how can i add custom row to the Excel file with nova
Cuz i stuck in that
YadavGulshan 2021-10-24 19:48:05
laravel_discuss-98046.jpg
How laravel’s middleware is different?
YadavGulshan 2021-10-24 19:48:39
I mean, it provides the same thing right…. Some kind of authentication using barrier token… So why to even use jwt in laravel??
YadavGulshan 2021-10-24 19:49:31
I see many videos on yt recommending to use jwt… But they didn’t said, why??? Can anyone please help me clearing this doubt..
Nurullah Demirel 2021-10-24 19:51:21
how can ı create cron job in symfony
Nurullah Demirel 2021-10-24 19:51:45
is someone know a good source to learn
|