Таблица oc_order - это таблица, в которой хранятся все заказы. Она в движке есть всегда. Возможно, у вас префикс таблицы не oc_ или просто проблемы с базой.
запросом, который вы написали ее создавать не правильно. Если ее нет, советую переустановить базу
Эта таблица создается так:
CREATE TABLE IF NOT EXISTS `oc_order` (
`order_id` int(11) NOT NULL AUTO_INCREMENT,
`invoice_no` int(11) NOT NULL DEFAULT '0',
`invoice_prefix` varchar(26) NOT NULL,
`store_id` int(11) NOT NULL DEFAULT '0',
`store_name` varchar(64) NOT NULL,
`store_url` varchar(255) NOT NULL,
`customer_id` int(11) NOT NULL DEFAULT '0',
`customer_group_id` int(11) NOT NULL DEFAULT '0',
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(96) NOT NULL,
`telephone` varchar(32) NOT NULL,
`fax` varchar(32) NOT NULL,
`payment_firstname` varchar(32) NOT NULL,
`payment_lastname` varchar(32) NOT NULL,
`payment_company` varchar(32) NOT NULL,
`payment_company_id` varchar(32) NOT NULL,
`payment_tax_id` varchar(32) NOT NULL,
`payment_address_1` varchar(128) NOT NULL,
`payment_address_2` varchar(128) NOT NULL,
`payment_city` varchar(128) NOT NULL,
`payment_postcode` varchar(10) NOT NULL,
`payment_country` varchar(128) NOT NULL,
`payment_country_id` int(11) NOT NULL,
`payment_zone` varchar(128) NOT NULL,
`payment_zone_id` int(11) NOT NULL,
`payment_address_format` text NOT NULL,
`payment_method` varchar(128) NOT NULL,
`payment_code` varchar(128) NOT NULL,
`shipping_firstname` varchar(32) NOT NULL,
`shipping_lastname` varchar(32) NOT NULL,
`shipping_company` varchar(32) NOT NULL,
`shipping_address_1` varchar(128) NOT NULL,
`shipping_address_2` varchar(128) NOT NULL,
`shipping_city` varchar(128) NOT NULL,
`shipping_postcode` varchar(10) NOT NULL,
`shipping_country` varchar(128) NOT NULL,
`shipping_country_id` int(11) NOT NULL,
`shipping_zone` varchar(128) NOT NULL,
`shipping_zone_id` int(11) NOT NULL,
`shipping_address_format` text NOT NULL,
`shipping_method` varchar(128) NOT NULL,
`shipping_code` varchar(128) NOT NULL,
`comment` text NOT NULL,
`total` decimal(15,4) NOT NULL DEFAULT '0.0000',
`order_status_id` int(11) NOT NULL DEFAULT '0',
`affiliate_id` int(11) NOT NULL,
`commission` decimal(15,4) NOT NULL,
`language_id` int(11) NOT NULL,
`currency_id` int(11) NOT NULL,
`currency_code` varchar(3) NOT NULL,
`currency_value` decimal(15,8) NOT NULL DEFAULT '1.00000000',
`ip` varchar(40) NOT NULL,
`forwarded_ip` varchar(40) NOT NULL,
`user_agent` varchar(255) NOT NULL,
`accept_language` varchar(255) NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL,
PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;