Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Error message "Unknown columm..." Mysql Workbench

Questions related to installing, updating, setting up and configuring
Post Reply
leodutra
Posts: 3
Joined: Thu Nov 24, 2022 1:36 am
nuBuilder Version: 4.5

Error message "Unknown columm..." Mysql Workbench

Unread post by leodutra »

Hi,

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
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
kev1n
nuBuilder Team
Posts: 3801
Joined: Sun Oct 14, 2018 6:43 pm
nuBuilder Version: 4.5
Has thanked: 2 times
Been thanked: 9 times
Contact:

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

Unread post by kev1n »

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`;
Post Reply