Page 2 of 2
Re: Problem importing a nuBuilder 4.5 db
Posted: Mon Feb 01, 2021 12:23 pm
by 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
Re: Problem importing a nuBuilder 4.5 db
Posted: Mon Feb 01, 2021 1:11 pm
by 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.
Re: Problem importing a nuBuilder 4.5 db
Posted: Mon Feb 01, 2021 1:20 pm
by kev1n
apmuthu wrote: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?
Re: Problem importing a nuBuilder 4.5 db
Posted: Mon Feb 01, 2021 1:31 pm
by 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
Re: Problem importing a nuBuilder 4.5 db
Posted: Tue Feb 02, 2021 2:54 am
by apmuthu
Check if your DB user has permissions to CREATE VIEW and any access limitations in using information schema DB.
Re: Problem importing a nuBuilder 4.5 db
Posted: Tue Feb 02, 2021 12:34 pm
by steven
apmuthu,
I believe I do have permissions to CREATE VIEW.
Steven
Re: Problem importing a nuBuilder 4.5 db
Posted: Tue Feb 02, 2021 6:28 pm
by 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.
Re: Problem importing a nuBuilder 4.5 db
Posted: Tue Feb 02, 2021 6:30 pm
by kev1n
apmuthu wrote: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`