Help Abuot "Error during query execution?

[Dan]

Hi,
My script work well but when I submit a new data I see this phrase "Error during query execution"?

What It means?
Thank Dan

 

[Dan]

RESOLT BY MYSELF

 

[Paul]

Hi, How di you resolve the error? I am having the same issue. thxDan wrote:

> RESOLT BY MYSELF

 

[Dan]

If I remember well my code of sql table was wrong.
Maybe you put in your PHPadmin a new code like a test

example:


CREATE TABLE `TEST` (
`ID_cust` smallint(6) NOT NULL auto_increment,
`Contes` char(50) NOT NULL default '',
`Region` char(50) NOT NULL default '',
`country` char(50) NOT NULL default '',
`street` char(10) NOT NULL default '',
`number_rooms` char(10) NOT NULL default '',
`price` char(10) NOT NULL default '',
`Contract` char(10) NOT NULL default '',
`e_mail` char(50) NOT NULL default '',
`Note` char(200) NOT NULL default '',
`Data_adv` date NOT NULL default '2002-08-31',
PRIMARY KEY (`ID_cust`),
UNIQUE KEY `ID_cust` (`ID_cust`)
) TYPE=MyISAM


Maybe this code table work well but I am not sure.

Dan
Dan

 

[Richard]

Paul wrote:
> Hi, How di you resolve the error? I am having the same issue.
> thxDan wrote:
> RESOLT BY MYSELF


Enable debugging in config.php and tell us what you get.

$display_sql = 1;
$debug_mode = 1;


Richard.

 

[Paul]

I figured it out. When ever a single quote is in the field name the error is generated. If I use O'Connor I got the error but O"Connor didn't give me the error.

I am making sure the people entering the info don't enter single quotes. Is there any other other change I can make to the dadabik code to fix. I don't have access to the php.ini

Thanks!

 

[PLMresearch]

I believe if you enable "magic_quotes" in your php.ini file, this will not be a problem. magic_quotes escapes out ( \ ) characters that coud cause harm to the server - such as the ' in O'Connor.

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