vBulletin DataBase Hataları ve Çözümleri

[Leydihan]

[Only Registered Users Can See Links] Gözüken Hata Çıktığında Çözümü SQL Sorgusu Olarak Çalıştırınız

Hata

MySQL Error : Unknown column 'styleid' in 'where clause'

Çözüm

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

[Leydihan]

Hata

MySQL Error : Unknown column 'signaturepermissions' in 'field list'

PHP- Kodu:

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

[Leydihan]

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';

[Leydihan]

Hata

MySQL Error : Unknown column 'field1' in 'field list'

Çözüm

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 ;

[Leydihan]

Hata

MySQL Error : Unknown column 'whoviewed' in 'field list'

Çözüm

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

[Leydihan]

Hata

MySQL Error : Unknown column 'ipaddress' in 'field list'

Çözüm

ALTER TABLE `moderatorlog` ADD `ipaddress` MEDIUMBLOB NOT ¤¤¤¤;

[Leydihan]

Hata

MySQL Error : Unknown column 'user.htmail' in 'field list'

Çözüm

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

[Leydihan]

Hata

MySQL Error : Unknown column 'userfield.field16' in 'field list'

Çözüm

ALTER TABLE userfield ADD `field16` mediumtext;

[Leydihan]

Hata

MySQL Error : Can't open file: 'xxxxx.MYI (errno: 145)

Çözüm

???? ????? ??????? ???????? ????????

[Leydihan]

Hata

MySQL Error : Unknown column 'adminoptions' in 'field list'

Çözüm

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

[Leydihan]

Hata

MySQL Error : Unknown column 'infractiongroupid' in 'field list'

Çözüm

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

[Leydihan]

Hata

mysql error: Unknown column 'title' in 'where clause'

Çözüm

Alter table `profilefield` add `title` varchar(50) NOT ¤¤¤¤ default '';

[Leydihan]

Hata

MySQL Error : Unknown column 'customprofilepic.width' in 'field list'

Çözüm

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

[Leydihan]

Hata

MySQL Error : Unknown column 'post_parsed.styleid_code' in 'on clause'

Çözüm

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

[Leydihan]

Hata

MySQL Error : Unknown column 'maxnewthread' in 'field list'

Çözüm

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 ¤¤¤¤ ;

[Leydihan]

Hata

MySQL Error : Unknown column 'lastpostid' in 'field list'

Çözüm

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

[Leydihan]

Hata

MySQL Error : Unknown column 'infractiongroupid' in 'field list'

Çözüm

ALTER TABLE `infractiongroup` ADD `infractiongroupid` int(10) unsigned NOT ¤¤¤¤ auto_increment; ?? ALTER TABLE user ADD `infractiongroupid` smallint(5) unsigned NOT ¤¤¤¤ default '0' ;

[Leydihan]

Hata

MySQL Error : Unknown column 'grouptitle' in from

Çözüm

ALTER TABLE `settinggroup` ADD `grouptitle` varchar(50) NOT ¤¤¤¤;

[Leydihan]

Hata

MySQL Error : Column 'filedata' in field list is ambiguous

Çözüm

SUBSTRING(filedata ? SUBSTRING(attachment.filedata