ALMAJ

sorry, my last post has a typo, it is "tekcente_tek.ps_configuration" not 'tps_configuration' still there is no reference to 'tekcente_tek.ps_configuration' on my database and inside config folder... regards

thanks for the reply I've checked with phpmyadmin and the table tps_configuration dos not exist on my database and yes 'tekcente_tek' is ok there is n tekcente_tek.ps_configuration o 'r' I think the best way to do is exporting all the database data to a new prestashop 1.6 installation? Regards

Hello everyone. I've a problem with my prestashop webstore! After upgrading my prestashop webstore (www.tekcenter.pt/store) from 1.5.6 to 1.6.1.4 with the 1-click upgrade module I got a blank page on my front office, I then rollback to the previous version with the same tool 1-click upgrade module but now I get this error message on my front office and back office, that it seems to be related to a missing table on the database: Fatal error: Uncaught Table 'tekcente_tek.ps_configuration' doesn't exist<br /><br /><pre>SELECT c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.id_configuration = cl.id_configuration)</pre> thrown in /home1/tekcente/public_html/store/classes/db/Db.php on line 613 I need to upgrade my webstore to prestashop 1.6.1.4 Can someone please help me out? Best regards

Hi How to remove the product Condition only for Virtual Products for Prestashop 1.5.6.2? Does not make any sense to have product conditions on Virtual Products... I have found this fix repo but it is only for Prestashop 1.6.x my prestashop version is 1.5.6.2 PS; sorry for hijack this thread. Regards

Hello forum, In product comparison I don't have an option to share my comparisons with my friends trough Facebook, google+ or twitter, and the page "Product Comparison" itself doesn't have an unique url link to be able to share... it only have the same url link: "http://www.tekcenter.pt/store/pt/index.php?controller=products-comparison%20COMPARISON" How can I fix this issue? Prestashop version: 1.5.6.2 (custom theme: REVIVER) Store URL: www.tekcenter.pt/store Please if anyone have some solution, please share, I will do my best by searching for a solution Best regards to all

This worked well for ordering product feature! but how to order The product Feature Values as set in the Back Office / Product page? thanks again

Ok, so i have discovered the source of the problem... it turns out that the problem was some special characters (/) and (') in the product features, that is not acceptable by default in the SQL database syntax now the question is: how to have special characters in the product features and to be acceptable in the SQL database syntax? if anyone knows a solution please let me know Best regards - Alcino Major

Hi, I'm getting an error when I try to compare products on my prestashop 1.5.6.x store Error: [PrestaShopDatabaseException] 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 '(12.95cm) (/) na diagonal' AND id_lang='2' LIMIT 1' at line 1 SELECT * FROM ps_feature_value_lang WHERE value='5.1' (12.95cm) (/) na diagonal' AND id_lang='2' LIMIT 1 at line 613 in file classes/db/Db.php 607. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 608. } 609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 610. { 611. if ($sql) 612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 613. throw new PrestaShopDatabaseException($this->getMsgError()); 614. } 615. } 616. 617. /** DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 526 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 103 - override/controllers/front/CompareController.php] - [1 Arguments] CompareController->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument] ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument] -------------------------------------------------------------------------------------------------------------------------------- URL: www.tekcenter.pt/store Prestashop version: 1.5.6.2 (with custom theme: REVIVER) can someone please help me out? thanks in advance

just find this code: })(jQuery); jQuery(function(){ jQuery('ul.sf-menu').superfish(); }); and replace by this code: })(jQuery); jQuery(function(){ jQuery('ul.sf-menu').superfish(); var sticky = $('.sf-menu').offset().top; $(window).scroll(function(){ if ($(window).width() > 1182){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'1170px'}); } else { $('.sf-menu').css({position: 'relative'}); } } if ($(window).width() > 974 && $(window).width() < 1183 ){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'940px'}); } else { $('.sf-menu').css({position: 'relative'}); } } if ($(window).width() > 750 && $(window).width() < 975){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'720px'}); } else { $('.sf-menu').css({position: 'relative'}); } } }); to reset the global.css to the original values you should have made a backup of the original file Always make a backup first! Regards

"fixed" means that it stays fixed to the screen page when you scroll the page the "fixed" content stays always on the screen. you must change the file: "/modules/blocktopmenu/js/superfish-modified.js" and paste this code: var sticky = $('.sf-menu').offset().top; $(window).scroll(function(){ if ($(window).width() > 1182){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'1170px'}); } else { $('.sf-menu').css({position: 'relative'}); } } if ($(window).width() > 974 && $(window).width() < 1183 ){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'940px'}); } else { $('.sf-menu').css({position: 'relative'}); } } if ($(window).width() > 750 && $(window).width() < 975){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'720px'}); } else { $('.sf-menu').css({position: 'relative'}); } } });

It seems the position of the header is fixed, try to change it to "relative" did you have tried sooroos solution? try this: var sticky = $('.sf-menu').offset().top; $(window).scroll(function(){ if ($(window).width() > 1182){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'1170px'}); } else { $('.sf-menu').css({position: 'relative'}); } } if ($(window).width() > 974 && $(window).width() < 1183 ){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'940px'}); } else { $('.sf-menu').css({position: 'relative'}); } } if ($(window).width() > 750 && $(window).width() < 975){ if( $(window).scrollTop() > sticky ) { $('.sf-menu').css({position: 'fixed', top: '0px','max-width':'720px'}); } else { $('.sf-menu').css({position: 'relative'}); } } }); sorry but this tutorial was made for prestashop 1.5.6.x and not for 1.6.x.x and I do not yet have prestashop 1.6.x.x because it's unstable

try this: open: Themes/default-bootstrap/css/modules/blocktopmenu/css/superfish-modified.css now on the line 13 change it to position: fixed after that clean all your cache Regards

No, it needs changes to the code and also the files have different names, I did not yet tried on PS 1.6.x.x please see sooroos solution, I will post if I find a solution. Regards

Hi, If I understand correctly, you have problems with floating top menu when view your site in a mobile device? what is your prestashop version, you have a default theme or custom theme? regards

Hey Vekia, can you make a module that auto restore your store/theme/data? I will be the first to buy