Problem importing a nuBuilder 4.5 db

[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

[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.

[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

[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.

[kev1n]

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.

[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

[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.

[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

[kev1n]

You could reach out to the Bluehost support team if you haven't done so.

[steven]

kev1n,

I will thanks.


Steven