|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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 __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |