default route '/' is still listed on top of artisan route:list

See also questions close to this topic

• En dash cause error when Import data using load data in file

  we are using load data infile

  $this->db->query("LOAD DATA LOCAL INFILE '".$file_path."' 
  INTO TABLE excel_details 
  CHARACTER SET  utf8mb4
  FIELDS TERMINATED BY ','
  OPTIONALLY ENCLOSED BY  '\"' 
  LINES TERMINATED BY '\r\n' 
  IGNORE 1 LINES 
  (Email,name,address) 
  SET cid =".$cid.", csvsheet_id=".$csvsheet_id
  ); 
  

  string contain en dash cause 1300 error address contain 2–5
• Woocommerce price filter ordering by Post ID rather than price high to low

  I'm stumped at this one.

  I've got Woocommerce and using the theme 2017 (All other plugins and themes disabled) and I'm looking to order them in price High to low however when I select this dropdown and press it the prices are not being ordered instead it's being ordered by Post ID instead.

  

  All the prices are correct inside of the database also

  
• Allow to remove product automatically added from cart in Woocommerce

  In Woocommerce, I am using this official code snippet to automatically add a to cart a product when customer visit my website:

  add_action( 'template_redirect', 'add_product_to_cart' );
  function add_product_to_cart() {
      if ( ! is_admin() ) {
          $product_id = 1234; //replace with your own product id
          $found = false;
          //check if product already in cart
          if ( sizeof( WC()->cart->get_cart() ) > 0 ) {
              foreach ( WC()->cart->get_cart() as $cart_item_key => $values ) {
                  $_product = $values['data'];
                  if ( $_product->get_id() == $product_id )
                      $found = true;
              }
              // if product not found, add it
              if ( ! $found )
                  WC()->cart->add_to_cart( $product_id );
          } else {
              // if no products in cart, add it
              WC()->cart->add_to_cart( $product_id );
          }
      }
  }
  

  It works fine and adds the product to cart.

  But I want the customers to provide the option to remove this item from cart if they don't want it. But actually the product cannot be removed.

  How can I make the product auto added to cart removable?
• Laravel caching items still hitting the database

  this code is not caching the items.

  its getting into the condition but still hitting the database. what could be wrong?

  the items are saved in redis. and I can access it

  get laravel:stores_ar_19_36_80_93

  My Controller looks like this.

  class StoresController extends Controller
    {
      public function get(Request $request)
       {
            if (\Cache::has($key)) {
                \Log::info('cache hit on stores');
                 return \Cache::get($key);
             }
          return Store::with('openingHours', 'currency', 'storeTags.tag')->find($areaStore);
       }
    }
  

  UPDATE

  I'm using the waavi translation package and apparently something is getting messed up with that. it's not a caching problem.
• Laravel: Selecting Items with WHERE condition is in joined table

  I have two tables (films and reviews). One Film HasMany Reviews and one Review BelongsTo one Film

  Relations: Film.php

  public function reviews()
  {
      return $this->hasMany('App\Review');
  }
  

  and Review.php

  public function film()
  {
      return $this->belongsTo('App\Film');
  }
  

  Since I am using Laravel Eloquent relations, I want to build a list of films ordered by reviews using Eloquent. Reviews go from 0 = non rated, to 5 = maximum rating.

  In plain English I need:

  • join the two tables
  • get all the films that has reviews
  • group by film_id
  • calculate the average (one film could have many reviews so I need the average)
  • organize the resulting list
  • get the list

  My solutions using the Query Builder get an error:

  $best_films = DB::table('films')
               ->join('reviews', 'reviews.film_id', '=', 'films.id')
               ->select('films.id', 'avg(reviews.rating)')
               ->groupBy('films.id')
               ->orderByRaw('avg(reviews.rating) DESC')
               ->get();
  

  With this I get the following error: Column not found: 1054 Unknown column 'avg(reviews.rating)' ...

  Using Eloquent ORM I can not order by columns in oteher table. Something like this does not work:

   $films = Film::whereHas('reviews')->orderBy('reviews.film_id', 'desc')->get();
  

  I get the error: Column not found: 1054 Unknown column 'reviews.film_id' in 'order clause'...

  My Question: Any idea how to solve that problem? (I would prefer using Eloquent Orm)
