skoobi

Hi @devfrey. I checked it over this morning and found that it was due to me adding a length to the "tag_number" integer.

Changed $table->integer('tag_number', 11)->nullable(); to $table->integer('tag_number')->nullable(); and it worked. Im still not quite sure why, im sure i used to put a length into the integer before! May be my old age lol.

Many thanks

Hi.

Im trying to setup a migration which on delete cascades but i keep getting the error::

SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key (SQL: create table `stock_list` (`id` bigint unsigned not null auto_increment primary key, `user_id` int unsigned not null, `name` varchar(255) null, `tag_number` int null auto_increment primary key, `notes` text null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

Heres my migration for the stock_list::

Schema::create('stock_list', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->unsignedInteger('user_id');
            $table->string('name', 255)->nullable();
            $table->integer('tag_number', 11)->nullable();
            $table->text('notes')->nullable();
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
        });

I don't quite understand why this error is popping up and on another project which this was copied and pasted from (BirdBoard Tutorial) it works perfect)

Any help would be grateful

Cheers

Found a solution.

It looks like apache was running in the background which I think was stopping it from loading nginx etc.

Heres a link for some troubleshooting​ guides.

https://gist.github.com/adamwathan/6ea40e90a804ea2b3f9f24146d86ad7f#problem-im-getting-a-502-bad-gateway-error

After stopping apache and restarting valet it all worked.

Hi.

For some reason yesterday, I switched my machine on and none of my test sites worked. I got the message "Failed to open page", "Safari cannot connect to the server".

I checked 'brew services list' and found that some are yellow and some are green. dnsmasq, nginx, php and redis are the ones in yellow and the rest are green. Yellow normally means it cannot get the status. All has been working perfectly​ up until​ yesterday. Nothing has changed on the system.

dnsmasq   started root       /Library/LaunchDaemons/homebrew.mxcl.dnsmasq.plist
[email protected] started root       /Library/LaunchDaemons/[email protected]
nginx     started root       /Library/LaunchDaemons/homebrew.mxcl.nginx.plist
php       started root        /Library/LaunchDaemons/homebrew.mxcl.php.plist
[email protected]   started            /Library/LaunchAgents/[email protected]
redis     started root        /Library/LaunchDaemons/homebrew.mxcl.redis.plist

Things I've​ tried:

• Update composer global
• update brew
• valet install
• valet restart
• Unlink from brew and install again

Nothing seems to have worked. Yesterday I switched the machine back of and then back on again and all was working, till this morning when I tried to access a different project and im getting the same as yesterday.

Any ideas?

Cheers

The only solution I can find is to use anything Firefox and then import the Valet certificate. https://github.com/laravel/valet/issues/296

I tried Firefox and chrome but same issue. I've un-secured the project and resecured and still the same Heres a more detaild error from firefox

myapp.test uses an invalid security certificate. The certificate is not trusted because the issuer certificate is unknown. The server might not be sending the appropriate intermediate certificates. An additional root certificate may need to be imported. Error code: SEC_ERROR_UNKNOWN_ISSUER

Hi. Im using Safari and in the last few days, not sure if there was an update or what, but all my .test sites I have which are served by valet are now showing "This Connection Is Not Private" warning.

I've done the usual thing and "trust All" for the certificates but nothing seems to work. I just cannot access any of my .test sites through Safari. I know i can use Firefox or Chrome but I just like Safari .

Anyone else had this issue.

Ive tried several variations of

orderByRaw('SOUNDEX(username), LENGTH(username), username desc') 

but as an example If i am at user BT101 (last of the BT users) and then click previous, I would expect to get the last of the A users, so in this case A1476, but it doesnt. It jumps straight to A989 which is correct in terms of its the last user in that order if it was in numerical.

Hi.

I'm having an issue when trying to order the users by username and using as a next / previous button!

I am using view composer to populate a sidebar that has a previous and next button.

I then get the current id from the URL segment and find the current user.

How i want them ordered is by Username as follows :::

A001 A009 A110 A212 A330 A789 A982 A1012 A1234

BT001 BT009 BT110 BT212 BT330 BT789 BT982 BT1012 BT1234

SA001 SA009 SA110 SA112 SA330 SA789 SA982 SA1012 SA1234

etc...

But they're not showing up like this. They either go from A1500 to A150 or when it get to the next row of usernames it just goes back the the start.

Here's the code i have already:::

 $user = Auth::user();
        $id = request()->route('id');
        $customer = User::where('id', $id)->first();
        $mail_centre_id = MailCentreHelper::get_mail_centre_id();


          
        $previous = User::where('username', '<', $customer->username)
                ->findMailCentre($mail_centre_id)
                ->orderByRaw('SOUNDEX(username), LENGTH(username), username desc')
                ->status([1,2,3,4,5,6,9])
                ->pluck('id')
                ->first();

          $next = User::where('username', '>', $customer->username)
                ->findMailCentre($mail_centre_id)
                ->orderByRaw('SOUNDEX(username), LENGTH(username), username asc')
                ->status([1,2,3,4,5,6,9])
                ->pluck('id')
                ->first();

Any help or ideas would be grateful..

Many thanks

Have you checked the test .env file. When you run tests, it creates a separate .env file to run.

You can create a .env.testing file to add your credentials etc for the test environment.

https://laravel.com/docs/5.7/testing

Thats my only idea on it i think. :)

