Dalma

Can you also share your migration file?

That is a great idea thank you!

What are others doing to seed tables when they are created in production environment.

I'm in the progress of moving from a hardcoded menuing structure to a table driven one using brand new tables. My development environment has the menus populated but as I release my code to production these tables will need to be populated immediately. Are you doing something at a database utility level or creating seeders?

Are you using composer on this install, if so have you run composer update?

If you have run composer require xxx/xxx in your development environment then this will update composer.json and composer.lock which when pushed to your repository via git will be pulled when the forge script runs.

git pull origin master <--- will download all of your changes including composer.json and composer.lock composer install --no-interaction --prefer-dist --optimize-autoloader <--- will download xxx/xxx package on your server

Okay I have figured this out so I thought I would share

$users = User::all();
foreach($users as $user){
  $roles = $user->roles->unique()->pluck('id');
  $user->roles()->sync([]);   // to clear old association
  $user->roles()->sync($roles);
}

Hi everyone I'm looking for some elegant way to correct an issue I created. I have a Roles table which is a Many-to-many relationship with Users. Due to a bug in my code I now have Users that have the same Role attached 6 or 7 times.

I'm looking for an elegant way to code an update to fix the following example

User: Jim Jones
Role: Technician
          Technician
          Technician

User:Peter Smith
Role: Technician
          Coordinator
          Designer
          Designer
          Designer

I guess basically I'm wanting to return a list of unique attached roles and then perform a sync of these ids

Could your file be in the wrong location?

I expect that you are getting the last id listed?

You are building your modal after your foreach list has completed which means the value you have in $game->id is the last one. You will need to use some javascript to read the id from your table.

      {!! Form::model($game, ['method' =>'PATCH', 'action'=> ['[email protected]', $game->id], 'files'=>true, 'enctype'=>'multipart/form-data']) !!}
      

I would also vote that you stagger your backup's but assign each machine a specific time.

Hi Ruborg, you start an OS command that is a queue worker. Details are here: https://laravel.com/docs/5.7/queues

Sorry I didn't think to search first. Thank you for your help.

I see that the forge interface shows the latest deployment request directly on the UI. Is there an underlying log file with a series of deployments, if so does anyone know the file name and location?

Something happened yesterday on my site where existing code used for email notification events is suddenly not working today. This code has been running in production for two months and now today is throwing 'not property of object' errors. Using tinker I can pull up the object and it works correctly so I want to see if an install of one application program as triggered a laravel or symphony update when it was released through forge.

Try changing your first() to get() and see if the error goes away.

For my schedules I specify the timezone. Below is an example from the Laravel docs

$schedule->command('foo')
          ->weekdays()
          ->hourly()
          ->timezone('America/Chicago')
          ->between('8:00', '17:00');

Phpstorm

This series is long but it builds step by step. I followed the entire series and then have viewed about another 100 posted on here and with each I was able to grow in my understanding.

I have been a software developer for a long time but had not worked with PHP at all and until recently didn't even know of Laravel. I found the following video series and by the time I was done I was in good shape.

This is on the DevMarketer youtube channel - Called build a blog with Laravel

https://www.youtube.com/watch?v=R8B4og-BeCk&list=PLwAKR305CRO-Q90J---jXVzbOd4CDRbVx&index=1

After following this series I was prepared for Jeff's more focused and advanced videos.

Are you loading the default bootstrap js as well somewhere, is it required by your library?

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js">

Using the same Chrome inspection tool do you see any output in the Console section as it will show JS errors there?

If you look this example https://appdividend.com/2018/02/07/laravel-ajax-tutorial-example/ and jump down to step 4.

I was successful with this format for reading data attributes

var $id = $(this).data('id');

That is great news

Are you trying to do a drop from a ssh command line? I would suggest that you need to either be the database user via su dbusername or the root user.

I think the issue you are facing is not with composer but with git on the forge server. I have run into this and had to execute a git command to stash my changes.

If you have not already done so, check to see the URL being presented for images that work and those that don't work and compare paths and domain names. Hopefully something should be apparent and from that we can work to better assist you.

