Admin: Categories / Products Error

[seelumirun]

Sorry if this has been posted previously, but I was unable to find a solution using the forum search, and any possibly relevant solutions in the known bugs database either didn't work or broke the install even more.

 

I'm using a clean install with only the STS module and my own skin files (html and image files) added. I've already tried deleting everything and reinstalling. After a fresh install, there is no error, but once I add STS and my skin files the error appears.

 

I haven't added any products. Only the sample categories and products are in the database, and they're still displaying properly in the catalog portion of the site. I just can't edit them in the admin portion.

 

In the Categories / Products section of the Catalog admin panel, the following error is displayed:

 

1054 - Unknown column 'cd.categories_htc_title_tag' in 'field list'

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

[TEP STOP]

 

As mentioned above, the fixes for other 1054 errors dont appear to work.

 

Thanks very much,

 

Jon

[wheeloftime]

Sorry if this has been posted previously, but I was unable to find a solution using the forum search, and any possibly relevant solutions in the known bugs database either didn't work or broke the install even more.

 

I'm using a clean install with only the STS module and my own skin files (html and image files) added. I've already tried deleting everything and reinstalling. After a fresh install, there is no error, but once I add STS and my skin files the error appears.

 

I haven't added any products. Only the sample categories and products are in the database, and they're still displaying properly in the catalog portion of the site. I just can't edit them in the admin portion.

 

In the Categories / Products section of the Catalog admin panel, the following error is displayed:

 

1054 - Unknown column 'cd.categories_htc_title_tag' in 'field list'

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

[TEP STOP]

 

As mentioned above, the fixes for other 1054 errors dont appear to work.

 

Thanks very much,

 

Jon

It looks like some mixup with the header tag control contribution. Have you been trying that and/or which STS version are you working with ?

[seelumirun]

It looks like some mixup with the header tag control contribution. Have you been trying that and/or which STS version are you working with ?

 

STS 4.3.3. It looks like the STS install I used does include Header Tags Controller.

 

There's a Header Tags section of the Admin panel... in it, it lists the following two errors:

 

Permissions settings for the /home/luminum/artneedlepoint.com/includes/header_tags.php file appear to be incorrect

 

Permissions settings for the /home/luminum/artneedlepoint.com/includes/languages/english/header_tags.php file appear to be incorrect

 

What should I change the permissions settings to?

[wheeloftime]

STS 4.3.3. It looks like the STS install I used does include Header Tags Controller.

 

There's a Header Tags section of the Admin panel... in it, it lists the following two errors:

 

Permissions settings for the /home/luminum/artneedlepoint.com/includes/header_tags.php file appear to be incorrect

 

Permissions settings for the /home/luminum/artneedlepoint.com/includes/languages/english/header_tags.php file appear to be incorrect

 

What should I change the permissions settings to?

I picked this from the installation instructions for Header Tags 2.6.1

NOTES:

 

1 - It is a vital to make sure two files have the correct permissions to allow the Header Tags

admin to access and change them. The permissions should be set to CHMOD 755 (777 for some

seervers). If you do not know what this is or how to do it, ask your host to help you.

If you get a message about permission denied like this:

----------

THE ERROR

----------

Warning: fopen(../includes/languages/english/header_tags.php):

failed to open stream: Permission denied in /home/xxxxxx/public_html/admin/includes/functions/header_tags.php on line 208

----------

THE FIX

----------

Change the permissions in the following files.

 

catalog/includes/header_tags.php

catalog/includes/languages/english/header_tags.php

 

 

2 - Some hosts restrict a function used in catalog/admin/includes/functions/header_tags.php.

If you get an error regarding the chmod() php function in this file, and you have addressed

the file permission stated above, you may have to comment out the function. The following

will direct you to the problem and provide the solution.

-----------

THE ERROR

-----------

Warning: chmod(): Operation not permitted in /home/xxxxxx/public_html/admin/includes/functions/header_tags.php on line 203

Cannot change the mode of file (../includes/languages/english/header_tags.php)

-----------

THE FIX

-----------

OPEN: catalog/admin/includes/functions/header_tags.php

 

Around line 201 you find this code:

 

if (!is_writable($filename))

{

if (!chmod($filename, 0666)) {

echo "Cannot change the mode of file ($filename)";

exit;

}

}

 

Replce that with the following code:

 

if (!is_writable($filename))

{

echo "The file isn't writable";

exit;

/* if (!chmod($filename, 0666)) {

echo "Cannot change the mode of file ($filename)";

exit;

} */

}

 

So try to change the permissions to 777 and see if the error goes away.

[seelumirun]

I picked this from the installation instructions for Header Tags 2.6.1

So try to change the permissions to 777 and see if the error goes away.

 

The error on the header tags page goes away, but the Catalogs page error doesnt.

 

1054 - Unknown column 'cd.categories_htc_title_tag' in 'field list'

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

 

:(

[wheeloftime]

The error on the header tags page goes away, but the Catalogs page error doesnt.

 

1054 - Unknown column 'cd.categories_htc_title_tag' in 'field list'

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

 

:(

No, that is because you didn't fully install the HTC contribution going with this STS version.

Read the installation instructions and find the part, and file, where you have to apply some database changes. The categories_htc_title_tag field is just one of them. If I look through the provided header.sql file I see:

ALTER TABLE products_description ADD products_head_title_tag VARCHAR(80) NULL;
ALTER TABLE products_description ADD products_head_desc_tag LONGTEXT NULL;
ALTER TABLE products_description ADD products_head_keywords_tag LONGTEXT NULL;

ALTER TABLE categories_description ADD categories_htc_title_tag VARCHAR(80) NULL;
ALTER TABLE categories_description ADD categories_htc_desc_tag LONGTEXT NULL;
ALTER TABLE categories_description ADD categories_htc_keywords_tag LONGTEXT NULL;
ALTER TABLE categories_description ADD categories_htc_description LONGTEXT NULL;

ALTER TABLE manufacturers_info ADD manufacturers_htc_title_tag VARCHAR(80) NULL;
ALTER TABLE manufacturers_info ADD manufacturers_htc_desc_tag LONGTEXT NULL;
ALTER TABLE manufacturers_info ADD manufacturers_htc_keywords_tag LONGTEXT NULL;
ALTER TABLE manufacturers_info ADD manufacturers_htc_description LONGTEXT NULL;

 

It is essential you follow all the provided steps otherwise you will encounter more errors due to this.

 

HTH

[ocelote]

I'm just answering here to confirm that the solution is to update the sql entries. I'm in the same situation, a clean install of osc + sts with header tags, and the same error, I solved it executing the file database_setup.php (included in the sts STSv4.3.3 pack) in the server.