[Foruma üye olmadığınız sürece forum içeriğindeki bağlantıları görüntüleyemezsiniz. Foruma üye olmak için TIKLAYIN!]

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

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'

---

PHP- Kodu:

PHP- Kodu:

---

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

---

Hata
PHP- Kodu:

PHP- Kodu:

---

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

---

Çözüm

PHP- Kodu:

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

---