Google froogle feeder + deal gates pipelines.

[shackle]

Do both of these require you to not have database prefixes like Zen_?

Can anyone fix the SQL files so they work with zen_ I'm almost sure you just add zen_ to the database tables, but I'm not 100% sure what places I should be adding the zen_ prefixes. This would save me a lot of headaches toying around with it till I get it right, and possibly messing up a database.

It would be helpful if someone could fix them to work with zen_ prefixes (maybe post the modified code) since many people sometimes use fantastico to install zen-cart. ( Just a time saver sometimes)

OR... Is there a way to remove prefixes from a MYSQL database I toyed around with it, and searched the net couldn't seem to find a solution.

[Louis]

If you use Admin>Tools>Install SQL patch to update/install the sql on the database the prefix will be added automatically for you.

[shackle]

Tried that for Froogle, and I still get SQL errors. Also the cofig-> froogle config doesn't show up either. Blank page.

Deal gates doesn't have a SQL file.

If you use Admin>Tools>Install SQL patch to update/install the sql on the database the prefix will be added automatically for you.

[shackle]

Here is the error below for Froogle, and as I said before admin-> configuration -> Google Froogle Configuration Page is blank.

For dealgates I just need to know what all to add the zen_ (in the dealgates_pipeline.php file) prefix to for it to work with a cart with SQL table prefixes.

Running zen-cart ver. 1.3.7

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/04/17 22:39:37
Feed file - /home/d2hoster/public_html/jad/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
Processing: Feed - Yes, Upload - No
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 'ORDER BY p.products_id ASC' at line 10
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id ASC]

[shackle]

I managed to fix froogle :)

Didn't copy/paste into the text box. I just selected browse uploaded the file that was the problem.

Still need help with Deal gates though.

Thanks.

[CJ Internet Sales]

I had been struggling with this issue for a couple of days. Tried and tried to update SQL by using the Browse and Upload links with no positive results.

I had not thought to open the file and copy/paste into the updates area. This thread really opened up the answer and taught me what I needed to fix this problem and any future updates to SQL.

Many thanks,