my orders won't show up :(

[xperyens]

Hello everybody. Well, i've got another problem here. I don't use an on-line payment module. I use only Payment @ delivery. My web site was working ok. Then i've tried to optimize my files for search engine. I've added a contribution for meta tags. The site was running smooth. After that i've added a contrib ("Ultimate Seo Url") and the site was working fine but the orders didn't show up in my admin and in my "history orders". Then i've uninstalled the "Ultimate Seo Url" contrib, but still i've got the same problem, My orders won't show up. After a few days i've reached the next conclusion. The main problem for not displaying my orders was because my sql `orders_total` table it's not populated. The rest of my orders tables are working fine, are populated. Here i'm gonna show you my orders tables: (clean fields).

 

--

-- Dumping data for table `orders`

--

 

 

-- --------------------------------------------------------

 

--

-- Table structure for table `orders_products`

--

 

CREATE TABLE `orders_products` (

`orders_products_id` int(11) NOT NULL auto_increment,

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

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

`products_model` varchar(12) default NULL,

`products_name` varchar(64) NOT NULL default '',

`products_price` decimal(15,4) NOT NULL default '0.0000',

`final_price` decimal(15,4) NOT NULL default '0.0000',

`products_tax` decimal(7,4) NOT NULL default '0.0000',

`products_quantity` int(2) NOT NULL default '0',

PRIMARY KEY (`orders_products_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

--

-- Dumping data for table `orders_products`

--

 

 

 

-- --------------------------------------------------------

 

--

-- Table structure for table `orders_products_attributes`

--

 

CREATE TABLE `orders_products_attributes` (

`orders_products_attributes_id` int(11) NOT NULL auto_increment,

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

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

`products_options` varchar(32) NOT NULL default '',

`products_options_values` varchar(32) NOT NULL default '',

`options_values_price` decimal(15,4) NOT NULL default '0.0000',

`price_prefix` char(1) NOT NULL default '',

PRIMARY KEY (`orders_products_attributes_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

 

--

-- Dumping data for table `orders_products_attributes`

--

 

 

-- --------------------------------------------------------

 

--

-- Table structure for table `orders_products_download`

--

 

CREATE TABLE `orders_products_download` (

`orders_products_download_id` int(11) NOT NULL auto_increment,

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

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

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

`download_maxdays` int(2) NOT NULL default '0',

`download_count` int(2) NOT NULL default '0',

PRIMARY KEY (`orders_products_download_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

--

-- Dumping data for table `orders_products_download`

--

 

 

-- --------------------------------------------------------

 

--

-- Table structure for table `orders_status`

--

 

CREATE TABLE `orders_status` (

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

`language_id` int(11) NOT NULL default '1',

`orders_status_name` varchar(32) NOT NULL default '',

PRIMARY KEY (`orders_status_id`,`language_id`),

KEY `idx_orders_status_name` (`orders_status_name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

--

-- Dumping data for table `orders_status`

--

 

INSERT INTO `orders_status` VALUES (1, 1, 'Pending');

INSERT INTO `orders_status` VALUES (2, 1, 'Processing');

INSERT INTO `orders_status` VALUES (3, 1, 'Delivered');

 

-- --------------------------------------------------------

 

--

-- Table structure for table `orders_status_history`

--

 

CREATE TABLE `orders_status_history` (

`orders_status_history_id` int(11) NOT NULL auto_increment,

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

`orders_status_id` int(5) NOT NULL default '0',

`date_added` datetime NOT NULL default '0000-00-00 00:00:00',

`customer_notified` int(1) default '0',

`comments` text,

PRIMARY KEY (`orders_status_history_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

--

-- Dumping data for table `orders_status_history`

--

 

 

-- --------------------------------------------------------

 

--

-- Table structure for table `orders_total`

--

 

CREATE TABLE `orders_total` (

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

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

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

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

`value` decimal(15,4) NOT NULL default '0.0000',

`class` varchar(32) NOT NULL default '',

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

PRIMARY KEY (`orders_total_id`),

KEY `idx_orders_total_orders_id` (`orders_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

 

--

-- Dumping data for table `orders_total`

--

 

 

My on-line store is http://www.multiservice-canon.ro .

 

This is how my order fields look like. I'm guessing that my table looks just fine. Now i'm thinking i've got a problem with a file but i don't know witch one. Please i really need help with this one. I've already post messages in Chemo's Ultimate Seo Contrib Url's, but they don't know the problem and sent me here.

 

Thanks in advance, Cezar.