No Data Types showing

Fernando

New member
I am testing dadabik and when I create a table by adding new fields the list of data types does not appear, only the blank editor.
 

Attachments

  • Captura desde 2022-10-13 10-37-58.png
    Captura desde 2022-10-13 10-37-58.png
    30.5 KB · Views: 1

eugenio

Administrator
Staff member
That's the advanced mode. Admin -> Data -> Settings -> check "data types": simple
 

Fernando

New member
I already tried it. But when I do that the Id field is not created and neither is the list of data types.
 

Attachments

  • Captura desde 2022-10-13 10-46-31.png
    Captura desde 2022-10-13 10-46-31.png
    25.1 KB · Views: 1
  • Captura desde 2022-10-13 10-45-42.png
    Captura desde 2022-10-13 10-45-42.png
    17.3 KB · Views: 1

eugenio

Administrator
Staff member
Ok. Post all the info as requested.

Is the installation publicly available? If yes, post here the URL
Can you replicate the issue in our online demo, if you start a blank demo (http://dadabik.com/demo) ?
 

eugenio

Administrator
Staff member
Ok. There was a bug that can trigger this behaviour on some specific versions of MySQL and mariadb but it has recently been fixed, if you have downloaded DaDaBIK in the last few days it's strange you still see it.
Is the version you are using the one you downloaded recently?
If yes, let's try to debug it:

1) Can you confirm that using advanced settings everything works (sure, you have to type manually the field type ... that's how the advance setting works)?

2) Try to set "advanced" and created a new table. Then paste here the field type of your primary key EXACTLY as it is in the textbox (including trailing spaces, if any). It should be "int(11)" but please paste here, on a new line containing only that piece of text, the content of the field type textbox.
 

Fernando

New member
Ok. There was a bug that can trigger this behaviour on some specific versions of MySQL and mariadb but it has recently been fixed, if you have downloaded DaDaBIK in the last few days it's strange you still see it.
Is the version you are using the one you downloaded recently?
If yes, let's try to debug it:

1) Can you confirm that using advanced settings everything works (sure, you have to type manually the field type ... that's how the advance setting works)?

2) Try to set "advanced" and created a new table. Then paste here the field type of your primary key EXACTLY as it is in the textbox (including trailing spaces, if any). It should be "int(11)" but please paste here, on a new line containing only that piece of text, the content of the field type textbox.
I downloaded the file .zip yesterday.

In advanced mode it works fine. The "Fyeld Type" field does not display the list. Other fields do show the list but not the arrows.
 

Attachments

  • Captura desde 2022-10-13 13-57-55.png
    Captura desde 2022-10-13 13-57-55.png
    96.5 KB · Views: 3
  • Captura desde 2022-10-13 13-56-11.png
    Captura desde 2022-10-13 13-56-11.png
    15.8 KB · Views: 3

eugenio

Administrator
Staff member
You have to follow the instructions I gave in the previous email point 2) and paste the text, the screenshot is useless for debugging this issue.
 

eugenio

Administrator
Staff member
I can't replicate this issue. I've tried with both MySQL and MariaDB but it seems that int(11) is handled correctly by DaDaBIK.

Can you publish your test app with a public URL? If yes, I can have a closer look.

I have noticed now that in the screenshot of your second post the columns "nullable", "pk index" etc are not created. This is very strange and maybe there is a PHP error during the creation of the field type column that prevent the rest of the code to be executed. Does the page stop there? If yes, you should check with "view source" (or similar) the html of the page to see if at the end there is an error message.
 

Fernando

New member
I can't replicate this issue. I've tried with both MySQL and MariaDB but it seems that int(11) is handled correctly by DaDaBIK.

Can you publish your test app with a public URL? If yes, I can have a closer look.

I have noticed now that in the screenshot of your second post the columns "nullable", "pk index" etc are not created. This is very strange and maybe there is a PHP error during the creation of the field type column that prevent the rest of the code to be executed. Does the page stop there? If yes, you should check with "view source" (or similar) the html of the page to see if at the end there is an error message.
 

Attachments

  • Captura desde 2022-10-14 09-13-58.png
    Captura desde 2022-10-14 09-13-58.png
    68 KB · Views: 1
  • Captura desde 2022-10-14 09-15-09.png
    Captura desde 2022-10-14 09-15-09.png
    76.7 KB · Views: 1

eugenio

Administrator
Staff member
What we need is "right click" -> view source on the second page, not the browser console.

PS: if you don't reply to the questions I ask, it's very difficult to provide further support ...
 

Fernando

New member
Ok, sorry, I did not understand.

(not possible to attach txt files????)
 

