google base error??

OK - in root/googlefroogle.php There is this LINE 38:

@define('GOOGLE_PRODUCTS_DIRECTORY', 'feed/google/');

So the config in admin must be set to feed/google/... check

The old version was only feed/

Still this damn warning:

No such file or directory in /opt/apache-2.2.13/htdocs/storename/admin/googlefroogle.php on line 185
LINE 185:

if ($handle = opendir(DIR_FS_CATALOG . GOOGLE_PRODUCTS_DIRECTORY)) { 

Can this be hard coded to point directly?

I wonder if it's worth (or even good to do) wiping out all google related info from the data base and installing the install.sql instead of the upgrade1.10.2.sql I did.

You mean the update.sql? When I set it up, I ran both. Ran the install.sql first and then the update.sql. Frankly, I don't know if I even needed to run the update patch after running the install patch. The update patch produced a duplicate entry error.

RescoCCC:

You mean the update.sql? When I set it up, I ran both. Ran the install.sql first and then the update.sql. Frankly, I don't know if I even needed to run the update patch after running the install patch. The update patch produced a duplicate entry error.

Hmmm - I ran just the update.sql patch.
Now thinking about it I had a version of google feed that's a bit old. I probably should have uninstalled the whole thing and ran the install.sql.
I am unsure about doing that though for negative side affects but seems like the thing to do.

sbbemn:

OK - in root/googlefroogle.php There is this LINE 38:

@define('GOOGLE_PRODUCTS_DIRECTORY', 'feed/google/');

> 
> So the config in admin must be set to **feed/google/**... check
> 
> The old version was only feed/
> 
> Still this damn warning:
> 
> No such file or directory in /opt/apache-2.2.13/htdocs/storename/admin/googlefroogle.php on line 185
> LINE 185:
> ```php
if ($handle = opendir(DIR_FS_CATALOG . GOOGLE_PRODUCTS_DIRECTORY)) { 

Can this be hard coded to point directly?

My googlefroogle.php file has the same entry, but my directory is setup as simply feed/, and is working fine.

sbbemn:

Hmmm - I ran just the update.sql patch.
Now thinking about it I had a version of google feed that's a bit old. I probably should have uninstalled the whole thing and ran the install.sql.
I am unsure about doing that though for negative side affects but seems like the thing to do.

On one of my sites the feed version I was using was old, on the other very old. They had been working so beautifully I didn't want to mess with them, but Google forced our hand.

well that's puzzling.

You can see the file (name_products_.xml) generated to your feed/ folder and not your feed/google/ folder?

sbbemn:

That file is the admin/googlefroogle.php file - just check to make sure it's there first and/or the correct one.

?

As far as I can see it is in the admin and the correct file since i have now reinstalled 34 times and still no google option in admin.tools

sbbemn:

well that's puzzling.

You can see the file (name_products_.xml) generated to your feed/ folder and not your feed/google/ folder?

Yes, it's generated in the feed folder. I don't even have a feed/google folder. I nuked it.

marvin:

As far as I can see it is in the admin and the correct file since i have now reinstalled 34 times and still no google option in admin.tools

Sorry that should reinstalled it 4 times.

Still no admin/tools Google option. Any ideas?? Anyone.

I believe the sql script malfuctioned along the way during uninstall/install/upgrade if the page is not appearing in admin.

As far as the Warning goes, here is the culprit line:
No such file or directory in /opt/apache-2.2.13/htdocs/storename/admin/googlefroogle.php on line 185

if ($handle = opendir(DIR_FS_CATALOG . GOOGLE_PRODUCTS_DIRECTORY)) {

Is it possible to hard code the file directory as in feed/ or feed/google/ in the code instead of "GOOGLE_PRODUCTS_DIRECTORY" and force it to understand?

FIXED WARNING:

So I did this already a couple of days ago, but today seemed to want to work.

I ran uninstall.sql
Ran install.sql - Got the duplicate error message screen, hit back button
Ran upgrade 1.10.2.sql and got the same duplicate page, hit back button
Went to Tools>google feed... NO WARNING?!
hit Confirm, and got this....

Google Merchant Center Feeder v started 2011/10/07 15:09:23
Feed file - /xx/xxxxxx/xxxxxx/storename/feed/google/domain_products_en.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 40.032531 Seconds 4530 of 4799 Records

Are the ~~~~~ normal? I've never seen them before.

sbbemn:

FIXED WARNING:

So I did this already a couple of days ago, but today seemed to want to work.

I ran uninstall.sql
Ran install.sql - Got the duplicate error message screen, hit back button
Ran upgrade 1.10.2.sql and got the same duplicate page, hit back button
Went to Tools>google feed... NO WARNING?!
hit Confirm, and got this....

Google Merchant Center Feeder v started 2011/10/07 15:09:23
Feed file - /xx/xxxxxx/xxxxxx/storename/feed/google/domain_products_en.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 40.032531 Seconds 4530 of 4799 Records

Are the ~~~~~ normal? I've never seen them before.

That looks like it processed the feed as it should. Missing a small percentage of items, but there are a number of reasons that can happen. Does it upload to Google Merchant Center okay? Are the required attributes in the feed file?

RescoCCC:

That looks like it processed the feed as it should. Missing a small percentage of items, but there are a number of reasons that can happen. Does it upload to Google Merchant Center okay? Are the required attributes in the feed file?

Well, I uploaded it to google and: 1. availability missing , 2. XML tag mismatch 3. Invalid RSS/Atom document format

I just read that numinix put out a 1.11.2 with availability and fix for my 1.3.8a.

I quickly downloaded it, installed and guess what - I'M BACK to the same Warning problem I had before. what a day.

I noticed on the numinix site that it's latest version is 1.11.2

There is no sql patch for 1.11.2. Wondering if that is a problem or not.

The fix for me earlier today was to run the uninstall/upgrade from 1.10.2.

In my old version of google feed, all I am missing is the availability.

Shame I couldn't just write that in. Is this easy enough to do?

sbbemn:

In my old version of google feed, all I am missing is the availability.

Shame I couldn't just write that in. Is this easy enough to do?

What are your settings for:

Show quantity
Include zero quantity
Default quantity

Show quantity False
Include zero quantity True
Default quantity 1

We have a custom backorder code that allows negative qty

sbbemn:

Show quantity False
Include zero quantity True
Default quantity 1

We have a custom backorder code that allows negative qty

Change them to:

Show quantity True
Include zero quantity False
Default quantity 0

And see if the feed generates the availability attribute.

• <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
• <channel>
• <title>
• <![CDATA[ Store Name ]]> </title> <link>GOOGLE_PRODUCTS_ADDRESS</link> <description>GOOGLE_PRODUCTS_DESCRIPTION</description> </channel> </rss>

I did that change and this is what it spits out.

When I had fixed 1.10.2, the output filename was domain_products_en.xml.
Now that I am *trying *to use 1.11.2, it is back to to a malfuctioning domain_products_.xml

I would got back to 1.10.2. It was working except for the availability attribute, and that just may have been a condiguration issue.