Ordered Products not showing in Order Information

I am running through my testing of my site. I can select items and add to the cart. I can also checkout and make payment and confirm the payment process works, but I get the following issues.

1. Order Creation Email looks fine and gets sent to customer. Ordered Products are displayed.
2. Order Status Change emails get sent, but there is no Product information displayed, like unit, description or unit price.
3. Order Confirmation email is sent to customer and again no Unit Price, Unit Description or Quantity displayed, nor Tax information even though it is setup.

On the Back-end, when I review orders:

1. No products under the Product List nor in the Invoice or Shipping Invoice.

On the Front-end, when a customer reviews orders there is not Product information under the Product list.

The only time the product information is displayed is during the Shopping Cart, Checkout and Order Creation Email.

What settings should I check?

Nicolas,

No good, I have even updated to version 2.0. Looking at the insert statement and the table, I think there is a missing "," for the first field that is Auto Incremented.

can you please check the SQL statement generated.

Thanks,
Richard

Could it be my version of MySQL, current running 5.0.96, latest the ISP provider is supplying.

Mine looks identical.

CREATE TABLE IF NOT EXISTS `j25_hikashop_order_product` (
`order_product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(10) unsigned NOT NULL DEFAULT '0',
`product_id` int(10) unsigned NOT NULL DEFAULT '0',
`order_product_quantity` int(10) unsigned NOT NULL DEFAULT '1',
`order_product_name` varchar(255) NOT NULL DEFAULT '',
`order_product_code` varchar(255) NOT NULL DEFAULT '',
`order_product_price` decimal(17,5) NOT NULL DEFAULT '0.00000',
`order_product_tax` decimal(17,5) NOT NULL DEFAULT '0.00000',
`order_product_options` text NOT NULL,
`order_product_option_parent_id` int(10) unsigned DEFAULT '0',
`order_product_tax_info` text NOT NULL,
`order_product_wishlist_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`order_product_id`),
KEY `order_id` (`order_id`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;

Could if be the version of MySQL? What version are you running?

Is there away to capture the SQL statement generated in your version to compare against the one throwing and error in mine. My hosting company is not able to upgrade the MySQL version as it is a shared system. But if I can modify the code to the correct the SQL statement.

Regards,
Richard

Below is the SQL generated, I don't see an issue accept for the table name. I would have thought it would have resolved this to the correct name.

string(888) "INSERT IGNORE INTO #__hikashop_order_product (order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id,order_product_tax_info,order_product_wishlist_id,lining,insert) VALUES (3,1676,1,'d2i DVD Storage Box Divider Set','d2i_DVD_Storage_Box_Divider_Set','15.2915','1.52915','',47,'a:1:{i:0;O:8:\"stdClass\":11:{s:11:\"taxation_id\";s:1:\"2\";s:12:\"zone_namekey\";s:20:\"country_Australia_13\";s:16:\"category_namekey\";s:11:\"default_tax\";s:11:\"tax_namekey\";s:3:\"GST\";s:18:\"taxation_published\";s:1:\"1\";s:13:\"taxation_type\";s:0:\"\";s:15:\"taxation_access\";s:3:\"all\";s:19:\"taxation_cumulative\";s:1:\"0\";s:8:\"tax_rate\";s:7:\"0.10000\";s:9:\"zone_type\";s:7:\"country\";s:10:\"tax_amount\";d:1.529150000000000009237055564881302416324615478515625;}}',0,'','')"

Nicolas,

Was close but not the issue. If I create a custom field and select the table to be 'Item' from the pull-down list and add to a product category, then the query fails no matter the name. I have checked in phpMyAdmin and there is no j25_hikashop_item table. There are the other tables:

Address
User
Product
Order
Category
Entry

I then checked the tables.sql from the HikaShop_Business_2.0.0 release and all tables are defined but Item. I believe here is the bug.

Can you confirm if there is supposed to be a Item table.

Regards,
Richard

Hi,

You have deleted the custom field with the name "insert" and it still doesn't work ?
It's normal to not have a table "item", it's just to add the information of which database to insert the custom field. In that case the table "#__hikashop_order_product"

Thank you for that bit of information. With that I was able to determine what the columns needed to be so manually created them in the order_product table and all works now.

Richard