Rich Walker

No. I dumped prestashop and moved woocommerce

The upgrade seemed to go smoothy but i now get Bad SQL query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'invoice_date`, invoice_number` AS `invoice_number`, einote` AS `einote` , ' at line 2 when i try access the orders in the admin SELECT SQL_CALC_FOUND_ROWS a.`id_order`, `reference`, `total_paid_tax_incl`, `payment`, a.`date_add` AS `date_add`, invoice_date` AS `invoice_date`, invoice_number` AS `invoice_number`, einote` AS `einote` , a.id_currency, a.id_order AS id_pdf, CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `customer`, osl.`name` AS `osname`, os.`color`, IF((SELECT so.id_order FROM `ps_orders` so WHERE so.id_customer = a.id_customer AND so.id_order < a.id_order LIMIT 1) > 0, 0, 1) as new, country_lang.name as cname, IF(a.valid, 1, 0) badge_success, current_state, id_order as id_order2 FROM `ps_orders` a LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`) LEFT JOIN `ps_address` address ON address.id_address = a.id_address_delivery LEFT JOIN `ps_country` country ON address.id_country = country.id_country LEFT JOIN `ps_country_lang` country_lang ON (country.`id_country` = country_lang.`id_country` AND country_lang.`id_lang` = 1) LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`) LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) WHERE 1 ORDER BY a.`id_order` DESC LIMIT 0, 50 at line 791 in file classes/db/Db.php 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. } Is this a bug or a problem with my mysql database?

Hi bellini13 I have the same problem. If i run ALTER TABLE `ps_specific_price` ADD UNIQUE( `id_specific_price_rule`, `id_product`, `id_shop`, `id_shop_group`, `id_currency`, `id_country`, `id_group`, `id_customer`, `id_product_attribute`, `from_quantity`, `from`, `to`); I get MySQL said: #1062 - Duplicate entry '0-492-0-0-0-0-0-6198-298-1-0000-00-00 00:00:00-0000-00-00 00:00:' for key 'id_specific_price_rule_2' Any help would be appreciated. Thanks

We have upgraded to 1.6.1.0 & have hit a problem with Specific pricing not displaying not showing. Here is the error message from debug. I'm hoping someone can help. Key 'id_product_2' doesn't exist in table 'ps_specific_price' SELECT *, ( IF (`id_group` = 2, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 6651, 32, 0)) AS `score` FROM `ps_specific_price` USE INDEX (id_product_2) WHERE `id_product` IN (0, 623) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 2) AND `id_customer` IN (0, 6651) AND ( (`from` = '0000-00-00 00:00:00' OR '2015-07-23 17:25:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2015-07-23 17:25:00' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 at line 765 in file classes/db/Db.php 760. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 761. } 762. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 763. { 764. if ($sql) 765. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 766. 767. throw new PrestaShopDatabaseException($this->getMsgError()); 768. } 769. } 770.

We have upgrade our prestashop from 1.4.x to 1.6.0.8. Everything has gone well but for 1 thing. If we have an attribute for a product then the price shows for 1 second and then goes to 0.00. I have attached a screenshot. Solve the problem. Just changed {$group_reduction} and replace it with {1-$group_reduction} inside my product.tpl file.

I have created links to /prices-drop & /new-products but i don't seem to be able to get sfHover to show in the <li> when you visit that page. I have found the block of code i need to change ( line 585). I sure i need to add some thing like $selected = ($this->page_name == 'cms' && (Tools::getValue('id_linksmenutop') == $id)) ? ' class="sfHover"' : ''; But this will only work for the index page. Any ideas?

Hi Alexander Thank you so much for your help. That works great. Thank you

Hi Alexander, That didn't work. Thanks anyway.

I'm trying to add fancybox to the product description. The code below makes the fancybox popup but for the life of me i can't work out why it won't show the text. <a href="#inline1?content_only=1&TB_iframe=true&width=700&height=470&thickbox=true" class="iframe">INGREDIENTS | ORIGIN</a> <script type="text/javascript">/* <![CDATA[ */$('a.iframe').fancybox();/* ]]> */</script> <div id="#inline1" style="width:400px;display: none;"> {$product->description_short} </div> Any one got any ideas?

Solve the problem. If i remove require_once _PS_CLASS_DIR_ . 'AdminTab.php'; from the 2nd line. The menu loads fine & saves any changes. Thanks

Hi tomerg3 There isn't anything is the override/classes folder. Any other ideas?

Can i have a copy of your jbx_menu? We are running 1.5.3.1 & the only thing we see is Fatal error: Cannot redeclare class AdminTabCore in /var/www/vhosts/domain.co.uk/httpdocs/classes/AdminTab.php on line 31

The error that i'm getting is Fatal error: Cannot redeclare class AdminTabCore in /var/www/vhosts/domain.co.uk/httpdocs/classes/AdminTab.php on line 31 Thanks

Hi folks I ma really stuck. I have updated our prestshop from 1.4 to 1.5.3 & the jbx menu works on the front of the shop. However when i click configure on the backend it just goes to a white screen. I am running the latest verison of jbx_menu 2.8.6. I have checked the error logs on the server and get lots of errors like this below. [Fri Apr 19 14:19:21 2013] [error] [client 1.1.1.1] PHP Notice: Undefined index: logged in /var/www/vhosts/domain.co.uk/httpdocs/cache/smarty/compile/667a50f481fabc67ac3cf823d58270a456ed1880.file.menu_tree.tpl.php on line 32, referer: https://www.domain.co.uk/ Any idea?

We have upgrade from prestashop 1.4.8 to 1.5.3.1 & the layered navigation displays in the admin but doesn't on the from end. I have checked the module positions and it there. Any ideas?