HELP!!! I screwed up my files!!!! Backup is not helping!!!

I followed a thread about moving my "additional images". I made a bit of a mess. I restored the backup I made earlier today and it did not fix the problem. So I though, O no!! I must have made the errors in my backup files somehow. So I restored a backup from 2 days ago. The problem still is not corrected. How can this be? If I restored the files from 2 days ago how can the problem still exist?:oops:

I found that I needed to delete the old directory before uploading the backup. Don't know why but it worked. :clap:
I'm getting better.:smartalec:

Persistence pays. You have come along ways since I have read your posts.. :smile:

When i was first getting the hang of FTP and editing .php files this is what I did..As a rule of thumb when you want to make changes is make a copy first of the original like: tpl_products_info_display.php and save it to a folder on your computer I call Editing..

Now I use my ftp program and rename this file on my server like: tpl_products_info_display.old

Now I make changes to the saved copy in my Editing file with notepad ++ or Ultra Edit and upload to the server. If everything went well the page loads with my changes.. :smile:
If she is all messed up delete the file on the server (tpl_products_info_display.php) you just uploaded and rename old back to the .php.. tpl_products_info_display.old back to tpl_products_info_display.php

I should have done what you said Haredo...but since I was making small changes I thought I could just go in a delete exactly what I put in. I did that and everything came back fine on my website, except when I go to Admin/Product Categories and try to edit a product I get this: (what I was originally doing was trying to add new product fields - but it didnt work out) Can you tell me where to fix this error? Thanks!

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from znc_products p, znc_products_description pd w' at line 14
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id, from znc_products p, znc_products_description pd where p.products_id = '1052' and p.products_id = pd.products_id and pd.language_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

The problem with the SELECT is the comma before the from ...

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id[B],[/B] from znc_products p, znc_products_description pd where p.products_id = '1052' and p.products_id = pd.products_id and pd.language_id = '1'

why you have that, I am not sure ...

Check your collect_info.php for the Product type ... if using Product General ... look at:
/admin/includes/modules/product/collect_info.php

and look at the select around line 45:

      $product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,
                                      p.products_id, p.products_quantity, p.products_model,
                                      p.products_image, p.products_price, p.products_virtual, p.products_weight,
                                      p.products_date_added, p.products_last_modified,
                                      date_format(p.products_date_available, '%Y-%m-%d') as
                                      products_date_available, p.products_status, p.products_tax_class_id,
                                      p.manufacturers_id,
                                      p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                      p.product_is_free, p.product_is_call, p.products_quantity_mixed,
                                      p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,
                                      p.products_sort_order,
                                      p.products_discount_type, p.products_discount_type_from,
[B]                                      p.products_price_sorter, p.master_categories_id
                              from " . TABLE_PRODUCTS . " p, " . [/B]TABLE_PRODUCTS_DESCRIPTION . " pd
                              where p.products_id = '" . (int)$_GET['pID'] . "'
                              and p.products_id = pd.products_id
                              and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

What do you see on the code around the word from

Thank you! That fixed it. It was me trying to mess with PHP when I know nothing about it. My web developer already admonished me and I sadly ignored him. :blush: He said I owe you a cup of coffee...

I was trying to add tables to the database for more product descriptions.

Here is my dilemma. My supplier provides me with a csv file for products but has product descriptions in 3 or 4 separate columns....so before I upload it to ZC using easy populate I have to do alot of manipulation in the excel spreadsheet to get those product descriptions into one cell....any suggestions?

Not off the top of my head ...

Perhaps someone with a similar issue could jump in on here ...

I'm not 100% sure about your issue but does this thread help?

http://www.zen-cart.com/forum/showthread.php?t=146297

It's might help load yours.