Tekil Mesaj gösterimi
  #1  
Alt 05-07-2014, 07:04 AM
Teoman Teoman isimli Üye şimdilik offline konumundadır
   
Standart vbulletin database hataları ve çözümleri


Aşagıda karşılaştığınız hatalarda SQL sorgusu çalıştırmanız gerekmektedir.

MySQL Hatası;
MySQL Error : Unknown column 'styleid' in 'where clause'
Çözüm:
Kod:
ALTER TABLE `style` ADD `styleid` INT(10) UNSIGNED DEFAULT '0' NOT ¤¤¤¤;  
==========
------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'signaturepermissions' in 'field list'
Çözüm:
Kod:
alter table usergroup add `signaturepermissions` int(10) unsigned NOT ¤¤¤¤ default '0';  
==========
-------------------------------------------------------------

MySQL Hatası;
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';  
==========
---------------------------------------------------------------

MySQL Hatası;
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 ;  
==========
-----------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'whoviewed' in 'field list'
Çözüm:
Kod:
ALTER TABLE `thread` ADD `whoviewed` INT(10) UNSIGNED DEFAULT '0' NOT ¤¤¤¤;  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'ipaddress' in 'field list'
Çözüm:
Kod:
ALTER TABLE `moderatorlog` ADD `ipaddress` MEDIUMBLOB NOT ¤¤¤¤;  
==========
--------------------------------------------------------------------

MySQL Hatası;
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 ¤¤¤¤;  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'userfield.field16' in 'field list'
Çözüm:
Kod:
ALTER TABLE userfield ADD `field16` mediumtext;  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Can't open file: 'xxxxx.MYI (errno: 145)
Çözüm:
Kod:
???? ????? ??????? ???????? ????????  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'adminoptions' in 'field list'
Çözüm:
Kod:
ALTER TABEL user ADD `adminoptions` int(10) unsigned NOT ¤¤¤¤ default '0';  
==========
------------------------------------------------------------------
MySQL Hatası;
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Çözüm :
Kod:
ALTER TABEL user ADD `infractiongroupid` smallint(5) unsigned NOT ¤¤¤¤ default '0';  
==========
------------------------------------------------------------------

MySQL Hatası;
mysql error: Unknown column 'title' in 'where clause'
Çözüm:
Kod:
Alter table `profilefield` add `title` varchar(50) NOT ¤¤¤¤ default '';  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'customprofilepic.width' in 'field list'
Çözüm:
Kod:
ALTER TABLE customprofilepic ADD `width` smallint(5) unsigned NOT ¤¤¤¤ default '0';  
==========
------------------------------------------------------------------

MySQL Hatası;
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';  
==========
------------------------------------------------------------------

MySQL Hatası;
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 ¤¤¤¤ ;  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'lastpostid' in 'field list'
Çözüm:
Kod:
ALTER TABLE user ADD `lastpostid` int(10) unsigned NOT ¤¤¤¤ default '0';  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Çözüm:
ALTER TABLE `infractiongroup` ADD `infractiongroupid` int(10) unsigned NOT
Kod:
¤¤¤¤ auto_increment; 
  
  
?? 
  
  
ALTER TABLE user ADD `infractiongroupid` smallint(5) unsigned NOT ¤¤¤¤ default '0' ;  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Unknown column 'grouptitle' in from
Çözüm:
Kod:
ALTER TABLE `settinggroup` ADD `grouptitle` varchar(50) NOT ¤¤¤¤;  
==========
------------------------------------------------------------------

MySQL Hatası;
MySQL Error : Column 'filedata' in field list is ambiguous
Çözüm:
Kod:
SUBSTRING(filedata 
  
  
?  
  
  
SUBSTRING(attachment.filedata
Alıntıdır..
Alıntı ile Cevapla
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137