DB Error: Unknown ErrorDB

Forums » Scripts »» DB Error: Unknown ErrorDB_Error Object

Sat Apr 26, 2008 1:46 pm - DB Error: Unknown ErrorDB_Error Object

#1873

DB Error: Unknown ErrorDB_Error Object

can you help me with this error i get i just installed easysite scrip that im trying out but i get this error

DB Error: unknown errorDB_Error Object
(
[error_message_prefix] =>
[error_prepend] =>
[error_append] =>
[mode] => 16
[level] => 1024
[code] => -1
[message] => DB Error: unknown error
[debuginfo] =>
[userinfo] => select *, if(id in (null), concat(title, '[shared]'), title) as title from es__layers where (site_key = 'default' or id in (null)) and ( restrict_to = '0' or restrict_to = '' or restrict_to like '%%' or restrict_to='' ) order by id desc [nativecode=Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'concat']
[callback] => errhndl
)

what can i do

author: tufat com

Share this post by copy and paste this URL and put it on your forums or use it on your profile like myspace, friendster, Facebook, Twitter or others and add in with your comments.

Use this HTML code to embed this topic, just copy the code from the "Embed" box. Once you've copied the code, just paste it into your website or blog to embed it.

BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin® and others. Just Copy and Paste this code on with Posts and Replies on your forums

Sat Sep 26, 2009 10:23 am - Re: DB Error: Unknown ErrorDB_Error Object

#2103

Web Hosting Support

i remember this error. basically you are getting it because the Collation is setup incorrectly. you need to change it to UTF-8

############ !!!! WARNING !!!! ############
ALWAYS DO A BACKUP OF YOUR DATA BEFORE YOU ATTEMPT ANYTHING LIKE THIS, OR ELSE YOU COULD LOSE YOUR DATA. I AM NOT RESPONSIBLE FOR ANY DATA LOST. IF YOU ARE GOING TO ATTEMPT THIS, ALWAYS MAKE A BACKUP COPY OF YOUR CURRENT DATA.

Sat Apr 26, 2008 2:08 pm - Re: DB Error: Unknown ErrorDB_Error Object

#2104

tufat com

ok i followed what you told me

this is how i fixed it

i logged into my phpmyadmin then i click on the EXPORT link at the top

Sat Apr 26, 2008 2:11 pm - Re: DB Error: Unknown ErrorDB_Error Object

#2105

tufat com

then i checked these:

Structure:
Add AUTO_INCREMENT value
Enclose table and field names with backquotes

Data:
Use hexadecimal for binary fields

and exported the data, you can either exported to a file or you can copy and paste.

Sat Apr 26, 2008 2:13 pm - Re: DB Error: Unknown ErrorDB_Error Object

#2106

tufat com

i copy and paste into a blank notepad then i replaced these (control H)

Find what: CHARSET=utf8

Replace with: CHARSET=latin1

Sat Apr 26, 2008 2:17 pm - Re: DB Error: Unknown ErrorDB_Error Object

#2107

tufat com

then i went back to my database and i have to delete all the tables so i click on CHECK ALL and select DROP from the drop down menu of choices

and i click YES to delete all

Sat Apr 26, 2008 2:22 pm - Re: DB Error: Unknown ErrorDB_Error Object

#2108

tufat com

now that my datbase is empty i can just import (or dump) my new database with the new charset so click on the SQL button or link at the top of your page and copy and paste all the information from your notepad into the text area and click go

thats it

now when you go back to you easysite page, you will not see your error but instead you will see the default page