Gibanel
Offline
Joined: Dec 18, 2007
Posts: 6
Location: The Netherlands
0 👍
/
0 👎
Tue Dec 18, 2007 10:32 am
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
NanoCaiordo
Offline
Joined: Jun 29, 2004
Posts: 4291
Location: Italy
0 👍
/
0 👎
Tue Dec 18, 2007 11:39 am
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
Gibanel
Offline
Joined: Dec 18, 2007
Posts: 6
Location: The Netherlands
0 👍
/
0 👎
Tue Dec 18, 2007 12:02 pm
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
9.1.2.1
NanoCaiordo
Offline
Joined: Jun 29, 2004
Posts: 4291
Location: Italy
0 👍
/
0 👎
Tue Dec 18, 2007 1:22 pm
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
Gibanel
Offline
Joined: Dec 18, 2007
Posts: 6
Location: The Netherlands
0 👍
/
0 👎
Tue Dec 18, 2007 1:39 pm
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
NanoCaiordo
Offline
Joined: Jun 29, 2004
Posts: 4291
Location: Italy
0 👍
/
0 👎
Tue Dec 18, 2007 4:00 pm
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
Gibanel
Offline
Joined: Dec 18, 2007
Posts: 6
Location: The Netherlands
0 👍
/
0 👎
Tue Dec 18, 2007 7:46 pm
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
NanoCaiordo
Offline
Joined: Jun 29, 2004
Posts: 4291
Location: Italy
0 👍
/
0 👎
Tue Dec 18, 2007 10:38 pm
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
Gibanel
Offline
Joined: Dec 18, 2007
Posts: 6
Location: The Netherlands
0 👍
/
0 👎
Wed Dec 19, 2007 9:07 am
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
NanoCaiordo
Offline
Joined: Jun 29, 2004
Posts: 4291
Location: Italy
0 👍
/
0 👎
Wed Dec 19, 2007 9:32 am
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
Gibanel
Offline
Joined: Dec 18, 2007
Posts: 6
Location: The Netherlands
0 👍
/
0 👎
Wed Dec 19, 2007 10:05 am
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