DB Error: Unknown ErrorDB_Error Object

This Page Contains information about DB Error: Unknown ErrorDB_Error Object By tufat com in category Scripts with 6 Replies. [2763], Last Updated: Sun Jul 05, 2020

tufat com

Sat Apr 26, 2008

6 Comments

341 Visits

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

tufat com

Sat Apr 26, 2008

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

tufat com

Sat Apr 26, 2008

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.

tufat com

Sat Apr 26, 2008

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

Find what: CHARSET=utf8

Replace with: CHARSET=latin1

tufat com

Sat Apr 26, 2008

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

tufat com

Sat Apr 26, 2008

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
https://www.webune.com/forums/db-error-unknown-errordb-error-object.html

Open Source Windows Server Controlpanel

DB Error: Unknown ErrorDB_Error Object

Related Pages