rma contribution

[crash3903]

Guys

 

I have found that there are some posts saying about this error but i have not ben able to find an answer

 

I have this error

 

1146 - Table 'db86081255.gv_tracking' doesn't exist

 

insert into gv_tracking (gv_number, date_created, customer_id_sent, sent_firstname, sent_surname, emailed_to, gv_amount) values ('0aa7dbef73732a8e', NOW(),'0','Sent by','Admin','[email protected],'26.0312')

 

what is the sql to create the table pls

 

thank for your help

 

regards

 

mark

[crash3903]

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

 

#

# 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