Looking at the result it may be its not passing 'stream_id' through.

If you don't need the stream_id (which looks like you may do) then you can set it to null in the database or nullable() in the migration.

Sorry for the late reply. I don't seem to be getting any emails from Laracast!

I have done as you have here but I'm​ getting `Cannot use object of type stdClass as arr

The one thing which I need to try and get working is that telephone etc can change. I.e. it may be name or address etc Ive tried so many different things to try to get it to work that im at a loss.

I like the Accessors, I've ​learned​ something new :)

Ok im pretty confused.

Ive tried to access

{
"type":"account",
"old":{
    "telephone":"12345678",
    "email":"[email protected]"
},
"new":{
    "telephone":"12345678333",
    "email":"[email protected]"}
}

By using

// Get the record
$data = CustomerActivity::where('user_id', $user->id)->get();
$activities = json_decode($data);


// In blade
@foreach($activities as $activity)
<tr>
    <td>{{ \Carbon\Carbon::parse($activity->created_at)->format('d/m/Y H:i:s') }}</td>
    <td class="textLeft">
         <strong style="text-transform: capitalize;">Old</strong>:: {{ $activity->data }} <br>
        {{-- <strong style="text-transform: capitalize;">New</strong>:: {{ $activity->data['new']['telephone'] }} --}}
    </td>
</tr>
@endforeach 

// The dd output
array:1 [▼
  0 => {#822 ▼
    +"id": 29
    +"user_id": 447
    +"data": "{"type":"account","old":{"telephone":"123456783","email":"[email protected]"},"new":{"telephone":"123456783333","email":"[email protected]"}}"
    +"old": null
    +"new": null
    +"type": null
    +"created_at": "2019-01-28 15:27:32"
    +"updated_at": "2019-01-28 15:27:32"
  }
]


// What I have tried
{{ $activity->data->new['telephone'] }}
{{ $activity->data['new']['telephone'] }}
{{ $activity['data']['new']['telephone'] }}
{{ $activity['data']->new['telephone'] }}
// Also user the $activity[0] etc.. Cant remember what gave me the 'data'. I think it was if I returned the $activity in the view.

But none seem to work. I know in the grand scheme of it all it will need to be a $key, $val instead of the telephone as it will be dynamic, but if I can get it working then I'll have a bit of a chance.

Is there any Laracast videos which go into this in detail? Or can someone help with this.

