Jump to content

Left column in the categories page

pippobr80

By pippobr80
in OUT - 1.6.0.11 [7 Jan 2015]

 Share

Recommended Posts

pippobr80 Newbie

pippobr80

Posted
Posted

Hello in the category page of my site does not appear the left column will post the link. my version is 1.6.05 pestashop the theme is default. Inside the manufacturers list the left column is present. There are no exclusions for categories page. It will be another bug!

 

http://www.reusedfashionstore.it/index.php?id_category=6&controller=category&id_lang=2

 

Thanks...

Link to comment
Share on other sites
pippobr80 Newbie

pippobr80

Posted
  • Author
Posted

you enabled left column on theme preferences page?

also, make sure that modules attached to the left column haven't defined "exceptions"

 

I am sure that there are no exclusions. The theme is enabled because the link producers, the left column is visible

http://www.reusedfashionstore.it/index.php?id_manufacturer=4&controller=manufacturer&id_lang=2

Link to comment
Share on other sites
lokifer Newbie

lokifer

Posted
Posted

strange that it doesnt appear.

so, you enabled left column for categories

mmlicTp.png

 

 

maybe it's worth to resave this option and clear cache in entrie shop (with force compilation)

I have a similar problem, and when i try to enable the left column for categories, i get this error: An error occurred while updating this meta.

 

Can someone point me in the direction to solve this.

Thanks

Link to comment
Share on other sites
vekia Apprentice

vekia

Posted
Posted

I have a similar problem, and when i try to enable the left column for categories, i get this error: An error occurred while updating this meta.

 

Can someone point me in the direction to solve this.

Thanks

 

can you check theme_meta table?

have you got there id_theme_meta = 27 ?

Link to comment
Share on other sites
lokifer Newbie

lokifer

Posted
Posted (edited)

have you got an access to database manager like phpmyadmin?

 

btw. you see the same problem when you're trying to activate column for other page? or it just appears when you're trying to do it for "category" ?

 

Yes i have phpmyadmin, but the tables only go until (ps_supplier), i have no T., last table is ps_supplier,   do i have to create  something new ?

 

It happens in category, CMS, Index

Edited by lokifer (see edit history)
Link to comment
Share on other sites
lokifer Newbie

lokifer

Posted
Posted (edited)

 

this is why it doesn't want to work.

run this query in your PhpMyAdmin

