Can't find information_schema

[steven]

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

[kev1n]

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

[steven]

kev1n,

Thanks


Steven

[apmuthu]

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.

[kev1n]

The case is not the issue. It's the

overly, explicit, information_schema, column name