MySQL Error After 1.2.0 -> 1.3.0 Upgrade

[tealnet]

When we go to add a new product, we see this error several times around the area where images are uploaded:

MySQL error: 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 '' at line 1
Query was: SELECT Large_Image FROM Products WHERE record_number =

The MySQL database upgrade script ran fine. In fact we had no troubles at all with the upgrade process.

Erick

[Jamie]

Hi Erick,

This is a bug. Please see this post for a fix:

http://www.ldev.com/forums/showthread.php?t=1071

Thanks,
Jamie

[tealnet]

Hi Erick,

This is a bug. Please see this post for a fix:

http://www.ldev.com/forums/showthread.php?t=1071

Thanks,
Jamie

Okay, I applied the update (manually) which fixed the MySQL errors. But the problem is now, images are not being uploaded properly. It seems like the main image is actually being uploaded... but you can't see it anywhere. What I did is upload a large image and told it to autogenerate the rest from the large one. I filled in the width and left the height auto. It appears to add the product successfully, but the image does not appear the in cart. There is a "no image available" filler. When I go back into the cart admin, the pictures are all gone and the large image I uploaded shows an X unless I click on it, then it does pop up the correct image. Any idea why the images are getting tweaked?

[Jamie]

Not sure what is causing that. If you open a helpdesk ticket, we can check it out.

Thanks,
Jamie