7145 replies to this topic

[ianhaney]

Hi Jack

I did the http://www.irhtoys.co.uk/headertags_seo_uninstall.php and got the following error

1091 - Can't DROP 'products_head_title_tag'; check that column/key exists

ALTER TABLE products_description DROP products_head_title_tag

[TEP STOP]

So I did the http://www.irhtoys.co.uk/headertags_seo_install.php and got the following error

1048 - Column 'set_function' cannot be null

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES (NULL,'Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set the limits for the keyword density use to dynamically select the keywords. Enter two figures, separated by a comma', '543', '54', NULL, now(), NULL)

[TEP STOP]

I am really stuck with this add on, I don't know what to do as is a good add on and will help the seo for the website

[14steve14]

Ian

I had a similar problem to your 1048 - Column 'set_function' cannot be null problem. I know i did something in the database but have no idea what it was unfortunately. It had something to do with the way the database was set up, and needed something changing to do with how it handles null.

If i can remember where the post was i will let you know.

[ianhaney]

yeah that would be great Steve

Thank you so much

frustrating as it looks a really good add on and could help in the seo

[14steve14]

Ian you are right it does help. I have the file somewhere, i will try to look it out.

[ianhaney]

Hi Steve

I found this post

http://forums.oscommerce.com/topic/370724-database-optimizer/page__st__40

and followed the advice on there to remove the default NULL so I removed all the NULL from the keyword density range section and got this error

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set ' at line 1

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES (,'Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set the limits for the keyword density use to dynamically select the keywords. Enter two figures, separated by a comma', '543', '54', now()

[TEP STOP]

I am going to give up in a minute on this add on

[ianhaney]

yeah thank you for looking appreciate it

I really hope I can get this add on working

[Jack_mcs]

ianhaney, on 21 June 2012 - 04:05 PM, said:

Hi Steve

I found this post

http://forums.oscommerce.com/topic/370724-database-optimizer/page__st__40

and followed the advice on there to remove the default NULL so I removed all the NULL from the keyword density range section and got this error

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set ' at line 1

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES (,'Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set the limits for the keyword density use to dynamically select the keywords. Enter two figures, separated by a comma', '543', '54', now()

[TEP STOP]

I am going to give up in a minute on this add on

The following should work:

 
[b]INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function) VALUES (NULL,'Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set the limits for the keyword density use to dynamically select the keywords. Enter two figures, separated by a comma', '543', '54', now(), NULL)[/b]
Edit the sql and remove DEFAULT NULL from the set_function line

However, there will probably be others. The best thing to do is to edit your database and change the entry for set_function in the configuration table to have a default setting of NULL.

[ianhaney]

Ok I have copied the following line from above Jack and put it in the headertags_seo_install.php file and uploaded that again to the web server


INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function) VALUES (NULL,'Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set the limits for the keyword density use to dynamically select the keywords. Enter two figures, separated by a comma', '543', '54', now(), NULL)

