Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Google position contribution


funkyneil

Recommended Posts

Hi all,

 

http://www.oscommerce.com/community/contri...l/search,google

 

has anyone used this before?

 

I'm getting error messages that read like this

 

Warning: fopen("http://www.google.com/search?as_q=mysitename&num=10&hl=en&ie=UTF-8&btnG=Google+Search&as_epq=&as_oq=&as_eq=&lr=&as_ft=i&as_filetype=&as_qdr=all&as_nlo=&as_nhi=&as_occt=any&as_dt=i&as_sitesearch=&safe=images&start=0", "r") - Success in /home/mysitename/public_html/catalog/admin/google_position.php on line 72

Unable to open remote file http://www.google.com/search?as_q=mysitena...=images&start=0. Warning: Supplied argument is not a valid File-Handle resource in /home/mysitename/public_html/catalog/admin/google_position.php on line 130

Link to comment
Share on other sites

I'm the author and I tested it in two different shops before uploading. Did you create the database table? The posted error shows the search term to be mysitename. What words and url are you using to test it? You can send these to me via email if you prefer not posting it here. I can't imagine it would make a difference but that's all I can think of ATM.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I installed it about 15 minutes ago and it works as advertised. I did not find any bugs or errors in the instructions and it executes properly. I may not like the results ;) but this contribution works just fine.

 

B)

Link to comment
Share on other sites

I'm the author and I tested it in two different shops before uploading.  Did you create the database table?  The posted error shows the search term to be mysitename.  What words and url are you using to test it?  You can send these to me via email if you prefer not posting it here.  I can't imagine it would make a difference but that's all I can think of ATM. 

 

Jack

I copied the error message and replaced the actual www.site name.com with "my site name" before posting.

 

I've got the table in there, here's the export so you can see it

 

#
CREATE TABLE `google` (
?`date` datetime NOT NULL default '0000-00-00 00:00:00',
?`search_url` varchar(100) default NULL,
?`search_term` varchar(50) default NULL,
?`rank` int(4) default '0',
?`sites_searched` tinyint(4) default '0',
?`show_results` tinyint(4) default '0'
) TYPE=MyISAM;

#
# Dumping data for table `google`
#

INSERT INTO `google` VALUES ('2004-08-11 14:59:44', 'www.mysite.co.uk', 'fashion', 99999, 10, 1);
? ?

 

 

I will go back and check I've followed all instructions properly and then i will post back my findings / success

Edited by funkyneil
Link to comment
Share on other sites

Hi Jack B)

 

I have this working in my store, works fine.

 

A little suggestion for the next release, what about adding a number of searchwords, and getting a report per word. WOuld be hlpful if it you could also search Yahoo, Lycos etc. etc.

 

Regards

Raj Bangar

SimplySpice

Link to comment
Share on other sites

7) Add the following to admin/includes/boxes/tools.php before the final ?>

  '<a href="' . tep_href_link(FILENAME_GOOGLE_POSITION) . '" class="menuBoxContentLink">' . BOX_TOOLS_GOOGLE_POSITION . '</a><br>' .

 

i think this bit may have caught me out, i put it before the ?> but then an echo before and ; after that cos it didn't make sense

Link to comment
Share on other sites

Drop the google table out of the database and run the original sql file again.

 

It might have something to do with you inserting 99999

 

where the `rank` int(4) default '0',

 

I could be wrong!

 

Mark

Lifes a bitch, then you marry one, then you die!

Link to comment
Share on other sites

She canna tek it capan

 

she dunner av te powah capan

 

same errors again I'm afriad

 

Theoretically if its working for everyones else I must not have followed the instructions properly, but i have just done it twice in a row now :|

Link to comment
Share on other sites

The '99999' is in the contribution's SQL instruction

 

Step 7 should be changed to read so that you enter the link in admin/includes/boxes/tools.php on the line just BEFORE the last existing entry, not before the closing ?> (the last entry before the closing ?> ends with a right parenthesis and a semi-colon)

 

Other than that, it seems to work fine in my installation

... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Link to comment
Share on other sites

Hi there,

 

I get the same errormessage as "funkyneil" , i have not done the total errorcheck runthrough yet....but initially because some get it and some dont.....i would hazzard a guess that it is conected to if you have your admin in ssl or not.....

 

Mine is in ssl ......

Link to comment
Share on other sites

Just tested with and without ssl , same error message..... Well that just means i have to look harder....lol

 

Unless someone out there already has found a solution?

Link to comment
Share on other sites

She canna tek it capan

 

she dunner av te powah capan

 

same errors again I'm afriad

 

Theoretically if its working for everyones else I must not have followed the instructions properly, but i have just done it twice in a row now :|

As Stuart mentioned, there is a mistake in step 7. It says

7) Add the following to admin/includes/boxes/tools.php before the final ?>

  '<a href="' . tep_href_link(FILENAME_GOOGLE_POSITION) . '" class="menuBoxContentLink">' . BOX_TOOLS_GOOGLE_POSITION . '</a><br>' .

This is not correct. It should be
7) Find the line in admin/includes/boxes/tools.php that reads

'<a href="' . tep_href_link(FILENAME_FILE_MANAGER) . '" class="menuBoxContentLink">' . BOX_TOOLS_FILE_MANAGER . '</a><br>' .

 

and insert the following code after it:

                           

'<a href="' . tep_href_link(FILENAME_GOOGLE_POSITION) . '" class="menuBoxContentLink">' . BOX_TOOLS_GOOGLE_POSITION . '</a><br>' .

Sorry for the confusion. Make this correction and see if that helps.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Hi Jack B)

 

I have this working in my store, works fine.

 

A little suggestion for the next release, what about adding a number of searchwords, and getting a report per word. WOuld be hlpful if it you could also search Yahoo, Lycos etc. etc.

 

Regards

Raj Bangar

SimplySpice

Thanks for the suggestion Raj.

 

Each unique search word is recorded in the database. Putting a dropdown list to display them is probably a good idea.

 

I've got the code for Yahoo but haven't had time to implement it yet.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I just tried checking your location using my shop and it came back at position 1. Are you using ssl in admin like someone else suggested? Did you see the change I made to step 7?

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I just tried checking your location using my shop and it came back at position 1. Are you using ssl in admin like someone else suggested? Did you see the change I made to step 7?

 

Jack

Thanks for your help.

 

I checked step 7 and it is done correctly. The same error occurs when using ssl or not.

 

Any further suggestions are appreciated.

Link to comment
Share on other sites

Google Position

The site motorcycle.com is not in the top 10 for the term motorcycle

?

This is not true.

This contribution causes very specific results to be returned. If you look for thisdomain.com and the Google results are www.thisdomain.com, you will get an answer that it's not in the top 'X' results even if it appears as #1 when you do the search on Google

... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Link to comment
Share on other sites

LOLOL :lol:

I've been accused before of making a good point null ;)

... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Link to comment
Share on other sites

Ahh, yes. Stuart makes a good point Null. Did you type in www.motorcycle.com or motorcycle.com?

 

Jack

I tried it both ways - www.motorcycle.com and motorcycle.com.

 

Something is not working properly as the error message:

Unable to open remote file http://www.google.com/search?as_q=motorcyc...=images&start=0.

appears at the top of the page.

 

If I cut and paste the link directly into another browser window, the correct google page is called up.

 

What causes this error message to appear?

 

Thanks.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...