Product Extra Fields for text, pdfs and flash

Printable View

Show 100 post(s) from this thread on one page

27 Jul 2015, 05:02 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by Parafanaylya

Where might I find the debug-log files?

I found this in my CPanel: ( I substituted user and template names)

Quote:

[Sun Jul 26 23:03:41.045466 2015] [access_compat:error] [pid 453343] [client 66.249.64.38:35723] AH01797: client denied by server configuration: /home/my_username/public_html/includes/templates/old_template_name

What is interesting is that I haven't used my old_template_name since upgrading to 1.5.4
27 Jul 2015, 03:52 PM
delia

Re: Product Extra Fields for text, pdfs and flash

Actually, I never do what you did - renaming and uploading. I always take the contents and upload them in the correct place. But I don't see how could have gone wrong doing that either.
27 Jul 2015, 04:01 PM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by delia

Actually, I never do what you did - renaming and uploading. I always take the contents and upload them in the correct place. But I don't see how could have gone wrong doing that either.

Hi

I have changed the local directory name back to admin. I'll download a home directory backup.

Then rename only the template directory as per read.txt , and upload in batches to their relevant locations. Where the server file is older than your files, I'll overwrite.

Will let you know asap.
28 Jul 2015, 04:31 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Quote:

WARNING: An Error occurred, please refresh the page and try again.

This is what has happened to my admin page again with a manual install of all files
28 Jul 2015, 05:34 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Busy uploading a home directory backup. At the pathetic local ISP speeds, it may take 2-3 days. We are meant to have a 20mbps line, which is the best affordable line in my neighbourhood of Johannesburg. (Pop 6-8 million, with isolated areas offering fibre to fewer than 50 000)
28 Jul 2015, 11:55 AM
delia

Re: Product Extra Fields for text, pdfs and flash

Did you run the sql?
28 Jul 2015, 12:31 PM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Can't access admin since uploading files. See above.
28 Jul 2015, 12:38 PM
delia

Re: Product Extra Fields for text, pdfs and flash

I don't know what you are doing wrong but this shouldn't be an issue if in fact you are matching zen cart versions.
28 Jul 2015, 12:48 PM
lat9

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by Parafanaylya

This is what has happened to my admin page again with a manual install of all files

When you receive the "Warning: An error occurred", there's a debug log with details that identify the symptom (and possibly the source) of the error. Check your /logs folder for Zen Cart v1.5.1 or later; /cache folder for earlier versions.
28 Jul 2015, 01:09 PM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Running 1.5.4 and V1.8?
28 Jul 2015, 01:15 PM
delia

Re: Product Extra Fields for text, pdfs and flash

Yes, that is correct. Have you checked the logs folder for the error logs.

Thanks lat9 for that helpful bit of advice!
28 Jul 2015, 02:37 PM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by delia

Yes, that is correct. Have you checked the logs folder for the error logs.

Thanks lat9 for that helpful bit of advice!

There are 2 log folders that I know of - both in CPanel

/public.html/logs which has a lot of stuff that seems unrelated to admin, and:

Quote:

