Google Base Feeder Support Thread [OLD]

[wizer]

anyone?

[torvista]

v10.1
I found that accented characters were being corrupted on my hosting (linux, php 5.2) server and not on any test (windows PHP5.3) machines.

To fix this
in google_base.php in the infamous (to me anyway) google_base_sanita function

find

      if (phpversion() >= 5.3) {
        $str = htmlentities($str, ENT_QUOTES | ENT_IGNORE, 'UTF-8');
      } else {
        $str = htmlentities($str);
      }
      return $str; 

and change to

      if (phpversion() >= 5.3) {
        $str = htmlentities($str, ENT_QUOTES | ENT_IGNORE, 'UTF-8');//ENT_IGNORE silently deletes an invalid character
      } else {
        $str = htmlentities($str, ENT_QUOTES, 'UTF-8');//Not having ENT_IGNORE returns an empty string if containing an invalid character
      }
      return $str; 

[gowzel]

v10.1
I found that accented characters were being corrupted on my hosting (linux, php 5.2) server and not on any test (windows PHP5.3) machines.

To fix this
in google_base.php in the infamous (to me anyway) google_base_sanita function

find

      if (phpversion() >= 5.3) {
        $str = htmlentities($str, ENT_QUOTES | ENT_IGNORE, 'UTF-8');
      } else {
        $str = htmlentities($str);
      }
      return $str; 

and change to

      if (phpversion() >= 5.3) {
        $str = htmlentities($str, ENT_QUOTES | ENT_IGNORE, 'UTF-8');//ENT_IGNORE silently deletes an invalid character
      } else {
        $str = htmlentities($str, ENT_QUOTES, 'UTF-8');//Not having ENT_IGNORE returns an empty string if containing an invalid character
      }
      return $str; 

Is that a fix for general ampersands commas signs etc or just accents. I have just entered a couple of hundred products and its not reading the descriptions of any. Example below:

EDIT Now that I have pasted it here I see all the ##, those are spaces in the originals, is that the problem? how can I fix it without edting all the products

LED’s work on a set colour wave length, so if a white bulb is placed in a green
lens it will usually result in a blue-ish light. Therefore it’s important that a direct
colour replacement LED light bulb, ie. green for green, red for red, and white
for white is used.##<div>Shock resistant##</div><div>Produce only a small amount of heat when in use.##</div><div>Use only a fraction of the power used by the standard navigation light bulb##</div><div>Direct BAY15D replacement, can be used in most types of navigation lights.
Offset bayonet fitting with both positive and negative connections through base.##</div><div>Because of this, they will only work one way, so, if after fitting them they do not light, simply change over the + and - terminals in the light fitting.
Fitting the bulb with the terminals the wrong way round will not damage the LED
light bulb.</div><div><br /></div><div><u><b>Buy all 3 colours for only £29.00</b></u></div><div>&nbsp;</div><div>20 LED direct replacement navigation light bulb.##
</div><div>Life expectancy 80,000 - 100,000 hours##</div><div>Power Draw 1.5 Watts##</div><div>Light output 60 Lm / 20 Watts approx##</div><div>Fitting BAY15D##</div><div>Voltage Rating 12 or 24 volts DC##</div><div><br /></div><div>Dimensions:##</div><div>## ##Height 55-60mm##</div><div>## ##Diameter##</div><div>## ## ##Bulb 25mm##</div><div>## ## ##Base 15mm</div><div>&nbsp;</div><div>Light Colours:##</div><div>## ##White##</div><div>## ##Red##</div><div>## ##Green</div>

[gowzel]

Altered it now, got rid of the spaces (###) and divs got rid of the / and it still comes back with 0 description

LED’s work on a set colour wave length, so if a white bulb is placed in a green
lens it will usually result in a blue-ish light. Therefore it’s important that a direct colour replacement LED light bulb, ie. green for green, red for red, and white for white is used.<br />Shock resistant<br />Produce only a small amount of heat when in use.<br />Use only a fraction of the power used by the standard navigation light bulb<br />Direct BAY15D replacement, can be used in most types of navigation lights.
Offset bayonet fitting with both positive and negative connections through base.<br />Because of this, they will only work one way, so, if after fitting them they do not light, simply change over the + and - terminals in the light fitting.
Fitting the bulb with the terminals the wrong way round will not damage the LED
light bulb.<br /><br /><u><b>Buy all 3 colours for only £29.00</b></u><br /><br />20 LED direct replacement navigation light bulb.<br />Life expectancy 80,000 - 100,000 hours<br />Power Draw 1.5 Watts<br />Light output 60 Lm - 20 Watts approx<br />Fitting BAY15D<br />Voltage Rating 12 or 24 volts DC<br /><br />Dimensions:<br />Height 55-60mm<br />Diameter<br />Bulb 25mm<br />Base 15mm<br /><br />Light Colours:<br />White<br />Red<br />Green

[gowzel]

Well after a couple of hours playing with this, I really dont understand it at all. The word lens caused it to fail, that is until I deleted it and typed it in then it passed. Pasted a few more words in and it failed again. What is so difficult with this??

[Justwade]

I would like to get this contribution back on my site. I had not upgraded from google base 1.3.7a apparently, never used it for a long time.

I have Zen 1.3.9h, went back and found the sql unistall for 1.3.7a beings all the updates seem to not go back that far. I backed up,
copied the uninstall into admin and ran, but google still shows in my admin for the settings.

Based on what I am reading, I think I should install 1.3.91 for now until some changes are updated, is that sound ok?
Then does anyone think that my new store can just take the new files ( I never merged the php over) and copy up just the new SQL? Or how would I update SQL?

Or is that pesky admin setting that still show up mean I may mess up my DB?

[delia]

Or is that pesky admin setting that still show up mean I may mess up my DB?

If you are talking about the settings under configuration, the install sql will probably not run completely. The only way to completely rid yourself of that is to go into the database itself.

Using phpmyadmin or similar interface, first, look at your configuration groups table and find the one for the feeder. Note the group id for it.

Then go to the configuration table. Do a search for that group id and then delete what shows up. You can also then delete that group id in the groups table.

Suggestion though: also do a search in the config table for a group id of 0. If you have results, check to see if any of those look like they are for the feeder. If so , delete them. If you have others, they also may need deleting. Having a group id of 0 means those settings don't show up in the admin and are usually from botched installs. I have had to do this for the google feeder install before.