• How to count in laravel from different table

  Hei I'm making data table to show how many comment that on my post from user that login and making that post but I got some bug it retrieve only 1 but actually I got like 26 comment, I dont know why.

  In my controller:

  public function getCountComment()
  {
      $user = Auth::user();
      return $all_count = $user->post()
          ->withCount('comment_to_post')
          ->take(5)->get();
  }
  

  Model comment.php:

  public function comment_to_post()
  {
      return $this->belongsTo('App\Post','id_user');
  }
  

  I've got like 26 comment but it retrieve only 1 comment count. Hope you can help me guys

  "comment_to_post_count": 1
• rails 5 route locale in mainapp and mounted engine

  I'm build a rails 5 application and I configured the locale like so

  # config/routes.rb
  scope '/:locale' do
    resources :organizations, except: [:delete] do
      get 'settings'
      mount MyEngine::Engine => '/', as: :myengine
      end
      IchE2bR3::Engine.routes.draw do
      end
  end
  

  Unfortunately, MyEngine routes also have the scope for locale.

  MyEngine::Engine.routes.draw do
    scope '/:locale' do
    end
  end
  

  Right now my URLs look like these

  www.example.org
  www.example.org/en/organizations/1/settings
  www.example.org/en/organizations/1/en/myenginepath
  

  As you can see in the third URL, en appears twice. Is there a way to mount engines and join/share the scope with the mainapp? Am I mounting the engine awkwardly/not in the right way?

  Thanks for the help
• How to seperate ProdcutsController and ImagesController if is form the same?

  I have a productsController and it basicly doing CRUD nicely. But there is a issue. My controller methods getting too long. So I decided to seperate ImageController and Image table from products. Because the images need to has on CRUD. I created the relationship between them.

  However, there is one only one form for creating image and products detail. So, what is the best practice when hitting end point both images and products should be stored. Also what should be the route look like ?

  ---

  Note: This is a general question. Also code is too long. That's why I didn't add the code here.
• How to use two controllers method in one form on laravel?

  I have a productsController and it basicly doing CRUD nicely. But there is a issue. My controller methods getting too long. So I decided to seperate ImageController and Image table from products. Because the images need to has on CRUD.

  However, the form which is uploading this items is the same with uploading images. So, what is the best practice to make two controller from one form? Also what should be the route look like ?

  ---

  Note: This is a general question. Also code is too long. That's why I didn't add the code here.