I found my solution. I needed to wrap the inital or clauses in a closure

        $hightech = ['0' => 'Please Select'] +
            User::where(function ($query) use ($myofficeid) {
                $query->where('office_id','=', $myofficeid)
                      ->orwhereHas('offices', function ($query) use ($myofficeid){
                          $query->where('offices.id', '=', $myofficeid);
                      });
            })->where('status','=', 1)
            ->whereHas('roles', function ($query){
                $query->where('name','=', 'High Tech Coordinator');
            })->orderBy('name')->pluck('name','id')->toArray();

try something like:

'departement_id' => Faculty::find($facultyId)

->whereHas( 'departements', function ($query) use ($request['departementName']) {
    $query->where('name', $request['departementName']);
})
->get()

I have a query that I'm struggling to get to bracket correctly, query appears at the end of this post

I have three relations:

User
User->offices()
User->roles()

The User has a default office id stored in the office_id field and a ManytoMany relationship accessed via the User->offices() relation and ManytoMany relationship accessed via the User->roles() relation.

to pseudocode

if $myofficeid > 0 ( find user where office_id = $myofficeid OR user->offices().id = $myofficeid) AND user->roles() has name = "High Tech Coordinator)

what I'm getting now is effectively

if $myofficeid > 0  find user where office_id = $myofficeid OR (user->offices().id = $myofficeid and user->roles() has name = "High Tech Coordinator)

I assumed that trying to place both of the office related queries in the ->when closure would bracket them together.

$hightech = ['0' => 'Please Select'] + User::where('status','=',1)
            ->when($myofficeid > 0 , function($query) use($myofficeid){
                $query->whereHas('offices', function($query) use ($myofficeid){
                    $query->where('offices.id', '=', $myofficeid);
                })
                     ->orWhere('office_id','=',$myofficeid);
            })
            ->whereHas('roles', function ($query){
                   $query->where('name','=', 'High Tech Coordinator');
            })
            ->orderBy('name')->pluck('name','id')->toArray();

No the conditionals flow as follows:

@if 
@elseif
@else 
@endif

or

@if 
@elseif 
@endif

I see 3 @if but 4 @endif statements??

You have an extra @else and @endif in the posted code

I think that you are missing ->total in your comparison statement.

After you have a successful ajax call to populate your database you can in your javascript clear the data from the modal element(s).

How do you have your eloquent relationships defined between your tables?

Using JQuery you can easily execute code that based on data embedded in your page can replace existing classes in elements.

If you had a div or field with a class of bg-light you could via JQuery remove bg-light and change it to bg-success as an example.

I don't think that laravel loaded Php on your computer, it must have been installed previously. Normally on a windows machine a package like WAMP is installed which provides Php and MySql. I would guess that you already had Php on your machine.

Hi @sergiu17 that worked perfectly.

Would the substituted code then end up as

$$parent

I have a large blade view file where a section of code is repeated except for a variable name that is table specific.

I have a view with a parent, child, grandchild relationship and within each I have 30 line block of code that repeats except that in each it has a {{$parent->id}} or {{$child->id}} or {{$grandchild->id}} embedded.

I'm trying to pull all 30 lines of code into another blade template and then pass in a variable being the $table name.

Something like

@include('admin.project.scheduleblock', ['table' => '$parent'])

@include('admin.project.scheduleblock', [table => '$child'])

If this does in fact work I can't figure out the appropriate syntax.

Partial code in my include file

<div class="schedule-list">
    @foreach($table->schedules as $item)
        <div class="form-row">
            <div class="col-md-3">
                @if($loop->first)
                    <label class="col-form-label-sm"><small>Start Date</small></label>
                @endif
                <input type="text" class="form-control form-control-sm " name="start_dt" value="{{$item->start_dt->format('m-d-Y H:i')}}" disabled>
            </div>
            <div class="col-md-3">
                @if($loop->first)
                    <label class="col-form-label-sm"><small>End Date</small></label>
                @endif
                <input type="text" class="form-control form-control-sm " name="end_dt" value="{{$item->end_dt->format('m-d-Y H:i')}}" disabled>
            </div>

Hi @cronix I don't have any model specific aliases in the /config/app.php. I will chock this Tinker issue up to something unusual with the name of my class. As always thank you for your help.

Hi @cronix in my regular code I do have the use statement in place. When using Tinker I never need to specify the App\ name except for this model.

[!] Aliasing 'Stage' to 'App\Stage' for this Tinker session.
=> App\Stage {#4334
     id: 12,
     created_at: "2018-10-04 09:00:29",
     updated_at: "2018-10-04 09:00:29",
     name: "Not Started",
   }
>>>

All of the other models have the Aliasing message, this must mean that the class name of Schedule must confuse tinker.

I have a model named Schedule that has an unexpected namespacing issue, it behaves differently than my other models. Laravel 5.7

I will contrast two models

Schedule (not working as expected - this is also my first polymorphic model)

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Spatie\Activitylog\Traits\LogsActivity;


class Schedule extends Model
{
    use LogsActivity;

    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'schedules';

    /**
    * The database primary key value.
    *
    * @var string
    */
    protected $primaryKey = 'id';

    /**
     * Attributes that should be mass-assignable.
     *
     * @var array
     */
    protected $fillable = ['start_dt', 'end_dt', 'note', 'schedulable_id', 'schedulable_type'];

    public function schedulable()
    {
        return $this->morphTo();
    }
}

Task model that works as expected

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Spatie\Activitylog\Traits\LogsActivity;
use App\Events\TaskUpdated;


class Task extends Model
{
    use LogsActivity;

    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'tasks';

    /**
    * The database primary key value.
    *
    * @var string
    */
    protected $primaryKey = 'id';

    /**
     * Attributes that should be mass-assignable.
     *
     * @var array
     */
    protected $fillable = ['phase_id', 'name', 'start_date', 'end_date', 'required', 'stage_id', 'tech_id', 'notes', 'technotes', 'status_id', 'dependant_upon', 'weight'];

    protected static $logFillable = true;

    public function phase()
    {
        return $this->belongsTo('App\Phase');
    }
    public function stage()
    {
        return $this->belongsTo('App\Stage');
    }
    public function tech()
    {
        return $this->belongsTo('App\User');
    }
    public function status()
    {
        return $this->belongsTo('App\Status');
    }
    public function user()
    {
        return $this->belongsTo('App\User');
    }

    public function schedules()
    {
        return $this->morphMany('App\Schedule','schedulable');
    }

    protected $dispatchesEvents = [
      'updated' =>   TaskUpdated::class,
    ];
}

from the following tinker commands

Task::first()

This returns the first model as expected

Schedule::first()

This fails with the message PHP Fatal error: Class 'Schedule' not found

App\Schedule::first()

This works

Both of the models are in the normal laravel file structure in the app directory.

Is Schedule perhaps a reserved word or have I overlooked the obvious?

So your problem does not seem to be network related.

Is your computer connected to domain controller or any other device that may act as a DNS controller?

From a command prompt try and run a traceroute

tracert localhost

Do you have multiple hops to your host? Mine is a single hope with less than 1 ms response.

My first guess would be something unusual in your hosts file.

Can you share the content of your C:/Windows/System32/drivers/etc/hosts file?

Do you have something like?

127.0.0.1 localhost
::1 localhost

Do you have other content in this file?

Of course this makes sense. Thank you.

Was this a previously working database connection or is this a new site?

I'm working on a project management tool were there will be a series of tasks. Each task may have either

• 1. a single date
• 1. a single date range with a start date and end date
• 1. multiple date ranges each with a start and end date

How have you presented this in the UI and then how did you store the data?

Have you configured Wamp's Apache server to host your site and respond on port 8000 or are you attempting to use the small server included with laravel which is started via

php artisan serve

As the php server responds on port 8000 I suspect that this is the server that you are attempting to hit and it may not be running unless you issued the command above.

Is this a new deployment or are you releasing and update to your existing site?

There are always other options but this is a clean and easy to implement package.