• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

Bulk importer column `importing_content_id`

N

nixer

Chevereto Member
Sorry if it is not the same bug. I am trying bulk inporter at importing/parse-users

Log:
1731110430 - [Thread #0] PDOException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'importing_content_id' cannot be null ~ #0 /home/u351358265/domains/public_html/app/src/Legacy/G/DB.php(153): PDOStatement->execute()
#1 /home/u351358265/domains/public_html/app/src/Legacy/G/DB.php(365): Chevereto\Legacy\G\DB->exec()
#2 /home/u351358265/domains/public_html/app/src/Legacy/Classes/DB.php(125): Chevereto\Legacy\G\DB::insert()
#3 /home/u351358265/domains/public_html/app/src/Legacy/Classes/Import.php(551): Chevereto\Legacy\Classes\DB::insert()
#4 /home/u351358265/domains/public_html/app/legacy/commands/bulk-importer.php(41): Chevereto\Legacy\Classes\Import->process()
#5 /home/u351358265/domains/public_html/app/legacy/entrypoints/cli.php(55): require_once('/home/u35135826...')
#6 /home/u351358265/domains/public_html/app/bin/legacy(13): require_once('/home/u35135826...')
#7 {main}
 
nixer said:
Sorry if it is not the same bug. I am trying bulk inporter at importing/parse-users

Log:
1731110430 - [Thread #0] PDOException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'importing_content_id' cannot be null ~ #0 /home/u351358265/domains/public_html/app/src/Legacy/G/DB.php(153): PDOStatement->execute()
#1 /home/u351358265/domains/public_html/app/src/Legacy/G/DB.php(365): Chevereto\Legacy\G\DB->exec()
#2 /home/u351358265/domains/public_html/app/src/Legacy/Classes/DB.php(125): Chevereto\Legacy\G\DB::insert()
#3 /home/u351358265/domains/public_html/app/src/Legacy/Classes/Import.php(551): Chevereto\Legacy\Classes\DB::insert()
#4 /home/u351358265/domains/public_html/app/legacy/commands/bulk-importer.php(41): Chevereto\Legacy\Classes\Import->process()
#5 /home/u351358265/domains/public_html/app/legacy/entrypoints/cli.php(55): require_once('/home/u35135826...')
#6 /home/u351358265/domains/public_html/app/bin/legacy(13): require_once('/home/u35135826...')
#7 {main}
Click to expand...
I'm beginning to suspect the pattern is going to be related to the PDO execution that's causing the whole problem I mean it probably is something very very simple and I'm sure it can easily result but you know or anyone but again I'm sure it's very basic hopefully yeah we hear back from him soon
 
Hi there,

I appreciate your patience, though I need to clarify that the bulk importer relies on a number of processes that are definitely not as simple as they might appear on the surface. PDO execution is just one of the many factors involved, and pinpointing the exact cause takes a detailed review.

Thanks for bearing with us as we work to ensure everything is running smoothly.
 
@nixer

Code: 
PDOException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'importing_content_id' cannot be null

This issue is due to a missing SQL update statement regarding the chv_importing table. From Chevereto v4.2.0 onwards, the column importing_content_id should be set to DEFAULT NULL. Previous installations define this column as NOT NULL DEFAULT '0', which is causing the failure. I've already addressed this, and the patch will be available in v4.2.3.
 
You must log in or register to reply here.
Back
Top