[Tue Jul 28 08:12:48.127231 2015] [access_compat:error] [pid 857032] [client 66.102.6.226:62151] AH01797: client denied by server configuration: /home/my_user_name/public_html/includes/templates/old_template_name, referer: http://joburgonline.com/
[Tue Jul 28 08:12:48.125849 2015] [access_compat:error] [pid 857921] [client 66.102.6.230:53004] AH01797: client denied by server configuration: /home/my_user_name/public_html/includes/templates/old_template_name, referer: http://joburgonline.com/
[Tue Jul 28 08:12:48.125680 2015] [access_compat:error] [pid 858320] [client 66.102.6.230:41939] AH01797: client denied by server configuration: /home/my_user_name/public_html/includes/templates/old_template_name, referer: http://joburgonline.com/
[Tue Jul 28 08:12:48.125682 2015] [access_compat:error] [pid 855490] [client 66.102.6.226:46355] AH01797: client denied by server configuration: /home/my_user_name/public_html/includes/templates/old_template_name, referer: http://joburgonline.com/
[Tue Jul 28 08:12:48.125609 2015] [access_compat:error] [pid 857036] [client 66.102.6.226:62958] AH01797: client denied by server configuration: /home/my_user_name/public_html/includes/templates/old_template_name, referer: http://joburgonline.com/
[Tue Jul 28 08:12:48.125609 2015] [access_compat:error] [pid 854743] [client 66.102.6.226:38886] AH01797: client denied by server configuration: /home/my_user_name/public_html/includes/templates/old_template_name, referer: http://joburgonline.com/
[Tue Jul 28 08:12:48.125595 2015] [access_compat:error] [pid 858188] [client 66.102.6.226:55230] AH01797: client denied by server configuration: /home/my_user_name/public_html/includes/templates/old_template_name, referer: http://joburgonline.com/
[Tue Jul 28 08:12:48.122814 2015] [access_compat:error] [pid 855431] [client 66.102.6.230:59157] AH01797: client denied by server configuration: /home/my_user_name/public_html/includes/templates/old_template_name, referer: http://joburgonline.com/
28 Jul 2015, 03:17 PM
lat9

Re: Product Extra Fields for text, pdfs and flash

Check also for myDEBUG*.log files, present in your store's /logs directory.
28 Jul 2015, 03:39 PM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by lat9

Check also for myDEBUG*.log files, present in your store's /logs directory.

Where might I find those logs. I don't have access to admin.
28 Jul 2015, 03:46 PM
lat9

Re: Product Extra Fields for text, pdfs and flash

Use your cPanel's "File Explorer" or FTP. You'll see the /logs folder as a first-level sub-folder, at the same level as your /includes folder.
28 Jul 2015, 04:03 PM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by lat9

Use your cPanel's "File Explorer" or FTP. You'll see the /logs folder as a first-level sub-folder, at the same level as your /includes folder.

I have them - anything in particular. The newest is dated 05/10/15
28 Jul 2015, 04:20 PM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

my backup's corrupted :(
29 Jul 2015, 07:46 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Please confirm code I need to remove to restore my admin:

from admin/includes/modules/copy_to_confirm.php

Code:

///new fields- code taken from the music type fields and applied with new fields here - adp /03/03/2010 $product_extra = $db->Execute("select extra_field, text_1, text_2, text_3, text_4, file_1, file_2, file_3, file_4, file_1_title, file_2_title, file_3_title, file_4_title, video, video_title, height, width from " . TABLE_PRODUCT_EXTRA_FIELDS . " where products_id = '" . (int)$products_id . "'"); $db->Execute("insert into " . TABLE_PRODUCT_EXTRA_FIELDS . " (products_id, extra_field, text_1, text_2, text_3, text_4, file_1, file_2, file_3, file_4, file_1_title, file_2_title, file_3_title, file_4_title, video, video_title, height, width) values ( '" . (int)$dup_products_id . "', '" . zen_db_input($product_extra->fields['extra_field']) . "', '" . zen_db_input($product_extra->fields['text_1']) . "', '" . zen_db_input($product_extra->fields['text_2']) . "', '" . zen_db_input($product_extra->fields['text_3']) . "', '" . zen_db_input($product_extra->fields['text_4']) . "', '" . zen_db_input($product_extra->fields['file_1']) . "', '" . zen_db_input($product_extra->fields['file_2']) . "', '" . zen_db_input($product_extra->fields['file_3']) . "', '" . zen_db_input($product_extra->fields['file_4']) . "', '" . zen_db_input($product_extra->fields['file_1_title']) . "', '" . zen_db_input($product_extra->fields['file_2_title']) . "', '" . zen_db_input($product_extra->fields['file_3_title']) . "', '" . zen_db_input($product_extra->fields['file_4_title']) . "', '" . zen_db_input($product_extra->fields['video']) . "', '" . zen_db_input($product_extra->fields['video_title']) . "', '" . zen_db_input($product_extra->fields['height']) . "', '" . zen_db_input($product_extra->fields['width']) . "')"); // eo: zen_copy_extra_fields
29 Jul 2015, 07:53 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

