Error after uploading image during edit
 

Recently upgraded to Classifieds 4.0.
Having two issues.
1. Can't seem to upload a .jpg file using the EditProduct. Images upload just fine when they are added using uploadproduct.php, but not editproduct.php.

2. This error was emailed to me which may have something to do with the first error:

An error was encountered during execution of the query:

UPDATE cp_products SET cat=avatars, approved=1 WHERE id=63

The query returned with an errorcode of:

Unknown column 'avatars' in 'field list'

well that has nothing to do with uploading an image I would think

test buy - PhotoPost Classifieds

I replace an image without fail

The query your talking about only happens when you try moving an ad to a different category but the issue I see is where in the world is your category variable being set to avatars? I can not replicate your issue but you can try changing line 22 of image-inc.php to this and see if it helps

Wanted to close the loop on this issue. It was related to my having removed the catoption/category move selection from edittemplate.tmpl without addressing the variable, category, that is set from that selection. Once I added that in as a hidden input, the problems all went away.
Thank you.

yeah that makes sense.

Was wondering how you ever got the issue to begin with and modifying code would do that