Recently i had some trouble involving white pages showing up instead of my forums i contacted the support staff and i managed to get them back up after a database problem in my attachment table, unfortunatly now i realied no one can post a thread and get this error
Database error in vBulletin 4.0.2:
Invalid SQL:
SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings,
at.contenttypes
FROM attachment AS a
INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.posthash = '0446545a14f2ca0e0f38b5046cf43e24'
AND
a.userid = 1
AND
a.contenttypeid = 1
ORDER BY a.contentid, a.attachmentid;
MySQL Error : Unknown column 'a.contentid' in 'field list'
Error Number : 1054
Request Date : Tuesday, April 6th 2010 @ 03:25:38 PM
Error Date : Tuesday, April 6th 2010 @ 03:25:38 PM
I was told i was missing a field in my attachment table and have re-added it the following way as told
Field: state
Type: Enum
Length/Values: 'visible','moderation'
(with those single quotes around them)
Null: not null
Default: visible
This bought my forums back although not fully for some reason
Any help much loved
Database error in vBulletin 4.0.2:
Invalid SQL:
SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings,
at.contenttypes
FROM attachment AS a
INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.posthash = '0446545a14f2ca0e0f38b5046cf43e24'
AND
a.userid = 1
AND
a.contenttypeid = 1
ORDER BY a.contentid, a.attachmentid;
MySQL Error : Unknown column 'a.contentid' in 'field list'
Error Number : 1054
Request Date : Tuesday, April 6th 2010 @ 03:25:38 PM
Error Date : Tuesday, April 6th 2010 @ 03:25:38 PM
I was told i was missing a field in my attachment table and have re-added it the following way as told
Field: state
Type: Enum
Length/Values: 'visible','moderation'
(with those single quotes around them)
Null: not null
Default: visible
This bought my forums back although not fully for some reason
Any help much loved
Comment