I will be doing these files one at a time as I don't need to dig myself into a deeper hole.
29 Jul 2015, 09:11 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

From admin/includes/modules/delete_product_confirm.php

Quote:

//delia - product extra fields mod
$db->Execute("delete from " . TABLE_PRODUCT_EXTRA_FIELDS . "
where products_id = '" . (int)$product_id . "'");
//
29 Jul 2015, 09:16 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Remove the following code from admin/includes/modules/new_product_preview.php:

Quote:

//extra fields mod

if ($_POST['file_1_title'] != '') {
$products_file_1 = new upload('file_1');
$products_file_1->set_destination(DIR_FS_PRODUCT_EXTRA);
if ($products_file_1->parse() && $products_file_1->save(true)) {
$products_file_1_name = $products_file_1->filename;
} else {
$products_file_1_name = (isset($_POST['previous_file_1']) ? $_POST['previous_file_1'] : '');
}
}

if ($_POST['file_2_title'] != '') {
$products_file_2 = new upload('file_2');
$products_file_2->set_destination(DIR_FS_PRODUCT_EXTRA);
if ($products_file_2->parse() && $products_file_2->save(true)) {
$products_file_2_name = $products_file_2->filename;
} else {
$products_file_2_name = (isset($_POST['previous_file_2']) ? $_POST['previous_file_2'] : '');
}
}

if ($_POST['file_3_title'] != '') {
$products_file_3 = new upload('file_3');
$products_file_3->set_destination(DIR_FS_PRODUCT_EXTRA);
if ($products_file_3->parse() && $products_file_3->save(true)) {
$products_file_3_name = $products_file_3->filename;
} else {
$products_file_3_name = (isset($_POST['previous_file_3']) ? $_POST['previous_file_3'] : '');
}
}

if ($_POST['file_4_title'] != '') {
$products_file_4 = new upload('file_4');
$products_file_4->set_destination(DIR_FS_PRODUCT_EXTRA);
if ($products_file_4->parse() && $products_file_4->save(true)) {
$products_file_4_name = $products_file_4->filename;
} else {
$products_file_4_name = (isset($_POST['previous_file_4']) ? $_POST['previous_file_4'] : '');
}
}
if ($_POST['video_title'] != '') {
$products_video = new upload('video');
$products_video->set_destination(DIR_FS_PRODUCT_EXTRA);;
if ($products_video->parse() && $products_video->save(true)) {
$products_video_name = $products_video->filename;
} else {
$products_video_name = (isset($_POST['previous_video']) ? $_POST['previous_video'] : '');
}
}

?>

and change the following (was highlighted in Diffmerge)

Quote:

if (!isset($_GET['read']) || $_GET['read'] == 'only') {
$products_image = new upload('products_image');
$products_image->set_destination(DIR_FS_CATALOG_IMAGES . $_POST['img_dir']);
if ($products_image->parse() && $products_image->save($_POST['overwrite'])) {
$products_image_name = $_POST['img_dir'] . $products_image->filename;
} else {
$products_image_name = (isset($_POST['products_previous_image']) ? $_POST['products_previous_image'] : '');
}

to this (I can't see any difference):

Quote:

if (!isset($_GET['read']) || $_GET['read'] == 'only') {
$products_image = new upload('products_image');
$products_image->set_destination(DIR_FS_CATALOG_IMAGES . $_POST['img_dir']);
if ($products_image->parse() && $products_image->save($_POST['overwrite'])) {
$products_image_name = $_POST['img_dir'] . $products_image->filename;
} else {
$products_image_name = (isset($_POST['products_previous_image']) ? $_POST['products_previous_image'] : '');
}
29 Jul 2015, 09:24 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

remove from admin/includes/modules/update_product.php

Quote:

//extra product fields
$tmp_value = zen_db_prepare_input($_POST['text_1']);
$text_1 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['text_2']);
$text_2 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['text_3']);
$text_3 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['text_4']);
$text_4 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_1']);
$file_1 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_2']);
$file_2 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_3']);
$file_3 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_4']);
$file_4 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_1_title']);
$file_1_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_2_title']);
$file_2_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_3_title']);
$file_3_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_4_title']);
$file_4_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['video']);
$video = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['video_title']);
$video_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['extra_field']);
$extra_field = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['height']);
$height = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['width']);
$width = ($tmp_value=='') ? "null" : $tmp_value;

