Product Extra Fields for text, pdfs and flash

[wmorris]

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?

[oavs]

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.

[delia]

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

[oavs]

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

[oavs]

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.

[oavs]

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

[oavs]

OK solution is here >> https://www.zen-cart.com/showthread....21#post1316221

[oavs]

Opps , sorry

[katdidit]

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>

[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.