Manage Variant Not working

  • Posts: 567
  • Thank you received: 11
  • Hikashop Business
13 years 4 months ago #21468

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 ^_^

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
13 years 4 months ago #21478

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.

Please Log in or Create an account to join the conversation.

  • Posts: 567
  • Thank you received: 11
  • Hikashop Business
13 years 4 months ago #21524

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

Please Log in or Create an account to join the conversation.

  • Posts: 567
  • Thank you received: 11
  • Hikashop Business
13 years 4 months ago #21525

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


File Attachment:

File Name: when_click...stic.txt
File Size:4 KB


File Attachment:

File Name: When_click...iant.txt
File Size:9 KB

Attachments:
Last edit: 13 years 4 months ago by ler@singmuiheng.com.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
13 years 4 months ago #21536

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.

Please Log in or Create an account to join the conversation.

  • Posts: 567
  • Thank you received: 11
  • Hikashop Business
13 years 4 months ago #21626

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

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
13 years 4 months ago #21661

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.067 seconds
Powered by Kunena Forum