Support ⇒ Troubleshootings :: Archives ⇒ can't install modules :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexTroubleshootings

Archived ⇒ can't install modules


I now can't install modules, in the modules/install page. when I try to install a mod, I get the below error
(i used to have kpads, but deleted a long time ago)
Array
(
[theme] => Odyssey
[session_time] => 1198038993
[admin] => Array
(
[page] => modules
)

[user] => Array
(
[page] => modules
[file] =>
[uri] => /admin.php?op=modules&install=Business_Directory
)

[banned] =>
[Pkads] => Array
(
[adscount] => 1
[adsmoney] => We currently have over € 12,00 EUR in
)

[update_monitor] => 1
[tables_cleanup] => 1
[comments] => Array
(
[mode] => thread
[order] => 0
[thold] => 0
)

[session_start] => 1198032522
[Forums] => Array
(
[track_topics] => Array
(
[46] => 1198035046
)

)

)
modu

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL 4.1.15-log / PHP 4.3.10 / DF 9.0.1.1


This isn't an error - this is just debug info. Does it give an actual error?

Admin - Great Lakes Web Designs
Theme Designer - WebSite Guru Designs
Site Admin - Families with Food Allergies

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux 2.6.27-grsec/Apache 2.2.11/MySQL 5.0.67-community-log/PHP 5.2.8/DF 9.2.1


I am not getting the error (it is not emailing it to me)

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL 4.1.15-log / PHP 4.3.10 / DF 9.0.1.1


doese this help?
includes/db/db.php

* CMS Warning line 75: On /admin.php?op=modules&install=Business_Directory While executing query "CREATE TABLE cms_directory ( did INT(10) UNSIGNED NOT NULL auto_increment, cid INT(10) UNSIGNED NOT NULL, user_id MEDIUMINT(8) UNSIGNED NOT NULL, title VARCHAR(60) NOT NULL, address VARCHAR(100), town VARCHAR(100), county VARCHAR(50) DEFAULT '', postcode VARCHAR(10), telephone VARCHAR(20), fax VARCHAR(20), url VARCHAR(100) NOT NULL DEFAULT 'http://', email VARCHAR(100), summary VARCHAR(200) NOT NULL, description TEXT NOT NULL, image_name VARCHAR(100), active TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', bold TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', hilite TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', promo_top TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', promo_parent TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', promo_front TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', recommended TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', show_map TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', date_added DATE NOT NULL, rating TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', vote_count INT(11) UNSIGNED NOT NULL DEFAULT '0', comment_count INT(11) UNSIGNED NOT NULL DEFAULT '0', language VARCHAR(30) NOT NULL, PRIMARY KEY (did), KEY directory_n1 (title), KEY directory_n2 (cid)) TYPE=MyISAM DEFAULT CHARSET=null" the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null' at line 32 In: /usr/www/users/honunet/ikunming/includes/classes/installer.php on line: 61

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL 4.1.15-log / PHP 4.3.10 / DF 9.0.1.1


yep, that's the error Smile Still a collation problem

"DEFAULT CHARSET=null"

go into phpMyAdmin and set default charset to utf8 for the database

Admin - Great Lakes Web Designs
Theme Designer - WebSite Guru Designs
Site Admin - Families with Food Allergies

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux 2.6.27-grsec/Apache 2.2.11/MySQL 5.0.67-community-log/PHP 5.2.8/DF 9.2.1


Actually I think honurox has incorrectly edited his config file - inability to install modules has been documented many times now.

WRONG: define('DB_CHARSET', 'null');
RIGHT: define('DB_CHARSET', NULL);

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


I can the DEFAULT CHARSET in the congif.php file right?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL 4.1.15-log / PHP 4.3.10 / DF 9.0.1.1


Yes, for your version it should be in your root directory. I suspect that version also requires you to use a utf-8 compatible editor for config.php.

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


I see when I view the db with phpmyadmin, most of the table are Latin_sweden_ci

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL 4.1.15-log / PHP 4.3.10 / DF 9.0.1.1


I has already change the DEFAULT CHARSET to "NULL", but that did not work

utf8_bin

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL 4.1.15-log / PHP 4.3.10 / DF 9.0.1.1


I trust you used NULL without the quotes, as in my example above. By adding the quotes, you will get precisely the error you provided.

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


this is what I have done, but it is still have not fixed it ( I still can;t install the modules.
if (!defined('CPG_NUKE')) { exit; }

define('DB_TYPE', 'mysql');
define('DB_CHARSET', NULL); // NULL (is default), latin1, utf8, etc.
$dbhost = 'db119@112.com

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL 4.1.15-log / PHP 4.3.10 / DF 9.0.1.1


If you still get the same database error, then your site config.php file still has an incorrect setting for charset.

Aside from that, your DF version is now so old and out of date that you have a constant security risk, and support is becoming extremely difficult.

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


ok, thanks. I just upgraded to 9.1.2.1 from 9.0.1.1

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL 4.1.15-log / PHP 4.3.10 / DF 9.0.1.1


What I did to fix the mixed collation for a couple sites I upgraded:

1. export database via phpMyAdmin to file
2. Edit file with good text editor (Notepad2 or UltraEdit). Use Find&Replace to change all tables to:
DEFAULT CHARSET=utf8
3. Make sure default charset in MySql is set to utf8-general-ci
4. Create new database
5. Import edited sql dump into new db
6. Edit includes\config.php to point to new db

Once confirmed this works, original sql database can be dropped.
This takes care of any tables that have fields that are different collations and such also.

Admin - Great Lakes Web Designs
Theme Designer - WebSite Guru Designs
Site Admin - Families with Food Allergies

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux 2.6.27-grsec/Apache 2.2.11/MySQL 5.0.67-community-log/PHP 5.2.8/DF 9.2.1

All times are UTC