$sql_data_array = array('products_id' => $products_id,
'extra_field' => $extra_field,
'text_1' => $text_1,
'text_2' => $text_2,
'text_3' => $text_3,
'text_4' => $text_4,
'video_title' => $video_title,
'file_1' => $file_1,
'file_2' => $file_2,
'file_3' => $file_3,
'file_4' => $file_4,
'file_1_title' => $file_1_title,
'file_2_title' => $file_2_title,
'file_3_title' => $file_3_title,
'file_4_title' => $file_4_title,
'video' => $video,
'height' => $height,
'width' => $width
);

zen_db_perform(TABLE_PRODUCT_EXTRA_FIELDS, $sql_data_array);

&

Quote:

//extra product fields
$tmp_value = zen_db_prepare_input($_POST['extra_field']);
$extra_field = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['text_1']);
$text_1 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['text_2']);
$text_2 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['text_3']);
$text_3 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['text_4']);
$text_4 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_1']);
$file_1 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_2']);
$file_2 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_3']);
$file_3 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_4']);
$file_4 = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_1_title']);
$file_1_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_2_title']);
$file_2_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_3_title']);
$file_3_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['file_4_title']);
$file_4_title = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['video']);
$video = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['video_title']);
$video_title = ($tmp_value=='') ? "null" : $tmp_value;

$tmp_value = zen_db_prepare_input($_POST['height']);
$height = ($tmp_value=='') ? "null" : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['width']);
$width = ($tmp_value=='') ? "null" : $tmp_value;

$sql_data_array = array('extra_field' => $extra_field,
'text_1' => $text_1,
'text_2' => $text_2,
'text_3' => $text_3,
'text_4' => $text_4,
'file_1' => $file_1,
'file_2' => $file_2,
'file_3' => $file_3,
'file_4' => $file_4,
'file_1_title' => $file_1_title,
'file_2_title' => $file_2_title,
'file_3_title' => $file_3_title,
'file_4_title' => $file_4_title,
'video' => $video,
'video_title' => $video_title,
'height' => $height,
'width' => $width

);

zen_db_perform(TABLE_PRODUCT_EXTRA_FIELDS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");
29 Jul 2015, 12:03 PM
delia

Re: Product Extra Fields for text, pdfs and flash

You are making this very hard when it is not.

There are only a few files in the upload for this mod. All you have to do is grab those same files from the default 1.5.4 and upload them. Look at the readme for a list.
29 Jul 2015, 04:56 PM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Thanks so much Delia. I am a novice - and learning on the fly. I was in a bit of a panic.
30 Jul 2015, 11:40 AM
Parafanaylya

Re: Product Extra Fields for text, pdfs and flash

Sorted :)

Would you be interested in trying it out with temporary access?
30 Jul 2015, 12:30 PM
delia

Re: Product Extra Fields for text, pdfs and flash

What do you mean try it out?
28 Nov 2015, 12:28 PM
giuly

1 Attachment(s)

Re: Product Extra Fields for text, pdfs and flash

hello thanks for your mod, I installed successfully in fact I see in admin, but i insert values and they don't appear on product page.
I have ZC 1.5.4

I upload every folder (included tabproductsv1.10) under my site, and I run the .sql correctly, but the only problem is that don't appear on product page, in admin appears correctly.

Please, thanks in advance Attachment 15830
28 Nov 2015, 01:45 PM
delia

Re: Product Extra Fields for text, pdfs and flash

Did you change the template folder name to the name of your custom template?
28 Nov 2015, 02:21 PM
giuly

Re: Product Extra Fields for text, pdfs and flash

