Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order Status Emails - Backup database


dccshj

Recommended Posts

Hi,

 

I've added the contribution "order status emails "

http://www.oscommerce.com/community/contributions,4518

 

And works like a dream and i can really see so much potential for it, however since installing i can no longer backup the database through "database backup" in the admin panel.

 

I get the 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 'from,subject,message,mail_type from orders_status_emails' at line 1

 

select id,orders_status_id,days_after,from,subject,message,mail_type from orders_status_emails

 

[TEP STOP]

 

Ive created the table as described in the install text ...

--run sql query

 

CREATE TABLE `orders_status_emails` (

`id` int(10) unsigned NOT NULL auto_increment,

`orders_status_id` int(10) unsigned NOT NULL default '0',

`days_after` int(10) unsigned NOT NULL default '0',

`from` varchar(128) NOT NULL default '',

`subject` varchar(255) NOT NULL default '',

`message` text NOT NULL,

`mail_type` char(1) NOT NULL default 'H',

PRIMARY KEY (`id`)

) TYPE=MyISAM;

 

Anyone else experiencing the same problem or is it time for a power nap as i've missing something so obvious!

 

Cheers

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...