Announcement

Collapse
No announcement yet.

Erase the FAQ?

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

  • Erase the FAQ?

    I already posted about this but did not get an official response...I get this error when I try and erase the current FAQ so I can create a new one.

    Code:
    Database error in vBulletin 3.0.7:
    Invalid SQL: 
    	SELECT faqname, text AS title
    	FROM faq AS faq
    	INNER JOIN phrase AS phrase ON (phrase.varname = faq.faqname AND phrase.phrasetypeid = 7000 AND phrase.languageid IN(-1, 0))
    	WHERE faqname = 'vb_faq'
       
    mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
    mysql error number: 1267
    Date: Tuesday 10th of May 2005 09:11:02 PM
    Script: [url="http://www.nightmaremotorsports.com/forum/admincp/faq.php?do=delete&faq=vb_faq"]http://www.nightmaremotorsports.com/forum/admincp/faq.php?do=delete&faq=vb_faq[/url]
    Referer: [url="http://www.nightmaremotorsports.com/forum/admincp/faq.php?null=0"]http://www.nightmaremotorsports.com/forum/admincp/faq.php?null=0[/url]
    Username: CrimsonGT
    IP Address: 68.101.88.243

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

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

    Workaround:
    http://www.vbulletin.com/forum/showthread.php?t=125929
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      lol, I read through both those threads and it was like trying to read a owners manual written in arabic. From what I could gather...

      I just run this query from phpmyadmin and it should fix it?

      ALTER TABLE `phrase` CHANGE `varname` `varname` VARCHAR( 250 ) NOT NULL

      Comment


      • #4
        It looks like it's more than just that:

        http://www.vbulletin.com/forum/showthread.php?t=125929
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Well crap, I pay for hosting so I imagine I dont have access the the MySQL config file.

          Comment


          • #6
            Ask your host to fix this.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            Loading...
            Working...
            X