[SOLVED] Absolutely Serious Database Issues

[MalaSilver]

When I placed an order, no data is being written to ps_order_detail table. In effect, I am unable to see any indepth details of any order.

Feel free to visit the website and try placing an order. I have added cash on delivery as a payment method for testing the orders.

I have also tried running the sql query suggested in another post, but it seemed of no logic as I already have a table which the SQL query suggests creating.

Please check the attached screenshots.

Please visit http://www.malasilver.co.uk to give it a try for yourself.

Need help as website adverts are starting soon.

[MalaSilver]

Dropped the original table and executed the following SQL query. Seems to be working smoothly now..

CREATE TABLE IF NOT EXISTS `ps_order_detail` (
`id_order_detail` int(10) unsigned NOT NULL auto_increment,
`id_order` int(10) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL,
`product_attribute_id` int(10) unsigned default NULL,
`product_name` varchar(255) NOT NULL,
`product_quantity` int(10) unsigned NOT NULL default '0',
`product_quantity_in_stock` int(10) unsigned NOT NULL default '0',
`product_quantity_refunded` int(10) unsigned NOT NULL default '0',
`product_quantity_return` int(10) unsigned NOT NULL default '0',
`product_quantity_reinjected` int(10) unsigned NOT NULL default '0',
`product_price` decimal(20,6) NOT NULL default '0.000000',
`reduction_percent` decimal(10,2) NOT NULL default '0.00',
`reduction_amount` decimal(20,6) NOT NULL default '0.000000',
`group_reduction` decimal(10,2) NOT NULL default '0.00',
`product_quantity_discount` decimal(20,6) NOT NULL default '0.000000',
`product_ean13` varchar(13) default NULL,
`product_reference` varchar(32) default NULL,
`product_supplier_reference` varchar(32) default NULL,
`product_weight` float NOT NULL,
`tax_name` varchar(16) NOT NULL,
`tax_rate` decimal(10,3) NOT NULL default '0.000',
`ecotax` decimal(21,6) NOT NULL default '0.000000',
`ecotax_tax_rate` decimal(5,3) NOT NULL,
`discount_quantity_applied` tinyint(1) NOT NULL default '0',
`download_hash` varchar(255) default NULL,
`download_nb` int(10) unsigned default '0',
`download_deadline` datetime default '0000-00-00 00:00:00',
PRIMARY KEY (`id_order_detail`),
KEY `order_detail_order` (`id_order`),
KEY `product_id` (`product_id`),
KEY `product_attribute_id` (`product_attribute_id`),
KEY `id_order_id_order_detail` (`id_order`,`id_order_detail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1

[joshrhinbenj]

Dropped the original table and executed the following SQL query. Seems to be working smoothly now..

CREATE TABLE IF NOT EXISTS `ps_order_detail` (
`id_order_detail` int(10) unsigned NOT NULL auto_increment,
`id_order` int(10) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL,
`product_attribute_id` int(10) unsigned default NULL,
`product_name` varchar(255) NOT NULL,
`product_quantity` int(10) unsigned NOT NULL default '0',
`product_quantity_in_stock` int(10) unsigned NOT NULL default '0',
`product_quantity_refunded` int(10) unsigned NOT NULL default '0',
`product_quantity_return` int(10) unsigned NOT NULL default '0',
`product_quantity_reinjected` int(10) unsigned NOT NULL default '0',
`product_price` decimal(20,6) NOT NULL default '0.000000',
`reduction_percent` decimal(10,2) NOT NULL default '0.00',
`reduction_amount` decimal(20,6) NOT NULL default '0.000000',
`group_reduction` decimal(10,2) NOT NULL default '0.00',
`product_quantity_discount` decimal(20,6) NOT NULL default '0.000000',
`product_ean13` varchar(13) default NULL,
`product_reference` varchar(32) default NULL,
`product_supplier_reference` varchar(32) default NULL,
`product_weight` float NOT NULL,
`tax_name` varchar(16) NOT NULL,
`tax_rate` decimal(10,3) NOT NULL default '0.000',
`ecotax` decimal(21,6) NOT NULL default '0.000000',
`ecotax_tax_rate` decimal(5,3) NOT NULL,
`discount_quantity_applied` tinyint(1) NOT NULL default '0',
`download_hash` varchar(255) default NULL,
`download_nb` int(10) unsigned default '0',
`download_deadline` datetime default '0000-00-00 00:00:00',
PRIMARY KEY (`id_order_detail`),
KEY `order_detail_order` (`id_order`),
KEY `product_id` (`product_id`),
KEY `product_attribute_id` (`product_attribute_id`),
KEY `id_order_id_order_detail` (`id_order`,`id_order_detail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1

Hi, How do you do this?