Many thanks

Hi @mikemacdowell.

Thank you for your reply. I forgot to reword the post. I changed the database to grab the encoded json and add it all like so::

$data = json_encode([
            'type' => 'account',
            'old' => [
                'telephone' => Auth::user()->details->telephone,
                'email' => Auth::user()->email
            ],
            'new' => [
                'telephone' => $request->get('telephone'),
                'email' => $request->get('email')
            ]
        ]);

which produces '{"type":"account","old":{"telephone":"12345678","email":"[email protected]"},"new":{"telephone":"12345678333","email":"[email protected]"}}'

For whatever reason I cannot for the life of me get it to display the correct data.

Many thanks

Hi., Sorry I don't do much with JSON and am trying to learn/use it more to learn.

I wanted to add a custom activity tracker to a small test project I have that tracks the old and new values from a webform. So if a user updates their phone number it logs the old value and the new one.

The way it works at the moment is that when an user saves their details, It grabs the old data and the new data and saves it to the database under old and new columns::

public function saveActivity($request)
    {
       $data = json_encode([
            'type' => 'account',
            'old' => [
                'telephone' => Auth::user()->details->telephone,
                'email' => Auth::user()->email
            ],
            'new' => [
                'telephone' => $request->get('telephone'),
                'email' => $request->get('email')
            ]
        ]);
        $activity = Helpers::saveUserActivity($data);
    }

this saves the data into the data field along with the authenticated user id.

What I can quite get my head around is displaying it on a blade template.

The issue I think I'm going to get is if theres a different types which I want to filter and there will be different fields depending on the type.

Can someone point me in the right direction with this one.

Many thanks

Just checked and im not passing through the public $validator;

So should look like

public $validator;


**
     * Determine if the user is authorized to make this request.
     *
     * @return bool
     */
    public function authorize()
    {
        return true;
    }

    /**
     * Get the validation rules that apply to the request.
     *
     * @return array
     */
    public function rules()
    {
        return [
            'courier_id' => 'required_if:send_by,4|numeric',
        ];
    }

    /**
    * Overrid Handle a failed validation attempt.
    *
    * @param  \Illuminate\Contracts\Validation\Validator  $validator
    * @return void
    *
    * @throws \Illuminate\Validation\ValidationException
    */
    protected function failedValidation(\Illuminate\Contracts\Validation\Validator $validator)
    {
        $this->validator = $validator;
    }

Ah ok. Strange as it works on other validation. Ill have to go back and double check that its the same as the others and not been changed ...

Cheers

Hi. Im getting an odd issue where I cannot validate inputs.

When trying to add a required_if attribute to the courier_id field it comes back ass a pass.

The strange thing is, if I make it a required field it also passes.

Controller (for testing)::

public function store(StoreDespatchRequest $request, User $user)
{
        if (isset($request->validator) && $request->validator->fails()) {
            Toaster::danger("It looks like there is a problem!!");
            return redirect()->back()->withErrors($validator)->withInput();
        }
        return $request->all();
}

StoreDespatchRequest::

**
     * Determine if the user is authorized to make this request.
     *
     * @return bool
     */
    public function authorize()
    {
        return true;
    }

    /**
     * Get the validation rules that apply to the request.
     *
     * @return array
     */
    public function rules()
    {
        return [
            'courier_id' => 'required_if:send_by,4|numeric',
        ];
    }

    /**
    * Overrid Handle a failed validation attempt.
    *
    * @param  \Illuminate\Contracts\Validation\Validator  $validator
    * @return void
    *
    * @throws \Illuminate\Validation\ValidationException
    */
    protected function failedValidation(\Illuminate\Contracts\Validation\Validator $validator)
    {
        $this->validator = $validator;
    }

View::

