Illuminate/Database/QueryException with message 'SQLSTATE[42S22]: Column not found: 1054
I tried to create admin user using php artisan tinker. When I try to save, it return an error. Please help me to fix the issue.
Here is the error
Illuminate/Database/QueryException with message 'SQLSTATE[42S22]:
Column not found: 1054 Unknown column 'admin' in 'field list' (SQL:
updateuserssetupdated_at= 2018-12-28 05:41:31,admin= 1
whereid= 1)'
laravel eloquent
edited Dec 28 '18 at 6:17
Jignesh Joisar
2,4131820
asked Dec 28 '18 at 5:49
SajiSaji
176
add a comment |
I tried to create admin user using php artisan tinker. When I try to save, it return an error. Please help me to fix the issue.
Here is the error
Illuminate/Database/QueryException with message 'SQLSTATE[42S22]:
Column not found: 1054 Unknown column 'admin' in 'field list' (SQL:
updateuserssetupdated_at= 2018-12-28 05:41:31,admin= 1
whereid= 1)'
laravel eloquent
edited Dec 28 '18 at 6:17
Jignesh Joisar
2,4131820
asked Dec 28 '18 at 5:49
SajiSaji
176
You don`t haveadmincolumn in youUsertable.
– Prashant Deshmukh.....
Dec 28 '18 at 5:53
2
@Saji show urUsermodel in question
– Jignesh Joisar
Dec 28 '18 at 6:16
add a comment |
I tried to create admin user using php artisan tinker. When I try to save, it return an error. Please help me to fix the issue.
Here is the error
Illuminate/Database/QueryException with message 'SQLSTATE[42S22]:
Column not found: 1054 Unknown column 'admin' in 'field list' (SQL:
updateuserssetupdated_at= 2018-12-28 05:41:31,admin= 1
whereid= 1)'
laravel eloquent
edited Dec 28 '18 at 6:17
Jignesh Joisar
2,4131820
asked Dec 28 '18 at 5:49
SajiSaji
176
I tried to create admin user using php artisan tinker. When I try to save, it return an error. Please help me to fix the issue.
Here is the error
Illuminate/Database/QueryException with message 'SQLSTATE[42S22]:
Column not found: 1054 Unknown column 'admin' in 'field list' (SQL:
updateuserssetupdated_at= 2018-12-28 05:41:31,admin= 1
whereid= 1)'
laravel eloquent
laravel eloquent
edited Dec 28 '18 at 6:17
Jignesh Joisar
2,4131820
asked Dec 28 '18 at 5:49
SajiSaji
176
edited Dec 28 '18 at 6:17
Jignesh Joisar
2,4131820
asked Dec 28 '18 at 5:49
SajiSaji
176
edited Dec 28 '18 at 6:17
Jignesh Joisar
2,4131820
edited Dec 28 '18 at 6:17
Jignesh Joisar
2,4131820
edited Dec 28 '18 at 6:17
Jignesh Joisar
2,4131820
2,4131820
asked Dec 28 '18 at 5:49
SajiSaji
176
asked Dec 28 '18 at 5:49
SajiSaji
176
asked Dec 28 '18 at 5:49
SajiSaji
176
176
You don`t haveadmincolumn in youUsertable.
– Prashant Deshmukh.....
Dec 28 '18 at 5:53
2
@Saji show urUsermodel in question
– Jignesh Joisar
Dec 28 '18 at 6:16
add a comment |
You don`t haveadmincolumn in youUsertable.
– Prashant Deshmukh.....
Dec 28 '18 at 5:53
2
@Saji show urUsermodel in question
– Jignesh Joisar
Dec 28 '18 at 6:16
You don`t have
admin column in you User table.– Prashant Deshmukh.....
Dec 28 '18 at 5:53
You don`t have
admin column in you User table.– Prashant Deshmukh.....
Dec 28 '18 at 5:53
2
2
@Saji show ur
User model in question– Jignesh Joisar
Dec 28 '18 at 6:16
@Saji show ur
User model in question– Jignesh Joisar
Dec 28 '18 at 6:16
add a comment |
3 Answers
3
active
oldest
votes
You have no column named 'admin' in 'users' table of your database. Add an 'admin' column.
This should solve the error.
answered Dec 28 '18 at 5:54
Nabil FarhanNabil Farhan
949
Done. But then return another error "PHP Error: Call to undefined method stdClass::save() in Psy Shell code on line 1"
– Saji
Dec 28 '18 at 6:15
Try this $me = new AppUser $me = AppUser::find(1) $me->admin = 1 $me->save()
– Nabil Farhan
Dec 28 '18 at 8:13
add a comment |
Please remove admin in $fillable and try again
answered Dec 28 '18 at 6:02
Nguyen Hung ThaiNguyen Hung Thai
1144
add a comment |
You must create a migration containing the new columns you want to add to your DB schema.
Example: (this will add a TINYINT admin column with 0 as default value)
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class AddsAdminColumnToUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->tinyInteger('admin')->default(0);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('admin');
});
}
}
Read more about Laravel Migrations here.
answered Dec 28 '18 at 8:33
GiamPyGiamPy
2,22211833
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53954193%2filluminate-database-queryexception-with-message-sqlstate42s22-column-not-fou%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
You have no column named 'admin' in 'users' table of your database. Add an 'admin' column.
This should solve the error.
answered Dec 28 '18 at 5:54
Nabil FarhanNabil Farhan
949
Done. But then return another error "PHP Error: Call to undefined method stdClass::save() in Psy Shell code on line 1"
– Saji
Dec 28 '18 at 6:15
Try this $me = new AppUser $me = AppUser::find(1) $me->admin = 1 $me->save()
– Nabil Farhan
Dec 28 '18 at 8:13
add a comment |
You have no column named 'admin' in 'users' table of your database. Add an 'admin' column.
This should solve the error.
answered Dec 28 '18 at 5:54
Nabil FarhanNabil Farhan
949
Done. But then return another error "PHP Error: Call to undefined method stdClass::save() in Psy Shell code on line 1"
– Saji
Dec 28 '18 at 6:15
Try this $me = new AppUser $me = AppUser::find(1) $me->admin = 1 $me->save()
– Nabil Farhan
Dec 28 '18 at 8:13
add a comment |
You have no column named 'admin' in 'users' table of your database. Add an 'admin' column.
This should solve the error.
answered Dec 28 '18 at 5:54
Nabil FarhanNabil Farhan
949
You have no column named 'admin' in 'users' table of your database. Add an 'admin' column.
This should solve the error.
answered Dec 28 '18 at 5:54
Nabil FarhanNabil Farhan
949
answered Dec 28 '18 at 5:54
Nabil FarhanNabil Farhan
949
answered Dec 28 '18 at 5:54
Nabil FarhanNabil Farhan
949
answered Dec 28 '18 at 5:54
Nabil FarhanNabil Farhan
949
949
Done. But then return another error "PHP Error: Call to undefined method stdClass::save() in Psy Shell code on line 1"
– Saji
Dec 28 '18 at 6:15
Try this $me = new AppUser $me = AppUser::find(1) $me->admin = 1 $me->save()
– Nabil Farhan
Dec 28 '18 at 8:13
add a comment |
Done. But then return another error "PHP Error: Call to undefined method stdClass::save() in Psy Shell code on line 1"
– Saji
Dec 28 '18 at 6:15
Try this $me = new AppUser $me = AppUser::find(1) $me->admin = 1 $me->save()
– Nabil Farhan
Dec 28 '18 at 8:13
Done. But then return another error "PHP Error: Call to undefined method stdClass::save() in Psy Shell code on line 1"
– Saji
Dec 28 '18 at 6:15
Done. But then return another error "PHP Error: Call to undefined method stdClass::save() in Psy Shell code on line 1"
– Saji
Dec 28 '18 at 6:15
Try this $me = new AppUser $me = AppUser::find(1) $me->admin = 1 $me->save()
– Nabil Farhan
Dec 28 '18 at 8:13
Try this $me = new AppUser $me = AppUser::find(1) $me->admin = 1 $me->save()
– Nabil Farhan
Dec 28 '18 at 8:13
add a comment |
Please remove admin in $fillable and try again
answered Dec 28 '18 at 6:02
Nguyen Hung ThaiNguyen Hung Thai
1144
add a comment |
Please remove admin in $fillable and try again
answered Dec 28 '18 at 6:02
Nguyen Hung ThaiNguyen Hung Thai
1144
add a comment |
Please remove admin in $fillable and try again
answered Dec 28 '18 at 6:02
Nguyen Hung ThaiNguyen Hung Thai
1144
Please remove admin in $fillable and try again
answered Dec 28 '18 at 6:02
Nguyen Hung ThaiNguyen Hung Thai
1144
answered Dec 28 '18 at 6:02
Nguyen Hung ThaiNguyen Hung Thai
1144
answered Dec 28 '18 at 6:02
Nguyen Hung ThaiNguyen Hung Thai
1144
answered Dec 28 '18 at 6:02
Nguyen Hung ThaiNguyen Hung Thai
1144
1144
add a comment |
add a comment |
You must create a migration containing the new columns you want to add to your DB schema.
Example: (this will add a TINYINT admin column with 0 as default value)
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class AddsAdminColumnToUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->tinyInteger('admin')->default(0);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('admin');
});
}
}
Read more about Laravel Migrations here.
answered Dec 28 '18 at 8:33
GiamPyGiamPy
2,22211833
add a comment |
You must create a migration containing the new columns you want to add to your DB schema.
Example: (this will add a TINYINT admin column with 0 as default value)
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class AddsAdminColumnToUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->tinyInteger('admin')->default(0);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('admin');
});
}
}
Read more about Laravel Migrations here.
answered Dec 28 '18 at 8:33
GiamPyGiamPy
2,22211833
add a comment |
You must create a migration containing the new columns you want to add to your DB schema.
Example: (this will add a TINYINT admin column with 0 as default value)
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class AddsAdminColumnToUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->tinyInteger('admin')->default(0);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('admin');
});
}
}
Read more about Laravel Migrations here.
answered Dec 28 '18 at 8:33
GiamPyGiamPy
2,22211833
You must create a migration containing the new columns you want to add to your DB schema.
Example: (this will add a TINYINT admin column with 0 as default value)
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class AddsAdminColumnToUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->tinyInteger('admin')->default(0);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('admin');
});
}
}
Read more about Laravel Migrations here.
answered Dec 28 '18 at 8:33
GiamPyGiamPy
2,22211833
answered Dec 28 '18 at 8:33
GiamPyGiamPy
2,22211833
answered Dec 28 '18 at 8:33
GiamPyGiamPy
2,22211833
answered Dec 28 '18 at 8:33
GiamPyGiamPy
2,22211833
2,22211833
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53954193%2filluminate-database-queryexception-with-message-sqlstate42s22-column-not-fou%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You don`t have
admincolumn in youUsertable.– Prashant Deshmukh.....
Dec 28 '18 at 5:53
2
@Saji show ur
Usermodel in question– Jignesh Joisar
Dec 28 '18 at 6:16