nuBuilder Forum

Posted: **Thu Dec 29, 2022 2:51 pm**

Hi,

This error message comes after execute sql script "nubuilder4.sql" on MySQL Workbench.

10:20:26	CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `zzzzsys_object_list`  AS SELECT `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` FROM `information_schema`.`TABLES` WHERE (`information_schema`.`tables`.`TABLE_SCHEMA` = database())	Error Code: 1054. Unknown column 'information_schema.tables.TABLE_NAME' in 'field list'	0.047 sec

This error does not happen when I delete lines 2387 and 2389 from the script.

Code: Select all

DROP TABLE IF EXISTS `zzzzsys_object_list`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `zzzzsys_object_list`  AS SELECT `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` FROM `information_schema`.`TABLES` WHERE (`information_schema`.`tables`.`TABLE_SCHEMA` = database())  ;

DB Version: V.4.5-2022.12.27.00
Files Version: V.4.5-2022.12.27.03

I could not run the script in PhpMyAdmin on my server. It's in infinite loading and nothing else happens.

MySQL 10.5

Posted: **Thu Dec 29, 2022 3:55 pm**

Isn't there a column TABLE_NAME in information_schema? Or is it lowercase ?

Run this SQL:

Code: Select all

SELECT * FROM `information_schema`.`tables`;

nuBuilder Forum

Error message "Unknown columm..." Mysql Workbench

Error message "Unknown columm..." Mysql Workbench

Re: Error message "Unknown columm..." Mysql Workbench