Jump to content

cbjarnson

Members
  • Posts

    86
  • Joined

  • Last visited

cbjarnson's Achievements

Newbie

Newbie (1/14)

1

Reputation

1

Community Answers

  1. Just want to post what worked for me. It actually ended up being having some meta descriptions and titles being too long. I went into the databse and deleted those and then I was able to save my products.
  2. I am getting this error on my store. Table 'sunstone_prestashop.ps_attribute_shop' doesn't exist SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 62 AND al.`id_lang` = 1 AND agl.`id_lang` = 1 GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. } DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 3505 - classes/Product.php] - [1 Arguments] ProductCore->getAttributesGroups - [line 422 - controllers/front/ProductController.php] - [1 Arguments] ProductControllerCore->assignAttributesGroups - [line 237 - controllers/front/ProductController.php] ProductControllerCore->initContent - [line 189 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Any ideas?
  3. PrestaShop version 1.6.0.14 Shop URL http://sunstoneformulas.com/ Current theme in use default-bootstrap We have been on prestashop since 1.4
  4. Using default theme. All of the pack products is only showing the first product below. https://sunstoneformulas.com/en/kits/244-zombie-buster-kit.html see above link for example.
  5. Has anyone found an answer to this? We need to have a tax exempt wholesale group.
  6. When I enable the contact information block it has weird formating. I cant figure out how to get rid of it. I have reset the module and that has not fixed it. Any ideas? site is http://sunstoneformulas.com
  7. It dissapears when I disable the block contact information block. However now the contact info is not on the footer of the store.
  8. They are in the footer for example in looking at source. <h4>Store Information</h4><ul class="toggle-footer"><li> <i class="icon-map-marker"></i>Pickup, 1243 Hillside Dr. Pleasant Grove, UT 84062</li><li> <i class="icon-phone"></i>Call us now: <span>1 888 838-4118</span></li><li> <i class="icon-envelope-alt"></i>Email: <span><a href="mailto:%73%75%70%70%6f%72%74@%73%75%6e%73%74%6f%6e%65%66%6f%72%6d%75%6c%61%73.%63%6f%6d" >[email protected]</a></span></li></ul></div>
  9. When using the mac program integrity to find broken links. I am getting long crazy urls on every product page. for example. http://sunstoneformulas.com/en/syrups/mailto:%73%75%70%70%6f%72%74@%73%75%6e%73%74%6f%6e%65%66%6f%72%6d%75%6c%61%73.%63%6f%6d Any ideas on what is causing this? site is sunstoneformulas.com
  10. Thanks prestashop fanatic! That is good info. I will leave friendly url enabled and change the links.
  11. After updating to 1.6 from 1.5 all of my links formatted like this href="/product.php?id_product=167 are not working anymore. Is there a way to fix this so I do not have to fix all of the internal links that are in product descriptions? Site is http://sunstoneformulas.com
  12. This appears to be an error related to presto-changeo's mailchimp module. When I disable it, this error goes away. I sent them a request for technical support.
  13. This just recently popped up. I have no idea what caused it. When a new customer comes to the site and creates a new account when it goes to the authentication section it just goes to a blank screen and nothing happens. It appears that new users are still getting their welcome email. But it is a little confusing to just have a blank screen after filling in information. They have to leave and come back to the site to log in. the site is http://sunstoneformulas.com any help is appreciated. I am on 1.5.6
  14. I got the github paypal module to work on my sites. I tried the paypausa on github and that did not work. Make sure to just use the paypal module.
×
×
  • Create New...