Manage Variant Not working

Hi Nicolas

There was another problem i encounter

not sure if is my upload not complete or it is existing bug as i saw in previous posting of other user they seem did not have this problem

the problem as follow:

After adding characteristic to my products
fabrics-55cm and fabrics-36inches


when i click apply button in the product editor page, the 'successfully saved' desplayed but the page end up in blank
after i enter this product again, there are only 1 characteristic added

and , another problem, more serious
after adding the two option characteristic, clicked on the "manage variant"(as i want to set different price for it)
"Successfully Saved
Before configuring the variant of your product, you need first to create one or several characteristics with the menu Products->Characteristics, and then add one or several characteristics to your product"

this message occurs and i have no way to edit the price for variants except direct edit in SQL

Wonder if it is my file problem or existing bug and how to solve this problem

Will be greatly appreciate your help

Hi,
It sounds like it is not able to generate the variants automatically. Could you try to activate the debug mode of joomla in the configuration of joomla and try again ? You might see error messages this time which will help us understand the problem.

Hi Nicolas

After activate debug mode, found error on frontend product page but no error at back end

front end error as below

500 - JDatabaseMySQL::query: 1054 - Unknown column 'product_last_seen_date' in 'field list' SQL=UPDATE `jos_hikashop_product` SET `product_hit`='1',`product_last_seen_date`='1311038088' WHERE product_id='279'
•You may not be able to visit this page because of:•

•an out-of-date bookmark/favourite•
•a search engine that has an out-of-date listing for this site•
•a mistyped address•
•you have no access to this page•
•The requested resource was not found.•
•An error has occurred while processing your request.•
•Please try one of the following pages:•


•Home Page•

•If difficulties persist, please contact the System Administrator of this site.•

JDatabaseMySQL::query: 1054 - Unknown column 'product_last_seen_date' in 'field list' SQL=UPDATE `jos_hikashop_product` SET `product_hit`='1',`product_last_seen_date`='1311038088' WHERE product_id='279'

Call stack
# Function Location
1 JSite->dispatch() d:\singmuiheng\index.php:68
2 JComponentHelper->renderComponent() d:\singmuiheng\includes\application.php:124
3 require_once() d:\singmuiheng\libraries\joomla\application\component\helper.php:162
4 JController->execute() d:\singmuiheng\components\com_hikashop\hikashop.php:53
5 hikashopController->show() d:\singmuiheng\libraries\joomla\application\component\controller.php:236
6 hikashopController->display() d:\singmuiheng\administrator\components\com_hikashop\helpers\helper.php:797
7 JController->display() d:\singmuiheng\administrator\components\com_hikashop\helpers\helper.php:957
8 ProductViewProduct->display() d:\singmuiheng\libraries\joomla\application\component\controller.php:310
9 ProductViewProduct->show() d:\singmuiheng\components\com_hikashop\views\product\view.html.php:34
10 hikashopProductClass->save() d:\singmuiheng\components\com_hikashop\views\product\view.html.php:496
11 hikashopClass->save() d:\singmuiheng\administrator\components\com_hikashop\classes\product.php:344
12 JDatabaseMySQL->updateObject() d:\singmuiheng\administrator\components\com_hikashop\helpers\helper.php:996
13 JDatabaseMySQL->query() d:\singmuiheng\libraries\joomla\database\database\mysql.php:577
14 JError->raiseError() d:\singmuiheng\libraries\joomla\database\database\mysql.php:229
15 JError->raise() d:\singmuiheng\libraries\joomla\error\error.php:173
16 JException->__construct() d:\singmuiheng\libraries\joomla\error\error.php:138

back end click add characteristic in product editor as attached:
back end click manage variant in product editor as attached:

Thank you.

That means that the database structure could be updated properly last time you updated HikaShop.
You need to go in the database administration tool provided by your hosting company ( it's likely to be PHPMyAdmin ) and run the query :
ALTER TABLE `jos_hikashop_product` ADD `product_last_seen_date` INT UNSIGNED DEFAULT 0
That will solve the query error on the front end.

For the characteristics issue, could you make sure that you don't have any variant in the "manage variants" area of your product, then, delete the two characteristics, save your product, and add them again ? Then, the system should automatically recreate the variants properly.

Do as what you suggest, but still the same problem after adding new characteristic and variant

Could you do a screenshot of the edition screen of each of your characteristics ?