Attachments

  • Captura desde 2022-10-14 13-06-02.png
    Captura desde 2022-10-14 13-06-02.png
    242.7 KB · Views: 1
  • Captura desde 2022-10-14 13-04-45.png
    Captura desde 2022-10-14 13-04-45.png
    285.1 KB · Views: 1
  • Captura desde 2022-10-14 13-05-08.png
    Captura desde 2022-10-14 13-05-08.png
    254.9 KB · Views: 1
  • Captura desde 2022-10-14 13-05-50.png
    Captura desde 2022-10-14 13-05-50.png
    228.2 KB · Views: 1
  • Captura desde 2022-10-14 13-05-39.png
    Captura desde 2022-10-14 13-05-39.png
    257.4 KB · Views: 1
  • Captura desde 2022-10-14 13-05-28.png
    Captura desde 2022-10-14 13-05-28.png
    266.3 KB · Views: 1
  • Captura desde 2022-10-14 13-07-03.png
    Captura desde 2022-10-14 13-07-03.png
    235.7 KB · Views: 1
  • Captura desde 2022-10-14 13-07-17.png
    Captura desde 2022-10-14 13-07-17.png
    242.7 KB · Views: 1
  • Captura desde 2022-10-14 13-07-27.png
    Captura desde 2022-10-14 13-07-27.png
    229.8 KB · Views: 1
  • Captura desde 2022-10-14 13-07-36.png
    Captura desde 2022-10-14 13-07-36.png
    229.8 KB · Views: 1

Fernando

New member
Continue...
 

Attachments

  • Captura desde 2022-10-14 13-07-53.png
    Captura desde 2022-10-14 13-07-53.png
    212 KB · Views: 1
  • Captura desde 2022-10-14 13-08-16.png
    Captura desde 2022-10-14 13-08-16.png
    295.5 KB · Views: 1
  • Captura desde 2022-10-14 13-08-05.png
    Captura desde 2022-10-14 13-08-05.png
    231.5 KB · Views: 1
  • Captura desde 2022-10-14 13-08-27.png
    Captura desde 2022-10-14 13-08-27.png
    244.1 KB · Views: 1
  • Captura desde 2022-10-14 13-08-43.png
    Captura desde 2022-10-14 13-08-43.png
    229.1 KB · Views: 1
  • Captura desde 2022-10-14 13-08-53.png
    Captura desde 2022-10-14 13-08-53.png
    264.2 KB · Views: 1
  • Captura desde 2022-10-14 13-09-07.png
    Captura desde 2022-10-14 13-09-07.png
    228.2 KB · Views: 1
  • Captura desde 2022-10-14 13-09-24.png
    Captura desde 2022-10-14 13-09-24.png
    260.4 KB · Views: 1
  • Captura desde 2022-10-14 13-09-53.png
    Captura desde 2022-10-14 13-09-53.png
    377.1 KB · Views: 1

eugenio

Administrator
Staff member
Hi,
it's very difficult to go through these screenshots.

1) Can you publish your test app with a public URL? If yes, I can have a closer look.

2) IF the page with "new_table_to_test" ends after the field type (empty) menu (as it seems from your screenshot), then as I said there could be a hidden PHP error. You have to show the HTML source of the page and paste here (NO screenshot, paste the text) the last few lines of the code.
 

Fernando

New member
<tr class="table_interface_container_tr_top_menu_admin_area">
<td>
<table class="table_interface_container_table_top_submenu_admin_area">

<tr>



<td ><a class="bottom_menu_active" href="data.php?function=show_tables_views&tablename=dadabik_groups">&nbsp;&nbsp;Tables and Views&nbsp;&nbsp;</a></td>


<td ><a class="bottom_menu" href="data.php?function=show_relationships&tablename=dadabik_groups">&nbsp;&nbsp;Relationships&nbsp;&nbsp;</a></td>

<td ><a class="bottom_menu" href="data.php?function=show_settings&tablename=dadabik_groups">&nbsp;&nbsp;Settings&nbsp;&nbsp;</a></td>
<td style="width:100%"></td>
</tr>
</table>

</td>
</tr>



<tr>
<td class="table_interface_container_td_content">
<table class="table_interface_container_table_content"><tr>
<td class="td_content" valign="top">
<div id="top_messages"></div>



<span id="confirmation_message_container">
</span>

<a name="top"></a>
<h1>Data</h1>

