Hello guys..
I have 2 problems about mysql database..

First, What means that error :

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0


Second, If someone try to search in FAQ, he'll get that error shown below:

Database error in vBulletin 3.0.7:

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, 1)
AND (
faqparent IN('vb_lost_password', 'vb_use_cookies', 'vb_why_register')
OR
faqname IN('vb_lost_password', 'vb_use_cookies', 'vb_why_register')
)

mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

mysql error number: 1267

Date: Sunday 05th of June 2005 06:50:31 PM
Script: http://xxx.xxx.xxx/forum/faq.php?s=&...l&titlesonly=0

What's wrong ?
Thanks.

I believe the first one means it can't connect to the database, not sure though.
Have you made any modifications to the faq.php file?

The first one as deaths said, the MySQL database isn't connecting. And the second one is done incorrectly. Use LEFT JOIN. If you can, don't use alot of conditions inside your left join if you don't have to.

__________________
Earnersforum.com - Learn how to make money online! New Look!

Ken Iovino / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers