PDA

View Full Version : Image upload error. Any suggestions?


fluentdesigns
04-03-2008, 06:22 PM
Database error in vBulletin 3.7.0 Beta 6:

Invalid SQL:

INSERT INTO adv_dyna_attachments
(entryid, filename, userid, dateline, filesize, hasthumb, valid, extension, posthash, file_data, thumb_data)
VALUES (
0,
'main-1',
'1',
1207257550,
38333,
1,
1,
'jpg',
'ace3924fafc5d3cd5c1405bd63e16b2e',
'',
''
);

MySQL Error : Unknown column 'file_data' in 'field list'
Error Number : 1054
Date : Thursday, April 3rd 2008 @ 04:18:47 PM
Script : /test/dynamics/newattachment.php?do=manageattach&p=
Referrer : /test/dynamics/newattachment.php?catid=7&poststarttime=1207256899&posthash=ace3924fafc5d3cd5c1405bd63e16b2e
Username : Nicholls
Classname : vb_database
MySQL Version : 4.1.22-standard

Brian
04-04-2008, 01:14 PM
Those columns should have been added during the upgrade... Not sure what could have prevented them from being added, but you can add them manually by running the following query through your Admin CP or phpMyAdmin.

ALTER TABLE adv_dyna_attachments ADD file_data MEDIUMBLOB NULL DEFAULT NULL, ADD thumb_data MEDIUMBLOB NULL DEFAULT NULL;