yes obviously
It is a demo site, in which I charge a test product, if you want to see the link is
www_giocattoliamo_it/prova
and in home page there is the test product
thanks
28 Nov 2015, 04:54 PM
giuly

Re: Product Extra Fields for text, pdfs and flash

if you want i can give to you data access in some way, I would need of this mod please
14 Jan 2016, 12:34 PM
teaj

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by kdays

modules/product_listing.php is not part of this mod.

It works great for the product info page but I also need the field to show on the product listing page.

Have you done this before?

Quote:

Originally Posted by delia

haven't done it but is doable. PM me.

Hello, I would also like to display these extra fields on the Product Listing page....is there some code / more info available?

Has any body acheived this? I had a go but no joy yet....

Thanks!
14 Jan 2016, 02:01 PM
delia

Re: Product Extra Fields for text, pdfs and flash

Sorry, I'm having surgery tomorrow and have been a bit off recently. I don't know what you are doing wrong but you've missed something somewhere. Are you saying that you have put in the extra information and when looking at that particular product, it doesn't show on the product page?

Did you change the folder names before you uploaded the includes folder?
14 Jan 2016, 02:13 PM
teaj

Re: Product Extra Fields for text, pdfs and flash

The extra fields are all working fine on the product info page...I would just like to display the extra field(s) on the product listing page too.

Good luck with your surgery....hope it goes smoothly and isn't too major.

Thanks
14 Jan 2016, 02:20 PM
delia

Re: Product Extra Fields for text, pdfs and flash

oh, that's totally different and is not in the mod.
26 Apr 2016, 04:07 AM
wmorris

Re: Product Extra Fields for text, pdfs and flash

Hi Delia,

I have installed this mod on the newest versions of Zen Cart. Everything is installed but I have made two extra fields for Materials & Dimensions. After I enter them it doesn't show up on Product Info page(s).
26 Apr 2016, 12:14 PM
delia

Re: Product Extra Fields for text, pdfs and flash

are you sure you added the changes to the product info template?
26 Apr 2016, 03:31 PM
wmorris

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by delia

are you sure you added the changes to the product info template?

Yes I did and it didn't change or work at all.
26 Apr 2016, 03:35 PM
delia

Re: Product Extra Fields for text, pdfs and flash

well, it does work properly if installed properly - just to be clear. I have not upgraded this mod for 1.5.5. If you are using it on 1.5.5, then I can't speak to what your problem may be. But I don't expect there to be anything in 1.5.5 that prevents it from working.
26 Apr 2016, 03:57 PM
wmorris

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by delia

well, it does work properly if installed properly - just to be clear. I have not upgraded this mod for 1.5.5. If you are using it on 1.5.5, then I can't speak to what your problem may be. But I don't expect there to be anything in 1.5.5 that prevents it from working.

Well I re-upload the files indvidually and install all SQL files and still doesn't work.
26 Apr 2016, 04:13 PM
delia

Re: Product Extra Fields for text, pdfs and flash

What version of zen cart?
28 Apr 2016, 08:49 PM
wmorris

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by delia

What version of zen cart?

delia,

When I try to install this SQL directly into phpMyAdmin:

Code:

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:

Code:

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?
21 Jul 2016, 01:41 AM
oavs

4 Attachment(s)

Re: Product Extra Fields for text, pdfs and flash

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.
21 Jul 2016, 02:15 PM
delia

Re: Product Extra Fields for text, pdfs and flash

right off hand I can't answer that. Let me see if I can get it working with 1.5.5a.
22 Jul 2016, 09:33 AM
oavs

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by 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
26 Jul 2016, 08:08 AM
oavs

Re: Product Extra Fields for text, pdfs and flash

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.
26 Jul 2016, 09:41 AM
oavs

Re: Product Extra Fields for text, pdfs and flash

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
27 Jul 2016, 03:16 AM
oavs

Re: Product Extra Fields for text, pdfs and flash

OK solution is here >> https://www.zen-cart.com/showthread....21#post1316221
27 Jul 2016, 03:29 AM
oavs

