DB Error: Unknown ErrorDB

DB Error: Unknown ErrorDB_Error Object

Webune

db error: unknown errordb_error object

db, error, unknown, errordb, error, object

Home Forums

SEO Forums » Tools » Scripts » DB Error: Unknown ErrorDB_Error Object

DB Error: Unknown ErrorDB_Error Object

Post Description: db error: unknown errordb_error object

db, error, unknown, errordb, error, object

This Post Has Been Viewed 71 Times Since Sat Apr 26, 2008 1:46 pm Posted By tufat com with 6 replies

POST# 1327

Posted On: Sat Apr 26, 2008 1:46 pm

tufat com

Topic: 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

BBCODE:

HTML Code:

Sat Apr 26, 2008 1:47 pm

Web Hosting Support

Reply #2005

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

Sat Apr 26, 2008 2:08 pm

tufat com

Reply #2006

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

tufat com

Reply #2007

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

tufat com

Reply #2008

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

tufat com

Reply #2009

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

tufat com

Reply #2010

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

DB Error: Unknown ErrorDB_Error Object

What do you think?