Laravel 5.4 - Cannot update mysql table column

Question

So I'm using this DB facade and eloquent in updating table column

$affectedRows = DB::table('Users')
            ->where('Phone',$phonenumber)
            ->update(['IsActivated' => 'Y']);

or this one:

$affectedRows = Users::where('Phone','=',$phonenumber)
->update(['IsActivated' => 'Y']);

but I encountered this error when I access the url

 <span class="exception_message">SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'where clause' (SQL: select * from `users` where (`0` = Phone and `1` = = and `2` = 0000000000) limit 1)</span>

What is the value of $phonenumber when you print it out? Maybe it is an array and not a number? — Jack Vial
– Jack Vial, Commented Apr 24, 2017 at 14:45
@Jack the phonenumber value is 0000000000 it's a varchar. ps. I change the phonenumber to 0000000000 since it's my personal number :) — iamj
– iamj, Commented Apr 24, 2017 at 14:49
@Jack tried replacing $phonenumber with '00000' and the update is successful. Anyways restarted mysql service today and tried accessing the /url , guess what it 's already fixed. — iamj
– iamj, Commented Apr 26, 2017 at 12:56

Nigel Ren · Accepted Answer · 2017-04-24 15:01:57Z

3

Can you try using

$affectedRows = Users::where('Phone',$phonenumber)->update(['IsActivated' => 'Y']);

answered Apr 24, 2017 at 15:01

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

iamj Over a year ago

Yes this one : SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'where clause' (SQL: select * from users where (0 = Phone and 1 = = and 2 = 0000000000) limit 1)

Nigel Ren Over a year ago

Can you check the line number of the error. Make sure there are no other attempts to fetch the user in the same page as well

iamj Over a year ago

It's in Connection.php line 647, There's no other fetching attempts since I'm using postman in accessing the URL

Dimitri Mostrey · Accepted Answer · 2017-04-24 16:06:09Z

1

Try these in this exact order and tell us at what commands give an error. Mind I use users and phone, not Users and Phone. It won't affect the query. First add these helper lines in your Users model, right above class Users extends Model

/**
 * App\User
 *
 * @property int $id
 * @property string $phone
 * @property-read \App\User $user
 * @method static wherePhone($value)
 * @mixin \Eloquent
 */

$results = DB::table('users')->where('id', '1')->first();
dd($results);
$results = DB::table('users')->where('id', '1')->get();
dd($results);
$results = DB::table('users')->where(['phone' => '000000000000'])->get();
dd($results);
$results = DB::table('users')->where('phone', '000000000000')->get();
dd($results);
$results = DB::table('users')->where('phone', $phonenumber)->get();
dd($results);
$results = DB::table('users')->wherePhone($phonenumber)->get();
dd($results);

If none of these work, then there is a problem with your model. As no results can be found, an update is impossible. You can inter-exchange DB::table('users')->where(...) with Users::where(...)

Did you by any change called your User model Users.php instead of User.php? I had your problem a while ago but can't really remember what the cause was. It had to do with the User model settings.

answered Apr 24, 2017 at 16:06

Dimitri Mostrey

2,3551 gold badge14 silver badges12 bronze badges

3 Comments

iamj Over a year ago

Let me try that and btw I'm using User.php.

iamj Over a year ago

Hi Dimitri tried the above code and it was all successful. Thank you for your response and I'm sorry for the late response. Tried to restart mysql today and now I was able to update the column

Dimitri Mostrey Over a year ago

Pleasure bro, happy you found a way out. It was a strange error you were encountering.

Collectives™ on Stack Overflow

Laravel 5.4 - Cannot update mysql table column

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related