Re: Product Extra Fields for text, pdfs and flash

Opps , sorry
27 Feb 2017, 07:05 PM
katdidit

Re: Product Extra Fields for text, pdfs and flash

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?

Code:

<?php echo "<a href='products_extra_files/flash.php?id=" . $_GET['pID'] . "'>" . $pInfo->video_title . "</a>
3 Mar 2017, 03:34 PM
delia

Re: Product Extra Fields for text, pdfs and flash

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.
14 Mar 2017, 06:34 AM
katdidit

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by 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.
14 Mar 2017, 02:27 PM
delia

Re: Product Extra Fields for text, pdfs and flash

That's a good idea. I tell folks convert to use on YouTube. That way you aren't using your bandwidth either!
3 Sep 2017, 12:22 AM
jsarwar

Re: Product Extra Fields for text, pdfs and flash

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.
3 Sep 2017, 11:53 AM
delia

Re: Product Extra Fields for text, pdfs and flash

most likely you have done something wrong with the installation if it's not working. Try reinstalling first.
17 Sep 2017, 03:45 PM
HeleneWallis

Re: Product Extra Fields for text, pdfs and flash

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.
17 Sep 2017, 04:46 PM
delia

Re: Product Extra Fields for text, pdfs and flash

it was added so that if you have tab products mod installed, it will work. Otherwise not to worry.
23 Jan 2018, 08:16 PM
siilike1232

Re: Product Extra Fields for text, pdfs and flash

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 :(
23 Jan 2018, 09:24 PM
delia

Re: Product Extra Fields for text, pdfs and flash

Did you change the folder name from your_custom_template?
24 Jan 2018, 07:43 AM
siilike1232

Re: Product Extra Fields for text, pdfs and flash

Yes, I changed the folder to my custom template
24 Jan 2018, 01:38 PM
delia

Re: Product Extra Fields for text, pdfs and flash

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.
29 Oct 2018, 08:23 AM
oavs

Re: Product Extra Fields for text, pdfs and flash

How can you delete or un associate the once you upload a pdf file?

For example I have uploaded a pdf for product and it shows fine.
Now I duplicate the product and then rename the product but I want to remove previously uploaded file. I do not want to link to any file. Just leave as blank.

How?
30 Oct 2018, 01:47 PM
delia

Re: Product Extra Fields for text, pdfs and flash

well, that wasn't anticipated! and therefore not possible in admin if I remember correctly. It would have to be a database change. If you are comfortable with working with phpmyadmin, this information is all stored in one table named products_extra_fields. Do a search for the product id that you are wanting to change and edit the field that pdf is in. The only checks for displaying is to have something/ anything in that database field.
30 Oct 2018, 11:06 PM
oavs

Re: Product Extra Fields for text, pdfs and flash

Thank you for getting back to my question. Yes as you said I basically deleted in phpMyAdmin.
It would be great if there was an option to delete in case file was old/incorrect one.

Thank you
28 Jun 2019, 12:19 PM
jimmie

Re: Product Extra Fields for text, pdfs and flash

hello, instead of uploading file,( i have problems uploading) is there a way we can add a field to put in file name, like we can do for images on product info page?
like this Or, select an existing file from server, filename: ########################################_
28 Jun 2019, 04:43 PM
delia

Re: Product Extra Fields for text, pdfs and flash

It's simply way more complicated than that. Otherwise there would be no need for a full mod.
29 Jun 2019, 12:01 AM
jimmie

Re: Product Extra Fields for text, pdfs and flash

i figured it out,
i changed it to this,

Code:

<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . ' ' . zen_draw_input_field('file_1') . ' '. TEXT_PRODUCTS_FILE_DESCRIPTION . ' ' . zen_draw_input_field('file_1_title', $pInfo->file_1_title) . zen_draw_hidden_field('previous_file_1', $pInfo->file_1).' '.$pInfo->file_1; ?></td>

. first i upload file through ftp than put in info.
16 Jul 2019, 12:10 PM
jimmie

Re: Product Extra Fields for text, pdfs and flash

how can i add your modification into this modification?

Code:

FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)" . $npf_tables . " WHERE p.products_id = '" . (int)$_GET['pID'] . "' AND pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

