Konu: vbulletin database sorunları ve çözümleri

Mysql'de sorgu olarak çalıştırıp sorunları düzeltebilirsiniz,,

HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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:

Kod:

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

ÇÖZÜM:

Kod:

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:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

ALTER TABLE userfield ADD `field16` mediumtext;

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

اعمل اصلاح للقاعدة البيانات والجداول

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

MySQL Error : Unknown column 'grouptitle' in from

ÇÖZÜM:

Kod:

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

---------------------------------------------------------
HATA:

Kod:

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

ÇÖZÜM:

Kod:

SUBSTRING(filedata 
  
  
و  
  
  
SUBSTRING(attachment.filedata

ellerinize sağlık