Problem importing a nuBuilder 4.5 db

[nac]

Steven,

I have no idea if this will help, but I have a very basic Bluehost account and I have just tried the query

Code: Select all

SELECT `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` FROM `information_schema`.`tables`

It seems to work, giving this result.

Code: Select all

zzzzsys_object_list_id
CHARACTER_SETS
CLIENT_STATISTICS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
COLUMNS
COLUMN_PRIVILEGES
INDEX_STATISTICS
ENGINES
EVENTS
FILES
GLOBAL_STATUS
GLOBAL_TEMPORARY_TABLES
GLOBAL_VARIABLES
KEY_COLUMN_USAGE
OPTIMIZER_TRACE
PARAMETERS
PARTITIONS
PLUGINS
PROCESSLIST
PROFILING
REFERENTIAL_CONSTRAINTS
ROUTINES
SCHEMATA
SCHEMA_PRIVILEGES
SESSION_STATUS

The MySQL version is : 5.6.41-84.1 - Percona Server (GPL), Release 84.1, Revision b308619

Let me know if I can help in any way to investigate this further.

Neil

[apmuthu]

Untick set_denied in Settings.

This must be set to 0 in nubuilder4.sql - only then will some DB functions work even for globeadmin.

Try to install nuBuilder v4 from my repo and see if it is possible to import SQLs.

[kev1n]

Untick set_denied in Settings.

The SELECT query doesn't even work in phpMyAdmin for him.

This must be set to 0 in nubuilder4.sql - only then will some DB functions work even for globeadmin.

I don't see the connection. Can you give an example?

[steven]

kev1n,

I have spoken with a guy from bluehost help who tried the same SQL on my server and got the same problem.

So currently the issue has been escalated and I have a ticket number.

I'll see what happens.


Steven

[apmuthu]

Check if your DB user has permissions to CREATE VIEW and any access limitations in using information schema DB.

[steven]

apmuthu,

I believe I do have permissions to CREATE VIEW.


Steven

[apmuthu]

Must set set_denied = 0 in nubuilder4.sql so that on fresh install, the languages can be created. When we go to Settings, we see that all languages are chosen, but the languages will not get created unless some change is made to the select2 and then changed back to all perhaps and then untick set_denied and then save. The language strings will get populated in the translate table. This problem does not exist in v4 - no select2 and set_denied=0 by default.

[kev1n]

Must set set_denied = 0 in nubuilder4.sql so that on fresh install, the languages can be created. When we go to Settings, we see that all languages are chosen, but the languages will not get created unless some change is made to the select2 and then changed back to all perhaps and then untick set_denied and then save. The language strings will get populated in the translate table. This problem does not exist in v4 - no select2 and set_denied=0 by default.

That's not the problem.

This query doesn't run in phpMyAdmin:

Code: Select all

SELECT `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` FROM `information_schema`.`tables`