Announcement

Collapse
No announcement yet.

Databases and Avatar problem[vb3.06]

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

  • Databases and Avatar problem[vb3.06]

    Hi to all .

    I have vb 3.06 working on IIS and win2000, with mysql 4.1.8.

    Now I have a new PC with linux fedora c3 , so I have move the mysqldatabases to the linux PC.(with mysql 4.1.10);

    I have also upgrading to php 4.3.11 (from 4.3.10)
    I continue to use the FCGI module (Caraveo DLL).

    Now my configuration is :

    Forum on win PC
    Mysql on Linux PC

    After this change (tonight) I have the followinng problem :

    The avatar of the user do not appear correctly
    (to view this problem please go to http://www.actionscript.it/forum )

    From the Vbulletin technical forum mail I have received the following error

    Code:
     
    Database error in vBulletin 3.0.6:
     
    Invalid SQL: 
     
    SELECT faqname, faqparent, phrase.text AS title
     
    FROM faq AS faq
     
    INNER JOIN phrase AS phrase ON(phrase.phrasetypeid = 7000 AND phrase.varname = faq.faqname)
     
    WHERE phrase.languageid IN(-1, 0, 2)
     
    AND (
     
    faqparent IN('vb_attachment_explain', 'vb_board_search', 'vb_calendar_how', 'vb_email_notification', 'vb_poll_explain', 'vb_thread_rate', 'vb_threadedmode', 'vb_why_register')
     
    OR
     
    faqname IN('vb_attachment_explain', 'vb_board_search', 'vb_calendar_how', 'vb_email_notification', 'vb_poll_explain', 'vb_thread_rate', 'vb_threadedmode', 'vb_why_register')
     
    )
     
     
     
    mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
     
    mysql error number: 1267
     
    Date: Thursday 28th of April 2005 11:30:42 AM
     
    
    and

    Code:
     
     
    Database error in vBulletin 3.0.6:
     
    Invalid SQL: 
     
    SELECT faqname, faqparent, phrase.text AS title
     
    FROM faq AS faq
     
    INNER JOIN phrase AS phrase ON(phrase.phrasetypeid = 7000 AND phrase.varname = faq.faqname)
     
    WHERE phrase.languageid IN(-1, 0, 2)
     
    AND (
     
    faqparent IN('vb_board_search', 'vb_censor_explain', 'vb_clear_cookies', 'vb_memberlist_how')
     
    OR
     
    faqname IN('vb_board_search', 'vb_censor_explain', 'vb_clear_cookies', 'vb_memberlist_how')
     
    )
     
     
     
    mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
     
    mysql error number: 1267
     
    Date: Thursday 28th of April 2005 11:30:56 AM
     
    
    any help is welcome.


    PS: Sorry for my english , I'm italian

  • #2
    This is a bug in MySQL 4.1.x. Please see these threads:

    Bug report:
    http://www.vbulletin.com/forum/bugs...view&bugid=3627

    Workaround:
    http://www.vbulletin.com/forum/showthread.php?t=125929

    Comment


    • #3
      I would also recommend upgrading vBulletin to the latest version 3.0.7 as this fixes a security hole. See the release announcement:

      Comment


      • #4
        Hi Boxy tnx for the reply.

        So if I understand all the problems have the same cause.

        So I must change the "character set" and "collation" to latin1 and latin1_swedish_ci.

        To do this I must make sure that all the tables in the db forums are latin1/latin1_swedish_ci .

        I must also change the character set and collation for the mysqlserver ?

        If yes , can I perform this operation with mysql administrator ? (I have the 1.019).

        Thanks for the support

        Comment


        • #5
          I have now verified from phpMyAdmin that all the tables have collation
          latin1_swedish_ci but mysql server (hosted on linux) use
          UTF-8 Unicode (utf8) and utf8_general_ci.





          Comment


          • #6
            This problem is strange.

            If this affect also the problem of the avatar , I think that the problem is also the character set of the operating system.

            I have read the configuration of the previous mysql database (that is hosted on win) and the character set/collation of the server it's the same of the new mysql forum db (hosted now in linux).

            Do you think I must set the character set of the linux PC equal to win PC ?

            Comment


            • #7
              Can anyone help me ?

              I don't find the solution

              Comment


              • #8
                Ok , I have resolved the problem of the Avatars , I have move it in the filesystem and I have reupload the Avatars.

                One problem is resolved.

                Comment

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