Database error when I backup

[HelleM]

For the 5' time I try to backup the database - and then try to restore it - and EVERY TIME I get this error???

 

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'left', 'right'),' , PRIMARY KEY (configuration_id) )' at line

create table theme_configuration ( configuration_id int(11) not null auto_increment, configuration_title varchar(64) not null , configuration_key varchar(64) default 'BOX_HEADING_' not null , configuration_value varchar(255) not null , configuration_description varchar(255) not null , configuration_group_id int(11) default '1' not null , configuration_column varchar(64) default 'left' not null , location int(5) default '0' not null , sort_order int(5) , last_modified datetime , date_added datetime default '0000-00-00 00:00:00' not null , box_heading varchar(64) not null , set_function varchar(255) default 'tep_cfg_select_option(array('left', 'right'),' , PRIMARY KEY (configuration_id) )

[TEP STOP]

 

As far as I can guess - I think it may have to do with the "InfoBox Admin"??

 

I installed the 28/06/06 InfoBox Admin v.2.24 + Danish

and then right after this SQL from

31/07/06 New InfoBox Items, German translation

 

.....all this info about left / right talk is from the 31/07/06 SQL file

 

everything works fine when I install the SQL, but as soon as I backup - nope??

 

What do I do?

 

Please

Helle :(

[wheeloftime]

For the 5' time I try to backup the database - and then try to restore it - and EVERY TIME I get this error???

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'left', 'right'),' , PRIMARY KEY (configuration_id) )' at line

create table theme_configuration ( configuration_id int(11) not null auto_increment, configuration_title varchar(64) not null , configuration_key varchar(64) default 'BOX_HEADING_' not null , configuration_value varchar(255) not null , configuration_description varchar(255) not null , configuration_group_id int(11) default '1' not null , configuration_column varchar(64) default 'left' not null , location int(5) default '0' not null , sort_order int(5) , last_modified datetime , date_added datetime default '0000-00-00 00:00:00' not null , box_heading varchar(64) not null , set_function varchar(255) default 'tep_cfg_select_option(array('left', 'right'),' , PRIMARY KEY (configuration_id) )

[TEP STOP]

 

As far as I can guess - I think it may have to do with the "InfoBox Admin"??

 

I installed the 28/06/06 InfoBox Admin v.2.24 + Danish

and then right after this SQL from

31/07/06 New InfoBox Items, German translation

 

.....all this info about left / right talk is from the 31/07/06 SQL file

 

everything works fine when I install the SQL, but as soon as I backup - nope??

 

What do I do?

 

Please

Helle :(

With the above syntax there is the error on import. If you change the single quotes around left, right to double quotes it should work okay.

So for that table it should read:

create table theme_configuration ( configuration_id int(11) not null auto_increment, configuration_title varchar(64) not null , configuration_key varchar(64) default 'BOX_HEADING_' not null , configuration_value varchar(255) not null , configuration_description varchar(255) not null , configuration_group_id int(11) default '1' not null , configuration_column varchar(64) default 'left' not null , location int(5) default '0' not null , sort_order int(5) , last_modified datetime , date_added datetime default '0000-00-00 00:00:00' not null , box_heading varchar(64) not null , set_function varchar(255) default 'tep_cfg_select_option(array("left", "right"),' , PRIMARY KEY (configuration_id) )

[HelleM]

Thank you Howard for seeing that

 

Helle :-)

[ericcsc]

Hi

 

After I have installed the infobox admin and encountered the following error message. Can anyone advice me. I'm using the version InfoBox Admin v2.25 (http://www.oscommerce.com/community/contributions,1175/category,all/search,infoboxes).

 

I have checked the db, the table was correct, I have even recreated it.

 

.

1146 - Table 'oscommerce.TABLE_THEME_CONFIGURATION' doesn't exist

 

select configuration_column as cfgcol, configuration_title as cfgtitle, configuration_value as cfgvalue, configuration_key as cfgkey, box_heading from TABLE_THEME_CONFIGURATION order by location

 

[TEP STOP]

[jbphotos]

I'm getting the same error... as stated above.

 

Any help?

[♥geoffreywalton]

Have you followed the installation instructions re databasetables.php?