Header Tags Controller

[Guest]

Hello,

 

I am a little confused on exactly where to install the header.sql code for contribution Header Tags Controller. It mentions in the database. Can someone give me step by step instructions for this part? The rest seems straight forward.

 

Thanks for the support!

[bobg7]

If you have access to phpMy Admin, click on the Query Window and Import files. Or you can get the SQL Updater in Admin contribution. For me the SQL Updater in Admin contribution is faster and easier to use to import SQL updates.

 

Bob G.

[Jack_mcs]

Hello,

 

I am a little confused on exactly where to install the header.sql code for contribution Header Tags Controller. It mentions in the database. Can someone give me step by step instructions for this part? The rest seems straight forward.

 

Thanks for the support!

<{POST_SNAPBACK}>

You could also use the database_setup.php file. Just:

 

- upload it to your server

- visit the page (www.yoursite.com/database_setup.php)

- delete from your server

 

All done.

 

Jack

[Guest]

You could also use the database_setup.php file.  Just:

 

- upload it to your server

- visit the page (www.yoursite.com/database_setup.php)

- delete from your server

 

All done.

 

Jack

<{POST_SNAPBACK}>

 

 

Hi Jack,

 

I don't have that path to (www.yoursite.com/database_setup.php).

Any other advice?

Also, What do you mean by delete? the database_setup.php?

[Jack_mcs]

www.yoursite.com = your site .com

 

Yes, after you use the file, it should be deleted since it is no longer needed.

 

Jack

[Guest]

www.yoursite.com = your site .com

 

Yes, after you use the file, it should be deleted since it is no longer needed.

 

Jack

<{POST_SNAPBACK}>

 

 

Yes, I understand the www.yoursite.com = your site .com but not the /database_setup.php. when I try to go to www.moanagifts.com/database_setup.php it does not exist. I am still low tech so we maybe on two different wavelengths. I am lost on your advice maybe try to give it to me step by step if you have time.

 

Thanks for your help

[Jack_mcs]

The database_setup.php file is part of the Header Tags contribution. You need to take the file from there, upload it to your serever (where your shop is located), execute it by just opening the page, then delete the file from the server.

 

Jack

[Guest]

The database_setup.php file is part of the Header Tags contribution.  You need to take the file from there, upload it to your serever (where your shop is located), execute it by just opening the page, then delete the file from the server.

 

Jack

<{POST_SNAPBACK}>

 

 

Hi Jack,

 

I am installing Header Tags Controller v2.3.3 I don't see a database_setup.php file.

But I do see a database_tables.php in admin/includes.

I followed Bob G.'s advice and used the SQL Updater in Admin contribution seems to be ok accept when I go to admin and want to edit products I get this error:

 

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 products p, products_description pd where p.products_id = '217' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

 

Any idea what I did wrong?

 

Thanks again for the tremendous support!

[ozcsys]

Hi Jack,

 

I am installing Header Tags Controller v2.3.3 I don't see a database_setup.php file.

But I do see a database_tables.php in admin/includes.

I followed Bob G.'s advice and used the SQL Updater in Admin contribution seems to be ok accept when I go to admin and want to edit products I get this error:

 

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 products p, products_description pd where p.products_id = '217' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

 

Any idea what I did wrong?

 

Thanks again for the tremendous support!

<{POST_SNAPBACK}>

 

It means your database did not get updated. From your hosting control panel go to where you created your database and find a link for phpmyadmin, then choose your database, click on the sql tab at the top, click on the browse button then browse to the file and run it. Done.

[Jack_mcs]

Hi Jack,

 

I am installing Header Tags Controller v2.3.3 I don't see a database_setup.php file.

But I do see a database_tables.php in admin/includes.

I followed Bob G.'s advice and used the SQL Updater in Admin contribution seems to be ok accept when I go to admin and want to edit products I get this error:

 

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 products p, products_description pd where p.products_id = '217' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

 

Any idea what I did wrong?

 

Thanks again for the tremendous support!

<{POST_SNAPBACK}>

Why would install an outdated version? Anyway, if you look in the latest version, the file is in there. It is compatible with the version you are using if you are still having problems.

 

Jack

[Guest]

All is working fine now. A big thanks goes out to Jack and Richard. You guys know your stuff