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
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
vBulletin® v3.7.3, Copyright ©2000-2013, Jelsoft Enterprises Ltd.