Column not found: 1054 Unknown column 'EmailQueue.to' in 'field list'

#1

This was a clean VM install from the paid for version (OVA file download so out of the box install).

Worked fine on first computer, then when I go to retrieve my username on a second machine and it needs to send me an email it never arrives.

I manually run:
var/www/passbolt/bin/cake EmailQueue.sender

And get:
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘EmailQueue.to’ in ‘field list’ in [/var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php, line 39]

I can see items queued in the email_queue table.

Running:
/var/www/passbolt/bin/cake passbolt send_test_email --recipient=EMAIL@ADDRESS.COM works fine.

I’ve read on forums there can be a schema mismatch following upgrades but given I’ve installed the latest OVA I don’t see how this is the problem here.

0 Likes

#2

Hello,

Can you try clearing the cakephp cache?
./bin/cake cache clear_all
sudo su -s /bin/bash -c "./bin/cake migrations migrate" www-data

The previous version of the model (installed in the initial migration and droped after, to ensure v1 upgrade path) might still be loaded in cache. It’s a bit of a mystery to us as of why the application end up in this state in some rare occasions.

Feel free to contact us on support@passbolt.com since you’re using the pro edition, we can look into it together.

0 Likes

#3

Hi I’ve since resolved by doing a fresh Ubuntu install and deploying pass bolt on there rather than using the OVA. Seems strange the issue would be in the ore built OVA. No upgrades or anything.

Many thanks

Chris

1 Like

closed #4

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.

0 Likes