Help Center

Troubleshooting 'Column Not Found' Error (Error 1054) in MySQL: Solutions and Steps

Troubleshooting MySQL 'Column Not Found' Error 1054, Fixing 'Unknown column' issues in MySQL, Solutions and steps for resolving column-related errors in MySQL 1
Print

Symptom

After updating to WHMCS 8.5.1, admins attempting to create or edit products may encounter a Column not found error when using the Easy Translation feature:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shortDescription' in 'field list' in /path/to/whmcs/vendor/illuminate/database/Connection.php:485
 

Cause

The system expects a Product Short Description.

Workaround

To resolve this:

  1. Go to Configuration > System Settings > Products/Services.
  2. Edit the product.
  3. Enter a Product Short Description.
  4. Click Save Changes.

Repeat this process for each product.

 

 

The End! should you have any inquiries, we encourage you to reach out to the Vercaa Support Center without hesitation.


Was this answer helpful?

Still need a hand?

Our support team is on standby if this article didn't fully answer your question.

« Back