Yii1 which were running for many years, today stopped

1

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘job.’ in ‘on clause’. The SQL statement executed was: SELECT COUNT(*) FROM customs_sales_invoice_exit t LEFT OUTER JOIN customs_job_master job ON (t.job_id=job.``) LEFT OUTER JOIN customs_congress congress ON (t.congress_id=congress.id) LEFT OUTER JOIN customs_congress agents ON (t.agent_id=agents.id) WHERE ((t.active=“Y”) AND (invoice_date=“2020-04-24”))

2

Looks like database is missing a column.

3

Thanks Sir…

One of your team Mr. SIRIN solved my big problem.

The DB changed without any user intervention.

I really like the Yii team.

Thanks.