Install "Error during query execution"

[Martin Fritz]

I installed Dadabik 2.2.1 beta with php 4.1.2 and mysql 3.23.39. Mo matter what I do after install I keep getting "Error during query execution".

DB connection is there as all tables are shown in the admin page. I tried emtying the databse, Renaming tables etc.

Phpmyadmin runs fine and other mysql-php scripts run nicely too.

When I tried to run this pasted script from Eugenio´s tutorail on phpmyadmin:

CREATE TABLE `customers_tab` (
`ID_cust` SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`first_name_cust` CHAR(50) NOT NULL,
`last_name_cust` CHAR(50) NOT NULL,
`country_cust` CHAR(50) NOT NULL,
`phone_cust` CHAR(20) NOT NULL,
`email_cust` CHAR(50) NOT NULL,
`web_cust` CHAR(100) NOT NULL,
`age_cust` CHAR(3) NOT NULL,
`job_cust` CHAR(50) NOT NULL,
`notes_cust` TEXT NOT NULL,
`update_date_cust` DATE DEFAULT '2002-08-31' NOT NULL
);

I received errors untill I deleted all the ` signs.

Does this provide a clue?

Any ideas would be greatly appreciated. Thank you!

Martin

 

[Eugenio]

Martin Fritz wrote:

> When I tried to run this pasted script from Eugenio´s
> tutorail on phpmyadmin:
>
> CREATE TABLE `customers_tab` (
> `ID_cust` SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
> `first_name_cust` CHAR(50) NOT NULL,
> `last_name_cust` CHAR(50) NOT NULL,
> `country_cust` CHAR(50) NOT NULL,
> `phone_cust` CHAR(20) NOT NULL,
> `email_cust` CHAR(50) NOT NULL,
> `web_cust` CHAR(100) NOT NULL,
> `age_cust` CHAR(3) NOT NULL,
> `job_cust` CHAR(50) NOT NULL,
> `notes_cust` TEXT NOT NULL,
> `update_date_cust` DATE DEFAULT '2002-08-31' NOT NULL
> );
>
> I received errors untill I deleted all the ` signs.

It depends on the version of MySQL, older versions don't support the back quote sign, only the normal quote (').

Eugenio.

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