<div class="row despatchSection">
            <label class="inlinelabel">SEND BY</label>
            <select class="despatchSelect" name="send_by" id="send_by">
                @foreach($forwarding_by as $sent_by)
                <option value="{{ $sent_by->id }}" @if($customer->forwarding->forward_by_id == $sent_by->forward_by_id) selected @endif>{{ $sent_by->title }}</option>
                @endforeach
            </select>
        </div>

        <div class="row despatchSection" name="courier">
            <label class="inlinelabel">COURIER</label>
            <select class="despatchSelect" name="courier_id" id="courier">
                <option value=""></option>
                @foreach($delivers_by as $deliver_by)
                <option value="{{ $deliver_by->id }}">{{ $deliver_by->title }}</option>
                @endforeach
            </select>
        </div>

Response::

{
_token: "uXeep3ih8wZeifdq4NpB51syruMZpYjq3EySnPy8",
letters_out: "2",
large_letters_out: "0",
parcels_out: "0",
send_by: "4",
courier_id: null,
tracking_ref: null,
postage_cost: "1",
total: "3.80"
}

Any ideas on why its not picking up null and passing the request

Hi @snapey. It's running under root. I'm presuming it has the correct rights to see the folder, its all set up using Forge. The rest of the crons work.

Ye that command works perfectly. This is what's confusing me!

Hi @dalma. Ye sure, In the config it has an array to specify a disk to backup to so

'destination' => [

         /*
          * The disk names on which the backups will be stored.
          */
         'disks' => [
             'local',
         ],
     ],

I have it set to ftp. and the connection is good and all works when running the backup via the console.

Hi. Im getting an error when backing up to an ftp server through a task schedule.

The error is ::

Exception message: The dump process failed with exitcode 127 : Command not found : sh: 1: /usr/bin/mysqldump: not found

Now i know its installed because, well I installed it and i can run it from /usr/bin/mysqldump and if i run the command to backup from ssh it also works fine. But when its scheduled it just keeps failing.

On my testing server which is an exact duplicate of the production server, it works perfectly!

Heres some of the code:::

Kernel.php

$schedule->command('backup:run --only-db')->everyThirtyMinutes()->environments(['production']); // set to 30min for testing...

config/database.php

'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
            'dump' => [
                'dump_binary_path' => '/usr/bin',
            ]
        ],

Any ideas. According to spatie its a server config issue but if I can run it via the command line on the server, surely it should work from the schedule...

Cheers

Ah, thank you, guys. I'll try that in a bit and report back.

Hi @snapey They go from A then BT, TF so Laravel is doing as it should but is there a way to order them by the string and numeric so its like so::

A101 A102 A111 A1101 BT101 BT134 TF455 TF456 etc.

whats happening at moment is

A101 A1001 A1002 A102 A1020

BT101 BT134 TF455 TF456

Cheers

Hi.

I have a search query which grabs all the users and orders them by username.

In the search i use ->orderBy('username', 'asc') which will order them to a point...

The issue I'm getting is if say username is, A100 and then there's A1000 its order is then A100, A1000, A1001, A1002 etc and later when it gets to A110 it then goes A1100 etc.

Is there a way to order them correctly.

Cheers

Ok so after a lot of digging around and learning about Nginx i found a solution...

In the nginx config file i added ::

rewrite ^/registration.php /registration permanent;

This works perfectly.

Sorry, Ive tried all sorts now and it fails on the Forge Digital ocean server using Nginx...

Locally it works perfect using Valet but as soon as its on the DO server i get No input file specified.

I cannot figure it out at all. Any ideas??

This is my middleware that catches all requests ::

public function handle($request, Closure $next)
    {
        if (str_contains($request->url(), '.php')) {
            $url = str_replace('.php', '', $request->url());
            return redirect($url);
        }
        return $next($request);
    }

Cheers

Would that go in the

server {
$withoutExt = preg_replace('/\.[^.\s]{3,4}$/', '', $filename);
}

Thank guys. Im using nginx on forge. Im not going to lie but ive not used nginx before and a liitle afraid of messing with it.

