Problem with syntax changes in sql strings

[danièle deveaux]

Hi,

I am trying to install the 2.1b_beta release.
I use php-4.2.1 and my database built with mysql 3.22.32.
I encounter problem with the new syntax of sql strings in php files.
The sql strings are now built with ' for fields names.
Ex :
" delete from '$table_list_name' where 'name_table' ='$table_name_temp'" ;
before it was (release 2.0-1)
"delete from $table_list_name where name_table = '$table_name_temp'";
Can someone tells me why it don't work?
Is there a configuration modification to do somewhere?

Thank's for help

D.Deveaux

 

[Eugenio]

danièle deveaux wrote:
>
> Hi,
>
> I am trying to install the 2.1b_beta release.
> I use php-4.2.1 and my database built with mysql 3.22.32.
> I encounter problem with the new syntax of sql strings in
> php files.

Which kink of problems do you encounterd?
Please provide examples.

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

 

[danièle deveaux]

Hi,

I 'll try to give more details.

First case :
I try to execute install.php of the new release wiith dadabik_2 tables in the database
I got the message :

Error during query execution.
select `allowed_table` from `dadabik_table_list` where `name_table` = 'cnu'
MySQL server said: Something is wrong in your syntax près de '`allowed_table` from `dadabik_table_list` where `name_table` = '' à la ligne 1

(cnu is the name of a table that exits in the database).

Second case :
I execute install.php with no dadabik tables.
I got the form of dadabik administration but after click to install, the screen turns white
and that's all.
No table created.
If I modify in business_logic.php
$sql="CREATE TABLE '$table_list_name' (
by
$sql="CREATE TABLE $table_list_name (
the dadabik_table_list is created.
And so on with others sql string.
The sql strings built with ' in the string seems to be all in error.

D.Deveaux

 

[Eugenio]

danièle deveaux wrote:
>
> Hi,
>
> I am trying to install the 2.1b_beta release.
> I use php-4.2.1 and my database built with mysql 3.22.32.
> I encounter problem with the new syntax of sql strings in
> php files.
> The sql strings are now built with ' for fields names.
> Ex :
> " delete from '$table_list_name' where 'name_table'
> ='$table_name_temp'" ;
> before it was (release 2.0-1)
> "delete from $table_list_name where name_table =
> '$table_name_temp'";
> Can someone tells me why it don't work?
> Is there a configuration modification to do somewhere?

This bug has been corrected, do you still have the problem?

Eugenio.

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