Page 1 of 1
Registered customers cannot log in to the store (version 1.1.0.6)
Posted: Thu Jul 23, 2026 12:12 am
by cbi201214337
Hello everyone:
Mi nombre es Juan.
I just updated my online store from version 1.0.9.3 to 1.1.06.
I’ve been testing the features, and one problem I found is that registered customers can’t log in.
It displays the following message:
Your account has been suspended. Please contact us to reinstate your account.
I’ve checked everywhere, but I don’t know where the problem might be.
Has anyone else experienced this? And how did you fix it?
I suspect the following:
When I edit a product and try to save, the page goes blank.
I also tried to delete an order that wasn’t fulfilled, but I couldn’t delete it.
I’m sharing the links to two videos below.
https://www.astrocolorsllc.com/videos/V ... 175332.mp4
https://www.astrocolorsllc.com/videos/V ... 180011.mp4
Re: Registered customers cannot log in to the store (version 1.1.0.6)
Posted: Thu Jul 23, 2026 6:03 am
by BrockleyJohn
cbi201214337 wrote: ↑Thu Jul 23, 2026 12:12 am
Hello everyone:
Mi nombre es Juan.
I just updated my online store from version 1.0.9.3 to 1.1.06.
I’ve been testing the features, and one problem I found is that registered customers can’t log in.
It displays the following message:
Your account has been suspended. Please contact us to reinstate your account.
I suspect you did not run the update sql for 1.1.0.6 or that it failed somehow.
A new field status was added to customers and either it's missing or not set to default 1.
The sql was
Code: Select all
CREATE TABLE analytics_events (
id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
customer_id INT UNSIGNED DEFAULT NULL,
merchant_id INT UNSIGNED NOT NULL DEFAULT 0,
event_type VARCHAR(255) NOT NULL,
product_id INT UNSIGNED DEFAULT NULL,
payload LONGTEXT NOT NULL,
page_url TEXT DEFAULT NULL,
referrer TEXT DEFAULT NULL,
domain VARCHAR(255) DEFAULT NULL,
user_agent TEXT DEFAULT NULL,
ip_address VARCHAR(255) DEFAULT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
INDEX idx_event_type (event_type),
INDEX idx_product (product_id),
INDEX idx_merchant (merchant_id),
INDEX idx_created_at (created_at),
INDEX idx_customer_id (customer_id)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE customers ADD status INT NOT NULL DEFAULT '1';
ALTER TABLE products_description DROP products_viewed;
Re: Registered customers cannot log in to the store (version 1.1.0.6)
Posted: Thu Jul 23, 2026 10:23 am
by 14Steve14
Hi @cbi201214337 I am about to go through the upgrade, Assuming you updated your old database did you by any chance save all the sql updates that need doing into one file to save me going through all the updates one at a time?
Re: Registered customers cannot log in to the store (version 1.1.0.6)
Posted: Wed Aug 19, 2026 4:58 pm
by cbi201214337
BrockleyJohn, you were right.
I ran the query and it fixed the problem.
Thanks
Re: Registered customers cannot log in to the store (version 1.1.0.6)
Posted: Wed Aug 19, 2026 5:01 pm
by cbi201214337
14Steve14 wrote: ↑Thu Jul 23, 2026 10:23 am
Hi @cbi201214337 I am about to go through the upgrade, Assuming you updated your old database did you by any chance save all the sql updates that need doing into one file to save me going through all the updates one at a time?
14Steve14 I had version 1.0.9.3.
I took the long way around and updated version by version