Hi all, Thank you for reading. I would like to get the googlefroogle feeder up and running. Only I dont understand how to use the install sql patches.
I have uploaded googlefroogle.sql a million times and i get a white page that says theres a syntax error on line1 The error code is 1044. I think!

So can someone please tell me what im supposed to do in the sql patch installer?
I noticed that there are special instructions next to to the query editor:
Enter the query
to be executed:

Be sure to
end with ;

Im not really too sure what this means. Please help.
Thank You,
John

Please dont PM for help, its poor form.
If you are not getting the help you would like, add more details to the post. If you dont understand what details to add then add screen dump pictures with arrows and notes.

Okay. Thank you for that.

Is there help on the way now that I have enraged the "stagebrace" ?

The stage cant be enraged. I just state the facts as I see them. Can you get to providing more details. I just dont understand the question.

I am trying to install googlefroogle feeder.
I have all of the files that need to be uploaded uploaded into the right places.

here is the problem. I dont know what to do here to get my googlefroogle.sql file installed.

Thank You ,
John

Ok we can help with that. But before making any changes to the database and php files, have you made backups?

No I have not. I dont know anything about DBs. This is my first rodeo.
I have backed up my stores root and all thats in it a few times. All I do for that is Download a fresh copy once I make a few changes and overwrite my old copy here on local Z:.

To backup your Zen Cart database

• Login to cPanel by going to https://yourdomain:2083 for a secure connection. Or http://yourdomain:2082 to let any one that wants to copy your data as its saved to your local drive.
• Click mySQL Databases
• Click on Click here to access phpMyAdmin at the bottom of the page. A new window will open and load phpMyAdmin.
• If you have more than one database select the one you want to backup from the drop-down box in the left frame, or click on the name of the database if you have just one. A new page listing the tables will load in the right frame.
• Before we backup the database we shall optimize it. Click Check All and then from the drop-down box select Optimize Table.
• After the new page loads click on Export in the horizontal menu at the top.
• Now uncheck Data. Check Save as file. In File Name Template enter __DB___Structure. Select "zip" and then hit the Go button. You will be prompted to save a file. Save it. This file is your mySQL backup in gz format containing the Table Structure only
• Now check Data and uncheck Structure and change File Name Template to __DB___Data, while retaining all the other settings of step
• Click Go and save the file. .

Dont know if it matters or not but I use godaddy.
Login to cPanel by going to https://yourdomain:2083 for a secure connection.
This isnt working for me

Tried https://mydomain:2083
https://mydomain:2082

I get " Problem loading page" I think i can do the same thing from logging in through godaddy and getting to phpMyAdmin.

I know that i can get to my DB from godaddy. What im saying is, is it possible to do the same thing that way?

Oh my daddy. Me no no nasing about GoDaddy.
But until you have the php and database files backup, you should not be adding or changing the database with addon modules. That unless you have plenty of time to spare?

Dennis out for the night.

K. All is well got my @ download zips.

Thank you for the back up lesson. Works great. Have wanted to do it. Didnt know it would be that easy!
John

Well all the problem still stands. I still dont know how to make the sql installer in Admin install and sql patch.
Can someone please tell me how?
John

Well it should be as simple as open the sql file in notepad (not wordpad, or any richtext editor) select all and copy. Go to Admin>tools>install SQL patches and paste the copied code in the large text box and then click send.

Thank You Thank You Thank You.

Now All I have to do is learn to use it! Thank You.

                              John

Your welcome.

I got the pop up after i clicked submit.
It waited a few then this:

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/03/17 23:38:52
Feed file - /home/content/d/a/n/stomp16424/html/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...

Thats all.
the status of the browser its in says DONE. Is this right?
did it do it?

Nothing New. Same Screen . Same thing. Is it supposed to do something or just sit with the text in My previous Reply?

                John

I'm not sure I don't use the google froogle feed but did you follow the read file that come with the mod.> Install:

========

1. Unzip and upload all files to your store directory;
2. Go to Admin->Tools->Install SQL Patches and install googlefroogle.sql
3. Go to Admin->Configuration->Google Froogle Configuration and setup all parameters
4. Go to Admin->Tools>Google Froogle Feeder;

Tips

To have this update and automatically upload to Google Froogle Merchants, you
will need to set up a Cron job via your host's control panel.

To run it as a cron job (at 5:0am like you wanted), put something in your crontab like the
following:

0 5 * * * GET http://your_http_catalog/googlefroogle.php?feed=yes&upload=yes
or
0 5 * * * wget http://your_http_catalog/googlefroogle.php?feed=yes&upload=yes
or
0 5 * * * curl -s http://your_http_catalog/googlefroogle.php?feed=yes&upload=yes

If your hoster disable cron function, see a webcron services, such as http://www.webcron.org/ good luck....you've made it this far...

Yes I did follow the readme.

**INSTRUCTIONS: **
STEP 1: Click [HERE] to create / update your product feed.
NOTE: You may **view** your product feed file before proceeding to step 2.
STEP 2: Click [HERE] to upload product feed to Google Froogle Merchants.
NOTE: You may **view** Froogle Merchants FTP content.

It is step 2 from above that Im asking about.

bumba000:

I got the pop up after i clicked submit (step 2 click [HERE].
It waited a few then this:

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/03/17 23:38:52
Feed file - /home/content/d/a/n/stomp16424/html/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...

Thats all.
the status of the browser its in says DONE. Is this right?
did it do it?

Thank you
John

Well it appears to have created the feed txt file, whether it uploaded it I don't know. I will assume it worked cause I cut and pasted one of your product names into thwe froogle search and your product came up and when I clicked on it....off to your store I went.