Hi,
I currently used PostgreSQL in my project.
When I try to setup Polr
using PostgreSQL, I found some query error. There are :
- When insert data user
admin
account :
[2016-09-13 11:05:33] lumen.ERROR: exception 'PDOException' with message 'SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "role" violates not-null constraint
DETAIL: Failing row contains (1, admin, $2y$10$Mk3yXHToPcfFefGhOOwL4ODzIa3aJo6f3OizqAdWXN.lgXSoPjU96, admin@localhost, ::1, ad1ff4e525b5545b17804fd152445db3bbe915a4eac7dc44d510e98ad9013d9b..., null, 1, 0, f, 60, 2016-09-13 11:05:33, 2016-09-13 11:05:33, null).' in /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Connection.php:321
Stack trace:
#0 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Connection.php(321): PDOStatement->execute(Array)
#1 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Connection.php(644): IlluminateDatabaseConnection->IlluminateDatabase{closure}(Object(IlluminateDatabasePostgresConnection), 'insert into "us...', Array)
#2 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Connection.php(611): IlluminateDatabaseConnection->runQueryCallback('insert into "us...', Array, Object(Closure))
#3 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Connection.php(324): IlluminateDatabaseConnection->run('insert into "us...', Array, Object(Closure))
#4 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Connection.php(298): IlluminateDatabaseConnection->select('insert into "us...', Array, false)
#5 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Query/Processors/PostgresProcessor.php(20): IlluminateDatabaseConnection->selectFromWriteConnection('insert into "us...', Array)
#6 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Query/Builder.php(1827): IlluminateDatabaseQueryProcessorsPostgresProcessor->processInsertGetId(Object(IlluminateDatabaseQueryBuilder), 'insert into "us...', Array, 'id')
#7 [internal function]: IlluminateDatabaseQueryBuilder->insertGetId(Array, 'id')
#8 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Eloquent/Builder.php(949): call_user_func_array(Array, Array)
#9 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Eloquent/Model.php(1654): IlluminateDatabaseEloquentBuilder->__call('insertGetId', Array)
#10 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Eloquent/Model.php(1654): IlluminateDatabaseEloquentBuilder->insertGetId(Array, 'id')
#11 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Eloquent/Model.php(1623): IlluminateDatabaseEloquentModel->insertAndSetId(Object(IlluminateDatabaseEloquentBuilder), Array)
#12 /Users/untung/EclipseProjects/polr/vendor/illuminate/database/Eloquent/Model.php(1514): IlluminateDatabaseEloquentModel->performInsert(Object(IlluminateDatabaseEloquentBuilder), Array)
#13 /Users/untung/EclipseProjects/polr/app/Factories/UserFactory.php(24): IlluminateDatabaseEloquentModel->save()
#14 /Users/untung/EclipseProjects/polr/app/Http/Controllers/SetupController.php(215): AppFactoriesUserFactory::createUser('admin', 'admin@localhost', 'password', 1, '::1')
#15 [internal function]: AppHttpControllersSetupController->finishSetup(Object(IlluminateHttpRequest))
#16 /Users/untung/EclipseProjects/polr/vendor/illuminate/container/Container.php(507): call_user_func_array(Array, Array)
#17 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1399): IlluminateContainerContainer->call(Array, Array)
#18 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1364): LaravelLumenApplication->callControllerCallable(Array, Array)
#19 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1335): LaravelLumenApplication->callLumenController(Object(AppHttpControllersSetupController), 'finishSetup', Array)
#20 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1303): LaravelLumenApplication->callControllerAction(Array)
#21 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1288): LaravelLumenApplication->callActionOnArrayBasedRoute(Array)
#22 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1207): LaravelLumenApplication->handleFoundRoute(Array)
#23 [internal function]: LaravelLumenApplication->LaravelLumen{closure}(Object(IlluminateHttpRequest))
#24 /Users/untung/EclipseProjects/polr/vendor/illuminate/pipeline/Pipeline.php(139): call_user_func(Object(Closure), Object(IlluminateHttpRequest))
#25 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Http/Middleware/VerifyCsrfToken.php(43): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))
#26 [internal function]: LaravelLumenHttpMiddlewareVerifyCsrfToken->handle(Object(IlluminateHttpRequest), Object(Closure))
#27 /Users/untung/EclipseProjects/polr/vendor/illuminate/pipeline/Pipeline.php(124): call_user_func_array(Array, Array)
#28 /Users/untung/EclipseProjects/polr/vendor/illuminate/session/Middleware/StartSession.php(62): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))
#29 [internal function]: IlluminateSessionMiddlewareStartSession->handle(Object(IlluminateHttpRequest), Object(Closure))
#30 /Users/untung/EclipseProjects/polr/vendor/illuminate/pipeline/Pipeline.php(124): call_user_func_array(Array, Array)
#31 /Users/untung/EclipseProjects/polr/vendor/illuminate/cookie/Middleware/EncryptCookies.php(59): IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))
#32 [internal function]: IlluminateCookieMiddlewareEncryptCookies->handle(Object(IlluminateHttpRequest), Object(Closure))
#33 /Users/untung/EclipseProjects/polr/vendor/illuminate/pipeline/Pipeline.php(124): call_user_func_array(Array, Array)
#34 [internal function]: IlluminatePipelinePipeline->IlluminatePipeline{closure}(Object(IlluminateHttpRequest))
#35 /Users/untung/EclipseProjects/polr/vendor/illuminate/pipeline/Pipeline.php(103): call_user_func(Object(Closure), Object(IlluminateHttpRequest))
#36 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1439): IlluminatePipelinePipeline->then(Object(Closure))
#37 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1213): LaravelLumenApplication->sendThroughPipeline(Array, Object(Closure))
#38 /Users/untung/EclipseProjects/polr/vendor/laravel/lumen-framework/src/Application.php(1153): LaravelLumenApplication->dispatch(NULL)
#39 /Users/untung/EclipseProjects/polr/public/index.php(28): LaravelLumenApplication->run()
#40 {main}
- When creating short url :
SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "creator" violates not-null constraint
DETAIL: Failing row contains (1, jQ3WY, http://www.facebook.com, ::1, null, 0, null, f, f, f, 2016-09-13 11:20:48, 2016-09-13 11:20:48). (SQL: insert into "links" ("short_url", "long_url", "ip", "is_custom", "is_api", "updated_at", "created_at") values (jQ3WY, http://www.facebook.com, ::1, 0, 0, 2016-09-13 11:20:48, 2016-09-13 11:20:48) returning "id")
I’ve created pull request #223 to solve the error above and also I’ve put some code to support user DB_CONNECTION
between MySQL (default) and PostgreSQL.
regards.
#database #laravel #postgresql #laravel-8 #rest
Вопрос:
Ниже приведен API для загрузки файлов. это показывает ошибку —
SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "Userid" of relation "files" violates not-null constraintnDETAIL: Failing row contains (7, null, Distance Learning Promo.mp4, null, null, null, 2021-07-07 13:38:07, 2021-07-07 13:38:07). (SQL: insert into "files" ("FileName", "updated_at", "created_at") values (Distance Learning Promo.mp4, 2021-07-07 13:38:07, 2021-07-07 13:38:07) returning "id")
.
И Почтальон показывает статус 500 internal status error
.
Я не думаю, что моя Userid
колонка здесь пуста . Пожалуйста, помогите мне с некоторыми предложениями
Контроллер
<?php
namespace AppHttpControllers;
use IlluminateHttpRequest;
use AppModelsUploads;
use IlluminateSupportFacadesAuth;
class UploadController extends Controller
{
public function __construct()
{
$this->middleware('auth:api');
}
public function upload(Request $request)
{
$file=$request->file('file_name');
$fileName=$file->getClientOriginalName();
$folder = uniqid().'-'.now()->timestamp;
$file->storeAs('public/other-document/'.$folder, $fileName);
$filePath = $folder.'/'.$fileName;
$dataToInsert = array();
$dataToInsert['FileName'] = $fileName;
$dataToInsert['FilePath'] = $filePath;
if($request->has('uploadType'))
{
$dataToInsert['FileType'] = $request->uploadType;
}
$dataToInsert['uploadedBy'] = Auth::user()->id;
$dataToInsert['Userid'] = $request->bearerToken();
Uploads::create($dataToInsert);
}
}
Файл миграции
Schema::create('files', function (Blueprint $table) {
$table->id();
$table->string('Userid');
$table->string('FileName');
$table->string('FilePath');
$table->string('FileType');
$table->integer('uploadedBy');
$table->timestamps();
});
Комментарии:
1. пожалуйста, проверьте
$dataToInsert['Userid'] = $request->bearerToken();
, удерживает ли какое-либо значение2. @JEJ это имеет значение. даже если
Userid
в столбец вставлено фиктивное значение ,подобное этому —$dataToInsert['Userid'] =1
, оно показывает ту же ошибку.
Ответ №1:
$dataToInsert['Userid'] = $request->bearerToken(); // error is here
if(!$dataToInsert['Userid']){
return "Null value in userID";
}
Проверьте $dataToInsert['Userid']
, удерживает ли какое-либо значение.
Также убедитесь, что Вы передаете bearerToken в заголовке
Комментарии:
1. это имеет значение. даже если в столбец Userid также вставлено фиктивное значение- $dataToInsert[‘Идентификатор пользователя’] =1 ,оно показывает ту же ошибку.
2. @MG проверьте свои заполняемые файлы в модели
After a drush content-sync:export
and drush content-sync:import
on a new website:
$ drush content-sync:import
Differences of the export directory to the active content:
+-----------------------------------+------------------------------------------------------------------------+-----------+
| Collection | Content Name | Operation |
+-----------------------------------+------------------------------------------------------------------------+-----------+
| affiliate_system.affiliate_system | affiliate_system.affiliate_system.2c04c930-c3e0-4886-9aa4-2997cd1df439 | Create |
...
| user.user | user.user.0224dadc-510b-45d0-aea7-d356f46553ad | Create |
| user.user | user.user.b6d93e35-a28c-4f2d-9566-06ea8fa4604a | Create |
| user.user | user.user.c61929c6-1811-4954-9475-597e51ea5d7a | Delete |
| user.user | user.user.2d8c7ca2-f145-494e-9050-03e2a4e2ccd8 | Delete |
+-----------------------------------+------------------------------------------------------------------------+-----------+
Do you want to import? (yes/no) [yes]:
>
> [notice] 2d8c7ca2-f145-494e-9050-03e2a4e2ccd8 - Anonymous user or super admin can not be removed.
> [notice] c61929c6-1811-4954-9475-597e51ea5d7a - Anonymous user or super admin can not be removed.
> [error] The username <em class="placeholder">admin</em> is already taken.
> [error] The email address <em class="placeholder">admin@example.com</em> is already taken.
> [notice] Error importing content of type user.
> [error] DrupalCoreDatabaseIntegrityConstraintViolationException: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "user_id" violates not-null constraint
> DETAIL: Failing row contains (1, null, 2c04c930-c3e0-4886-9aa4-2997cd1df439, en, 1, null, Mexos, 1571995291, 1571995291).: INSERT INTO affiliate_system (vid, uuid, langcode, status, user_id, name, created, changed) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array
> (
> )
> in DrupalCoreDatabaseConnection->handleQueryException() (line 692 of /var/www/html/web/core/lib/Drupal/Core/Database/Connection.php).
>
> In SqlContentEntityStorage.php line 846:
>
> SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "user_id" viol
> ates not-null constraint
> DETAIL: Failing row contains (1, null, 2c04c930-c3e0-4886-9aa4-2997cd1df439, en,
> 1, null, Mexos, 1571995291, 1571995291).: INSERT INTO affiliate_system (vid, uuid,
> langcode, status, user_id, name, created, changed) VALUES (:db_insert_placeholder
> _0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3,
> :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_
> insert_placeholder_7); Array
> (
> )
>
>
> In Connection.php line 692:
>
> SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "user_id" viol
> ates not-null constraint
> DETAIL: Failing row contains (1, null, 2c04c930-c3e0-4886-9aa4-2997cd1df439, en,
> 1, null, Mexos, 1571995291, 1571995291).: INSERT INTO affiliate_system (vid, uuid,
> langcode, status, user_id, name, created, changed) VALUES (:db_insert_placeholder
> _0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3,
> :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_
> insert_placeholder_7); Array
> (
> )
>
>
> In Statement.php line 59:
>
> SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "user_id" viol
> ates not-null constraint
> DETAIL: Failing row contains (1, null, 2c04c930-c3e0-4886-9aa4-2997cd1df439, en,
> 1, null, Mexos, 1571995291, 1571995291).
>
>
> batch:process [--format [FORMAT]] [--fields FIELDS] [--field FIELD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-d|--debug] [-y|--yes] [--no] [--remote-host REMOTE-HOST] [--remote-user REMOTE-USER] [-r|--root ROOT] [-l|--uri URI] [--simulate] [--pipe] [-D|--define DEFINE] [--druplicon] [--notify [NOTIFY]] [--xh-link XH-LINK] [--] <command> <batch_id>
>
In ProcessBase.php line 172:
Output is empty.
content-sync:import [--entity-types [ENTITY-TYPES]] [--uuids [UUIDS]] [--actions [ACTIONS]] [--skiplist] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-d|--debug] [-y|--yes] [--no] [--remote-host REMOTE-HOST] [--remote-user REMOTE-USER] [-r|--root ROOT] [-l|--uri URI] [--simulate] [--pipe] [-D|--define DEFINE] [--druplicon] [--notify [NOTIFY]] [--xh-link XH-LINK] [--] <command> [<label>]
819 votes
10 answers
Get the solution ↓↓↓
I am building an application with postgres as my preferred database. I have a users table and in the process of saving into it, I got the error below:
SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column «verification_code» violates not-null constraintnDETAIL: Failing row contains (825, 2348035442578, S-LF79a_O3ELcNc0TQmLOjy5No0KScjT, $2y$13$tPS82tr5pH2CHfNiZ9OSKOmE/z8iXOpc0PQ0uGWmeQYXtMX9AguBq, null, [email protected], null, 0, 11, 2020-04-25 13:54:32, 2020-04-25 13:54:32, null, null, null, null).nThe SQL being executed was: INSERT INTO «users» («username», «auth_key», «password_hash», «email», «isActivated», «status», «created_at», «updated_at») VALUES (‘2348035442578’, ‘S-LF79a_O3ELcNc0TQmLOjy5No0KScjT’, ‘$2y$13$tPS82tr5pH2CHfNiZ9OSKOmE/z8iXOpc0PQ0uGWmeQYXtMX9AguBq’, ‘[email protected]’, 0, 11, NOW(), NOW()) RETURNING «id»
Here is the table structure:
Table "public.users"
Column | Type | Collation | Nullable | Default
Where do you think I should check for correction or what exactly am I not doing right?
2021-12-1
Write your answer
899
votes
808
votes
128
votes
644
votes
213
votes
Answer
——
id | integer | | not null | nextval(‘users_id_seq’::regclass)
username | character varying(255) | | not null |
auth_key | character varying(32) | | not null |
password_hash | character varying(255) | | not null |
password_reset_token | character varying(255) | | |
email | character varying(255) | | not null |
verification_code | character varying(255) | | not null |
isActivated | smallint | | not null | 0
status | smallint | | not null | 10
created_at | timestamp(0) without time zone | | not null |
updated_at | timestamp(0) without time zone | | not null |
profile_picture | character varying(55) | | |
filename | character varying(70) | | |
pin_no | integer | | |
last_login_date | date | | |
Share solution ↓
Additional Information:
Date the issue was resolved:
2021-12-1
Link To Source
Link To Answer
People are also looking for solutions of the problem: object of class stdclass could not be converted to string
Didn’t find the answer?
Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.
Similar questions
Find the answer in similar questions on our website.