Database error in vBulletin 3.6.4:
Invalid SQL:
UPDATE administrator SET
### Bitfield: administrator.adminpermissions ###
adminpermissions = IF(adminpermissions & 4, adminpermissions, adminpermissions + 4),
adminpermissions = IF(adminpermissions & 8, adminpermissions, adminpermissions + 8),
adminpermissions = IF(adminpermissions & 16, adminpermissions, adminpermissions + 16),
adminpermissions = IF(adminpermissions & 32, adminpermissions, adminpermissions + 32),
adminpermissions = IF(adminpermissions & 64, adminpermissions, adminpermissions + 64),
adminpermissions = IF(adminpermissions & 128, adminpermissions, adminpermissions + 128),
adminpermissions = IF(adminpermissions & 256, adminpermissions, adminpermissions + 256),
adminpermissions = IF(adminpermissions & 512, adminpermissions, adminpermissions + 512),
adminpermissions = IF(adminpermissions & 1024, adminpermissions, adminpermissions + 1024),
adminpermissions = IF(adminpermissions & 2048, adminpermissions, adminpermissions + 2048),
adminpermissions = IF(adminpermissions & 4096, adminpermissions, adminpermissions + 4096),
adminpermissions = IF(adminpermissions & 8192, adminpermissions, adminpermissions + 8192),
adminpermissions = IF(adminpermissions & 16384, adminpermissions, adminpermissions + 16384),
adminpermissions = IF(adminpermissions & 65536, adminpermissions, adminpermissions + 65536),
adminpermissions = IF(adminpermissions & 32768, adminpermissions - 32768, adminpermissions),
cssprefs = 'vBulletin_2_Default',
dismissednews = ''
WHERE userid = 58;
MySQL Error : Unknown column 'dismissednews' in 'field list'
Error Number : 1054
Date : Sunday, April 22nd 2007 @ 07:40:21 AM
Script : http://www.domain.com/admincp/adminpermissions.php?do=update
Referrer : http://www.domain.com/admincp/adminpermissions.php?do=edit&u=58
IP Address : 88.222.82.38
Username : Leo™
Classname : vb_databasebu hata sadece yonetıcı yetkılerını vermek ıstedıgımde degıl ayrıca uyegruplarında bırsey degıstırmek ıstedıgımdede aynı sorunla karsılasıyorum bu sorunu nasıl cozebılırım acaba yardımcı olabılecek arkadaslar varsa cıdden sevınırım
Arkadaslar biraz daha aramanın sonucunda sorunun cözümünü buldum yinede hepinize teşekkürler aynı sorunla karsılasabılecek diger arkadaşlar için Çözümü buraya yazıyorum
__________________________________________________ _________________________________________
Aşagıdaki sorguyu çalıştırın
ALTER TABLE administrator ADD dismissednews TEXT;ve ardından sadece tabloları onar deyip çıkın
kendi sorununun cevabını kendi bulanlara bayılıyorum