delia:

What version of zen cart?

delia,

When I try to install this SQL directly into phpMyAdmin:

SELECT @gid:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';


INSERT INTO configuration
VALUES (
NULL ,  'TPP ñ Extra Product Fields Tab',  ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ',  '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL ,  'zen_cfg_select_option(array(''0'', ''1''),'
)

phpMyAdmin gave me this error:

Error
SQL query: Documentation


INSERT INTO configuration
VALUES (
NULL ,  'TPP ñ Extra Product Fields Tab',  ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ',  '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL ,  'zen_cfg_select_option(array(''0'', ''1''),'
)
MySQL said: Documentation

#1136 - Column count doesn't match value count at row 1 

What am I missing?

Hi

Thank you for this great idea and your contribution. I am not a coder but do understand a little and have installed many mods before successfully.

My problem is I am using Zencart 1.5.5a. So I tried to merge all the files as much as I can also with a help from two other regular contributors.

I did create a New upload directory: product_extra_files/ (set permissions at 777 - where files will be uploaded to.
I did rename the admin to my own
I did rename the template to my own.
I did check merges several times although was difficult.

So far it shows up in admin (see attached image) .

Problem :

1. Uploaded files do not show in the next preview and naturally not in the product public view.
2. When the same product need to be edited or updated, selecting the same product opens with blank details as if it is a NEW product to be added with totally blank fields. Previous product entry somehow gets deleted in the background.

I will post a zip file of my merged files and if you would be so kind to check for me if I have done it correctly..obviously not :-(

Appreciate your help and love the idea of Product Extra Fields for text, pdfs and flash mod.

right off hand I can't answer that. Let me see if I can get it working with 1.5.5a.

delia:

right off hand I can't answer that. Let me see if I can get it working with 1.5.5a.

Any luck yet? Do you think there is a possibility?
I would really love it if it worked for 1.5.5a.

Thank you for looking in to

Ok some news.

I have re merged the fields and now confirm that when I edit the product (problem #2) , it does not delete the product as it was before.So it looks like it has been fixed..

Interestingly added PDFs also still show in the admin> preview.
... BUT I still can not see the PDF's in public.

Ok I am talking to my self here. That's fine ;-)

I think my problem is with the installation of 'TabProductsV1.10' which came with the 'products_extra_fields_v1.8'

I have added all the files from 'TabProductsV1.10'
Trying to install the mysql but keep giving MySql Error during instillation in phpMyAdmin.

================
SELECT @gid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';

INSERT INTO configuration
VALUES (
NULL , 'TPP – Extra Product Fields Tab', ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ', '0', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL , 'zen_cfg_select_option(array(''0'', ''1''),'
)

I even added my own the prefix 'zenwn_' like below but still not working.

================
SELECT @gid:=configuration_group_id
FROM zenwn_configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';

INSERT INTO zenwn_configuration
VALUES (
NULL , 'TPP – Extra Product Fields Tab', ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ', '0', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL , 'zenwn_cfg_select_option(array(''0'', ''1''),'
)

ERROR

SQL query: Documentation

INSERT INTO zenwn_configuration
VALUES (

NULL , 'TPP – Extra Product Fields Tab', ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ', '0', 'Set this to 1 if you want to enable the extra fields on your products', @gid , 1, NOW( ) , NOW( ) , NULL , 'zenwn_cfg_select_option(array(''0'', ''1''),'
)
MySQL said: Documentation

#1048 - Column 'configuration_group_id' cannot be null

OK solution is here >> https://www.zen-cart.com/showthread.php?220046-How-to-Add-Custom-Fields-for-Materials-amp-Dimensions-when-adding-products&p=1316221#post1316221

Opps , sorry

Hi,
I'm getting an error when uploading a flash (swf) to a product that we are missing the file flash.php in the admin_folder/products_extra_fields - which is called from the admin/includes/modules/product/preview_info.php It all seems a little odd to me, since the mod does not come with a file flash.php in the products_extra_files, and the products_extra_files folder isn't in the admin folder. Help?

<?php echo "<a href='products_extra_files/flash.php?id=" .  $_GET['pID'] . "'>" . $pInfo->video_title . "</a>

That's in admin preview only. It has nothing to do with uploading the file or displaying the flash on the website. I haven't looked at the flash section in many years and don't know that flash will still work with this mod. My question has to be at this point is why are you using flash at all? Mobile sites cannot display flash.

My apologies to everyone for disappearing for so long. I had multiple surgeries last year and have just begun to get back into the swing of things.

delia:

That's in admin preview only. It has nothing to do with uploading the file or displaying the flash on the website. I haven't looked at the flash section in many years and don't know that flash will still work with this mod. My question has to be at this point is why are you using flash at all? Mobile sites cannot display flash.

My apologies to everyone for disappearing for so long. I had multiple surgeries last year and have just begun to get back into the swing of things.

Thanks. I hope you are feeling better.
If it were up to me, there would be no flash anywhere on the internet. Others seem to cling to it... I will just comment out the options to upload it and point them to alternate ways to include videos.

That's a good idea. I tell folks convert to use on YouTube. That way you aren't using your bandwidth either!

Getting wired error. When insert product and enter data in extra field it does not insert in product extra field table therefore it does not show on product page. If I go back to edit product, edit product page shows all fields blank/empty in admin. For some reason it is not inserting product/content to extra field table. How to fix it? If I insert info/product id to extra field table via cpanel/sql then all fields appear in admin edit product page.

most likely you have done something wrong with the installation if it's not working. Try reinstalling first.

I'm thinking about installing this plugin so I can add our SKU's to the product description. But I see something called TabProductsV1.10 in the installation package. Is that supposed to be part of this plugin? I've skimmed through the posts here and don't see any specific reference to it or what it's for.

it was added so that if you have tab products mod installed, it will work. Otherwise not to worry.

Hi,
I have just uploaded v1.8 (zc v1.5.5f). I can see all the product extra field files in Admin, but nothing is coming up on the website :(

Did you change the folder name from your_custom_template?

Yes, I changed the folder to my custom template

This has not been tested with 1.5.5f - I can't think of a reason it wouldn't work but I don't know.