But as a fix for now, I made a middleware to process the request and check for the extention and remove it then redirect to the correct location

if (str_contains($request->url(), '.php')) {
            $url = str_ireplace('.php', '', $request->url());
            return redirect($url);
        }

Sorry. Ive got a workaround for now...

I created a middleware to deal with the request.

public function handle($request, Closure $next)
    {
        if (str_contains($request->url(), 'https://my-app.uk')) {
            return redirect('https://www.my-app.uk');
        }
        return $next($request);
    }

Happy new year everyone :)

I have a URL on some old site links that at the moment usehttps://www.my-app.com/regestration.php, on the new app that should be going to https://www.my-app.com/regestration so by removing the .php from the end it will return the correct url.

Hi, thank you for the reply. I tried that but unfortunately due to restrictions to the way the servers and old app was set up, I have some code that distinguishes the environment then sets the subdomains.

if (App::environment('local')) {
    $sub = '';
    $domain = 'my-app';
    $tld = '.test';
} elseif (App::environment('testing')) {
    $sub = 'testing.';
    $domain = 'my-app';
    $tld = '.uk';
} elseif (App::environment('production')) {
    $sub = 'www.';
    $domain = 'my-app';
    $tld = '.uk';
}

Route::domain($sub . $domain . $tld)->group(function () {
    Route::get('/testing', '[email protected]');
    Route::post('/testing', '[email protected]');
    Route::middleware(['guest'])->group(function () {
        Route::get('/{page?}', 'Frontend\[email protected]');
    });
});

Makes it a little more interesting lol.

Hi how do i forward requests to a certain routes file to www?

Many thanks

Hi. Is there a way to strip any .php filenames from the end of the url.

Im using Forge and Digitalocean but was wondering if theres a way to do it through middleware?

Cheers

No problem. Did it work? If so mark the best answer.

Cheers

In the file structure you have there, in public the index should be the index.php not html. I’m the index.php it with have the route to the main app

Sorry! Found the issue. Changed the port to 3307 and all worked. Cheers @d

Sorry for the late reply guys...

I tried the tunnel but doesn't work for some reason. Once I have a bit more time to check it out I'll post back.

What ive done for now is used Brew to install MySQL on my local machine and MacBook and then just used it like that without connecting to the test DB server. Its a bit of a pain as I don't have the same data throughout all machines but I can live with it.

It may be an idea to check the Laravel error logs on the forge server to see if something has been logged there.

The second part is the schedule will use the time from the kernel file. So if you set the job to run daily in the kernel file then it will run daily.

Hi.

I've got 2 servers setup with Digital ocean which was provisioned using forge. I have one as an app server and the other a database server.

I can connect using ssh tunnel on sequel pro but unless I add my IP to the firewall in forge, I cannot connect to the server when using local dev. I try to use a testing db on the server so when I'm away from the office I can carry on with local dev with the same data.

Any ideas on how to allow my local computer to connect ??

Cheers

Hi, @globals. Ye, I knew it wasn't passing but wasn't sure why as it was all fine on stripe end.

But figured it out by accident when tidying up the code.

So i done::

// This 
$product = $user->pricing->stripe_product_id;
$plan = $duration . 'months';

// Params 1. Product 2. Plan
$user->newSubscription($plan, $plan)->create($stripeToken, [
    'email' => $user->email,
]);

// Instead of this
$user->newSubscription($user->pricing->stripe_product_id, $duration . 'months')->create($stripeToken, [
    'email' => $user->email,
]);

And now all works normally.

Hi.

I'm just trying to get the subscriptions working but I keep hitting this error,

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null in 

Now I know it looks missing but that's all I'm doing so far is passing the data from vue to the controller and in the controller::

