PDA

View Full Version : Update in Mass problem (SQL Error)


Hobbit
12-28-2006, 07:04 AM
Hi, I've just installed Pixelpost 1.5 Final and uploaded 2 images for testing. When I entered the Images tab in the Administration panel there is the "Update in Mass" button and a list on the left to select an action. In that list there is the Unassign item and image categories below. So I select the unassign category and a few images, which belong to that category. Then I press the Update in Mass button and I get an 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 '2' ) or 0' at line 1".

Where is the problem and how can I solve it?
Help, please. Thanks in advance :)

Connie
12-28-2006, 07:17 AM
no help is possible without information ;?)

please, have a look in the admin panel and give us the information which is collected there:

Server Version
MySQL-Version etc.

without this I can tell you that there is an error
but that you know already ;=)

Hobbit
12-28-2006, 07:26 AM
I'm sorry. I forgot that information was needed :)

Pixelpost Information

You are running Pixelpost version: 1.5 Final - July 2006

Host Information

PHP-version 4.4.3 (Pixelpost's min requirement: PHP version: 4.3.0 )
Session save path /tmp

MySQL version5.0.27 - standard (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/1.3.37 (Unix) mod_jk/1.2.14 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.3 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a

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

Paths

Guessed imagepath: /home/rzkbs/public_html/hobbit/images/

Configured Imagepath: ../images/

Image Directory: OK - Can we write to the directory? YES. CHMOD: 0777

Thumbnails Directory: OK - Can we write to the directory? YES. CHMOD: 0777

Language Directory: OK

Addons Directory: OK

Includes Directory: OK

Templates Directory: OK

GeoS
12-28-2006, 06:54 PM
If you can present to us the rest of this SQL statement then we can try to help otherwise we dont have any possiblity to do that.

austriaka
12-28-2006, 07:44 PM
guessing: could it be your category name contains an apostroph ['] or a quotation mark ["]?
MySQL doesn't like that

KArin