Hi...

I have a problem in installing tender system. When I enter the username and password in database setting, the following error come out:

Module Errors
e18:Could not execute sql statement

ERROR -> Table 'ts_area_state' already exists:
SQL -> CREATE TABLE ts_area_state ( id integer NOT NULL, name varchar(255) default '' NOT NULL, status integer default '0' NOT NULL, created_date date, created_time time, created_by integer default '0', deleted_date date, deleted_time time, deleted_by integer default '0' , PRIMARY KEY (id) ):

Execution Number -> 0:

help me....

regards,
nisha

Nisha

The user does not have sufficient permissions to create a table.

Increase the database users permissions and all will work.

Please let me know when it works or if you experience any other problems.

I am really stuck here; I need help. I get the same bug as dabello which is this error:
•e18:Could not execute sql statement
•ERROR -> Table 'ts_area_state' already exists:
•SQL -> CREATE TABLE ts_area_state ( id integer NOT NULL, name varchar(255) default '' NOT NULL, status integer default '0' NOT NULL, created_date date, created_time time, created_by integer default '0', deleted_date date, deleted_time time, deleted_by integer default '0' , PRIMARY KEY (id) ):
•Execution Number -> 0:

I tried as you said to change the privilege of the user database but it did not work. Thus, I am stuck with this error and this step of installation, and i can't get forward.

What I need is how can I change the user privilege; maybe I did it wrong? and whether there is another solution.

Please answer me as soon as possible.

Hello is anybody here!!!

I have also the following installation problem:

* e18:Could not execute sql statement
* ERROR -> BLOB/TEXT column 'description' can't have a default value:
* SQL -> CREATE TABLE ts_item ( id integer NOT NULL, supplier integer NOT NULL references ts_organisation(id), category_sub integer NOT NULL references ts_category_sub(id), brand varchar(255) default '' NOT NULL, model varchar(255) default '' NOT NULL, description text default '' NOT NULL, price decimal(12,2) default '0.00' NOT NULL, stock integer default '0' NOT NULL, valid_until date NOT NULL, status integer default '0' NOT NULL, created_date date, created_time time, created_by integer default '0', deleted_date date, deleted_time time, deleted_by integer default '0' , PRIMARY KEY (id) ):
* Execution Number -> 9:

* OS: WindowsXP
* MySQL Server version: 5.1.45-community
* Apache/2.2.14 (Win32)
* PHP/5.3.1

Any help ? Is it possible to change the table statement to remove the default value option?

thank you.

According to the MySQL, it is not possible to set default value '' for TEXT columns.This was supported in older MySQL Versions but the current version. Please can anybody help me to overcome the above described problem???

Please help............

Thank you,
Meropi