laurent1979
Member Since 3 Years Ago
Experience
2,100 experience to go until the next level!
In case you were wondering, you earn Laracasts experience when you:
- Complete a lesson — 100pts
- Create a forum thread — 50pts
- Reply to a thread — 10pts
- Leave a reply that is liked — 50pts
- Receive a "Best Reply" award — 500pts
Completed
Awards
-
Start Your Engines
Earned once you have completed your first Laracasts lesson.
-
First Thousand
Earned once you have earned your first 1000 experience points.
-
One Year Member
Earned when you have been with Laracasts for 1 year.
-
Two Year Member
Earned when you have been with Laracasts for 2 years.
-
Three Year Member
Earned when you have been with Laracasts for 3 years.
-
Four Year Member
Earned when you have been with Laracasts for 4 years.
-
Five Year Member
Earned when you have been with Laracasts for 5 years.
-
School In Session
Earned when at least one Laracasts series has been fully completed.
-
Welcome To The Community
Earned after your first post on the Laracasts forum.
-
Full Time Learner
Earned once 100 Laracasts lessons have been completed.
-
Pay It Forward
Earned once you receive your first "Best Reply" award on the Laracasts forum.
-
Subscriber
Earned if you are a paying Laracasts subscriber.
-
Lifer
Earned if you have a lifetime subscription to Laracasts.
-
Laracasts Evangelist
Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.
-
Chatty Cathy
Earned once you have achieved 500 forum replies.
-
Laracasts Veteran
Earned once your experience points passes 100,000.
-
Ten Thousand Strong
Earned once your experience points hits 10,000.
-
Laracasts Master
Earned once 1000 Laracasts lessons have been completed.
-
Laracasts Tutor
Earned once your "Best Reply" award count is 100 or more.
-
Laracasts Sensei
Earned once your experience points passes 1 million.
-
Top 50
Earned once your experience points ranks in the top 50 of all Laracasts users.
-
Community Pillar
Earned once your experience points ranks in the top 10 of all Laracasts users.
Replied to DB::select() Error Sql #1140
Thank you for your reply,
I did that and it worked, I wanted to know why the query I had worked perfectly when I typed it in the terminal, but not with laravel. I mean in the terminal or a SQL GUI, this query works fine
Started a new Conversation DB::select() Error Sql #1140
Hello,
I have a simple query :
$query = 'SELECT count(date) AS total, substr(date, 1, 4) AS annee FROM sort_orders_by_times WHERE date LIKE \'' . $date .'%\'';
return DB::select($query);
This runs fine in the terminal mariadb client, however laravel gives me this error :
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
I tried to disable strict mode, which doesn't sound like a good solution anyway, i tried DB::raw and the pdo driver, nothing worked. What am i doing wrong ? Thank you !