Product Extra Fields for text, pdfs and flash

Parafanaylya:

Where might I find the debug-log files?

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

[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

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.

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.

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

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)

Did you run the sql?

Can't access admin since uploading files. See above.

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.

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.

Running 1.5.4 and V1.8?

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

Thanks lat9 for that helpful bit of advice!

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:

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

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

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.

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.

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

my backup's corrupted :(

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

from admin/includes/modules/copy_to_confirm.php

///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

I will be doing these files one at a time as I don't need to dig myself into a deeper hole.

From admin/includes/modules/delete_product_confirm.php

 > //delia - product extra fields mod

  $db->Execute("delete from " . TABLE_PRODUCT_EXTRA_FIELDS . "
                where products_id = '" . (int)$product_id . "'");
                //