I then went into my database and into the configuration table and gave the set_function a default of NULL and tried to run the http://www.irhtoys.co.uk/headertags_seo_install.php again but still got the same error - see below

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function) VALUES (NULL,'Keyword Density Range', 'HEADER_TAGS_KEYWORD_DENSITY_RANGE', '0.02,0.06', 'Set the limits for the keyword density use to dynamically select the keywords. Enter two figures, separated by a comma', '543', '54', now(), NULL

[TEP STOP]

Edited by ianhaney, 21 June 2012 - 04:48 PM.

[Cheloki]

Hello
My problem is with the option "fill tag", I have installed 10 languages, and attempting to fill the choices of categories, products, manufacturers etc ... to "fill tags" below choose the language, but it changed for another, if I keep them in Spanish, German saved me, if I keep it in French, Spanish saved me, and so with several languages.
The text says this:
  languages in the Header Tags table are: 6 ( русс ).   languages in the Header Tags table are: 9 ( Chino ).   languages in the Header Tags table are: 10 ( japones ).   languages in the Header Tags table are: 7 ( Svenskt ).   languages in the Header Tags table are: 1 ( English ).   languages in the Header Tags table are: 8 ( norske ).   languages in the Header Tags table are: 5 ( Italiano ).   languages in the Header Tags table are: 2 ( Español ).   languages in the Header Tags table are: 4 ( français ).



Curiously, here is changed the order of languages, because the admin is another order. Neither option works me "Description: (page)" tab of "fill tags", has any idea what could it be?
Thank you very much for the help
Chelo

[Jack_mcs]

ianhaney, on 21 June 2012 - 04:45 PM, said:

Ok I have copied the following line from above Jack and put it in the headertags_seo_install.php file and uploaded that again to the web server

That won't work. The code I posted is for directly changing the database. The code in the install file requires a different format. But now that you have changed the database, you should be able to run the uninstall and the original install file successfully.

[Jack_mcs]

Cheloki, on 21 June 2012 - 05:24 PM, said:

Hello
My problem is with the option "fill tag", I have installed 10 languages, and attempting to fill the choices of categories, products, manufacturers etc ...

Curiously, here is changed the order of languages, because the admin is another order. Neither option works me "Description: (page)" tab of "fill tags", has any idea what could it be?

I'm sorry but I can't understand the question. But is there a reason why you don't just use the All Languages option? I tried filling the languages in my setup here, both with all and with each language and didn't have any problems. That's not to say there isn't one but I can't see it if there is.

[ianhaney]

Well Jack I actually got a succesfully installed message after uploading the orginal headertags_seo_install.php file

Is it ok to keep you up to date only if I get any errors or stuck at any point but will try to work it out for myself first

[ianhaney]

Should I be using the instructions in 3.2.6 version as they seem to be for users that have STS or BTS stores and I have neither as I dont have any of the following on my web server


Your shop is an STS shop if there is an includes/sts_templates/ directory.
   Your shop is a BTS shop if there is a templates directory in the root directory.

What instructions would you recommend to use Jack

I have uploaded all the files from the version 3.2.6

Edited by ianhaney, 21 June 2012 - 06:04 PM.

[ianhaney]

Can I upload the files from the version 3.2.7 and use them instructions as well that come with the version 3.2.7

Would they be ok to use

[ianhaney]

all done and sorted, it works perfect now, I love it

After all that it was well worth it

Thank you so much Jack for all your help

[Cheloki]

Hi JaCk;
First, sorry for not speaking your language up correctly. I'll see if I can explain better. I completed the installation of the Header tags automatically, in a clean oscommerce, but additional languages ​​after the installation went, and had to install and uninstall the header tags several times. Each time you reinstall, change the order of languages​​, according to the test header tags, right now, I test this order;
languages in the Header Tags table are: 6 ( русс ).
languages in the Header Tags table are: 9 ( Chino ).
languages in the Header Tags table are: 10 ( japones ).
languages in the Header Tags table are: 7 ( Svenskt ).
languages in the Header Tags table are: 1 ( English ).
languages in the Header Tags table are: 8 ( norske ).
languages in the Header Tags table are: 5 ( Italiano ).
languages in the Header Tags table are: 2 ( Español ).
languages in the Header Tags table are: 4 ( français ).
But in reality, the actual order in the admin would be as follows;
1 ( English ).
2(Alemán)
3 ( français ).
4 ( Español )
5 ( Italiano )
6 ( русс )
7 ( Svenskt )
8 ( norske )
9 ( japones ).
10 ( Chino ).
The problem is that when filling options "fill tags", exchange content between languages, in the order indicated by the test header tags, meaning that the French appear in Spanish, the Spanish text appears in the German, etc ...
Besides, if I try to fill in the "fill tags" option "Description: (page)",I get this option is not reflected, not saved.
Probably if automatically install everything, solve everything, my problem is that I had finished the whole page with other things and have to start over other vez.Y cost me four months to finish it .... I am not a programmer, I hard time installing things ... I would appreciate any help
thanks
Cheloki

Edited by Cheloki, 22 June 2012 - 04:58 AM.

[Jack_mcs]

Cheloki, on 22 June 2012 - 04:56 AM, said:

First, sorry for not speaking your language up correctly. I'll see if I can explain better. I completed the installation of the Header tags automatically, in a clean oscommerce, but additional languages ​​after the installation went, and had to install and uninstall the header tags several times. Each time you reinstall, change the order of languages​​, according to the test header tags, right now, I test this order;

No need to apologize. I was just stating the problem I was having. It sounds like there is a problem with your language ID's but it would be too much to try to talk you through troubleshooting it so I won't be able to help.

[shawnkm]

Thank you to Jack for this great contribution!  Quick question...

I am using version OSCommerce version 2.2 MS2, so I am using instructions from "Use_if_version_lessthan_2.3" and having trouble getting it running correctly, so I was digging around to see if I could make it work.

I noticed something in the folder "catalog_for_new_shop_only_RC2"

In the Install_Admin.txt the first instruction says:

------

In admin/includes/function/general.php before the last ?>,

ADD:

  /*** Begin Header Tags SEO ***/
  require('includes/functions/header_tags_general.php');
  /*** End Header Tags SEO ***/
------

However the file header_tags_general.php is not contained in the directory: catalog_for_new_shop_only_RC2/admin/includes/functions/

The only file listed is general.php

I realize that header_tags_general.php is listed in the MS2 folder, but not in the RC2, but the install instructions are the same for both versions.  So, my question is if I am running MS2, do I need to commit out:

  require('includes/functions/header_tags_general.php');

I can't get MS2 admin to work unless I commit it out.  If I do commit it out, then it kind of works, but having trouble in the admin when editing a product in admin/categories.php  It does not load the page completely and has text like TEXT_PRODUCTS_LISTING_TEXT.  I am thinking the instructions is missing something.

Thank you in advance for the help!
Shawn

Edited by shawnkm, 24 June 2012 - 01:48 PM.

[Jack_mcs]

shawnkm, on 24 June 2012 - 01:39 PM, said:

However the file header_tags_general.php is not contained in the directory: catalog_for_new_shop_only_RC2/admin/includes/functions/

The only file listed is general.php

I realize that header_tags_general.php is listed in the MS2 folder, but not in the RC2, but the install instructions are the same for both versions.  So, my question is if I am running MS2, do I need to commit out:

  require('includes/functions/header_tags_general.php');

I can't get MS2 admin to work unless I commit it out.  If I do commit it out, then it kind of works, but having trouble in the admin when editing a product in admin/categories.php  It does not load the page completely and has text like TEXT_PRODUCTS_LISTING_TEXT.  I am thinking the instructions is missing something.

Thank you in advance for the help!
Shawn

The instructions state, "Upload all of the files in the included catalog directory." It sounds like you didn't do that. Instructions for MS2 shops were removed a version or two ago. The only difference, with regards to Header Tags SEO, between an MS2 and RC2 shop are the includes/application_top.php files so you will need to make those changes manually.

[shawnkm]

OK I may be getting somewhere with this problem.  I am running on a windows test machine using WAMPSERVER before I go live with it.

I double check my hacks and they are all correct.  I tested my uploads four times and they were all correct as well.  When I run the test, I get these results:
Permissions Error:  explain Cannot find file /mytestsite/emptyadmin/123admin/header_tags_seo.php. Cannot find file /mytestsite/emptyadmin/123admin/header_tags_fill_tags.php. Cannot find file /mytestsite/emptyadmin/123admin/includes/header_tags_seo_words.txt. Cannot find file /mytestsite/emptyadmin/123admin/includes/functions/header_tags.php. Cannot find file /mytestsite/emptyadmin/123admin/includes/boxes/header_tags_seo.php. Cannot find file /mytestsite/emptyadmin/123admin/includes/languages/english/header_tags_seo.php.

My root admin folder is 123admin.  /mytestsite/emptyadmin/123admin

Without a shadow of a doubt those files are there.

It seems as though everything is working when I commit out:

require('includes/functions/header_tags_general.php');

in admin/includes/functions/general.php the admin site works perfectly, if I don't commit it out, the admin will not load any page.

Any help or advise would be greatly appreciated.