meta description, keywords

[mezzodi]

how can i change the meta tags, description, keywords, etc. in the osCommerce html code? is there a user friendly way to do this, or do i need to change the original html?

 

:rolleyes:

[Jack_mcs]

The easiest way is to add the Header Tags contribution.

 

Jack

[gashead]

I have downloaded the header tag controller 2.3.7, and follow the instructions for autoinstall, the script works and generates appication_top.php_copy, and many files in the edited files folder.

 

I then uploaded the files above to the loacation specified in the autoinstall readme.txt.

 

I then uploaded the 2 folders (admin, includes) to my shop.

 

My shop is still working ok, But I'm not sure what to do next?

[ozcsys]

I have downloaded the header tag controller 2.3.7, and follow the instructions for autoinstall, the script works and generates appication_top.php_copy, and many files in the edited files folder.

 

I then uploaded the files above to the loacation specified in the autoinstall readme.txt.

 

I then uploaded the 2 folders (admin, includes) to my shop.

 

My shop is still working ok, But I'm not sure what to do next?

<{POST_SNAPBACK}>

 

You can add product specific tags by editing the new fields in your admin -> edit product. You can add site wide tags by going to the includes/languages/english/header_tags.php file.

[gashead]

You can add product specific tags by editing the new fields in your admin -> edit product. You can add site wide tags by going to the includes/languages/english/header_tags.php file.

<{POST_SNAPBACK}>

 

Thanks I can edit the site wide tags ok by editing the header_tags.php file

 

but I can't access my products at all I get this message

 

1054 - Unknown column 'pd.products_head_title_tag' in 'field list'

 

select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from oscommerce_products p, oscommerce_products_description pd where p.products_id = '28' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

 

Any Ideas

[Jack_mcs]

It doesn't sound like you finished the installation. You also have to upload a file to your database and make some code changes in admin. Did you do those?

 

Jack

[gashead]

It doesn't sound like you finished the installation.  You also have to upload a file to your database and make some code changes in admin.  Did you do those?

 

Jack

<{POST_SNAPBACK}>

 

Nope didn't do those

 

How do i upload the file to my database. Is it header.sql?

[Jack_mcs]

There are two easy ways. First, if you have phpmyadmin, you can upload the header.sql file. Second, you can use the database_setup.php file (only included with the latest version). Just copy the file to your site and then go to it with your browser. It will do the rest.

 

Jack

[gashead]

There are two easy ways.  First, if you have phpmyadmin, you can upload the header.sql file.  Second, you can use the database_setup.php file (only included with the latest version).  Just copy the file to your site and then go to it with your browser.  It will do the rest.

 

Jack

<{POST_SNAPBACK}>

 

hi,

 

I have made all the changes in readme to admin, I have tried running database_setup.php through the browers, but I get this message:

 

Warning: session_start(): open(/data/session/sess_a85ed008c2f52e3f7e87f9d6d6eed68c, O_RDWR) failed: Permission denied (13) in /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php on line 67

 

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php:67) in /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php on line 67

 

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php:67) in /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php on line 67

1146 - Table 'wherebis_com_1.products_description' doesn't exist

 

select * from products_description

 

[TEP STOP]

 

 

Warning: Unknown(): open(/data/session/sess_a85ed008c2f52e3f7e87f9d6d6eed68c, O_RDWR) failed: Permission denied (13) in Unknown on line 0

 

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/data/session) in Unknown on line 0

 

Any ideas also when I access my product and edit the the bottom of the page contains this error

 

TEXT_PRODUCT_METTA_INFO

 

Products Page Title: 1054 - Unknown column 'products_head_title_tag' in 'field list'

 

select products_head_title_tag from oscommerce_products_description where products_id = '0' and language_id = '1'

 

[TEP STOP]

[gashead]

hi,

 

I have made all the changes in readme to admin, I have tried running database_setup.php through the browers, but I get this message:

 

Warning: session_start(): open(/data/session/sess_a85ed008c2f52e3f7e87f9d6d6eed68c, O_RDWR) failed: Permission denied (13) in /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php on line 67

 

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php:67) in /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php on line 67

 

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php:67) in /data/members/paid/w/h/wherebis.com/htdocs/www/includes/functions/sessions.php on line 67

1146 - Table 'wherebis_com_1.products_description' doesn't exist

 

select * from products_description

 

[TEP STOP]

Warning: Unknown(): open(/data/session/sess_a85ed008c2f52e3f7e87f9d6d6eed68c, O_RDWR) failed: Permission denied (13) in Unknown on line 0

 

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/data/session) in Unknown on line 0

 

Any ideas also when I access my product and edit the the bottom of the page contains this error

 

TEXT_PRODUCT_METTA_INFO

 

Products Page Title:  1054 - Unknown column 'products_head_title_tag' in 'field list'

 

select products_head_title_tag from oscommerce_products_description where products_id = '0' and language_id = '1'

 

[TEP STOP]

<{POST_SNAPBACK}>

 

I also don't seem to have this code in the admin/catagories.php

 

Find the following (approx line 603)

 

 $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id  from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");
     $product = tep_db_fetch_array($product_query);

 

I have this at at line 291

 

 $product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");
           $product = tep_db_fetch_array($product_query);

 

and this at line 379

 $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");
     $product = tep_db_fetch_array($product_query);

 

and this at line 663

 

 

      $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id  from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'");
     $product = tep_db_fetch_array($product_query);

 

 

Any Idea's Please

[Jack_mcs]

If you don't have those items in the files and the instructions say to put them in the files, doesn't that mean you didn't do it?

 

Jack

[gashead]

If you don't have those items in the files and the instructions say to put them in the files, doesn't that mean you didn't do it?

 

Jack

<{POST_SNAPBACK}>

I know I making hard work of this but the instruction says to

Find the following (approx line 603) and replace it with other code

 

$product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");

$product = tep_db_fetch_array($product_query);

 

Which doesn't seem to in the file.

 

The code i listed above is the near in previous message is the nearest i can find

[Jack_mcs]

Find the following (approx line 603)

 

$product_query = tep_db_query("select p.products_id,

 

I have this at at line 291

 

$product_query = tep_db_query("select products_quantity,

 

and this at line 379

 

$product_query = tep_db_query("select pd.products_name, 

 

and this at line 663

 

$product_query = tep_db_query("select p.products_id,

Take a closer look at what the instructions said. Here is a partial quote from what you said above. Can you see the problem?

 

Jack