try {
            $user = User::where('id', Auth::id())->with(['pricing'])->firstOrFail();
            $duration = request('duration');
            $stripeToken = request('stripeToken');
           
            // Params 1. Product 2. Plan
            $user->newSubscription($user->pricing->stripe_product_id, $duration . 'months')->create($stripeToken, [
                'email' => $user->email,
            ]);

            return response()->json(['status' => 'Your payment has been successful.'], 200);
        } catch (\Exception $e) {
            event(new NotifyIssues($user, $e));
            $request->session()->flash('status', $e->getMessage());
            $request->session()->flash('alert', 'danger');

            return response()->json(['status' => $e->getMessage()], 422);
        }

It creates the subscription in stripe and does the payment, but doesn't save to the subscriptions table.

Any ideas? Or more to the point, what am i missing?

Fixed....

Turns out that when logging an activity, if a client logs-in then it saves it like so

{"user":447}

and if its to do with changing a value

{"attributes":{"telephone":"123456789"},"old":{"telephone":"1234567890"}}

Hi.

I'm trying to use Spatie ActivityLog to display all the activities on a page but I keep getting,

Undefined index: attributes

It used to work but for some reason, its stopped.

Heres the Code

// Controller
public function show($id)
    {
        $user = User::find($id);
        $activities = Activity::where('causer_id', $user->id)->orderBy('created_at', 'desc')->get();

        return view('admin.customers.settings-history.show')->with([
            'activities' => $activities,
        ]);
    }

// Blade
        @foreach($activities as $activity)
            <tr>
                <td>{{ $activity->created_at->format('d/m/Y') }}</td>
                <td>{{ $activity->created_at->format('H:i a') }}</td>
                <td class="textLeft">
                    @foreach($activity->changes['attributes'] as $key => $val)
                    <strong style="text-transform: capitalize;">{{ $activity->description }}</strong> :: {{"$key"}} From "{{ $activity->changes['old'][$key] }}" to "{{ $activity->changes['attributes'][$key]}}"<br>
                    @endforeach
                </td>
            </tr>
            @endforeach

Any ideas or help would be grateful.

Cheers

I think a good feature request for Laracast would be a "Are you sure you've checked your code?" Lol...

Thank you so much, I ended up just taking the value and name out of the all so it just grabs everything anyway.

Thank you

Hi. I'm trying to search users using scopes but when trying to search for all, it only returns the wrong data. I.e I have in the searches form a checkbox with "All" "Active" "in-Active" but if I choose all it returns only the active for some reason.

// Controller 

    $users = User::role('Customer')
            ->findMailCentre($request->get('mail_centres'))
            ->HasStatus($request->get('status'))
            ->region($request->get('region'))
            ->type($request->get('type'))
            ->scans($request->get('scans'))
            ->sms($request->get('sms'))
            ->with(['account', 'settings'])
            ->get();

        return $users;


// Model scope

public function scopeHasStatus($query, $status_id)
    {
        if (!$status_id) {
            return $query;
        }
        return $query->whereHas('account', function ($query) use ($status_id) {
            $query->orWhere('status_id', $status_id);
        });
    }

// Blade file
            <h3>Status</h3>
            <div class="broadcastWrapper">
                <p style="text-transform: uppercase;"><input name="status[]" type="checkbox" id="all_statuses" /> ALL</p>

                <div id="statuses">
                    @foreach($statuses as $status)
                    <p style="text-transform: uppercase;"><input name="status[]" value="{{ $status->id }}" type="checkbox"/> {{ $status->title }}</p>
                    @endforeach
                </div>
            </div>

Any help would be grateful.

Many thanks

The only thing I can think of is the ports. If your using SMTP on an insecure network then it's 25 or if it's secure it's 465 or 463 also try the encryption to tls

The mail host is normally something like

mail.domain.com

So in pleas when you setup a new email account you should be able to find the settings to setup that email address

If it’s already compiled the you use

Or whatever the path to the app.js is

If you get in touch with heroku support, they’re pretty good and can sort it out for you. But youll need a paid plan