More teething troubles

[MikeRodent]

Hi again,

So having got into the home screen with the 9 buttons I followed the instructions about importing course.zip contents. Two things I found:
1) I had to create a dbase in the phpMyAdmin page: nu4_course - your User Guide instructions say nothing about having to do this.
2) I had to import the .sql extracted from the course.zip: trying to import the .zip file didn't work.


[ SKIP THIS BIT IF YOU LIKE... various anomalies
Having followed everything else I now find that when I click the "Organizations" button on the "Main" tab it displays the table... but with no data whatsoever.

On p. 20 of the User Guide it appears to be the case that the "zzzz" tables (from nubuilder4.sql) have to be in the SAME database as the 3 "course" tables. There's no explicit mention of this in your instructions.

Oh NO! I deleted both tables in phpMyAdmin with a view to putting all tables in a single dbase called nu4_course... then imported both .sql files (nubuilder4.sql and course.sql).

Once again, the browsers (both Chrome and FF) are unable to display the login screen (just blank screen). Did a restart. Even created a new dbase, "nubuilder" and imported the "nubuilder4.sql" files. No dice with either browser. FF is displaying a blank screen, and Chrome is saying "This page isn't working... HTTP error 500" (Internal server error).

(few minutes later)

Oops... stranger and stranger. I deleted the dbase nuBuilder leaving only the dbase nbuilder4. Able to regain the nuBuilder login screen again.

(few minutes later)

]

Having deleted all nuBuilder dbases again and started again. Another attempt, another problem:

1. I set up a dbase "nubuilder4" with all the zzzz* tables
2. I set up a SECOND dbase, "nu4_course", with the zzzz* tables and the 3 course tables.
3. I managed to log into the nuBuilder login screen.
4. I followed the instructions about setting up a form - OK
5. I followed the instructions about setting up a button to run it - NO GO!
--> on the Home > Object screen, tab "Run", when I enter "org" in the "Run" box and then press the magnifying glass, not only is there no dropdown, but the text "org" gets deleted!

ENOUGH for today.

I also had a look at the FF inspector: Console, Debugger, Inspector tabs: no error output of any kind... Can you say where I find the PHP logger output for this?

Could you possibly have a look through the steps I took in the last attempt to get things going and say what you think might be going wrong? In particular, how many databases am I supposed to be creating, what are they meant to be called, and what tables are they meant to contain?

[kev1n]

Hi,

Just create one db and import course.sql into it.

https://www.nubuilder.com/guides/getting-started

[MikeRodent]

Thanks.

OK I've got a little further this time: I have managed to create a button which actually does display the output (listing of companies).

Are you aware how incredibly flakey this whole thing is in terms of the setup? For example, as I said:

1) you have to extract the .sql file from the course.zip file
2) I find that I have to restart my machine before I can see the nuBuilder control panel (with the 9 buttons)
3) the first attempt I made to create an "Organizations" button failed because "Home" was not an available option on the All Tab (see p. 32 of the User Guide, figure 34). The second time I tried it was an avialable option.

Maybe it will be much smoother from now on, who knows. But if you want to know why this excellent idea (flexible front end for MySQL) has not yet caught on, it is because you haven't yet taken the time to explain properly how to set the thing up... and it still appears to manifest glitches and inconsistencies.

Bear in mind that a database is usually a critical application, not only for a business, but also for people generally. If you want your application to become more widespread you need to make the whole thing, including the set up instructions, FAR more professional and comprehensive.