DB Error: Unknown ErrorDB_Error Object
RegisterLogin
DB Error: Unknown ErrorDB_Error Object
Post Description: DB Error: Unknown ErrorDB_Error Object
Tags: DB, Error:, Unknown, ErrorDB_Error, Object
This Post Was Posted On Apr 26, 2008 By tufat com #1873
Post Description: DB Error: Unknown ErrorDB_Error Object
Tags: DB, Error:, Unknown, ErrorDB_Error, Object
This Post Was Posted On Apr 26, 2008 By tufat com #1873
DB Error: Unknown ErrorDB_Error Object by tufat com
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
)
(
[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
Leave Your Comments
Related Pages: [Add Your Website]
Post New Topic
Web Hosting Support
#2103 1
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.
############ !!!! 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.
Sep 26, 2009 Reply Report abuse
tufat com
#2108 2
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
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
Apr 26, 2008 Reply Report abuse
tufat com
#2107 3
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
and i click YES to delete all
Apr 26, 2008 Reply Report abuse
tufat com
#2106 4
i copy and paste into a blank notepad then i replaced these (control H)
Find what: CHARSET=utf8
Replace with: CHARSET=latin1
Find what: CHARSET=utf8
Replace with: CHARSET=latin1
Apr 26, 2008 Reply Report abuse
tufat com
#2105 5
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.
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.
Apr 26, 2008 Reply Report abuse
tufat com
#2104 6
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
this is how i fixed it
i logged into my phpmyadmin then i click on the EXPORT link at the top
Apr 26, 2008 Reply Report abuse
Leave Your Comments...
©2011 Webune Forums - Fri Dec 23, 2011 7:23 pm
Powered by: Webune Forums V3
Powered by: Webune Forums V3