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