AutoFacebook [Support]

[shags38]

what version of zc are you using? Also, can you confirm in phpmyadmin that facebook_add is definitely in the products table?

same as you - v1.3.9h - yes it is definitely in the products table in db

[shags38]

copy of db 'structure' for 'products' showing facebook_add at bottom of list

Browse
Structure
SQL
Search
Insert
Export
Import
Operations
Triggers

# Name Type Collation Attributes Null Default Extra Action
1 products_id int(11) No None AUTO_INCREMENT Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
2 products_type int(11) No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
3 products_quantity float No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
4 products_model varchar(32) latin1_general_ci Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
5 products_image varchar(64) latin1_general_ci Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
6 products_price decimal(15,4) No 0.0000 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
7 products_virtual tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
8 products_date_added datetime No 0001-01-01 00:00:00 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
9 products_last_modified datetime Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
10 products_date_available datetime Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
11 products_weight float No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
12 products_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
13 products_tax_class_id int(11) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
14 manufacturers_id int(11) Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
15 products_ordered float No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
16 products_quantity_order_min float No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
17 products_quantity_order_units float No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
18 products_priced_by_attribute tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
19 product_is_free tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
20 product_is_call tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
21 products_quantity_mixed tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
22 product_is_always_free_shipping tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
23 products_qty_box_status tinyint(1) No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
24 products_quantity_order_max float No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
25 products_sort_order int(11) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
26 products_discount_type tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
27 products_discount_type_from tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
28 products_price_sorter decimal(15,4) No 0.0000 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
29 master_categories_id int(11) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
30 products_mixed_discount_quantity tinyint(1) No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
31 metatags_title_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
32 metatags_products_name_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
33 metatags_model_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
34 metatags_price_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
35 metatags_title_tagline_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
36 facebook_add tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
With selected: Check All / Uncheck All With selected:

[lankeeyankee]

hmm, I am not sure why it's doing that. I have looked and searched through my entire site files and these are the only files and the only lines affected. The only thing I can recommend at this point is to double check all of the code edits to make sure everything is there and nothing accidentally added or overwritten. If you are still having a problem, you can set up a temp ftp account for me and I can check your files or you can zip them all and send them to me to double check.

[lankeeyankee]

specifically, look in collect_info as that is where the problem is.

[shags38]

oooops! False alarm - I added facebook_add to the wrong db - long story as to why I have more than one db .

Products page is OK now - except for the following;
1. in admin/product and adding a new product after clicking 'preview' this piece of code appears on the top of the confirmation page } ?>
2. there is a comment at the very bottom of the page 'Facebook Will NOT be Updated.'
3. there is no radio button to select to add to facebook or not

cheers,
Mike

[lankeeyankee]

glad to hear that that problem is sorted. It sounds like some of the other code snippets are off or missing something. The }?> means that there is no <?php before it, probably in that blank space where you added the empty line. You should copy the entire facebook code block from the "insert" section and insert it into that "updates" section including the bits that I added.

That comment is supposed to appear, it lets you know before clicking the update button whether or not fb will be updated. In this case, it won't be.

It looks like you missed adding this section of code:

<tr>
          <td class="main">Add/update Facebook?</td>
            <td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_radio_field('facebook_add', '1', $is_facebook_add_enabled) . '&nbsp; Yes ' . zen_draw_radio_field('facebook_add', '0', $not_facebook_add_enabled) . ' No ' . ($pInfo->facebook_add == 1 ? 'Add to facebook?' : ''); ?></td>

          </tr>

in collect_info. You should be adding it around line 308, right above

<tr>
            <td class="main"><?php echo TEXT_PRODUCT_IS_FREE; ?></td>
            <td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_radio_field('product_is_free', '1', ($in_product_is_free==1)) . '&nbsp;' . TEXT_YES . '&nbsp;&nbsp;' . zen_draw_radio_field('product_is_free', '0', ($in_product_is_free==0)) . '&nbsp;' . TEXT_NO . ' ' . ($pInfo->product_is_free == 1 ? '<span class="errorText">' . TEXT_PRODUCTS_IS_FREE_EDIT . '</span>' : ''); ?></td>
          </tr>

Please check to make sure it's there. It will be a radio button right below where you add the product title, where the other radio button are above the tax and price.

This will work much better if you copy that block of fb code like I suggest, this way it will allow to add to fb if you are creating a new listing or updating an old one. Currently, you are only going to be able to do it when creating a new one since the block is missing from the "update" section.

Also note, I was lazy and hardcoded the text stuff for the radio button in the code instead of making it a define. If someone wants to be proper, they should substitute YES_TEXT and NO_TEXT for Yes and No in the above snippet as well as adding a define for the "Add to Facebook?" text.

[shags38]

Hi Lankee,

adding to previous post - new products will not add to the site after clicking insert - it just takes me to a totally blank page.

seems I am close but not close enough :)

cheers,
Mike

[lankeeyankee]

That should be TEXT_YES and TEXT_NO, too late to edit my post.

[lankeeyankee]

The fastest way is to just zip those 3 files and post them, I will have a quick look and fix them. Then I can discuss what went wrong to give you insight when working on other stuff and to maybe help someone else out that experiences these problems. Likely something very simple like a closing } or ; missing, probably in the preview_info file.

[shags38]

The fastest way is to just zip those 3 files and post them, I will have a quick look and fix them. Then I can discuss what went wrong to give you insight when working on other stuff and to maybe help someone else out that experiences these problems. Likely something very simple like a closing } or ; missing, probably in the preview_info file.

pleading ignorant here - how do I zip and post the zipped folder or files in here? (the files are copied and pasted in a previous past above) - ??