Problems with updating category images.

[JETC]

Hi,

I updated from pixelpost v1.5 to v1.6 and I am having problems when I try to update the image/s to remove a category. It adds a category fine but when I try to remove a category, it gives me an error like this:

ou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '4') or 0' at line 1

Any idea what it could be?

PHP-version 4.4.2 (Pixelpost's min requirement: PHP version: 4.3.0 )

Session save path /tmp

MySQL version 5.0.18-log (Pixelpost's min requirement: MySQL: 3.23.58 )

GD-lib bundled (2.0.28 compatible) with JPEG support

File Uploads to Pixelpost site are possible.

Server Software Apache/2.2.2 (Unix) mod_ssl/2.2.2 OpenSSL/0.9.8a DAV/2 PHP/4.4.2 mod_jk/1.2.15 mod_perl/2.0.2 Perl/v5.8.0

EXIF Pixelpost is using exifer v1.5 for EXIF-information.

[austriaka]

did you use the latest version for update? This sounds like an error we had in the first 1.6 Beta

KArin

[JETC]

No, I'm pretty sure I got the latest version. Hrmm... I guess I could start all over again.

[Dkozikowski]

No, I'm pretty sure I got the latest version. Hrmm... I guess I could start all over again.

Please try again as I just checked using the downloadable version of pixelpost 1.6.0 and i can not reproduce the problem.

If the problem continues, let me know and i'll have a deeper look into the situation.

[JETC]

hrmm, I did a clean install and uploaded an image. I tried to un-assign a category from the image and still gave me the same error. I could assign categories to an image just fine tho and also un-assign the category when i edit the image.

[Dkozikowski]

Can you be more specific??

What are you actually doing?
What page are you on when removing categories?

[JETC]

I am on the images page where it lists all the images you have uploaded. I am trying to mass update Un-assign categories from image/s. It doesn't matter how many images I pick (either 1 or more), it gives me the SQL syntax. I am able to assign categories to an image but not able to un-assign them.

[austriaka]

JETC, you are right, this little bug was not updated in current download version.

For now please open your admin/images_edit.php
Got to line 358
find this line:
echo "<option value=\"unassign-$id'\">$name</option>\n";
replace it with this line:
echo "<option value=\"unassign-$id\">$name</option>\n";
Save and upload.

Everything will work now :-)
KArin

PS: Dave, it only fails when magic_quotes is off in PHP configuration. with magic quotes on it works...

[JETC]

Yep, it works now. Thank you very much. :)

[Dkozikowski]

I am on the images page where it lists all the images you have uploaded. I am trying to mass update Un-assign categories from image/s. It doesn't matter how many images I pick (either 1 or more), it gives me the SQL syntax. I am able to assign categories to an image but not able to un-assign them.

Ahh. I was testing while in the edit menu.