Froogle Merchant Center merged into GoogleBase

[Woodymon]

Hi,

I ran your sql code but received the following error. What went wrong? Please advise. Thanks.

1146 Table 'dealbyet_zc2.configuration_group' doesn't exist
in:
[SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Note your TABLE Names have a prefix:

dealbyet_zc2.configuration_group'

Prefix is:

dealbyet_zc2

You can edit the SQL to append your prefix (wherever a TABLE name is observed).

But if you copy the existing SQL from a text editor and then paste into Tools >Install SQL patches it should work, without first editing SQL. But do NOT upload. (Install SQL Patches is suppose to auto append you DB table prefix but some issues with different server configurations).

Much previous discussion about this common issue in this thread (and same discussion in Google Sitemap and User Tracking support threads in this forum).

Good luck,
Woody

[NamSingh]

Woody,

Google have started rejecting my feed due to now unsupported field "label" and also they are not allowing the product type to be called "other". I've had a look at the feed and the easiest way to fix is to rename the label field and call it product_type. Have you already done this or should I get hacking code?

[numinix]

Woody,

Google have started rejecting my feed due to now unsupported field "label" and also they are not allowing the product type to be called "other". I've had a look at the feed and the easiest way to fix is to rename the label field and call it product_type. Have you already done this or should I get hacking code?

This member seems to have an idea of how to overcome the product types issue. If someone can implement this, please upload it right away .

[Rupert]

ditto :)
The product type problem is definitely an issue.
Anyone with a hack?
The best solution would be to be able to set the field in the admin as either a category is set up, or by product.

[NamSingh]

The hack is easy, I just forgot to post sorry.

Open up the file googlefroogle.php in thr ROOT folder of your website.

Search for the following and un-comment them as the are no longer supported by Google Products as it's now called and not needed either.

Find

$output["label"] = "product_type";
$output["product_type"] = "product_type";

Replace with

// $output["label"] = "product_type";
// $output["product_type"] = "product_type";

They are around lines 110-111 I think.

[Rupert]

Do you mean:

$output["label"] = "label";
$output["product_type"] = "product_type";

???

[NamSingh]

lol Yes, sorry I used the code from where I was testing, but google want you to use their wordings for the product type which is not possibly or feasible unless you re-organise your own database category names etc.. I'm not at my home machine at the moment so was pasting code from my test file

replace

$output["label"] = "label";
$output["product_type"] = "product_type";

with

// $output["label"] = "label";
// $output["product_type"] = "product_type";

Works fine, my feed got accepted quickly afterwards.

[a_berezin]

Note your TABLE Names have a prefix:

dealbyet_zc2.configuration_group'

Prefix is:

dealbyet_zc2

It not prefix, this name of a database

[dealbyethan.com]

Hi,

This is confusing. I previously run the sql by pasting and sending it in the admin but it didn't work. Can someone please tell me the exact sql code I need to use based on the error I get in order to make the froogle module work on my website? Thanks.

[Woodymon]

Note your TABLE Names have a prefix:
dealbyet_zc2.configuration_group'
Prefix is: dealbyet_zc2

It not prefix, this name of a database

Andrew is of course correct. I'm not dyslexic but the mind was somehow registering the underscore (_) and period (.) in reverse. My apologies.

What is the name of the SQL file you are attempting to patch with and what version of the GoogleFroogle mod?

It appears the SQL patch you may be running is a version updater and not the full SQL patch.

Did you have this mod (or a previous version) installed previously and are trying to upgrade? Or is this suppose to be a fresh install?

Try running googlefroogle.sql (this is the patch for new installs as described in the readme). Then no need to run the other sql patches

Woody