PDA

View Full Version : database error after installing


NjmUae.com
Tue 15th Apr '08, 4:12pm
Hi every one

I just install the blog
and when I inter this bage

http://www.njmuae.com/vb/blog_usercp.php (http://www.njmuae.com/vb/blog_usercp.php)

I found this database error

Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT blog.blogid, lastblogtextid AS blogtextid, blog_text.userid, blog_text.state, IF(blog_text.userid = 0, blog_text.username, user.username) AS username, blog.blogid, blog.title
FROM blog AS blog
LEFT JOIN blog_text AS blog_text ON (blog.lastblogtextid = blog_text.blogtextid)
LEFT JOIN user AS user ON (blog_text.userid = user.userid)
WHERE blog.userid = 2
AND blog_text.blogtextid <> blog.firstblogtextid
AND blog_text.state IN ('visible','moderation','deleted')
AND blog.state IN ('visible','moderation')
AND blog.dateline <= 1208286451
AND blog.pending = 0
ORDER BY blog.lastcomment DESC
LIMIT 5;
MySQL Error : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'if'
Error Number : 1267
Date : Tuesday, April 15th 2008 @ 11:07:31 PM
Script : http://www.njmuae.com/vb/blog_usercp.php
Referrer : http://www.njmuae.com/vb/usercp.php
IP Address : 195.229.236.214
Username : نجم الياه
Classname : vb_database

NjmUae.com
Wed 16th Apr '08, 7:38am
where are you guys
I change the name in the blog table to latin1_swedish_ci

and still the problem

Colin F
Wed 16th Apr '08, 12:04pm
I'm looking at this in your ticket.