General ⇒ FAQ (Frequently Answered Questions) :: Archives ⇒ Database Error after upgrading :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexFAQ (Frequently Answered Questions)

Archived ⇒ Database Error after upgrading


I just upgraded a friends website to the 9.1.2.1, i had some problems installing

I searched your forums and found that I had to rename a few tables in the mentioned files (cms_blocks and cms_bbsmilies)

After doing that the installation was finished, it told me to remove the install folder and the install.php

Done that, went in the admin section on the website, tried to activate the blocks I had deactivated and as soon as I did that, I had a Database Error.

Now I can't get in the forums or any directory anymore.

Is there a way to find out what it is that I've done wrong or is there no other option than to install it from scratch again?

Could it be a problem with the skin/templates he's using?

Thanks for your advice

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
9.1.2.1


Whats the link to the topic/post that say to rename those tables?

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


dragonflycms.org/Forum...18108.html

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
9.1.2.1


It doesn't say to renamed DragonflyCMS tables.

if you have cms_blocks but you also have a table that you created for other porpoises called blocks then you had to temporary rename "your blocks table".

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


it said that there was a duplicate in_module within the cms_blocks

that's what I renamed for the install to work again?

after I had done that the install worked and I could go on the website.

i had the error after i tried to activate the blocks again, so I guess that's where the error is somewhere? Can I upload something for it to work again?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
9.1.2.1


Whats the error?

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


How can I find that out? for some reason it hasn't been sent to the emailaddress

when I go to the website it only says there's a Database Error

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
9.1.2.1


includes/config.php
CPG_DEBUG = true;

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


thanks, the error is:

On /
While executing query "SELECT COUNT(*) FROM cms_poll_check WHERE ip='R�/' AND poll_id='1'"

the following error occured: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
9.1.2.1


I would like to remember all users to search our forums and read our FAQs.

Most likely your problems has been fixed or there is an answer already.

dragonflycms.org/FAQ/cat=17.html

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


I did go through the FAQ, but couldn't find out how to have it show the error


Thanks very much, that link sorted it

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
9.1.2.1

All times are UTC