Error message "Unknown columm..." Mysql Workbench
Posted: Thu Dec 29, 2022 2:51 pm
Hi,
This error message comes after execute sql script "nubuilder4.sql" on MySQL Workbench.
This error does not happen when I delete lines 2387 and 2389 from the script.
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
This error message comes after execute sql script "nubuilder4.sql" on MySQL Workbench.
Code: Select all
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
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