Column not found: 1054 Unknown column 'pid' in [...]

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • miwalter
    Junior Member
    • Feb 2016
    • 6

    Column not found: 1054 Unknown column 'pid' in [...]

    Hi ,

    although EspoCRM seems to work right, we get many errors in the log - this has to have happened between 4.8.X and 5.0.5.

    Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pid' in 'field list' at [...]/Cron/Job.php line 202.

    The field is not in the table "job" of the EspoCRM-database, so the error message seems to say the truth

    I don't think anything does not work, but I'm not sure yet. We use system-cron, maybe this is important:

    */2 0-2 * * * root /usr/bin/php -f /var/www/crm2/cron.php > /dev/null 2>&1

    Regards,
    Mirko
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hello
    weird. Was upgrade completed successfully? Try to rebuild EspoCRM. After the rebuild check is this column in database now. If not - check the log again. Any PDOException afetr this?

    Comment

    Working...