vBulletin Database Hatası, vBulletin Database Error Çözümleri

Birincide Gözüken Hata Çıktığında Çözümü SQL Sorgusu Olarak Çalıştırınız

Hata


PHP- Kodu:
MySQL Error : Unknown column 'styleid' in 'where clause'
Çözüm

PHP- Kodu:
ALTER TABLE `style` ADD `styleid` INT(10) UNSIGNED DEFAULT '0' NOT ¤¤¤¤;



Hata


PHP- Kodu:
MySQL Error : Unknown column 'signaturepermissions' in 'field list'
Çözüm


PHP- Kodu:
alter table usergroup add `signaturepermissions` int(10) unsigned NOT ¤¤¤¤ default '0';



Hata


PHP- Kodu:
MySQL Error : Unknown column 'defaultsortfield' in 'field list'
Çözüm


PHP- Kodu:


Alter table `forum` DROP `defaultsortfield`;
Alter table `forum` DROP `defaultsortorder`;
Alter table `forum` ADD `defaultsortfield` varchar(50) NOT ¤¤¤¤ default 'lastpost';
Alter table `forum` ADD `defaultsortorder` enum('asc','desc') NOT ¤¤¤¤ default 'desc';
Alter table `forum` ADD `showprivate` tinyint(3) unsigned NOT ¤¤¤¤ default '0';



Hata



PHP- Kodu:
MySQL Error : Unknown column 'field1' in 'field list'
Çözüm


PHP- Kodu:


ALTER TABLE userfield add `field1` mediumtext ;
ALTER TABLE userfield add `field2` mediumtext ;
ALTER TABLE userfield add `field3` mediumtext ;
ALTER TABLE userfield add `field4` mediumtext ;
ALTER TABLE userfield add `field5` mediumtext ;
ALTER TABLE userfield add `field6` mediumtext ;
ALTER TABLE userfield add `field7` mediumtext ;
ALTER TABLE userfield add `field8` mediumtext ;
ALTER TABLE userfield add `field9` mediumtext ;
ALTER TABLE userfield add `field10` mediumtext ;
ALTER TABLE userfield add `field11` mediumtext ;
ALTER TABLE userfield add `field12` mediumtext ;
ALTER TABLE userfield add `field13` mediumtext ;
ALTER TABLE userfield add `field14` mediumtext ;




Hata


PHP- Kodu:
MySQL Error : Unknown column 'whoviewed' in 'field list'
Çözüm


PHP- Kodu:
ALTER TABLE `thread` ADD `whoviewed` INT(10) UNSIGNED DEFAULT '0' NOT ¤¤¤¤;




Hata



PHP- Kodu:
MySQL Error : Unknown column 'ipaddress' in 'field list'
Çözüm


PHP- Kodu:
ALTER TABLE `moderatorlog` ADD `ipaddress` MEDIUMBLOB NOT ¤¤¤¤;



Hata


PHP- Kodu:
MySQL Error : Unknown column 'user.htmail' in 'field list'
Çözüm

PHP- Kodu:
ALTER TABLE `user` CHANGE `htmail` `msn` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT ¤¤¤¤;



Hata


PHP- Kodu:
MySQL Error : Unknown column 'userfield.field16' in 'field list'
Çözüm

PHP- Kodu:
ALTER TABLE userfield ADD `field16` mediumtext;





Hata



PHP- Kodu:
MySQL Error : Can't open file: 'xxxxx.MYI (errno: 145)
Çözüm


PHP- Kodu:
???? ????? ??????? ???????? ????????



Hata


PHP- Kodu:
MySQL Error : Unknown column 'adminoptions' in 'field list'
Çözüm


PHP- Kodu:
ALTER TABEL user ADD `adminoptions` int(10) unsigned NOT ¤¤¤¤ default '0';



Hata


PHP- Kodu:
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Çözüm


PHP- Kodu:
ALTER TABEL user ADD `infractiongroupid` smallint(5) unsigned NOT ¤¤¤¤ default '0';



Hata

PHP- Kodu:
mysql error: Unknown column 'title' in 'where clause'
Çözüm


PHP- Kodu:
Alter table `profilefield` add `title` varchar(50) NOT ¤¤¤¤ default '';



Hata


PHP- Kodu:
MySQL Error : Unknown column 'customprofilepic.width' in 'field list'
Çözüm


PHP- Kodu:
ALTER TABLE customprofilepic ADD `width` smallint(5) unsigned NOT ¤¤¤¤ default '0';



Hata


PHP- Kodu:
MySQL Error : Unknown column 'post_parsed.styleid_code' in 'on clause'
Çözüm

PHP- Kodu:
ALTER TABLE `post_parsed` ADD `styleid_code` int(11) NOT ¤¤¤¤ default '-1';



Hata


PHP- Kodu:
MySQL Error : Unknown column 'maxnewthread' in 'field list'
Çözüm

PHP- Kodu:


ALTER TABLE `usergroup` ADD `maxnewthread` INT( 11 ) DEFAULT '0' NOT ¤¤¤¤ ;
ALTER TABLE `usergroup` ADD `maxnewtime` INT( 11 ) DEFAULT '0' NOT ¤¤¤¤ ;
ALTER TABLE `usergroup` ADD `maxnewpost` INT( 11 ) DEFAULT '0' NOT ¤¤¤¤ ;
ALTER TABLE `usergroup` ADD `maxnewposttime` INT( 11 ) DEFAULT '0' NOT ¤¤¤¤ ;



Hata


PHP- Kodu:
MySQL Error : Unknown column 'lastpostid' in 'field list'
Çözüm


PHP- Kodu:
ALTER TABLE user ADD `lastpostid` int(10) unsigned NOT ¤¤¤¤ default '0';


Hata


PHP- Kodu:
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Çözüm


PHP- Kodu:
ALTER TABLE `infractiongroup` ADD `infractiongroupid` int(10) unsigned NOT ¤¤¤¤ auto_increment;


??


ALTER TABLE user ADD `infractiongroupid` smallint(5) unsigned NOT ¤¤¤¤ default '0' ;


Hata


PHP- Kodu:
MySQL Error : Unknown column 'grouptitle' in from
Çözüm


PHP- Kodu:
ALTER TABLE `settinggroup` ADD `grouptitle` varchar(50) NOT ¤¤¤¤;
==========


Hata


PHP- Kodu:
MySQL Error : Column 'filedata' in field list is ambiguous
Çözüm



PHP- Kodu:
SUBSTRING(filedata


?


SUBSTRING(attachment.filedata