lapis312

Thank you for fixing this, Peter! I’ll keep an eye on the update and let you know if the issue persists.

Happy New Year!

Hi @peterschulznl ,

Thank you for the quick response. The error is coming from the front-end when I started typing for a character in the field with lookup autocomplete. I’m using data forms (under Data Projects). The odd thing is when only 1 field has the lookup autocomplete enabled, everything works as expected. Only when 2 or more fields have that option enabled, it started throwing the “Not authorized” pop up when trying to lookup.
Below are the table structures:

CREATE TABLE IF NOT EXISTS customer (
id BIGINT(20) NOT NULL AUTO_INCREMENT
, fname VARCHAR(100) NOT NULL DEFAULT ”
, lname VARCHAR(100) NOT NULL DEFAULT ”
, phone VARCHAR(50) NULL
, email VARCHAR(320) NULLCURRENT_TIMESTAMP
, PRIMARY KEY (id)
, KEY customer_fname_lname_idx (fname, lname)
, KEY customer_phone_idx (phone)
, KEY customer_email_udx (email)
) ENGINE=InnoDB
COMMENT = ‘Table that stores customer information.’;

CREATE TABLE address (
id INT(10) NOT NULL AUTO_INCREMENT
, name VARCHAR(100) NOT NULL
, company VARCHAR(100) NULL
, addr_line_1 VARCHAR(100) NOT NULL
, addr_line_2 VARCHAR(50) NULL
, city VARCHAR(50) NOT NULL
, state VARCHAR(50) NOT NULL
, zip_code VARCHAR(20) NULL
, PRIMARY KEY (id)
, KEY address_name_idx (name)
, KEY address_company_idx (company)
) ENGINE=InnoDB
COMMENT = ‘Table that stores addresses.’;

CREATE TABLE order (
id BIGINT(20) NOT NULL AUTO_INCREMENT
, customer_id BIGINT(20) NOT NULL DEFAULT 0
, address_id INT(10) NULL
, shipping_method VARCHAR(50) NULL
, shipping_date DATE NULL
, PRIMARY KEY (id)
, KEY order_customer_shipping_date_idx (customer_id, shipping_date)
, FOREIGN KEY order_fk_customer (customer_id) REFERENCES customer(id) ON UPDATE CASCADE
, FOREIGN KEY order_fk_address (address_id) REFERENCES address(id) ON UPDATE CASCADE
) ENGINE=InnoDB
COMMENT = ‘Table that stores order history.’;

Thank you,
Daniel