Code:

from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCT_EXTRA_FIELDS . " pe where p.products_id = '" . (int)$_GET['pID'] . "' and p.products_id = pd.products_id and p.products_id = pe.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");
22 Sep 2019, 12:53 PM
jimmie

Re: Product Extra Fields for text, pdfs and flash

installed this on v 1.56 and it seems to work except when clicking the link, it goes to homepage
22 Sep 2019, 02:28 PM
delia

Re: Product Extra Fields for text, pdfs and flash

last version updated to is 1.5.4
3 Oct 2019, 12:21 AM
jimmie

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by delia

last version updated to is 1.5.4

anyway of making it compatible with v 1.56c
3 Oct 2019, 09:07 PM
delia

Re: Product Extra Fields for text, pdfs and flash

I truly don't know what the issue is.
6 Nov 2019, 06:34 PM
delia

Re: Product Extra Fields for text, pdfs and flash

Quote:

Originally Posted by jimmie

anyway of making it compatible with v 1.56c

When you say the link doesn't work, what link are you talking about? I'm presently working on an update. The changes from 1.5.4 to 1.5.5 are so minor that the mod should work fine. It should work fine with 1.5.6 as well but the changes in the code (which are probably updates for higher levels of PHP) are significant, so though it may work on your cart, it may have issues on php 7.
29 Aug 2020, 02:38 PM
marton_1

Re: Product Extra Fields for text, pdfs and flash

In the sql is ENGINE=MyISAM DEFAULT CHARSET=latin1

Should this reference utf8 now?
29 Aug 2020, 03:24 PM
delia

Re: Product Extra Fields for text, pdfs and flash

sure. I have not touched this one in years so it is out of date.
29 Aug 2020, 03:28 PM
marton_1

Re: Product Extra Fields for text, pdfs and flash

Thanks for the lightning-fast reply on a Saturday.
29 Aug 2020, 07:00 PM
marton_1

Re: Product Extra Fields for text, pdfs and flash

I got interested in your plugin because google got more serious about using the gtin attribute to submit Global Trade Item Numbers (GTINs).
They say "Products submitted without any unique product identifiers are difficult to classify and may not be eligible for all Shopping programs or features.
Your plugin is more than I need, probably I will set up a new DB table with one gtin field that I can update manually.

BTW, it is no longer possible to upload all plugin files, they will need to be merged with any existing files.
9 Sep 2020, 03:29 PM
delia

Re: Product Extra Fields for text, pdfs and flash

I'm well aware this is not up-to-date. It hasn't been touched in a number of versions. I'm no longer able to maintain all my plugins. Therefore, one should use extreme caution and be prepared to merge files into any version you are presently using.
9 Jun 2024, 04:37 PM
siilike1232

Re: Product Extra Fields for text, pdfs and flash

Upgrading from v1.5.5 to 2.0.1.
My v1.5.5 had products_extra_files plugin and all my products have 4-5 files attached to them.
I cannot find anything similar for newer versions.
Any recommendations?
10 Jun 2024, 03:14 PM
delia

Re: Product Extra Fields for text, pdfs and flash

One of the reasons I did this mod was because I didn't find or didn't like anything that was available at the time. I don't know of a substitute. I also have no idea if this is even possible with 2.0.1 like I did it initially as there has been some major changes to core code since. It is upsetting to me that you will be so impacted by upgrading. I actually wrote this more for the flash element than anything else so I assume you have heavily invested in the text fields? If so I expect a careful merge of the database tables would be possible.
13 Jun 2024, 09:03 AM
siilike1232

Re: Product Extra Fields for text, pdfs and flash

I managed to solve it by connecting database tables products_description and products_extra_fields by Products_id - now the files are displayed at the end of product description.
28 Dec 2024, 07:03 PM
jimmie

Re: Product Extra Fields for text, pdfs and flash

This does work in 210

Show 100 post(s) from this thread on one page