Froogle Merchant Center merged into GoogleBase

iI have just upgraded Zen from 1.3.2 to 1.3.6 and noticed that my Google Froogle feeder SQL file that had been used to install 1.3.2 was 1_2_6. I have downloaded the latest version of this MOD but I am having problems.

I have not seen an upgrade path in this thread or in the instructions and doing what I thought was obvious did not work. (Replace the old files with the new and run the SQl scripts)
When I run 1_2_9 SQl script I get the following 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 'id', 'model', 'false'),' WHERE configuration_key='GOOGLE_FROOGLE
in:
[UPDATE configuration SET configuration_title='Offer ID', configuration_description='A unique alphanumeric identifier for the item - products_id code.
Based on products_id or products_model', set_function='zen_cfg_select_option(array('id', 'model', 'false'),' WHERE configuration_key='GOOGLE_FROOGLE_OFFER_ID';]
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.

and something similar on the 1_3_1 scripts.
Any help is appreciated.
ZEN 1.3.6
PHP 4.4.3
MySQL 4.1.14 on Windows 2003

CBO, you only get SQL errors when you do this, can I see the old sql file, I don't know where to find the old versions of googlefroogle.

Pete

Try running the full googlefroogle.sql rather than the version-specific ones - which are only partial SQL updates.

Remember to write down your Froogle settings first - the full SQL will drop (ie. delete) the current settings and create new ones which you will then need to edit in the config of the mod in admin.

You can get the latest version (v 1.3.1) from Andrew's site - see the link in his signature.

kebeid:

CBO, you only get SQL errors when you do this, can I see the old sql file, I don't know where to find the old versions of googlefroogle.

Pete

Here is the SQL file that I used...........

UPDATE configuration SET configuration_title='The shipping options available for an item', configuration_value='', configuration_description='The shipping options available for an item' set_function='' WHERE configuration_key='GOOGLE_FROOGLE_SHIPPING';
UPDATE configuration SET configuration_title='Display quantity', configuration_description='Display products quantity?' WHERE configuration_key='GOOGLE_FROOGLE_IN_STOCK';

DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIPPING_LOW';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_TO_DISPLAY';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_TO';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_FROM_DISPLAY';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_FROM';

Try running the full 'googlefroogle.sql'. :smile:

Pixxi:

Try running the full googlefroogle.sql rather than the version-specific ones - which are only partial SQL updates.

Remember to write down your Froogle settings first - the full SQL will drop (ie. delete) the current settings and create new ones which you will then need to edit in the config of the mod in admin.

You can get the latest version (v 1.3.1) from Andrew's site - see the link in his signature.

Did that as well...results in the following......

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 'in:
[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.

I've installed the latest version of this mod (v1.3.1) several times on zen 1.3.6 using the full SQL without any errors.

See posts 281-284 (?) above by Woodymon - perhaps your server has the same issue, if it is server-related.

Or it might be due to you attempting to first run the partial SQL - in which case, you'll need to manually edit those inserts out (ie. delete them) in the configuration table.

CBO:

Here is the SQL file that I used...........

UPDATE configuration SET configuration_title='The shipping options available for an item', configuration_value='', configuration_description='The shipping options available for an item' set_function='' WHERE configuration_key='GOOGLE_FROOGLE_SHIPPING';
UPDATE configuration SET configuration_title='Display quantity', configuration_description='Display products quantity?' WHERE configuration_key='GOOGLE_FROOGLE_IN_STOCK';

DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIPPING_LOW';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_TO_DISPLAY';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_TO';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_FROM_DISPLAY';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_SHIP_FROM';

Hmmm... it should work out fine, how did you install it, through the sql patches in the admin or through phpmyadmin?

Pete

kebeid:

Hmmm... it should work out fine, how did you install it, through the sql patches in the admin or through phpmyadmin?

Pete

As per directions with the SQl install in admin.

I'm starting to wonder if Just dropping everything and reinstalling with this version would be ok. However, Im one of those wanna be SQL/PHP guys and have no rel idea what the table is that I need to drop so I can reinstall.

Don't drop the table cuz it has all your other config stuff so yea don't do that.

I don't know if you're up to doing this since its gonna take a long time, but you can look at the things referred to in the sql file and drop those rows from the config table then install the googlefroogle fresh.

Pete

kebeid:

Don't drop the table cuz it has all your other config stuff so yea don't do that.

I don't know if you're up to doing this since its gonna take a long time, but you can look at the things referred to in the sql file and drop those rows from the config table then install the googlefroogle fresh.

Pete

OK, I dropped the rows and replaced all the files with the current set 1.3.1.
I reinstalled the reran the SQL script and reentered my data for froogle in the configuration area. Now, with this new install there seems to be a small issue remaining. Whenever I try and generate a new froogle file I get a pop up screen in my browser that is blank. The file is never created also after verifying the FEED dir to see if it was there..nothing. Could this be permissions causing this now? Either on the Feed dir or someplace else?

The pop-up window shows the result of the feed generation process (eg. xxx records ... success!). It can take a while if you have a lot of products, although this version is much faster than previous versions thanks to Andrew's optimisation efforts. But if you've less than 10k products and you've left it for a minute or so and it still hasn't completed then you probably have another problem.

The feed folder and file usually need to be 777 - the pop-up window will display a permissions error if the feed folder/file is not writeable, so it's unlikely to be that.

How many products do you have, and how long are you letting it run for?

Pixxi:

The pop-up window shows the result of the feed generation process (eg. xxx records ... success!). It can take a while if you have a lot of products, although this version is much faster than previous versions thanks to Andrew's optimisation efforts. But if you've less than 10k products and you've left it for a minute or so and it still hasn't completed then you probably have another problem.

The feed folder and file usually need to be 777 - the pop-up window will display a permissions error if the feed folder/file is not writeable, so it's unlikely to be that.

How many products do you have, and how long are you letting it run for?

Well I doubt if thats the issue. I onl have about 400 products loaded currently. The test box is on a very slow system but the actual froogle file that is uploaded never gets created if you look in the FEED folder. The pop up window is just blank. I am using IE7 as well, could there be an issue there?

Just a thought .. try creating the (empty) feed file - with the same name as you've set in the mod's config in admin - and set it to 777.

There used to be an error message with earlier versions of the mod if the feed file didn't exist - maybe (just maybe) that error is missing.

Put another way, the (empty) feed file needs to exist with the correct name (IIRC) before you try to generate the feed (that's why an empty feed file is included in the mod) ... and (of course) try it with FireFox to see if the pop-up is still blank :smile:

Pixxi:

Put another way, the (empty) feed file needs to exist with the correct name (IIRC) before you try to generate the feed (that's why an empty feed file is included in the mod) ... and (of course) try it with FireFox to see if the pop-up is still blank :smile:

Bummer, that didn't work either. The file as write permissions on it as well as the folder (Remember its a windoze box). I can see the page running but it returns nothing. (file is blank after the run also)
Also tried in FireFox as well. No luck.

Most likely problem in

CBO:

on Windows 2003

I am using a subtable in mysql and I keep getting a error

Error
SQL query:

SELECT (

@t4 := configuration_group_id
) AS t4
FROM configuration_group
WHERE configuration_group_title = 'Google Froogle Configuration';

MySQL said:

#1146 - Table 'chelsea_testing.configuration_group' doesn't exist

my tables are named like chelsea_testingconfiguration_group without the dot. Can anyone help please.

Use sql patches in the admin

Hello,
I am having same problem as mole 69.
the update sql will not load either. ( 1.2.9 sql works..but the other two and the googlefroogle.sql do not work)

I am guess that the @t4 statement is a php 5 thing.

I am using PHP Version 4.4.3 and none of the sql files in any of your contributions that have the @t4 statements work.

;-(

It has been several months since I have been able to do any coding, so I am a bit rusty.
Please help.

Thanks
Herbals