Error during query execution

[george crawford]

Hi,

I have dadabik installed and working perfectly on one of the tables in my database.

I have now tried to set it up for another table - I did exactly the same installation procedure, only the table name was different.

I can get to the ..../index.php page, and have the option to search, add, update etc. as normal. However, clicking on any of these links, or trying to access the internal database, results in the following:

Error during query execution

Can anyone help?

Thanks,

George

 

[Eugenio]

george crawford wrote:
>
> Hi,
>
> I have dadabik installed and working perfectly on one of the
> tables in my database.
>
> I have now tried to set it up for another table - I did
> exactly the same installation procedure, only the table name
> was different.
>
> I can get to the ..../index.php page, and have the option to
> search, add, update etc. as normal. However, clicking on any
> of these links, or trying to access the internal database,
> results in the following:
>
> Error during query execution

Please enable the debug mode in config.php and let me know the error message that will be showed up.

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

 

[mike]

After getting a similar message I get this msg upon trying your suggestion

 

[mike]

Error during query execution.
select name_field, present_insert_form_field, present_ext_update_form_field , present_search_form_field, required_field, present_results_search_field, check_duplicated_insert_field, type_field, content_field, label_field, select_options_field, separator_field, foreign_key_field, db_primary_key_field, select_type_field, prefix_field, default_value_field, width_field, height_field, maxlength_field, hint_insert_field, order_form_field from dadabik_ssp order by order_form_field
MySQL server said: Table 'fataldata.dadabik_ssp' doesn't exist

 

[mike]

I think this is maybe b/c I don't have root access to the server just to my DBase and enclosed tables.?!

 

[Eugenio]

mike wrote:
>
> I think this is maybe b/c I don't have root access to the
> server just to my DBase and enclosed tables.?!

Check your db, does the table dadabik_ssp exist in the fataldata db?

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