Tekil Mesaj gösterimi - Admin Silme Sorunu

Konu Admin Silme Sorunu

03-07-2007, 09:41:24

Lampard adlı üyeden alıntı: mesajı görüntüle

yokmu arkadaşlar sorunun ne olduğunu çözebilecek ? pleskede giremiyorum girsem bi ahh bunu admin panelden nasıl çözebilirim

Bu tür hataların genel sebebi ilişkili tabloların karışık Collation olmasıdır.
Hata kodunu genel açıklaması aşağıdaki gibidir

Error: 1267 SQLSTATE: HY000       (ER_CANT_AGGREGATE_2COLLATIONS)
Message: Illegal mix of collations (%s,%s) and (%s,%s) for       operation '%s'

Bu sorunu çözmek için sıra ile aşağıdaki sorgular çalışıtırılır

ALTER DATABASE `forum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci

ALTER TABLE `access`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `adminhelp`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `administrator`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `adminlog`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `adminmessage`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `adminutil`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `announcement`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `announcementread`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `attachment`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `attachmentpermission`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `attachmenttype`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `attachmentviews`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `avatar`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `bbcode`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `calendar`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `calendarcustomfield`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `calendarmoderator`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `calendarpermission`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `cpsession`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `cron`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `cronlog`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `customavatar`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `customprofilepic`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `datastore`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `deletionlog`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `editlog`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `event`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `externalcache`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `faq`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `forum`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `forumpermission`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `forumread`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `holiday`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `icon`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `imagecategory`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `imagecategorypermission`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `infraction`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `infractionban`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `infractiongroup`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `infractionlevel`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `language`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `mailqueue`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `moderation`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `moderator`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `moderatorlog`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `passwordhistory`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `paymentapi`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `paymentinfo`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `paymenttransaction`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `phrase`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `phrasetype`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `plugin`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `pm`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `pmreceipt`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `pmtext`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `podcast`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `podcastitem`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `poll`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `pollvote`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `post`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `posthash`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `postindex`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `postparsed`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `product`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `productcode`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `productdependency`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `profilefield`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `ranks`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `regimage`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `reminder`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `reputation`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `reputationlevel`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `rssfeed`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `rsslog`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `search`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `session`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `setting`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `settinggroup`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `sigparsed`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `sigpic`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `smilie`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `stats`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `strikes`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `style`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `subscribeevent`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `subscribeforum`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `subscribethread`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `subscription`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `subscriptionlog`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `subscriptionpermission`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `tachyforumpost`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `tachythreadpost`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `template`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `templatehistory`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `thread`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `threadrate`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `threadread`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `threadredirect`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `threadviews`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `upgradelog`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `user`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `useractivation`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `userban`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `userfield`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `usergroup`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `usergroupleader`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `usergrouprequest`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `usernote`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `userpromotion`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `usertextfield`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `usertitle`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `vbfields`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci
ALTER TABLE `word`  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

eğer yukarıdaki sorgu sorunu çözmesse aşağıdaki sorguyu çalıştırın

ALTER TABLE `user` 
CHANGE `membergroupids` `membergroupids` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `username` `username` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `password` `password` CHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `email` `email` CHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `parentemail` `parentemail` CHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `homepage` `homepage` CHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `icq` `icq` CHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `aim` `aim` CHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `yahoo` `yahoo` CHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `msn` `msn` CHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `skype` `skype` CHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `usertitle` `usertitle` CHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `timezoneoffset` `timezoneoffset` CHAR(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `birthday` `birthday` CHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `ipaddress` `ipaddress` CHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `salt` `salt` CHAR(3) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, 
CHANGE `infractiongroupids` `infractiongroupids` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL