Announcement

Collapse
No announcement yet.

Erase the FAQ?

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

  • Steve Machol
    replied
    Ask your host to fix this.

    Leave a comment:


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

    Leave a comment:


  • Steve Machol
    replied
    It looks like it's more than just that:

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

    Leave a comment:


  • CrimsonGT
    replied
    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

    Leave a comment:


  • Steve Machol
    replied
    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

    Leave a comment:


  • CrimsonGT
    started a topic Erase the FAQ?

    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
Loading...
Working...
X