Page 1 of 2
Problem importing a nuBuilder 4.5 db
Posted: Sun Jan 31, 2021 8:13 am
by steven
I'm trying to upload a nuBuilder 4.5 db from my PC to bluehost.com but I get this message...
info.PNG
Steven
Re: Problem importing a nuBuilder 4.5 db
Posted: Sun Jan 31, 2021 8:45 am
by kev1n
Hi Steven,
Does
Code: Select all
SELECT `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` FROM `information_schema`.`tables`
return a result?
Also open the DB information_schema, table tables to check if there is a column TABLE_NAME.
Re: Problem importing a nuBuilder 4.5 db
Posted: Sun Jan 31, 2021 9:13 am
by steven
kev1n,
No, it doesn't return anything.
I'm not sure I can even access the information_schema from this host.
info2.PNG
Would that be a normal thing on a shared server?
Steven
Re: Problem importing a nuBuilder 4.5 db
Posted: Sun Jan 31, 2021 9:46 am
by kev1n
nuBuildFastForm() runs this query:
Code: Select all
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE()
Does that run?
I'll check in the meantime if I get a result back on another shared server.
Re: Problem importing a nuBuilder 4.5 db
Posted: Sun Jan 31, 2021 9:58 am
by kev1n
steven wrote:
Would that be a normal thing on a shared server?
I've tested with two different shared web hosting providers and both times the query returned a result.
Re: Problem importing a nuBuilder 4.5 db
Posted: Sun Jan 31, 2021 10:27 am
by steven
kev1n,
It does work with Fast Forms and I created a Procedure that returned a result.
I think the problem is PHPMyAdmin because it won't run there and that is how I tried to import my exported dump from my PC. Nothing to do with nuBuilder. I'll figure out some other way.
Thanks for your help.
Steven
Re: Problem importing a nuBuilder 4.5 db
Posted: Sun Jan 31, 2021 10:31 am
by kev1n
Place your exported dump in nuBuilder's root directory and rename it to nubuilder4.sql.
nuBuilder will then import it the first time you log in.
Re: Problem importing a nuBuilder 4.5 db
Posted: Sun Jan 31, 2021 10:18 pm
by steven
kev1n,
Good idea, so I tried, but I got this...
Code: Select all
[0] :
===USER==========
globeadmin
===PDO MESSAGE===
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'information_schema.tables.TABLE_NAME' in 'field list'
===SQL===========
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()) ;
===BACK TRACE====
/home3/nubuilde/public_html/nubuilder/core/nucommon.php(1236) : eval()'d code - line 2 (nuRunQuery)
/home3/nubuilde/public_html/nubuilder/core/nucommon.php - line 1236 (eval)
/home3/nubuilde/public_html/nubuilder/core/nurunphp.php - line 15 (nuEval)
4 things are happening (I think)
1-The SELECT part works in nuBuilder (on Bluehost) but not in a CREATE VIEW.
2-The SELECT part does not work in PHPMyAdmin (on Bluehost) at all.
3-it all works on my PHPMyAdmin on my PC.
4-it all works on my nuBuilder on my PC.
Steven
Re: Problem importing a nuBuilder 4.5 db
Posted: Mon Feb 01, 2021 5:36 am
by kev1n
You could reach out to the Bluehost support team if you haven't done so.
Re: Problem importing a nuBuilder 4.5 db
Posted: Mon Feb 01, 2021 7:34 am
by steven
kev1n,
I will thanks.
Steven