Announcement

Collapse
No announcement yet.

Problems in memberslist

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems in memberslist

    I have a problem only in memberlist.php.. What is this. What can I do?

    I have MySQL 4.1.8-nt and PHP Version 5.0.3

    Code:
    Database error in vBulletin 3.0.5:
       
       Invalid SQL: 
       		SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
      		    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
     		,IF((NOT(options & 1024) AND (user.usergroupid IN (-1,6) OR FIND_IN_SET('6', membergroupids))), 0, reputation) AS reputationscore,level
     		,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
     		,customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline
       		 , lastactivity AS lastvisittime 
       		
       		FROM user AS user
       		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
       		LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
     		LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputationlevelid) 
     		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
     		LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) 
       		
       		WHERE 1=1
       			AND user.usergroupid IN (-1,6,7,2,5)
       		ORDER BY user.username asc 
       		LIMIT 0, 30
       	
     mysql error: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
       
       mysql error number: 1267
       
       Date: Saturday 08th of January 2005 04:49:00 PM
       Script: ***
       Referer: ***
       Username: ftopcu
       IP Address: ***

  • #2
    I think it is because of outdated zend optimizer.
    http://www.vbulletin.com/forum/showthread.php?t=123531

    Comment


    • #3
      I upgraded new version of zend optimizer but it didnt work..

      Comment


      • #4
        You are using MySQL 4.1.X which we still have not deemed safe to use with vBulletin 3 at this time, is it possible for you to go back to 4.0.20/22/23 ?

        Comment


        • #5
          Thanx Zachery. It worked.

          Comment


          • #6
            Originally posted by Zachery
            You are using MySQL 4.1.X which we still have not deemed safe to use with vBulletin 3 at this time, is it possible for you to go back to 4.0.20/22/23 ?
            WOuld this explain why after upgrading mySQL to 4.1.9 I'm getting the following error messages accessing my sites through a browser

            Database error in vBulletin :
            Link-ID == false, connect failed
            mysql error: Client does not support authentication protocol requested by server
            ; consider upgrading MySQL client
            mysql error number: 1251

            Database error in vBulletin :
            Link-ID == false, connect failed
            mysql error:
            mysql error number: 0

            but I can see the databases fine using mySQL Control Centre?

            Comment


            • #7
              Because MySQL 4.1.x uses a new authentication method, if you go into their website and search for OLD_PASSWORD you will find your anwsers,

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X