nuBuilder Forum

Posted: **Sat Mar 06, 2021 10:33 pm**

Hi people,

Both myself (on a bluehost.com) and another of my clients (using an in house server) are getting this error when installing or uploading a nuBuilder database.

CREATE 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())

MySQL said: Documentation

#1054 - Unknown column 'information_schema.tables.TABLE_NAME' in 'field list'

This does not happen when installing nuBuilder on my local WAMP stack from bitnami.

Does anyone know why?

Steven

Posted: **Sun Mar 07, 2021 9:48 am**

Steven,

Some versions of MySQL reportedly have problems with the overly, explicit, information_schema, column name

I was able to create the view with the slightly modified SQL

Code: Select all

CREATE VIEW `zzzzsys_object_list`  AS  select `table_name` AS `zzzzsys_object_list_id` from `information_schema`.`TABLES` where (`TABLE_SCHEMA` = database()) ;

Posted: **Sun Mar 07, 2021 11:47 pm**

kev1n,

Thanks

Steven

Posted: **Mon Mar 08, 2021 1:14 pm**

Modify that to be:

Code: Select all

CREATE VIEW `zzzzsys_object_list`  AS  select `TABLE_NAME` AS `zzzzsys_object_list_id` from `information_schema`.`TABLES` where (`TABLE_SCHEMA` = database()) ;

and have it exported in a linux machine to preserve case in the nubuilder4.sql file.

Posted: **Tue Mar 09, 2021 9:18 am**

The case is not the issue. It's the

overly, explicit, information_schema, column name

nuBuilder Forum

Can't find information_schema

Can't find information_schema

Re: Can't find information_schema

Re: Can't find information_schema

Re: Can't find information_schema

Re: Can't find information_schema