gv_tracking missiing?

[crash3903]

ok I have had a play with mysql through phpmyadmin and i have come up with this table

 

 

QUOTE

#

# Table structure for table `gv_tracking`

#

 

DROP TABLE IF EXISTS `gv_tracking`;

CREATE TABLE `gv_tracking` (

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

`gv_number` int(11) NOT NULL default '0',

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

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

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

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

`emailed_to` varchar(255) NOT NULL default '0',

`gv_amount` varchar(255) NOT NULL default '00.00',

PRIMARY KEY (`gv_tracking_id`)

) TYPE=MyISAM AUTO_INCREMENT=2 ;

 

#

# Dumping data for table `gv_tracking`

#

 

 

 

It seems to work ok however when i get an email saying there is a gift voucher for the return i get a page saying that it has already been redeemed

 

any ideas - i am nearly there i guess!

 

thanks

 

mark