DROP TABLE IF EXISTS `ps_theme_meta`;
CREATE TABLE IF NOT EXISTS `ps_theme_meta` (
  `id_theme_meta` int(11) NOT NULL AUTO_INCREMENT,
  `id_theme` int(11) NOT NULL,
  `id_meta` int(10) unsigned NOT NULL,
  `left_column` tinyint(1) NOT NULL DEFAULT '1',
  `right_column` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_theme_meta`),
  UNIQUE KEY `id_theme_2` (`id_theme`,`id_meta`),
  KEY `id_theme` (`id_theme`),
  KEY `id_meta` (`id_meta`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

DELETE FROM `ps_theme_meta`;
INSERT INTO `ps_theme_meta` (`id_theme_meta`, `id_theme`, `id_meta`, `left_column`, `right_column`) VALUES
	(1, 1, 1, 0, 0),
	(2, 1, 2, 1, 0),
	(3, 1, 3, 0, 0),
	(4, 1, 4, 1, 0),
	(5, 1, 5, 1, 0),
	(6, 1, 6, 1, 0),
	(7, 1, 7, 0, 0),
	(8, 1, 8, 1, 0),
	(9, 1, 9, 1, 0),
	(10, 1, 10, 0, 0),
	(11, 1, 11, 0, 0),
	(12, 1, 12, 0, 0),
	(13, 1, 13, 0, 0),
	(14, 1, 14, 0, 0),
	(15, 1, 15, 0, 0),
	(16, 1, 16, 0, 0),
	(17, 1, 17, 0, 0),
	(18, 1, 18, 0, 0),
	(19, 1, 19, 0, 0),
	(20, 1, 20, 0, 0),
	(21, 1, 21, 0, 0),
	(22, 1, 22, 1, 0),
	(23, 1, 23, 0, 0),
	(24, 1, 24, 0, 0),
	(25, 1, 25, 0, 0),
	(26, 1, 26, 0, 0),
	(27, 1, 28, 1, 1),
	(28, 1, 29, 0, 0),
	(29, 1, 27, 1, 1),
	(30, 1, 30, 0, 0),
	(31, 1, 31, 0, 0),
	(32, 1, 32, 0, 0),
	(33, 1, 33, 0, 0),
	(34, 1, 34, 0, 0);

 

Oce again im a nob, so i did go to SQY Query, pasted the code and got this :

 

MySQL said: dot.gif

#1046 - No database selected, dis i do something wrong?

 

Oce again, Vekia your the best thank you for helping me with this.

 

Sorry i'm an idiot ( No database selected, ), off couse i did not work,

i'm going to try again

Edited by lokifer (see edit history)
  • Like 1
Link to comment
Share on other sites
pippobr80 Newbie

pippobr80

Posted
  • Author
Posted

have you got an access to database manager like phpmyadmin?

 

btw. you see the same problem when you're trying to activate column for other page? or it just appears when you're trying to do it for "category" ?

 

I have this problem only on category select left column, on cms, on product

Link to comment
Share on other sites
lokifer Newbie

lokifer

Posted
Posted

Thank for help Vekia, and please im sorry but i'm a nob,

How can I view this ?, where is theme_meta table ?

 

is this in the database ?,

 

Thanks

 

I've got:

 

 id_theme_meta     id_theme     id_meta             left_column     right_column

 27                                1                         28     1     1

Link to comment
Share on other sites
vekia Apprentice

vekia

Posted
Posted

IT Works,

 

Vekia you are th Man

:P

Thanks

 

IT Works,

 

Vekia you are th Man

:P

Thanks

you're welcome :D

 

 

I have this problem only on category select left column, on cms, on product

can you please verify your database ps_theme_meta for ID = 27 ? left column value is 1 ?

Link to comment
Share on other sites
pippobr80 Newbie

pippobr80

Posted
  • Author
Posted

I've got:

 

 id_theme_meta     id_theme     id_meta             left_column     right_column

 27                                1                         28     1     1

 

This is my screen shoot  post-717590-0-70416000-1395664579_thumb.jpg

Link to comment
Share on other sites
pippobr80 Newbie

pippobr80

Posted
  • Author
Posted

Thanks 

 

 

this is why it doesn't want to work.

run this query in your PhpMyAdmin

DROP TABLE IF EXISTS `ps_theme_meta`;
CREATE TABLE IF NOT EXISTS `ps_theme_meta` (
  `id_theme_meta` int(11) NOT NULL AUTO_INCREMENT,
  `id_theme` int(11) NOT NULL,
  `id_meta` int(10) unsigned NOT NULL,
  `left_column` tinyint(1) NOT NULL DEFAULT '1',
  `right_column` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_theme_meta`),
  UNIQUE KEY `id_theme_2` (`id_theme`,`id_meta`),
  KEY `id_theme` (`id_theme`),
  KEY `id_meta` (`id_meta`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

DELETE FROM `ps_theme_meta`;
INSERT INTO `ps_theme_meta` (`id_theme_meta`, `id_theme`, `id_meta`, `left_column`, `right_column`) VALUES
	(1, 1, 1, 0, 0),
	(2, 1, 2, 1, 0),
	(3, 1, 3, 0, 0),
	(4, 1, 4, 1, 0),
	(5, 1, 5, 1, 0),
	(6, 1, 6, 1, 0),
	(7, 1, 7, 0, 0),
	(8, 1, 8, 1, 0),
	(9, 1, 9, 1, 0),
	(10, 1, 10, 0, 0),
	(11, 1, 11, 0, 0),
	(12, 1, 12, 0, 0),
	(13, 1, 13, 0, 0),
	(14, 1, 14, 0, 0),
	(15, 1, 15, 0, 0),
	(16, 1, 16, 0, 0),
	(17, 1, 17, 0, 0),
	(18, 1, 18, 0, 0),
	(19, 1, 19, 0, 0),
	(20, 1, 20, 0, 0),
	(21, 1, 21, 0, 0),
	(22, 1, 22, 1, 0),
	(23, 1, 23, 0, 0),
	(24, 1, 24, 0, 0),
	(25, 1, 25, 0, 0),
	(26, 1, 26, 0, 0),
	(27, 1, 28, 1, 1),
	(28, 1, 29, 0, 0),
	(29, 1, 27, 1, 1),
	(30, 1, 30, 0, 0),
	(31, 1, 31, 0, 0),
	(32, 1, 32, 0, 0),
	(33, 1, 33, 0, 0),
	(34, 1, 34, 0, 0);

Thanks it run    :P  :P  :P  :P

  • Like 1
Link to comment
Share on other sites
maurino Newbie

maurino

Posted
Posted

:| you haven't got left column there? :|

can you please follow this:

 

what number you see in the link after id_theme_meta ?

 

Hello, I have the same problem, in my database is present: ps_theme_meta inside there is: id_theme_meta; id_theme id_meta; left_column; right_column.

 

The link to the category box is: index.php?controller=AdminThemes&id_theme_meta=0&leftmeta&action=leftmeta&ajax=1&token=a8226f74e6ef4b0d528d8b48cdd3e9bd"> who is disabled and can not seem to activate.

 

How could I turn on the left column on the page categories?

Link to comment
Share on other sites
maurino Newbie

maurino

Posted
Posted

so we are one step closer.

it looks like you've got bug with this table.

 

 

try to run this query:

http://www.prestashop.com/forums/topic/317556-left-column-in-the-categories-page/?p=1607429

Hello,

I solved my problem, I manually inserted rows in the database.

 

 id_theme_meta=  id_theme=8  id_meta=27 left_column=1 right_column=0

id_theme_meta=  id_theme=8  id_meta=28 left_column=1 right_column=0

Link to comment
Share on other sites
maurino Newbie

maurino

Posted
Posted

Hello,

I solved my problem, I manually inserted rows in the database.

 

 id_theme_meta=  id_theme=8  id_meta=27 left_column=1 right_column=0

id_theme_meta=  id_theme=8  id_meta=28 left_column=1 right_column=0

you could make a list of correspondence with id_meta and the name that appears in the bo? I have the same problem with the meta CMS thanks to all

Link to comment
Share on other sites
Ray UK Collaborator

Ray UK

Posted
Posted

Cheers Vekia,

This bug also appeared in my dev site upgrade from 1.5.4.1 to 1.6.0.5

 

It didnt appear in the clean install of 1.6.0.5 though.

 

This is just another problem in the "1-click upgrade" :(

 

A clean install with "Import product/customer/module" options is needed. It should have been in the final 1.6 release.

That would help in eliminating problems like this

Link to comment
Share on other sites
TESB1980 Newbie

TESB1980

Posted
Posted

so you mean that ps_theme_meta doesn't exist in your DB ?!

it's an updated prestashop or fresh installation?

 

Hi vekia,

 

Sorry for the trouble, but I have the same problem with the columns too. Using an updated PS from 1.5.6.2.

 

I found that I am also missing ps_theme_meta, and have tried running your query in my PhpMyAdmin on database prestashop. Log states that # 34 rows affected, but nothing happens. There is no error message, and ps_theme_meta is not created.

 

Is there possibly something which prevents ps_theme_meta from being created?

 

 

Link to comment
Share on other sites
TESB1980 Newbie

TESB1980

Posted
Posted (edited)

I tried creating ps_theme_meta table again and noticed the comment "MySQL returned an empty result set (i.e. zero rows)." Sorry, I am new to this...

 

 

CREATE TABLE IF NOT EXISTS `ps_theme_meta` (
`id_theme_meta` int(11) NOT NULL AUTO_INCREMENT,
`id_theme` int(11) NOT NULL,
`id_meta` int(10) unsigned NOT NULL,
`left_column` tinyint(1) NOT NULL DEFAULT '1',
`right_column` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id_theme_meta`),
UNIQUE KEY `id_theme_2` (`id_theme`,`id_meta`),
KEY `id_theme` (`id_theme`),
KEY `id_meta` (`id_meta`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;# MySQL returned an empty result set (i.e. zero rows).


DELETE FROM `ps_theme_meta`;# 34 rows affected.

INSERT INTO `ps_theme_meta` (`id_theme_meta`, `id_theme`, `id_meta`, `left_column`, `right_column`) VALUES
(1, 1, 1, 0, 0),
(2, 1, 2, 1, 0),
(3, 1, 3, 0, 0),
(4, 1, 4, 1, 0),
(5, 1, 5, 1, 0),
(6, 1, 6, 1, 0),
(7, 1, 7, 0, 0),
(8, 1, 8, 1, 0),
(9, 1, 9, 1, 0),
(10, 1, 10, 0, 0),
(11, 1, 11, 0, 0),
(12, 1, 12, 0, 0),
(13, 1, 13, 0, 0),
(14, 1, 14, 0, 0),
(15, 1, 15, 0, 0),
(16, 1, 16, 0[...]

Edited by TESB1980 (see edit history)
Link to comment
Share on other sites
  • 2 weeks later...
Tuinkoken Newbie

Tuinkoken

Posted
Posted

Hallo,

 

I cannot enable the left column on certain pages of my website. I recently upgraded prestashop from 1.5 to 1.6.0.5. When I go to the menu in preferences>themes then  I cannot see the pages like 'product' and 'category'. Instead of those I have list tags, all posts, list posts and post detail. I think my wordpress blog somehow interferred with this upgrade? I also made a screenshot. Thanks for any help.

 

Raymond

post-373140-0-88537000-1396536132_thumb.jpg

post-373140-0-42010500-1396536757_thumb.jpg

Link to comment
Share on other sites
arlys Newbie

arlys

Posted
Posted

I'm getting mad!!

 

I read this post three times and didn't fount the solution for my problem: I can't show left colum on category page.

 

I have checked the option in the back office, I have verifyed that there are no exceptions for this module, and even I have took a look con my DB but it seems is all ok, but it still without work....

 

Is a fresh 1.6 installation

 

my web:

http://www.denuncialegal.es/

 

a category:

http://www.denuncialegal.es/19-denuncias-por-delitos-contra-las-obligaciones-familiares

 

and I attach a capture with all the information

captura.jpg

Link to comment
Share on other sites
Ray UK Collaborator

Ray UK

Posted
Posted (edited)

in the "displayLeftColumn" block, click Modify ( to the right of the module )

Then click "Manage Hooks" at the top of the page.

Make sure "Product page" is not selected.

Most of my modules were hidden when I upgraded, and this seemed to be the cause of a lot of the problems.

 

The hooks from the previous version seem to clash with something and dont copy over during the upgrade :(

just another ps16 bug to add to the many others :/

Edited by MerseyRay (see edit history)
Link to comment
Share on other sites
  • 8 months later...
  • 4 weeks later...
StudioJP Newbie

StudioJP

Posted
Posted (edited)

have you got category page under preferences > seo & urls ?

Hi,

 

Same problem with brand new installed 1.6.0.11: Lack of "category" in preference> themes.

 

No, there is no 'category' under preferences > seo&url, as well as 'product'. Moreover, no way to add these pages - the're not available on 'Add' list. 

 

Any suggestions? ps_meta and ps_theme_meta tables are OK.

Edited by StudioJP (see edit history)
Link to comment
Share on other sites
Jacob M Newbie

Jacob M

Posted
Posted (edited)

Hi,

 

Same problem with brand new installed 1.6.0.11: Lack of "category" in preference> themes.

 

No, there is no 'category' under preferences > seo&url, as well as 'product'. Moreover, no way to add these pages - the're not available on 'Add' list. 

 

Any suggestions? ps_meta and ps_theme_meta tables are OK.

Same problem here. No "Product" in preferences > seo url or in Theme configuration.

_____________________________________

 

Ok, executing query from here http://mypresta.eu/en/art/prestashop-16/an-error-occured-while-updating-this-meta.html did not helped.

 

Manually adding this:

 

id_theme_meta=  id_theme=8  id_meta=27 left_column=1 right_column=0

id_theme_meta=  id_theme=8  id_meta=28 left_column=1 right_column=0

 

did not helped too.

Edited by Jacob M (see edit history)
Link to comment
Share on other sites
Jacob M Newbie

Jacob M

Posted
Posted

Thanks 

 

Thanks it run    :P  :P  :P  :P

Yes ! Finally. It worked for me too. Now i can see product and cms in preferences > SEO & URL but i still can't see it in theme configuration. But the left column appears on product pages and cms pages in my shop.

 

Thank You veika.

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...