<p>In this section you create your data structures (<a href="#tables">tables</a> and <a href="#views">views</a>). We store data into <strong>tables</strong>: for example you can have a <b>products</b> table, representing all your products or a <b>customers</b> table, representing all your customers. Each table has one or more fields, e.g. for a <strong>customers</strong> table you could have <strong>id, firstname, lastname, email, phone</strong>.<br><br>A <strong>view</strong>, instead, is a sort of "virtual" table that you can create, in SQL, starting from a "real" table. If you are a beginner, don't worry, you probably don't need <strong>views</strong>.



<!--<p>Search Tables/Views by name: <input type="text" name="tablename_to_search"> <input class="button_admin" type="button" value ="SEARCH" onclick="alert('Search will be available in a future release.')"></p>-->

<a name="tables"></a>
<h2>TABLES</h2>

<form method="POST" action="data.php?function=create_table&tablename=dadabik_groups">Create a new table with name: <input type="text" name="tablename_to_create"> <input class="button_admin" type="submit" value ="CREATE"></form>

<a name="anchor_new_table_to_test"></a><div id="container_new_table_to_test"><h2>new_table_to_test</h2><form id="drop_table_form_0"><input type="hidden" name="tablename_to_drop" value="new_table_to_test"><input type="hidden" name="table_type_to_drop" value="table"><input class="button_admin" type="submit" value="DELETE TABLE"> <!--<input class="button_admin" type="button" value="CLONE TABLE" onclick="alert('Table cloning will be available in a future release.')">--> <a class="button button_admin" href="internal_table_manager.php?tablename=new_table_to_test&reset_preview=1" target="_blank" title="Open in a new tab the form configurator for the table new_table_to_test">FORM CONFIGURATOR </a></form><form id="alter_table_form_0"><input type="hidden" name="tablename_to_alter" value="new_table_to_test"><p><div style="width:156px;display:inline-block" ><b>Field name</b></div> <div style="width:156px;display:inline-block"><b>Field type <a href="javascript:show_admin_help('Field type', 'You are using simple data types (see settings).<br><br>If you are an advanced user, maybe you wan to know the correspondance between these data types and the mysql data types:<br><ul>
<li>Integer number: integer
<li>Decimal number: decimal(12,2)
<li>Float number: float
<li>Short text: varchar(255)
<li>Long text: text
<li>Date: date
<li>Date and time: datetime
<li>Time: time
</ul>');"><img alt="Help" title="Help" border="0" src="images/help.png" /></a></b></div> <div style="width:100px;display:inline-block"><b>Nullable <a href="javascript:show_admin_help('Nullable', 'Choose <i>Yes</i> if you allow the <i>NULL</i> value for this field. If a field is required, you should choose <i>No</i>.');"><img alt="Help" title="Help" border="0" src="images/help.png" /></a></b></div><div style="width:150px;display:inline-block" ><b>PK index <a href="javascript:show_admin_help('PK index', 'If the field is a primary key, choose <i>Primary Key</i>.<br>You can have only one primary key in your table and must be <i>nullable</i>: no.<br><br>If you change the PK of a table, DaDaBIK automatically changes the unique field in the pages section.');"><img alt="Help" title="Help" border="0" src="images/help.png" /></a></b></div><div style="width:180px;display:inline-block" ><b>Extra <a href="javascript:show_admin_help('Extra', 'Only for Primary Key fields you can set AUTO_INCREMENT if you want to automatically get a numeric value (1, 2, 3, ...) for this field when you insert a new record.');"><img alt="Help" title="Help" border="0" src="images/help.png" /></a></b></div><div style="width:150px;display:inline-block"><b>Linked table <a href="javascript:show_admin_help('Linked table (lookup)', 'If this is a lookup field (a field taking the options from another table, e.g. in a table <i>customers</i> you could have a drop down menu field <i>country</i> and you could take the available options from the <i>countries</i> table), in this coulumn you see the corresponding linked table, otherwise you see <i>No</i>.<br><br>To define a field as <i>lookup</i>, from the form configurator you should set a compatible field type (e.g. <i>select_single</i>) and then set <i>Lookup table name</i>, <i>Lookup table linked fields</i> and the other required parameters.');"><img alt="Help" title="Help" border="0" src="images/help.png" /></a></b></div></p><div id="container_new_table_to_test_0" data-fieldname="id" data-tablename="new_table_to_test"><p><input type="text" style="width:150px" name="name_field_0" value="id"> <select style="width:150px" name="type_field_0"><option value=""></option><option value="int"
 

eugenio

Administrator
Staff member
Ok, I think I understood what happened.
In your include/config.php file could you replace

$simple_field_types_variations['mysql']['int'] = 'int(11)';

with

$simple_field_types_variations['mysql']['int'] = array();
$simple_field_types_variations['mysql']['int'][] = 'int(11)';

and see if it works?
 
Top