0
Kayıt Ol

Admin Silme Sorunu

7

●

1.467

  • 03-07-2007, 02:59:32
    #1
    Lordreal
    Lordreal
    Config.php den id den sildim panelden sildiğimde bu hatayı alıyorum normal kayıtlı kullanıcı olarak tanımlıyorum

    Alıntı
    Database error in vBulletin 3.6.6:

    Invalid SQL:

    SELECT COUNT(*) AS users
    FROM user
    WHERE userid <> 2
    AND
    (
    usergroupid IN(6)
    OR FIND_IN_SET('6', membergroupids)
    );

    MySQL Error : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
    Error Number : 1267
    Date : Tuesday, July 3rd 2007 @ 01:39:44 AM
    Script : http://www.xxxxx.com/admincp/user.php?do=update
    Referrer : http://www.xxxxx.com/admincp/user.php?do=edit&u=2
    IP Address : 81.214.150.XXX
    Username : Dream
    Classname : vb_database
  • 03-07-2007, 07:58:16
    #2
    Lordreal
    Lordreal
    yokmu arkadaşlar sorunun ne olduğunu çözebilecek ? pleskede giremiyorum girsem bi ahh bunu admin panelden nasıl çözebilirim
  • 03-07-2007, 09:33:52
    #3
    Virtuozzo
    Virtuozzo
    Hem utf8_general_ci hem de latin1_swedish_ci kullanıyorsun.
  • 03-07-2007, 09:41:24
    #4
    tespara
    tespara
    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
  • 03-07-2007, 10:24:30
    #5
    jackal
    jackal
    Kimlik doğrulama veya yönetimden onay bekliyor.
    sıldığın uyenın ısmınde ozel karakter olabılrı belkıde bırde nıckı değiştir istersen oyle dene
  • 07-07-2007, 11:50:35
    #6
    Lordreal
    Lordreal
    tespara çok saol dostum ikinci verdiğin ile oldu karakter sorunu imiş saolasin.

    ama bu seferde böyle bir sorun verdi online.php de 


    Database error in vBulletin 3.6.6:
Invalid SQL:
   SELECT searchid, search.userid, query, searchuser, user.userid AS targetuserid
   FROM search AS search
   LEFT JOIN user AS user ON (user.username = search.searchuser)
   WHERE searchid IN (0,288,286);
MySQL Error  : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Date         : Saturday, July 7th 2007 @ 11:10:36 AM
Script       : http://www.xxxxxxx/online.php
Referrer     : http://www.xxxxxxxx.com/
IP Address   : 85.98.134.xxx
Username     : Dream
Classname    : vb_database
  • 07-07-2007, 12:35:50
    #7
    Lordreal
    Lordreal
    Nedir Arkadaşlar bu sorun bilen varmi acaba ? arada düzeliyor sonra gene gidiyor.
  • 07-07-2007, 15:17:40
    #8
    tespara
    tespara
    Lampard adlı üyeden alıntı: mesajı görüntüle
    Nedir Arkadaşlar bu sorun bilen varmi acaba ? arada düzeliyor sonra gene gidiyor.
    Anladığım kadarı ile sen db oluştururken hata yapmışsın. Tüm tabloların collationları farklı bunun için gerkli sorgular mesaj alanın sığmıyor .


    San özelden link attım oraya bak orda gerkli sorguları verdim ..