Comment changer le positionnement des produits phares ?

[karl20009]

des que je veut changer la position d'un produits phrare sa me mais sa:

1 erreur Failed to update the position.

merci de votre aide

Topic déplacé -yoya971

[Kircuys]

Salut,

J'ai le même problème que toi. As tu trouvé une solution ?

Bien cordialement

[cycleelcyc]

avez-vous des solutions? merci de poster ici.

[BrianR]

I hit this problem.

Using phpmyadmin look in ps_catgeory_product. For each category, there should be a set of id_product and position pairs, e.g. for id_category = 1, I had 6 entries with values of (id_product, position) of (10,0), (13,3), (14,4), (12,2), (11,1) and (15,4).

If the positions are not in strict monotonic sequence, e.g. 0,1,2,3,4,5... I think the updatePosition code cannot reorder the products and you get the error message.

I corrected it to read (10,0), (13,1), (14,5), (12,4), (11,3) and (15,2), and then I could reorder the products OK.

I assume the update code was interrupted at some time before it could complete an update operation. It should really detect the invalid position values and correct them as best it can [in this example by updating to (10,0), (13,3), (14,4), (12,2), (11,1) and (15,5)]. At least then the user could correct the order.

Hope this helps,
Brian

[Juanparati]

I have a fast patch for this bug:

Open the file classes/Product.php, find for this piece of code (about line 286):

       if (!$res = Db::getInstance()->ExecuteS('
       SELECT cp.`id_product`, cp.`position`, cp.`id_category` 
       FROM `'._DB_PREFIX_.'category_product` cp
       WHERE cp.`id_category` = '.intval(Tools::getValue('id_category')).' 
       ORDER BY cp.`position` '.(intval($way) ? 'ASC' : 'DESC')))

And reemplace for:

$valor = Tools::getValue('id_category');

     if ($valor==0)
      $valor = 1;

       if (!$res = Db::getInstance()->ExecuteS('
       SELECT cp.`id_product`, cp.`position`, cp.`id_category` 
       FROM `'._DB_PREFIX_.'category_product` cp
       WHERE cp.`id_category` = '.intval($valor).' 
       ORDER BY cp.`position` '.(intval($way) ? 'ASC' : 'DESC'))) 

The problems is that id_category is always 0 when is home and the select don't return rows because the home category is 1.

Backup your database before of testing this patch, for me work like a charm.

[Shaun]

I have a fast patch for this bug:

Open the file classes/Product.php, find for this piece of code (about line 286):

       if (!$res = Db::getInstance()->ExecuteS('
       SELECT cp.`id_product`, cp.`position`, cp.`id_category` 
       FROM `'._DB_PREFIX_.'category_product` cp
       WHERE cp.`id_category` = '.intval(Tools::getValue('id_category')).' 
       ORDER BY cp.`position` '.(intval($way) ? 'ASC' : 'DESC')))

And reemplace for:

$valor = Tools::getValue('id_category');

     if ($valor==0)
      $valor = 1;

       if (!$res = Db::getInstance()->ExecuteS('
       SELECT cp.`id_product`, cp.`position`, cp.`id_category` 
       FROM `'._DB_PREFIX_.'category_product` cp
       WHERE cp.`id_category` = '.intval($valor).' 
       ORDER BY cp.`position` '.(intval($way) ? 'ASC' : 'DESC'))) 

The problems is that id_category is always 0 when is home and the select don't return rows because the home category is 1.

Backup your database before of testing this patch, for me work like a charm.

[solved]
I'm going to be a little cheeky and mark this as solved because I tried the patch and it worked perfectly! Many thanks to Juanparati for the simple fix.

[cycleelcyc]

I have a fast patch for this bug:

Open the file classes/Product.php, find for this piece of code (about line 286):

       if (!$res = Db::getInstance()->ExecuteS('
       SELECT cp.`id_product`, cp.`position`, cp.`id_category` 
       FROM `'._DB_PREFIX_.'category_product` cp
       WHERE cp.`id_category` = '.intval(Tools::getValue('id_category')).' 
       ORDER BY cp.`position` '.(intval($way) ? 'ASC' : 'DESC')))

And reemplace for:

$valor = Tools::getValue('id_category');

     if ($valor==0)
      $valor = 1;

       if (!$res = Db::getInstance()->ExecuteS('
       SELECT cp.`id_product`, cp.`position`, cp.`id_category` 
       FROM `'._DB_PREFIX_.'category_product` cp
       WHERE cp.`id_category` = '.intval($valor).' 
       ORDER BY cp.`position` '.(intval($way) ? 'ASC' : 'DESC'))) 

The problems is that id_category is always 0 when is home and the select don't return rows because the home category is 1.

Backup your database before of testing this patch, for me work like a charm.

it works so good, tks!!!!

[fhcom]

hello

en français cela serait superbe merci pour nous

[GS VISION]

Works on 1.2.4,too

Thanks m8!

[harvey]

Works on 1.2.5 too.

Champagne for Juanparati !

thx fellow.

[ugur onur]

thanks.. this is good.....

[noesac]

I found this very useful, thanks a lot!

[Jarode]

Thank you

Pour ceux qui ne comprennent pas du tout l'anglais il faut faire une modification du fichier product.php qui se trouve dans le dossier classes
changer à partir de la ligne 286 ou si c'est comme moi c'est à partir de la ligne 293

if (!$res = Db::getInstance()->ExecuteS('
       SELECT cp.`id_product`, cp.`position`, cp.`id_category` 
       FROM `'._DB_PREFIX_.'category_product` cp
       WHERE cp.`id_category` = '.intval(Tools::getValue('id_category')).' 
       ORDER BY cp.`position` '.(intval($way) ? 'ASC' : 'DESC')))

par

$valor = Tools::getValue('id_category');

     if ($valor==0)
      $valor = 1;

       if (!$res = Db::getInstance()->ExecuteS('
       SELECT cp.`id_product`, cp.`position`, cp.`id_category` 
       FROM `'._DB_PREFIX_.'category_product` cp
       WHERE cp.`id_category` = '.intval($valor).' 
       ORDER BY cp.`position` '.(intval($way) ? 'ASC' : 'DESC'))) 

et cela fonctionne très bien.

[noesac]

Was this fixed in 1.3.1? I recently upgraded and I'm wondering whether I should reapply this fix.

[Patric]

This is of course a good thing to post a fix on the forum.
But a better thing would be to report the problem into our bug tracker.
Please could someone who meet this problem do it? Thanks.

[noesac]

This is of course a good thing to post a fix on the forum.
But a better thing would be to report the problem into our bug tracker.
Please could someone who meet this problem do it? Thanks.

So this hasn't been fixed? Should I log it?

[Patric]

I do not know. You can try to reproduce this bug on our SVN version (that you can install in local) and if it still happens, then post a bug report.
Thanks.