Froogle Merchant Center merged into GoogleBase

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.

Quote:

---

Originally Posted by 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:

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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?