Registered customers cannot log in to the store (version 1.1.0.6)

[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

[BrockleyJohn]

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; 

[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?

[cbi201214337]

BrockleyJohn, you were right.
I ran the query and it fixed the problem.
Thanks

[cbi201214337]

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