Fatal Error 1054 on upgrade (softaculous)

Fatal error: 1054 - Unknown column 'email' in 'where clause' update lcbn_orders set customer_id = '150' where lower(email) = lower('*****@gmail.com'); in ~/includes/library/lib_database.inc.php (Line 260)

Not sure how to find or fix this 
Assistance appreciated

Thank you

My site is not working due to this error...
Can someone help please??
Laura

Can you post the full error seen in the log file?
Register a support ticket and I will fix this on site:
https://www.litecart.net/support

I found the cause of the issue as the last instruction in the upgrade patch.
https://github.com/litecart/litecart/commit/f7d180cbf91da5cd2ced0bd442306b9ba3541e99

You should be fine from the upgrade. But there could be a vqmod causing a conflict with 2.3.0.

Register a support ticket and I can help you out.

Same error code showing when a new customer is creating an account.

Fatal error: 1054 - Unknown column 'date_blocked_until' in 'field list' update lcih_customers set code = '', status = '1', email = 'test@gmail.co', tax_id = '', company = '', firstname = 'Firstname', lastname = 'Lastname', address1 = '', address2 = '', postcode = '', city = '', country_code = 'PH', zone_code = 'mm', phone = '+639998887777', different_shipping_address = '0', shipping_company = '', shipping_firstname = '', shipping_lastname = '', shipping_address1 = '', shipping_address2 = '', shipping_postcode = '', shipping_city = '', shipping_country_code = '', shipping_zone_code = '', shipping_phone = '', notes = '', date_blocked_until = NULL, date_expire_sessions = NULL, date_updated = '2021-10-19 11:47:38' where id = 4 limit 1; in ~/includes/library/lib_database.inc.php (Line 260)

Appreciate all assistance
Terry

Had the same problem, it was the addon Minimum Quantity / Package Quantity and another addon wich was and is not updated yet.
So disable it for now and refresh.
Is a lesson in first check if the addons are compatible......

@user8143 confirmed. These fields were created in 2.3.0 but aren't created on fresh new installations:

Run th following MySQL query in phpMyAdmin to fix it:
Make sure the table prefix lc_ matches yours.
ALTER TABLE `lc_customers` ADD COLUMN `login_attempts` INT NOT NULL DEFAULT '0' AFTER `password_reset_token`, ADD COLUMN `date_blocked_until` TIMESTAMP NULL AFTER `date_login`, ADD COLUMN `date_expire_sessions` TIMESTAMP NULL AFTER `date_blocked_until`;

A fix has been committed
https://github.com/litecart/litecart/commit/92809283eeb1e16b45f1828aa5ff6ab699d84088

On a side note, I am committing an installer updater in 2.3.2 so we can address problems like this with a handsfree fix.
The problem has been that once it reaches Softaculous things becomes set in stone. But with an installer updater we can fix this.

Much appreciated [url=@tim[/url">https://www.litecart.net/en/users/2/tim]@tim[/url]

I ran the query and all is now working smoothly.