DragonflyCMS Projects > Audit (IP Tracker) > [solved]Install issue - incorrect db_charset in config > Community Forums > Phoenix Netology
Forum Index > Management > Audit (IP Tracker)

[solved]Install issue - incorrect db_charset in config Reply to topic


Tried installing this on 9.1.1 and get this db error:

includes/db/db.php

* CMS Warning line 75: On /admin.php?op=modules&install=IP_Tracker While executing query "CREATE TABLE nuke_iptracking ( ipid int(10) NOT NULL auto_increment, ipusername varchar(25), date_time int(10) UNSIGNED NOT NULL DEFAULT 1171780350, ip_address varchar(15) NOT NULL, hostname varchar(100) NOT NULL, page varchar(150) NOT NULL, ipcode smallint(6) NOT NULL default 0, PRIMARY KEY (ipid), KEY i1iptracking (ip_address, hostname)) 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 10 In: /home/rommel/domains/mydomain.us/public_html/includes/classes/installer.php on line: 61

Using 9.0.0.7. Any insight?

Please enter your server specs in your user profile! 😢


No time left today, but I will check it out tomorrow.

MySQL version?

Donations & Audit for DragonflyCMS

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

Last edited by Phoenix on Sun Feb 18, 2007 8:05 pm; edited 1 time in total


Understood. I appreciate it as I use this often. I run a political/military/intel site that gets some abuse from some of our Islamic fundi bretheren and it's always good to keep tabs on IP addresses if you know what I mean.

Please enter your server specs in your user profile! 😢


okay, I just had an afterthought as I was going out the door, MySQL version?

Donations & Audit for DragonflyCMS

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


American's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FC4/2.0.59/4.1.12/4.4.4/9.1.1

Also..while you're at it.... Smile
cpgnuke.com/Forums/vie...tml#121767

Some date issues with the profile in 9.1.1:

$Source: /cvs/html/modules/Your_Account/userinfo.php,v $
$Revision: 9.33 $
$Author: phoenix $
$Date: 2006/08/17 13:12:50 $

But my date in user's profiles still only gives the date like this: Joined: Tuesday, March 18

No year. It's correct in the forum when viewing a post just not in the profile.

Please enter your server specs in your user profile! 😢


It's not directly an issue with IPT - it's choking on DEFAULT CHARSET=NULL which is added by the installer, independently of IPT.

Do you have trouble installing any other module?

This looks like a DragonflyCMS installer issue, which I won't handle here, but have relayed to the developers.

Donations & Audit for DragonflyCMS

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

Last edited by Phoenix on Mon Feb 19, 2007 8:15 pm; edited 1 time in total


I do have charset set to null.... had utf8 issues.

I have installed weblinks, downloads, etc with no issues.

Would it help to reset charset to utf during ipt install and then change or ???

Please enter your server specs in your user profile! 😢


hmm, I edited while you were responding - I've forwarded to the developers as it's not a module issue.

Also I found someone else with the same issue on a different module.
dragonflycms.org/Forum...21733.html

Donations & Audit for DragonflyCMS

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


It appears your problem is caused by incorrect use of NULL in your config file.

Should be define('DB_CHARSET', NULL);
Not define('DB_CHARSET', 'NULL');

Donations & Audit for DragonflyCMS

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


I changed it... made no difference, here is how it looks now:

define('DB_CHARSET', NULL); // NULL (is default), latin1, utf8, etc.

Please enter your server specs in your user profile! 😢


well, NULL in quotes was incorrect and leads to the problem you had.

It's just not an IP Tracker installation issue.

Donations & Audit for DragonflyCMS

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


I apologize... must of been some sort of cache issue in my browser or something...works fine now.

Thank you for your help!

Please enter your server specs in your user profile! 😢


whew, thank goodness for that, coz there was no other answer Smile

Donations & Audit for DragonflyCMS

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

All times are Australia/Adelaide


Jump to: