MrjvanVeen Posted February 8, 2014 Share Posted February 8, 2014 Hi there!Today I was trying to add a left column to my CMS pages. But it's not working.I've deleted the exception in the hook configuration.Can anyone help me out with this please? 1 Link to comment Share on other sites More sharing options...
MrjvanVeen Posted February 8, 2014 Author Share Posted February 8, 2014 Nevermind. I already found the solution. I had to enable the left column in the theme. 1 Link to comment Share on other sites More sharing options...
w3bsolutions Posted March 17, 2014 Share Posted March 17, 2014 Hmm... I just updated to Prestashop 1.6.0.5 and on my theme the left colum disabled on CMS pages, when I edit the config and try to enable it I get this error message "An error occurred while updating this meta" What could the issue be? Where can I fix it? Thanks. 1 Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 17, 2014 Share Posted March 17, 2014 +1 I have the same problem. I use non responsive theme based on prestashop 1.5 default with several modification. After successfully upgrade to 1.6.0.5 before minutes i can`t hook left column on category page, product page and cms page. Have the same same error message like fire2:"An error occurred while updating this meta" I try to disable/enable other meta and don`t have problem with other. But this ( category page, product page and cms page ) is disabled by default and need to find issue to problem. Attach picture from BO. Live (test) store: markov.detelinmarkov.com Suggestions how to fix the problem or may be better to open ticket on forge? Thanks, Detelin Link to comment Share on other sites More sharing options...
w3bsolutions Posted March 17, 2014 Share Posted March 17, 2014 I have that exact problem on the same exact pages, and my theme is also the default 1.5 theme with some modifications... 1 Link to comment Share on other sites More sharing options...
vekia Posted March 17, 2014 Share Posted March 17, 2014 this theme control panel works only with 1.6 theme, not 1.5 1 Link to comment Share on other sites More sharing options...
w3bsolutions Posted March 17, 2014 Share Posted March 17, 2014 But why does it let you enable/disable columns for other pages and not those? Link to comment Share on other sites More sharing options...
Devil089 Posted March 17, 2014 Share Posted March 17, 2014 I have the same problem After installing 1.6 i cant activate the left and right column on product page. got the same error "An error occurred while updating this meta" I use the default 1.5 theme How i can fix this ? Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 17, 2014 Share Posted March 17, 2014 this theme control panel works only with 1.6 theme, not 1.5 Ok Vekia, but can be possible bug in 1.6 to detect our themes and from there to be our problem? I have hooked modules in left column, but they are not hooked in front office (have left column but is empty). Link to comment Share on other sites More sharing options...
w3bsolutions Posted March 17, 2014 Share Posted March 17, 2014 this theme control panel works only with 1.6 theme, not 1.5 The funny thing is I updated my fresh 1.6.0.4 RC shop that was working fine (test site, not production) using default bootstrap theme to the stable 1.6.0.5 and I am getting the exact same error, I cannot enable left or right columns on those pages... using default 1.6 theme. Link to comment Share on other sites More sharing options...
Devil089 Posted March 17, 2014 Share Posted March 17, 2014 very strange issue got exactly the same Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 17, 2014 Share Posted March 17, 2014 Fire2 i don't understand something: On test with Rc1 you are try only default bootstrap theme or boath (default bootstrap 1.6 theme AND YOUR theme based on 1.5 are working properly - after install you have left column or enable it after that? Excuse me for my missunderstanding. Link to comment Share on other sites More sharing options...
w3bsolutions Posted March 17, 2014 Share Posted March 17, 2014 Fire2 i don't understand something: On test with Rc1 you are try only default bootstrap theme or boath (default bootstrap 1.6 theme AND YOUR theme based on 1.5 are working properly - after install you have left column or enable it after that? Excuse me for my missunderstanding. Now I have two 1.6 shops, one I updated from a fresh 1.6.0.4 install I had from a few days ago and one I just updated from 1.5.6.2. On the previous RC I was using only default 1.6 theme and I had left column enabled on category and CMS pages. Now I updated to the stable version and the left column on those pages got disabled and I can't enable them (I get that error, the same error than if I try on the other 1.5 updated shop with my 1.5 theme). I hope its clear now. Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 17, 2014 Share Posted March 17, 2014 Yeap, now is clear. I will read checklist of 1.6.0.5 latter something that control this is changed and there is our problem. Link to comment Share on other sites More sharing options...
Devil089 Posted March 17, 2014 Share Posted March 17, 2014 also i have the issue that block_social network an block_contact ist not displayed in footer but blocks are activated did you have the same ? Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 17, 2014 Share Posted March 17, 2014 Devil089, I don`t use these modules anywhere in my shop and i don`t know.fire2, You are right! Now i check to enable default bootstrap 1.6 theme left column on category and product meta but not working! Link to comment Share on other sites More sharing options...
Devil089 Posted March 17, 2014 Share Posted March 17, 2014 ok thanks for the info if anyone have a solution for the problem on left and right column on cms, product and category that would be nice 1 Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 17, 2014 Share Posted March 17, 2014 Wow, now i check MSQL table that and in my table left column all is on. (have params 1) Link to comment Share on other sites More sharing options...
Devil089 Posted March 17, 2014 Share Posted March 17, 2014 that sounds, that the issue is hidden in the code Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 17, 2014 Share Posted March 17, 2014 You how upgrade? Do you change to default theme before upgrade? I activate default theme before upgrade. Now i try my other test shop. active other (modified) theme based on 1.5 - upgrade here from 1.6.0.2 to 1.6.0.5 and in theme config now i have two times category, two times CMS, two times index... one category i can enable (second one can`t) CMS and index to. And i see i this show left column on category page (on index none) Tomorrow i try to roll back first shop and upgrade but with active my modified theme. Link to comment Share on other sites More sharing options...
Devil089 Posted March 17, 2014 Share Posted March 17, 2014 I upgraded from 1.5.6 to 1.6.0.5 i have activated my modified theme before i upgraded. not the default one. if i understand you right, its a difference which theme is activated before upgrade ? right Link to comment Share on other sites More sharing options...
kbytin Posted March 18, 2014 Share Posted March 18, 2014 (edited) same issue here. Just updated to 1.6, and can't turn on left column on some pages - categories, cms, etc. Edited March 18, 2014 by gav304 (see edit history) Link to comment Share on other sites More sharing options...
SWcoins.com Posted March 18, 2014 Share Posted March 18, 2014 Same issue...cannot turn on right or left columns for product page, cms, etc. Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 18, 2014 Share Posted March 18, 2014 I upgraded from 1.5.6 to 1.6.0.5 i have activated my modified theme before i upgraded. not the default one. if i understand you right, its a difference which theme is activated before upgrade ? right I install clean 1.6.0.2 prestashop. Import my modified 1.5 theme and then i upgrade to 1.6.0.5 After upgrade i have 2 time problem meta! See picture: Today i will roll back first store that i test and will wait to next release - STABLE RELEASE! Dear Prestashop, I make several mistakes with 1.6 v! Thank you for distribution but you need to fix it. Integrating of responsive front and back office in one time is not god. I personaly want only 1.6 Back Office. I don`t want all of responsive technology in front office. You tell: 1.6 will be possible to use 1.5 theme but? I read other topics and many people have problems... Link to comment Share on other sites More sharing options...
Devil089 Posted March 18, 2014 Share Posted March 18, 2014 I install clean 1.6.0.2 prestashop. Import my modified 1.5 theme and then i upgrade to 1.6.0.5 After upgrade i have 2 time problem meta! See picture: detelin-markov104622001.png Today i will roll back first store that i test and will wait to next release - STABLE RELEASE! Dear Prestashop, I make several mistakes with 1.6 v! Thank you for distribution but you need to fix it. Integrating of responsive front and back office in one time is not god. I personaly want only 1.6 Back Office. I don`t want all of responsive technology in front office. You tell: 1.6 will be possible to use 1.5 theme but? I read other topics and many people have problems... ok i understand. the back office is really nice but the update gap really big from 1.5. 1.6 and this causes problems for modules an themes. the only solution for me actually is to roll back to 1.5 and wait for a stable version. but great work from the Prestashop Team , hope this bugs will be fixed in the future. or we find together a solution for it. this are the bugs i discover actually - left and right column problem on cms, product, and product page - block contact, block social not displayed in footer. 1 Link to comment Share on other sites More sharing options...
camereroloco Posted March 18, 2014 Share Posted March 18, 2014 Same issue... Link to comment Share on other sites More sharing options...
digitalideasrl Posted March 18, 2014 Share Posted March 18, 2014 Same issue... Link to comment Share on other sites More sharing options...
w3bsolutions Posted March 18, 2014 Share Posted March 18, 2014 Here is the issue on the forge: http://forge.prestashop.com/browse/PSCSX-1179 I solved it adding the missing rows to the database Link to comment Share on other sites More sharing options...
Devil089 Posted March 18, 2014 Share Posted March 18, 2014 Here is the issue on the forge: http://forge.prestashop.com/browse/PSCSX-1179 I solved it adding the missing rows to the database i don't really know how it works i looked at the github link try to execute the sql in my database and get a sql import error message how do you solve it exactly ? Link to comment Share on other sites More sharing options...
Thanat Posted March 18, 2014 Share Posted March 18, 2014 works for me https://github.com/PrestaShop/PrestaShop/blob/ef27ec278df5bc09ab680974d6e3dcd2eeaf4307/install-dev/upgrade/sql/1.6.0.6.sql Link to comment Share on other sites More sharing options...
Devil089 Posted March 18, 2014 Share Posted March 18, 2014 (edited) ok i got it it works thanks Edited March 18, 2014 by Devil089 (see edit history) Link to comment Share on other sites More sharing options...
Synthesis Posted March 19, 2014 Share Posted March 19, 2014 I'm getting an error message too: SQL query: ALTER TABLE `PREFIX_order_invoice_tax` ADD INDEX (`id_tax`); MySQL отговори: #1146 - Table 'presta.PREFIX_order_invoice_tax' doesn't exist Link to comment Share on other sites More sharing options...
Synthesis Posted March 19, 2014 Share Posted March 19, 2014 I got it, sorry. I just changed PREFIX with PS (the prefix of my tables) in the query and it worked perfectly. Thanks. Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 19, 2014 Share Posted March 19, 2014 Hm.. We have solution. Thank you fire2! Today i will try to upgrade one of my live shop. Link to comment Share on other sites More sharing options...
Detelin Markov Posted March 19, 2014 Share Posted March 19, 2014 (edited) End success. I successfully upgrade live shop to 1.6.0.5 and with SQL fix show left columns. If some moderator (may be Vekia) check this topic again may be it`s time to be [sOLVED] Happy selling guys! Regards Detelin Edited March 19, 2014 by Detelin Markov (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 19, 2014 Share Posted March 19, 2014 Hey guys, thanks for all the forge reports and Github requests. Here is the Github Fix for the Left Column bug, https://github.com/PrestaShop/PrestaShop/commit/ef27ec278df5bc09ab680974d6e3dcd2eeaf4307 Here is the forge http://forge.prestashop.com/browse/PSCSX-1179 Link to comment Share on other sites More sharing options...
Greenpilgrim Posted March 19, 2014 Share Posted March 19, 2014 Hi, I do not really understand how to fix this, what are you supposed to do with this code? I have gone to https://github.com/PrestaShop/PrestaShop/commit/ef27ec278df5bc09ab680974d6e3dcd2eeaf4307 and http://forge.prestashop.com/browse/PSCSX-1179 But doesnt really explain how to fix this (well for a simpleton like myself), So I dont really know what i am supposed to do to fix this issue, i have a very limited knowledge of php and sql stuff. Cheers Chris Link to comment Share on other sites More sharing options...
Synthesis Posted March 19, 2014 Share Posted March 19, 2014 go to your sql database, choose 'SQL', paste the code and click 'go'. Please be careful. Link to comment Share on other sites More sharing options...
Greenpilgrim Posted March 19, 2014 Share Posted March 19, 2014 (edited) Thanks, seems i get an error. I copied and pasted the whole thing from github i presume that is right. fyi i upgraded from 1.4.7 to this version, I dont now if i should have gone to 1.5 then to 1.6, maybe i am missign aload of tables that may have been in 1.5 any idea? Error SQL query: ALTER TABLE `PREFIX_order_invoice_tax` ADD INDEX ( `id_tax` ) MySQL said: #1146 - Table 'db403680663.PREFIX_order_invoice_tax' doesn't exist Edited March 19, 2014 by Greenpilgrim (see edit history) Link to comment Share on other sites More sharing options...
Synthesis Posted March 19, 2014 Share Posted March 19, 2014 Just change 'PREFIX' with the prefix of your tables (may be 'ps') Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 19, 2014 Share Posted March 19, 2014 Yes, in most cases the prefix (by default) is ps In that case, run this SQL query via your hosting admin or cpanel phpmyadmin INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0'); INSERT IGNORE INTO `ps_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`; 2 Link to comment Share on other sites More sharing options...
Greenpilgrim Posted March 19, 2014 Share Posted March 19, 2014 (edited) I did that now i get this come up. SQL query: INSERT IGNORE INTO `ps_meta` ( `id_meta` , `page` , `configurable` )VALUES ( NULL , 'products-comparison', '1' ), ( NULL , 'cms', '0' ), ( NULL , 'category', '0' ), ( NULL , 'product', '0' ), ( NULL , 'module-bankwire-payment', '0' ), ( NULL , 'module-bankwire-validation', '0' ), ( NULL , 'module-cheque-validation', '0' ), ( NULL , 'module-cheque-payment', '0' ) MySQL said: #1054 - Unknown column 'configurable' in 'field list' Sorry to be a pain Edited March 19, 2014 by Greenpilgrim (see edit history) Link to comment Share on other sites More sharing options...
Pronux Posted March 22, 2014 Share Posted March 22, 2014 Perfect, thanks! Link to comment Share on other sites More sharing options...
labeleng Posted March 22, 2014 Share Posted March 22, 2014 I am sorry i did not get what was done to fix the error below because i got a similar error too. My prefix is 'pr' ErrorSQL query: INSERT IGNORE INTO `pr_meta` ( `id_meta` , `page` , `configurable` )VALUES ( NULL , 'products-comparison', '1' ), ( NULL , 'cms', '0' ), ( NULL , 'category', '0' ), ( NULL , 'product', '0' ), ( NULL , 'module-bankwire-payment', '0' ), ( NULL , 'module-bankwire-validation', '0' ), ( NULL , 'module-cheque-validation', '0' ), ( NULL , 'module-cheque-payment', '0' ); MySQL said: #1054 - Unknown column 'configurable' in 'field list' Link to comment Share on other sites More sharing options...
vekia Posted March 23, 2014 Share Posted March 23, 2014 go to phpmyadmin, open pr_meta table then create new "configurable" column and try to run this query once again. specification of configurable field: TINYINT(1) unsigned NULL DEFAULT 1 1 Link to comment Share on other sites More sharing options...
Nihelan Posted March 23, 2014 Share Posted March 23, 2014 Fresh install here with default 'bootstrap' theme, with some minor modifications in CSS, also not displaying left_column on category, CMS, frontpage, product. It does however display in search_results page, strangely. Link to comment Share on other sites More sharing options...
dename Posted March 24, 2014 Share Posted March 24, 2014 Hi, 1.5 => 1.6 upgrade, default theme, after running that SQL script and some extensive clicking I got double entries for "category", "cms", "index", "order", "product" is it normal or is it required to do something with that? thanks! Link to comment Share on other sites More sharing options...
Greenpilgrim Posted March 24, 2014 Share Posted March 24, 2014 (edited) Ok I have done all these changes and it doesn't appear to do anything. I got these sql queries to work but i had to create a missing column (configurable) and missing table (ps_theme_meta and ps_theme) (copied settings from fresh install database) after doing this the commands worked fine. but doesn't appear change anything I installed a fresh install to compare the databases and there are quite a few tables in the new install that do not exist in my upgraded version. e.g. ps_themeconfigurator and ps_theme_specific I guess there is some sort of bug during the upgrade that hasnt created these tables or something. (i dont really know how all this works) Would creating these missing tables do anything? At this point i am thinking would it be better to try and export/import my products and customers from either my upgraded version or my original version (1.4.7). I may have a look for a module or something to import and export but would any existing modules be compatible with 1.6? or anyone have any success in doing this since this release? Cheers Chris Edited March 24, 2014 by Greenpilgrim (see edit history) Link to comment Share on other sites More sharing options...
Sheyl Posted March 24, 2014 Share Posted March 24, 2014 Thx you for the fix ! love <3 Link to comment Share on other sites More sharing options...
ldon Posted March 24, 2014 Share Posted March 24, 2014 Yes, in most cases the prefix (by default) is ps In that case, run this SQL query via your hosting admin or cpanel phpmyadmin INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0'); INSERT IGNORE INTO `ps_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`; I've done it and I've received: INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0');# MySQL returned an empty result set (i.e. zero rows). INSERT IGNORE INTO `ps_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`;# MySQL returned an empty result set (i.e. zero rows). Link to comment Share on other sites More sharing options...
ldon Posted March 24, 2014 Share Posted March 24, 2014 (edited) go to phpmyadmin, open pr_meta table then create new "configurable" column and try to run this query once again. specification of configurable field: TINYINT(1) unsigned NULL DEFAULT 1 My sql: http://files.uloziste.com/84fea795b05caa85/db.jpg It doesn't work. Edited March 24, 2014 by ldon (see edit history) Link to comment Share on other sites More sharing options...
vansrv7 Posted March 24, 2014 Share Posted March 24, 2014 (edited) Ok I have done all these changes and it doesn't appear to do anything. I got these sql queries to work but i had to create a missing column (configurable) and missing table (ps_theme_meta and ps_theme) (copied settings from fresh install database) after doing this the commands worked fine. but doesn't appear change anything I installed a fresh install to compare the databases and there are quite a few tables in the new install that do not exist in my upgraded version. e.g. ps_themeconfigurator and ps_theme_specific [...] Same here. It looks I miss the ps_themeconfigurator (ps_theme_specific exists but is empty) and who knows what else.... By the way, followed the instruction but nothing changed, I'm still unable to activate left (and right) column on category, cms and product page. Edited March 24, 2014 by vansrv7 (see edit history) Link to comment Share on other sites More sharing options...
Nihelan Posted March 24, 2014 Share Posted March 24, 2014 Same here. It looks I miss the ps_themeconfigurator (ps_theme_specific exists but is empty) and who knows what else.... By the way, followed the instruction but nothing changed, I'm still unable to activate left (and right) column on category, cms and product page. I didnt work for me right out of the box, but I fixed it eventually. Go to "Positions" and find "LeftColumn", then edit each block manually. It worked for me, I attached both images. Link to comment Share on other sites More sharing options...
labeleng Posted March 25, 2014 Share Posted March 25, 2014 Hello Vekia i followed through with the discussions but still have error with my sql ErrorSQL query: INSERT IGNORE INTO `pr_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` )SELECT `pr_theme`.`id_theme` , `pr_meta`.`id_meta` , `default_left_column` , `default_right_column`FROM `pr_theme` , `pr_meta` ; MySQL said: #1054 - Unknown column 'default_left_column' in 'field list' I still need some help Link to comment Share on other sites More sharing options...
vekia Posted March 25, 2014 Share Posted March 25, 2014 hello i released new guide related to this, i recently fixed this problem in several shops with this fix. 2 Link to comment Share on other sites More sharing options...
roo10 Posted March 26, 2014 Share Posted March 26, 2014 Found the solution. The database table "ps_theme_meta" didn't automatically add "id_meta" for products comparison page for the custom theme. Link to comment Share on other sites More sharing options...
Greenpilgrim Posted March 26, 2014 Share Posted March 26, 2014 Thanks for the help guys. I did all this it didnt seem to work, I think my theme was bugged, So i made a copy of the theme from my fresh install and added that to my upgraded version and it has worked. Thanks Chris Link to comment Share on other sites More sharing options...
dename Posted March 26, 2014 Share Posted March 26, 2014 (edited) hey but when you add left column to the homepage, product columns remain at 25% width, inconsistent with product columns on categories pages which are at 33.3% width. Is there a control for that besides global css? Edited March 26, 2014 by dename (see edit history) Link to comment Share on other sites More sharing options...
ujangeman Posted March 26, 2014 Share Posted March 26, 2014 Yes, in most cases the prefix (by default) is ps In that case, run this SQL query via your hosting admin or cpanel phpmyadmin INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0'); INSERT IGNORE INTO `ps_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`; it's Works..! Thanks for the fix ! 1 Link to comment Share on other sites More sharing options...
Phil_F Posted March 26, 2014 Share Posted March 26, 2014 Vekia, Thank you very much, it worked well for me. Link to comment Share on other sites More sharing options...
ldon Posted March 26, 2014 Share Posted March 26, 2014 hello i released new guide related to this, i recently fixed this problem in several shops with this fix. Finaly solution for (not only) my problem. But it is not working for CMS and so on. pic1 pic2 Link to comment Share on other sites More sharing options...
vekia Posted March 26, 2014 Share Posted March 26, 2014 Finaly solution for (not only) my problem. But it is not working for CMS and so on. pic1 pic2 is there any chance to inspect your shop, also in back office? just want to create universal solution Link to comment Share on other sites More sharing options...
ldon Posted March 26, 2014 Share Posted March 26, 2014 is there any chance to inspect your shop, also in back office? just want to create universal solution Unfortunately I'm on localhost. Link to comment Share on other sites More sharing options...
labeleng Posted March 27, 2014 Share Posted March 27, 2014 Vekia can i send you my back office credentials? Link to comment Share on other sites More sharing options...
Deynor Posted March 27, 2014 Share Posted March 27, 2014 (edited) Hi Vekia, i've read your tutorial (for 3 column) but i have a problem: left column only show in Product page right column show properly in every page slider module work terrible I think that the problem is the language translation that have to be made before. Also if i try to edit the translation i get this error: 403 Forbidden Access to this resource on the server is denied! I think that it's a big bug. i try to search more. thanks in advance (upgraded from 1.5) Edited March 27, 2014 by Deynor (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted March 27, 2014 Share Posted March 27, 2014 hello check modules attached to left column (and to right also) i bet on exceptions go to modules > positions search for your columns hooks, and click on edit button near each module attached to these lists. verify "exceptions" field for each of them. 1 Link to comment Share on other sites More sharing options...
Andre1007 Posted March 29, 2014 Share Posted March 29, 2014 Hello I have the same problem I have enabled the left column but if i look in firebug i see - index hide-left-column hide-right-column lang_nl - How can i fix this? thanks Link to comment Share on other sites More sharing options...
suziechs Posted March 29, 2014 Share Posted March 29, 2014 I tried all your sql queries and more to try and solve this issue..... has driven me insane..... Have given up....... Link to comment Share on other sites More sharing options...
vekia Posted April 2, 2014 Share Posted April 2, 2014 I tried all your sql queries and more to try and solve this issue..... has driven me insane..... Have given up....... any chance to get an access to your BO ? Link to comment Share on other sites More sharing options...
labeleng Posted April 2, 2014 Share Posted April 2, 2014 I tried all your sql queries and more to try and solve this issue..... has driven me insane..... Have given up....... Same for me too Link to comment Share on other sites More sharing options...
vekia Posted April 2, 2014 Share Posted April 2, 2014 hello guys, please if it is possible i can check everything for you, but in this ase i need an access to bo with granted privileges to manage themes & modules section Link to comment Share on other sites More sharing options...
labeleng Posted April 2, 2014 Share Posted April 2, 2014 Gave Vekia my BO credentials and amazingly he fixed it. Thanks so so muc Vekia Link to comment Share on other sites More sharing options...
Detelin Markov Posted April 4, 2014 Share Posted April 4, 2014 Vekia, I try your fix yesterday but not work for me. I can`t turn on left column in guest-tracking page. Try to add "guest-tracking" in Emilien SQL code but again do not show left column. SET NAMES 'utf8'; ALTER TABLE `ps_order_invoice_tax` ADD INDEX (`id_tax`); + INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'guest-tracking', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0'); INSERT IGNORE INTO `PREFIX_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`; Ideas how to fix it? Link to comment Share on other sites More sharing options...
vekia Posted April 4, 2014 Share Posted April 4, 2014 Vekia, I try your fix yesterday but not work for me. I can`t turn on left column in guest-tracking page. Try to add "guest-tracking" in Emilien SQL code but again do not show left column. SET NAMES 'utf8'; ALTER TABLE `ps_order_invoice_tax` ADD INDEX (`id_tax`); + INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'guest-tracking', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0'); INSERT IGNORE INTO `PREFIX_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`; Ideas how to fix it? without inspection in back office (to identify source of problems) it's hard to help, unfortunately ;( i've noticed that there is no universal solution for this, due to the fact, that problem has got different sources 1 Link to comment Share on other sites More sharing options...
Detelin Markov Posted April 4, 2014 Share Posted April 4, 2014 without inspection in back office (to identify source of problems) it's hard to help, unfortunately ;( i've noticed that there is no universal solution for this, due to the fact, that problem has got different sources Hm... Thanks for answer Milos! Link to comment Share on other sites More sharing options...
vekia Posted April 4, 2014 Share Posted April 4, 2014 Hm... Thanks for answer Milos! so, i can check it for you if you want if so just let me know on PM, Link to comment Share on other sites More sharing options...
sweszler Posted April 5, 2014 Share Posted April 5, 2014 I'm after upgrade to 1.6 version and I had the same problems and now finally helped me uninstall and install again every modules hooked to left column. Maybe try this way. Some modules have to update define value. Link to comment Share on other sites More sharing options...
redactuk Posted April 6, 2014 Share Posted April 6, 2014 (edited) Well I too have been having no success with all the fixes listed. For me what finally worked was: Modules > Postions - displayLeftColumn Edit New Products block and using CTRL unselect 'index' which was highlighted, then Save This then added that block to my left column on home page What seems to be happening is that despite all other changes proposed, in some cases, all the modules assigned by default to displayLeftColumn have an override set so they don't display. I'm not sure if this is something left over from above fixes or not, but by manually updating those exceptions lists for each module I wanted in left column I was able to ger them to display. Edited April 6, 2014 by redactuk (see edit history) Link to comment Share on other sites More sharing options...
Doglovers Posted April 7, 2014 Share Posted April 7, 2014 Tried all the above solutions as well. But still no left column. Link to comment Share on other sites More sharing options...
Rekha Posted April 10, 2014 Share Posted April 10, 2014 Hi legends and moderators, I upgraded with 1 click upgrade from 1.4.5.1 to 1.6. The layered navigation filer v1.10.5 does not show in the left column. The left column shows with other modules when I select a category in top menu. In theme/bootstrap left column list settings, category (id_meta is 28), cms (29), index (4,26), and product (27) are red and when I click error is "An error occurred while updating this meta." On phpmyadmin, I have set left column to 1 for category and all metas . <a class="list-action-enable ajax_table_link action-disabled" title="Disabled" href="index.php?controller=AdminThemes&id_theme_meta=0&leftmeta&action=leftmeta&ajax=1&token=ed47c4163cda57a415a10a0d3a0e4906"> I also replaced the theme from fresh install. Layered filter shows in the fresh install. What is missing? ow should I correct? Regards, Rekha Link to comment Share on other sites More sharing options...
Rekha Posted April 10, 2014 Share Posted April 10, 2014 One setting different from fresh install is: advanced parameters/ performance - "Disable all overrides" is 'Yes' and not changing to 'No'. In the fresh install the setting s 'No'. Layered filter is in left column with no exceptions. layered module in Positions is same as in fresh install. I can give you access to the website. Link to comment Share on other sites More sharing options...
Rekha Posted April 10, 2014 Share Posted April 10, 2014 Anyone can help please? I do not know how to execute the sql steps on previous page. Link to comment Share on other sites More sharing options...
ciscovj Posted April 10, 2014 Share Posted April 10, 2014 any chance to get an access to your BO ? Hi Vekia, I have the same problem, solution (http://mypresta.eu/en/art/prestashop-16/an-error-occured-while-updating-this-meta.html) doesnt work for me. If you want I can give you access to DB or admin page by PM. Thanks! Link to comment Share on other sites More sharing options...
Doglovers Posted April 10, 2014 Share Posted April 10, 2014 Hello everyone, I had tried all of the previous solutions to no avail. I then downloaded a fresh copy of prestashop 1.6 and extracted the default-bootstrap template and installed it, and like magic, we had a left column. This was the only solution that worked for me. Hope this helps some of you guys. Link to comment Share on other sites More sharing options...
Rekha Posted April 10, 2014 Share Posted April 10, 2014 But with a fresh install how can I import the database which has orders, customers, catalog ? Link to comment Share on other sites More sharing options...
Rekha Posted April 10, 2014 Share Posted April 10, 2014 Prestashop team, please help else I have to do fresh install and rebuild entire site again, which is very unpleasant to do. Link to comment Share on other sites More sharing options...
Doglovers Posted April 10, 2014 Share Posted April 10, 2014 Don't do a FRESH install of prestashop.........!!! Extract the default template from the prestashop 1.6 download, and install the TEMPLATE only.... Link to comment Share on other sites More sharing options...
Rekha Posted April 10, 2014 Share Posted April 10, 2014 I did that already with no change. I copied the bootstrap theme folder from a fresh install and copied over the existing theme. Once earlier too I had to do a fresh reinstall for a new version case the upgrade had severe faults, and it was very difficult cause I could not import the orders database. Link to comment Share on other sites More sharing options...
Rekha Posted April 10, 2014 Share Posted April 10, 2014 I pasted a code from https://github.com/PrestaShop/PrestaShop/blob/ef27ec278df5bc09ab680974d6e3dcd2eeaf4307/install-dev/upgrade/sql/1.6.0.6.sql . The left column appeared and layered filter shows. But in the layered navigation filter the prices are not getting reindexed, the page goes blank with only a digit 1 showing. Link to comment Share on other sites More sharing options...
Doglovers Posted April 10, 2014 Share Posted April 10, 2014 I don't know why, but it worked for me. Good luck! Link to comment Share on other sites More sharing options...
Rekha Posted April 10, 2014 Share Posted April 10, 2014 I just solved my problem, paste the same following code in the database via phpmyadmin in the SQL box and click Go. The category,cms and index values for left column were being considered as 0 even when set to 1 in the database tables. The code ignores the 0 . The left column appeared on category pages ie when I select a category in the menu. INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0'); INSERT IGNORE INTO `ps_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`; 1 Link to comment Share on other sites More sharing options...
Doglovers Posted April 10, 2014 Share Posted April 10, 2014 Good job! Link to comment Share on other sites More sharing options...
taoufiqaitali Posted April 11, 2014 Share Posted April 11, 2014 i used this query and it solved my problem INSERT INTO `ps_theme_meta`( `id_theme`, `id_meta`, `left_column`, `right_column`) select 5,ps_meta.id_meta,1,0 from ps_meta where ps_meta.id_meta not in(select id_meta from ps_theme_meta) Link to comment Share on other sites More sharing options...
roz Posted April 14, 2014 Share Posted April 14, 2014 so, i can check it for you if you want if so just let me know on PM, hi Vekia, can you still able to check my BO? i can't send you a PM. the site is not in local anymore so you will be able to access it now thank you. Link to comment Share on other sites More sharing options...
roz Posted April 14, 2014 Share Posted April 14, 2014 I just solved my problem, paste the same following code in the database via phpmyadmin in the SQL box and click Go. The category,cms and index values for left column were being considered as 0 even when set to 1 in the database tables. The code ignores the 0 . The left column appeared on category pages ie when I select a category in the menu. INSERT IGNORE INTO `ps_meta` (`id_meta`, `page`, `configurable`) VALUES (NULL, 'products-comparison', '1'), (NULL, 'cms', '0'), (NULL, 'category', '0'), (NULL, 'product', '0'), (NULL, 'module-bankwire-payment', '0'), (NULL, 'module-bankwire-validation', '0'), (NULL, 'module-cheque-validation', '0'), (NULL, 'module-cheque-payment', '0'); INSERT IGNORE INTO `ps_theme_meta` ( `id_theme` , `id_meta` , `left_column` , `right_column` ) SELECT `ps_theme`.`id_theme` , `ps_meta`.`id_meta` , `default_left_column` , `default_right_column` FROM `ps_theme` , `ps_meta`; this solved my problem too! thank you! Link to comment Share on other sites More sharing options...
vla123 Posted April 14, 2014 Share Posted April 14, 2014 Mine problem is, that I can see Left Column on Home, on Product, but not on Product List. Any idea to resolve this problem? Thanks. Link to comment Share on other sites More sharing options...
vekia Posted April 14, 2014 Share Posted April 14, 2014 Mine problem is, that I can see Left Column on Home, on Product, but not on Product List. Any idea to resolve this problem? Thanks. go to localization > positions search for displayLeftColumn list of modules then click on edit button near each of the module attached to list check "exceptions" field, if there is any exception defined: just remove it. 1 Link to comment Share on other sites More sharing options...
vla123 Posted April 14, 2014 Share Posted April 14, 2014 go to localization > positions search for displayLeftColumn list of modules then click on edit button near each of the module attached to list check "exceptions" field, if there is any exception defined: just remove it. Are you means Modules-Positions? There is only one module in the displayLeftColumn - the Categories block - v2.8 I checked it before I send my question. There are no exception. In Live Edit I can see Categories block in Product List, but this one is empty. This behavior is not OK, but not a catastrophic.:-) Link to comment Share on other sites More sharing options...
vekia Posted April 14, 2014 Share Posted April 14, 2014 category block appears only if there is some subcategory to display. if there is no subcategories - module will not show, in this case also whole left column. can you for test purposes attach to left column also other module? Link to comment Share on other sites More sharing options...
vla123 Posted April 14, 2014 Share Posted April 14, 2014 Are you means Modules-Positions? There is only one module in the displayLeftColumn - the Categories block - v2.8 I checked it before I send my question. There are no exception. In Live Edit I can see Categories block in Product List, but this one is empty. This behavior is not OK, but not a catastrophic.:-) Uff: Solved. In Configure "Categories block" module I switched Category root from Current to Home. :-\ Tahks for yours time. Link to comment Share on other sites More sharing options...
Recommended Posts