Search found 13307 matches

Search found 13307 matches

Re: JSON Error window pop-up upon API

Latest version; 2.0.3.1 .

Jump to post
  • Fri Sep 25, 2015 8:05 pm
  • Replies 2
  • Views 1116
JSON Error window pop-up upon API

I believe I may have found the cause on why the well known JSON error window pop-up issue. I am not sure if this fix has been posted before but one solution I would have would be to go In catalog/controller/api/login.php file, find: $this->load->model('account/api'); $api_info = $this->model_account...

Jump to post
  • Fri Sep 25, 2015 8:58 am
  • Replies 2
  • Views 1116
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

Assurez-vous que le filtre à partir du controlleur, ou sois à partir de votre fichier XML VQMod, n'utilise pas le p.artist_id dans le paramètre envers de faire appel à la méthode de getProduct. Autrement, si vous n'avez pas placé cette requête autrepart, je ne peux voir comment cette erreur peut rev...

Jump to post
  • Fri Sep 25, 2015 8:12 am
  • Replies 29
  • Views 10174
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

Dans la table artist, ajoutez le champ product_id ainsi que dans la table label. Assurez-vous de lier les produits correspondants envers ces deux tables. Ensuite, supprimez les deux champs artist_id et label_id dans la table des produits et essayez plutôt cette requête: $query = $this->db->query("SE...

Jump to post
  • Fri Sep 25, 2015 6:15 am
  • Replies 29
  • Views 10174
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

Le champ artist_id existe bien dans la table product? Si non, il faudrait que vous l'ajoutiez à partir de PHPMyAdmin. Cepdendant, de considérer l'idée concernant les tables additionnels pour relier les produits avec table d'artiste et la table des étiquettes seraient également une bonne idée si le m...

Jump to post
  • Fri Sep 25, 2015 3:54 am
  • Replies 29
  • Views 10174
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

AND p.artist_id = '1' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15 AND p.artist_id = '1' p.artist_id est localisé deux fois dans la requête. Vous devez enlever la 2e partie du: AND p.artist_id = '1' et de seulement laisser la première dans la ligne dans le cas prés...

Jump to post
  • Fri Sep 25, 2015 1:07 am
  • Replies 29
  • Views 10174
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

Je ne vois toujours pas p.label = 1 dans la requête modifiée.

Jump to post
  • Thu Sep 24, 2015 11:03 am
  • Replies 29
  • Views 10174
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

Ne sachant aucunement la façon dont vous l'aviez inséré, il faudra que vous postiez la requête entière afin de repérer l'erreur.

Jump to post
  • Thu Sep 24, 2015 10:45 am
  • Replies 29
  • Views 10174
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

'AND p.label_id = '1'' at line 1
D'après ma requête précédente, je n'ai pas fait mention de cette ligne.

Jump to post
  • Thu Sep 24, 2015 10:29 am
  • Replies 29
  • Views 10174
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

1 possibilité; sois que vous avez laissé votre ancienne requête là où elle était et vous n'aviez pas réversé le changement. Par contre, j'ai fait les ajustements à mon code. Je vous recommande par contre de complètement réverser le code avec l'original. Ensuite, d'essayer mon intégration.

Jump to post
  • Thu Sep 24, 2015 9:06 am
  • Replies 29
  • Views 10174
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

Maintenant que la demande est un peu plus éclairci, remplacez: WHERE p.product_id = '" . (int)$product_id . "' par: LEFT JOIN `" . DB_PREFIX . "artist` `a1` ON (`a1`.`artist_id` = `p`.`artist_id`) LEFT JOIN `" . DB_PREFIX . "artist_to_store` `a2s` ON (`a2s`.`store_id` = `p2s`.`store_id`) LEFT JOIN `...

Jump to post
  • Thu Sep 24, 2015 8:28 am
  • Replies 29
  • Views 10174
Re: SHowing price start product page if has options

Most pages are the same: Manufacturer(info), Search, Special. Same as Category. For the Product page things are a bit more complicated, since you have to do also the "related" products at the bottom. In the Product controller you need this: $this->data['has_option_price_increase'] = $this->model_ca...

Jump to post
  • Wed Sep 23, 2015 10:12 pm
  • Replies 11
  • Views 1123
Re: SHowing price start product page if has options

Then rather the addition of a new key in the $products array from the controller, you need to define a new $data with your array key and use it into the template as a stand alone variable outside the foreach loop.

Jump to post
  • Wed Sep 23, 2015 10:12 pm
  • Replies 11
  • Views 1123
Re: Adding LEFT JOIN in catalog/model/catalog/product.php

Since the artist_id and the label_id don't have the same significance as the original product_id, I would first assign a new product_id field on the artist and label table and assign each reliable products from either PHPMyAdmin or from a module before joining the tables so that at least one value w...

Jump to post
  • Wed Sep 23, 2015 9:33 pm
  • Replies 29
  • Views 10174
Re: SHowing price start product page if has options

You need to ensure to add the $product variable with your array key within the range where the foreach $products is being used. Otherwise, if outside the loop range, the affected variable will not be recognized by the browser.

Jump to post
  • Wed Sep 23, 2015 9:28 pm
  • Replies 11
  • Views 1123
Re: Fatal Error on admin login

The closest match that I can see, so far, and without the need to recall the API for each currencies that has the same functionality as Yahoo Finance but unfortunately not free would be with PayPal Adaptive Payments by using the ConvertCurrency method. The only downside with this method, regarding g...

Jump to post
  • Wed Sep 23, 2015 9:14 pm
  • Replies 4
  • Views 437
Re: SHowing price start product page if has options

One quick way to edit your text in front of the price would be by editing your catalog/view/theme/<your_theme>/template/product/product.tpl file where the $price line begins and within the specials block.

Jump to post
  • Wed Sep 23, 2015 8:36 pm
  • Replies 11
  • Views 1123
Re: About product view report Percent

One example would be to follow the admin/controller/dashboard/order.php file to differentiate the today's and yesterday's calculation based on the orders total count: // Total Orders $this->load->model('sale/order'); $today = $this->model_sale_order->getTotalOrders(array('filter_date_added' => date(...

Jump to post
  • Wed Sep 23, 2015 8:32 pm
  • Replies 1
  • Views 121
Re: Problem with editing orders or manually adding history t

Is there a simple way to view the currently enabled VQmods that are running on our store? That way I can list them to see if one of them may be the culprit.
Yes, it is called the: VQMod Manager extension.

Jump to post
  • Wed Sep 23, 2015 2:55 am
  • Replies 9
  • Views 952

Search found 13307 matches