Setting up the first table

[Uwe]

I have a problem to set up the first table.

The first thing, after initially clicking on "Create or update internal table " on the admin.php page I get the error

>>>Warning: Unable to save MySQL query result in /mnt/ls1/01/032/00000004/htdocs/dadabik/program_files/include/db_functions.php on line 80 Warning: Supplied argument is not a valid MySQL result resource in /mnt/ls1/01/032/00000004/htdocs/dadabik/program_files/include/db_functions.php on line 86
Internal table correctly installed/updated <<<

Is the internal table really correctly installed?

Then I'm not sure what to do next. In the documentation it says:

>>>Open the file http://your_host/your_dir/admin.php in your browser and click on "Create/update internal table"
Now you have created the internal table, a new table that contains the information about all the fields of the table you want to manage with DaDaBIK. Edit that database by using PHPMyAdmin or the MySQL text interface.<<<

I don't understand what "Edit that database" refers to. Do I have to create the table I want to manage with Dadabik myself using PHPMyAdmin or does Dadabik create that table after I add a row to the Dadabik internal table describing one of this table's fields?

If I have to create my table myself I don't see how Dadabik knows which table it is supposed to manage. I don't see the connection.

I did the following thing:
I added a row to Dadabik's internal table (using PHPMyAdmin) describing one field of the table I want to manage (without actually having created that table). Then I updated by clicking "Create or update internal table ". I got the message "Internal table correctly installed/updated". However when I went to the index page and clicked "insert a new record" I was shown the fields of the internal table. Here I expected to be able to add a record to "my" table. What am I doing wrong?

 

[jason]

I have the same problem you have, have got any answer for it?

 

[dave]

Installing and using PHPmyAdmin is a great way to edit the table created (this way you can add/change or modify format shown on HTML)

...in other words, yes, the admin setup the table MYSQL reads form and back...it's the one you setup in the config.php.

Enjoy!
D-

 

[Uwe]

Sorry, but I still don't get it. When I install Dadabik a so called internal table is installed. So, do I just work INSIDE this table so to speak, or is the table that I want to manage a SECOND table?

I understand your posting to mean rather the former. Then, how do I go along exactly?

- I install the internal table
- I add (let's say) 3 rows that stand for three fields

When do I have to update?

How do I enter the primary key?

 

[Eugenio]

Uwe wrote:
>
> I have a problem to set up the first table.
>
> The first thing, after initially clicking on "Create or
> update internal table " on the admin.php page I get the error
>
> >>>Warning: Unable to save MySQL query result in
> /mnt/ls1/01/032/00000004/htdocs/dadabik/program_files/include/db_functions.php on line 80 Warning: Supplied argument is not a valid MySQL result resource in /mnt/ls1/01/032/00000004/htdocs/dadabik/program_files/include/db_functions.php on line 86
> Internal table correctly installed/updated <<<
>
> Is the internal table really correctly installed?

No, it isn't, probably you have done some mistakes in config.php


As Dave wrote, with DaDaBIK you have to create the internal table (not the table you want to manage), then you can edit it using, for example, PHPMyAdmin; you need to edit it when you want change the properties of each field.

(Latest version of DaDaBIK when this message was posted: 1.5b)

 

[Eugenio]

DaDaBIK supposes that you have a pre-existent table that you want to manage (e.g. albums_table, the collection of your CDs).

When you install DaDaBIK, DaDaBIK automatically create another table (I call it internal table) (e.g. dadabik_albums_table) that it uses as support. In the internal table, for each field of the main one, you can see and change the properties of the fields (e.g. the label of the field).

To edit the internal table you can use, for example, phpmyadmin.

You have to set the primary key in the main table.

When you add new fields to the main table you have to re-run admin.php to refresh the internal table.

Anyway, I'm going to release the new version of DaDaBIK with a new and easy-to use administration interface to delete/change position/refresh the internal table.

(Latest version of DaDaBIK when this message was posted: 1.5b)