Install Error

P

Pam

Guest
After hitting the install button this is what i get with debug on:

Error during query execution.
CREATE TABLE dadabik_table_list ( name_table varchar(255) NOT NULL default '', allowed_table tinyint(4) NOT NULL default '0', enable_insert_table varchar(5) NOT NULL default '', enable_edit_table varchar(5) NOT NULL default '', enable_delete_table varchar(5) NOT NULL default '', enable_details_table varchar(5) NOT NULL default '', PRIMARY KEY (name_table), UNIQUE KEY name_table (name_table) ) TYPE=MyISAM
MySQL server said: You have an error in your SQL syntax near 'KEY name_table (name_table) ) TYPE=MyISAM ' at line 10

The version of mysql is: 3.22.15-gamma

There are NO spaces in any of my names, tables nor fields.

Does anyone know how to overcome this error?

Thank you.
 
E

Eugenio

Guest
Pam wrote:

> After hitting the install button this is what i get with
> debug on:
>
> Error during query execution.
> CREATE TABLE dadabik_table_list ( name_table varchar(255) NOT
> NULL default '', allowed_table tinyint(4) NOT NULL default '0',
> enable_insert_table varchar(5) NOT NULL default '',
> enable_edit_table varchar(5) NOT NULL default '',
> enable_delete_table varchar(5) NOT NULL default '',
> enable_details_table varchar(5) NOT NULL default '', PRIMARY
> KEY (name_table), UNIQUE KEY name_table (name_table) )
> TYPE=MyISAM
> MySQL server said: You have an error in your SQL syntax near
> 'KEY name_table (name_table) ) TYPE=MyISAM ' at line 10
>
> The version of mysql is: 3.22.15-gamma
>
> There are NO spaces in any of my names, tables nor fields.
>
> Does anyone know how to overcome this error?

Try to delete the last sql instruction in business_logic.php (should be line 1851):
PRIMARY KEY (name_table),
UNIQUE KEY name_table (name_table)

become:
PRIMARY KEY (name_table)

And let me know the results.

Eugenio.

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