PDA

View Full Version : SQL error when uploading or removing attachment


rgamill
12-17-2007, 11:08 PM
When I try to upload or remove attachments from the message, I get this SQL error:
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE adv_dyna_cfields_entries SET WHERE eid = 7;

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 'WHERE eid = 7' at line 1
Error Number : 1064
Date : Sunday, December 16th 2007 @ 08:15:24 PM
Script : http://www.zzzzzzzzz.com/zzzzzzz/newentry.php
Referrer : http://www.zzzzzzzzz.com/zzzzzzz/newentry.php?do=editentry&e=7
IP Address : xx.xxx.xx.xxx
Username : xxxxxxxx
Classname : vb_database

Remove in the upload window goes smooth. But when I click Save on the edit entry page, I get the above message.

All files I tried to upload/remove were under 2MB. Sometimes upload gives SQL mistake, sometimes it doesn't. But remove always does.

Is there a way to fix it?

P.S. Attachment works, it's just that SQL error page comes up (zzzzzzz.com/zzzzzzz/newentry.php) . I am using 1.0.0 (gold) version

Brian
12-18-2007, 05:00 PM
Looks like the same bug as reported here:

http://www.vbadvanced.com/forum/showthread.php?t=26251

Our Sponsors
 

rgamill
12-18-2007, 06:45 PM
Thanks, Brian! Working smooth now.