Product Edit Error

[whyme2011]

Hi! If anyone can help me, I would really really appreciate it! In the Admin/Categories-Products Page, I tried to edit my products; however, I get this error (copied below). Could anyone please help me? 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 products p, products_description pd where p.p' at line 13
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, from products p, products_description pd where p.products_id = '3' 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.

[kobra]

You need to ptovide more information as outlined in the posting FAQ's

ZenCart version and server info

[whyme2011]

Thanks.

new version 1.3.9h
server: mysql/linux

[kobra]

Suggest you read posting FAQ's
http://www.zen-cart.com/forum/faq.php

server: mysql/linux

What versions??
apache
php
mysql

[whyme2011]

sorry! i'm new to this and trying my best to learn. i really appreciate your understanding. the version is mysql 5.0.

What versions??
apache
php
mysql

[kobra]

How about the rest??

What versions??
apache
php
mysql = 5.0

[whyme2011]

Thanks. I got it fixed. My hosting server was updating/back up their server. So I couldn't do anything but wait.

Thanks again! Now I'm struggling with another problem completely separate from this.