• laravel 5.5 , vuejs 2 redirect for auth:api

  i have a problem when i try to access in a page protect by auth:api with my vuejs function ($http ) it return this error :

  POST http://localhost:8000/api/AddQuestion 401 (Unauthorized)

  i'd like to redirect it to login page if user is a guest (i use api_token for my users ) thank's a lot

  this is my vue function

        AddQuestion( NewQuestion ){
  
            this.$http.post('/api/AddQuestion',{
  
                       api_token:this.usertoken ,
  
                      Title_Forum : NewQuestion[0] ,  
  
                      Text_Forum : NewQuestion[1] ,  
  
  
  
                }).then(response => {
  
                            this.questions = response.data ;
  
                      }).catch( (error) =>{   console.log(error) }
  
                );
  

  and this is routes/api.php

    Route::middleware('auth')->group(function () {
  
        Route::post('/AddQuestion','ForumController@AddQuestion') ;
  
    });
  

  thank's a lot
• SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'created_at' in order clause is ambiguous Laravel 5.5

  I just don't know what's wrong with my code and why it produces this error

  SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'created_at' in order clause is ambiguous (SQL: select * from processes inner join bags on processes.bag_id = bags.id where bags.type = Recyclable and date(processes.created_at) = 2018-09-18 00:00:00 order by created_at desc limit 1) and here's my code

  $bag = Bagcollect::join('bags', 'bagcollects.bag_id', '=', 'bags.id')
          ->select('bags.type')
          ->where('bagcollects.bag_id', $request->input('bag_id'))
          ->first();
  
     //this query produce error
      $processexist = Process::join('bags', 'processes.bag_id', '=', 'bags.id')
          ->where('bags.type', $bag->type)
          ->whereDate('processes.created_at', Carbon::today())
          ->latest()
          ->first();
  
• Why am I getting a "Class 'App\Providers\Form' not found" error in Laravel 5.5.43?

  I did a Laravel 5.5.43 installation this morning with the following Composer command:

  composer create-project laravel/laravel project-name
  

  I then ran the following command in the project folder to install Laravel Collective:

  composer require "laravelcollective/html":"^5.4.0"
  

  I then added the following under providers in config/app.php:

  Collective\Html\HtmlServiceProvider::class,
  

  And I added the following under aliases in config/app.php:

  'Form' => Collective\Html\FormFacade::class,
  'Html' => Collective\Html\HtmlFacade::class,
  

  After that, I wanted to create custom form components, so I ran the following Artisan command:

  php artisan make:provider FormServiceProvider
  

  And in that new provider file, I added the following line to the boot method:

  Form::component('customText', 'components.form.text', ['name', 'value' => null, 'attributes' => []]);
  

  Lastly, I added the following to providers in config/app.php:

  App\Providers\FormServiceProvider::class,
  

  When I do that though and refresh the Laravel instance from the browser, I get the following error:

  Class 'App\Providers\Form' not found
  

  However, if I add the following at the top of the FormServiceProvider.php file, then it works:

  use Collective\Html\FormFacade AS Form;
  

  I understand the concept of namespaces and why that makes the Form::component method in the boot method in the file properly work, but what I don't get is why I need to add that use line to the file at all.

  Isn't the 'Form' => Collective\Html\FormFacade::class, line in the aliases array in the app.php file supposed to do that for me so I don't need to add the use line to the FormServiceProvider.php at all? What am I missing / doing wrong / not understanding?

  Thank you.
• Laravel .env file returns wrong data

  I've been trying to get data from my database in laravel 5.7.3, but it seems to be using the wrong database name, username and password as it returns this error:

  SQLSTATE[HY000] [1045] Access denied for user 'homestead'@'localhost' (using password: YES) (SQL: select * from `tasks`)
  

  My .env file database section is also according to my needs and set like this:

  DB_CONNECTION=mysql
  DB_HOST=127.0.0.1
  DB_PORT=3306
  DB_DATABASE=mrdb
  DB_USERNAME=root
  DB_PASSWORD=
  

  PS: My app environment is still local. I can also migrate and put in data into database with artisan tinker without issues, but cannot just fetch data from the database.

  The only way it gets to work is to change config/database.php mysql section to my parameters, which I believe it isn't just right.

  Why is the .env not wanting the change when the database is called?
• Laravel command: getting today's date on daily tas

  I wrote an Artisan command (L5.2) that takes in a datetime that is relative to the day the command runs. Would date(...) or time() inside of App\Console\Kernel::schedule give you the exact time when the task is scheduled/runs? How would I directly check this, beside waiting to see if the task runs?

  So for example, my command should run every day at midnight, but use an argument of yesterday (or some time in the past).

  $date = date('Y-m-d H:i:s', time() - 60 * 60 * 24); // Just an ex
  $schedule->command("command:do-this '{$date}'")->daily();
  

  I'm not looking to hardcode this in the command itself, as I would like to be able to use this manually with specific datetime arguments.
• Run php artisan command in out of laravel project

  I am writing an installer for laravel project.
  but for some reason, I don't run this installer from laravel project.
  I use PHP code. I want to use php artisan migrate on my installer and I know that I can use this command system("php artisan migrate") but I don't want to use system functions on my installer. Is there any way to artisan command on PHP out of laravel?